[kurta999]

What the fuck can cause this crash? I haven't changed anything within my server since 1 week. Worked before 100% okey, now just don't want to start on linux (at my host). With windows everything is okey.

THERE IS NOTHING WRONG IN MY MODE!!!

Код:

[2014/11/09 19:08:35] [debug] #0 0000000f in public zcmd_OnGameModeInit () at <unknown file>:0
[2014/11/09 19:08:35] [debug] #1 native CallLocalFunction () from samp03svr
[2014/11/09 19:08:35] [debug] #2 0000006b in public Itter_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\float.inc:0
[2014/11/09 19:08:35] [debug] #3 native CallLocalFunction () from samp03svr
[2014/11/09 19:08:35] [debug] #4 00001b28 in public ScriptInit_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\foreach_new.inc:774
[2014/11/09 19:08:35] [debug] #5 native CallLocalFunction () from samp03svr
[2014/11/09 19:08:35] [debug] #6 00000e88 in public OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\y_scriptinit.inc:127
[2014/11/09 19:08:35] [debug] Native backtrace:
[2014/11/09 19:08:35] [debug] #0 b743f50b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[2014/11/09 19:08:35] [debug] #1 b743820f in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[2014/11/09 19:08:35] [debug] #2 b74393fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[2014/11/09 19:08:35] [debug] #3 b7439866 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[2014/11/09 19:08:35] [debug] #4 b743f15c in ?? () from plugins/crashdetect.so
[2014/11/09 19:08:35] [debug] #5 b776340c in ?? ()
[2014/11/09 19:08:35] [debug] #6 b759c59f in ?? () from /lib/i386-linux-gnu/libc.so.6
[2014/11/09 19:08:35] [debug] #7 b73dce72 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql.so
[2014/11/09 19:08:35] [debug] #8 b73dd30b in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql.so
[2014/11/09 19:08:35] [debug] #9 b73d5a5e in _ZN16CMySQLConnection14ProcessQueriesEv () from plugins/mysql.so
[2014/11/09 19:08:35] [debug] #10 b73d6a2a in _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEE3runEv () from plugins/mysql.so
[2014/11/09 19:08:35] [debug] #11 b73fbf48 in ?? () from plugins/mysql.so
[2014/11/09 19:08:35] [debug] #12 b7742d4c in ?? () from /lib/i386-linux-gnu/libpthread.so.0
[2014/11/09 19:08:35] [debug] #13 b75519de in clone () from /lib/i386-linux-gnu/libc.so.6

Код:

[2014/11/09 19:12:12] [debug] #0 native SetDynamicObjectMaterial () from streamer.so
[2014/11/09 19:12:12] [debug] #1 0024b268 in public zcmd_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\gamemodes\Backup\3.8 - old stats\nmss.pwn:51959
[2014/11/09 19:12:12] [debug] #2 native CallLocalFunction () from samp03svr
[2014/11/09 19:12:12] [debug] #3 000384e8 in public Itter_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\zcmd2.inc:58
[2014/11/09 19:12:12] [debug] #4 native CallLocalFunction () from samp03svr
[2014/11/09 19:12:12] [debug] #5 00001b28 in public ScriptInit_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\foreach_new.inc:774
[2014/11/09 19:12:12] [debug] #6 native CallLocalFunction () from samp03svr
[2014/11/09 19:12:12] [debug] #7 00000e88 in public OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\y_scriptinit.inc:127
[2014/11/09 19:12:12] [debug] Native backtrace:
[2014/11/09 19:12:12] [debug] #0 b743c50b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[2014/11/09 19:12:12] [debug] #1 b743520f in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[2014/11/09 19:12:12] [debug] #2 b74363fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[2014/11/09 19:12:12] [debug] #3 b7436866 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[2014/11/09 19:12:12] [debug] #4 b743c15c in ?? () from plugins/crashdetect.so
[2014/11/09 19:12:12] [debug] #5 b776040c in ?? ()
[2014/11/09 19:12:12] [debug] #6 b759959f in ?? () from /lib/i386-linux-gnu/libc.so.6
[2014/11/09 19:12:12] [debug] #7 b73d9e72 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql.so
[2014/11/09 19:12:12] [debug] #8 b73da30b in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql.so
[2014/11/09 19:12:12] [debug] #9 b73d2a5e in _ZN16CMySQLConnection14ProcessQueriesEv () from plugins/mysql.so
[2014/11/09 19:12:12] [debug] #10 b73d3a2a in _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEE3runEv () from plugins/mysql.so
[2014/11/09 19:12:12] [debug] #11 b73f8f48 in ?? () from plugins/mysql.so
[2014/11/09 19:12:12] [debug] #12 b773fd4c in ?? () from /lib/i386-linux-gnu/libpthread.so.0
[2014/11/09 19:12:12] [debug] #13 b754e9de in clone () from /lib/i386-linux-gnu/libc.so.6

Код:

[2014/11/09 19:14:15] [debug] #0 002f4dfc in ?? () at C:\Users\Ati\Desktop\SERVER\gamemodes\Backup\3.8 - old stats\nmss.pwn:63975
[2014/11/09 19:14:15] [debug] #1 44df5416 in public zcmd_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\gamemodes\Backup\3.8 - old stats\nmss.pwn:64863
[2014/11/09 19:14:15] [debug] #2 native CallLocalFunction () from samp03svr
[2014/11/09 19:14:15] [debug] #3 000384e8 in public Itter_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\zcmd2.inc:58
[2014/11/09 19:14:15] [debug] #4 native CallLocalFunction () from samp03svr
[2014/11/09 19:14:15] [debug] #5 00001b28 in public ScriptInit_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\foreach_new.inc:774
[2014/11/09 19:14:15] [debug] #6 native CallLocalFunction () from samp03svr
[2014/11/09 19:14:15] [debug] #7 00000e88 in public OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\y_scriptinit.inc:127
[2014/11/09 19:14:15] [debug] Native backtrace:
[2014/11/09 19:14:15] [debug] #0 b741450b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[2014/11/09 19:14:15] [debug] #1 b740d20f in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[2014/11/09 19:14:15] [debug] #2 b740e3fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[2014/11/09 19:14:15] [debug] #3 b740e866 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[2014/11/09 19:14:15] [debug] #4 b741415c in ?? () from plugins/crashdetect.so
[2014/11/09 19:14:15] [debug] #5 b773840c in ?? ()
[2014/11/09 19:14:15] [debug] #6 b757159f in ?? () from /lib/i386-linux-gnu/libc.so.6
[2014/11/09 19:14:15] [debug] #7 b73b1e72 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql.so
[2014/11/09 19:14:15] [debug] #8 b73b230b in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql.so
[2014/11/09 19:14:15] [debug] #9 b73aaa5e in _ZN16CMySQLConnection14ProcessQueriesEv () from plugins/mysql.so
[2014/11/09 19:14:15] [debug] #10 b73aba2a in _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEE3runEv () from plugins/mysql.so
[2014/11/09 19:14:15] [debug] #11 b73d0f48 in ?? () from plugins/mysql.so
[2014/11/09 19:14:15] [debug] #12 b7717d4c in ?? () from /lib/i386-linux-gnu/libpthread.so.0
[2014/11/09 19:14:15] [debug] #13 b75269de in clone () from /lib/i386-linux-gnu/libc.so.6

Код:

[2014/11/09 19:16:24] [debug] Server crashed while executing nmss.amx
[2014/11/09 19:16:24] [debug] AMX backtrace:
[2014/11/09 19:16:24] [debug] #0 native TextDrawCreate () from samp03svr
[2014/11/09 19:16:24] [debug] #1 0026c614 in public zcmd_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\gamemodes\Backup\3.8 - old stats\nmss.pwn:53501
[2014/11/09 19:16:24] [debug] #2 native CallLocalFunction () from samp03svr
[2014/11/09 19:16:24] [debug] #3 000384e8 in public Itter_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\zcmd2.inc:58
[2014/11/09 19:16:24] [debug] #4 native CallLocalFunction () from samp03svr
[2014/11/09 19:16:24] [debug] #5 00001b28 in public ScriptInit_OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\foreach_new.inc:774
[2014/11/09 19:16:24] [debug] #6 native CallLocalFunction () from samp03svr
[2014/11/09 19:16:24] [debug] #7 00000e88 in public OnGameModeInit () at C:\Users\Ati\Desktop\SERVER\pawno\include\YSI\y_scriptinit.inc:127
[2014/11/09 19:16:24] [debug] Native backtrace:
[2014/11/09 19:16:24] [debug] #0 b73ff50b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[2014/11/09 19:16:24] [debug] #1 b73f820f in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[2014/11/09 19:16:24] [debug] #2 b73f93fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[2014/11/09 19:16:24] [debug] #3 b73f9866 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[2014/11/09 19:16:24] [debug] #4 b73ff15c in ?? () from plugins/crashdetect.so
[2014/11/09 19:16:24] [debug] #5 b772340c in ?? ()
[2014/11/09 19:16:24] [debug] #6 b755c59f in ?? () from /lib/i386-linux-gnu/libc.so.6
[2014/11/09 19:16:24] [debug] #7 b739ce72 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql.so
[2014/11/09 19:16:24] [debug] #8 b739d30b in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql.so
[2014/11/09 19:16:24] [debug] #9 b7395a5e in _ZN16CMySQLConnection14ProcessQueriesEv () from plugins/mysql.so
[2014/11/09 19:16:24] [debug] #10 b7396a2a in _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEE3runEv () from plugins/mysql.so
[2014/11/09 19:16:24] [debug] #11 b73bbf48 in ?? () from plugins/mysql.so
[2014/11/09 19:16:24] [debug] #12 b7702d4c in ?? () from /lib/i386-linux-gnu/libpthread.so.0
[2014/11/09 19:16:24] [debug] #13 b75119de in clone () from /lib/i386-linux-gnu/libc.so.6

Код:

[debug] #0 b73c966b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[debug] #1 b73c25bf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so
[debug] #2 b73c38fc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so
[debug] #3 b73c43e6 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so
[debug] #4 b73c92bc in ?? () from plugins/crashdetect.so
[debug] #5 b76f740c in ?? ()
[debug] #6 b75305cf in ?? () from /lib/i386-linux-gnu/libc.so.6
[debug] #7 b7055254 in _ZN11CMySQLQuery11StoreResultEP8st_mysqlP12st_mysql_res () from plugins/mysql_static.so
[debug] #8 b7055657 in _ZN11CMySQLQuery7ExecuteEP8st_mysql () from plugins/mysql_static.so
[debug] #9 b704c9e4 in _ZN16CMySQLConnection14ProcessQueriesEv () from plugins/mysql_static.so
[debug] #10 b704d2e7 in _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvNS_4_mfi3mf0Iv16CMySQLConnectionEENS2_5list1INS2_5valueIPS6_EEEEEEE3runEv () from plugins/mysql_static.so
[debug] #11 b70f6

[xeeZ]

I might be late but anyway, the server seems to be crasing in the MySQL processing thread while storing the result of a query (on Linux non-main threads usually start with a clone() call, plus there's a boost::thread thing in the middlle). This also would explain the non-sense AMX stack trace as it's happening in a totally different thread.

[kurta999]

So the problem with mysql plugin?

[xeeZ]

Yes.

[kurta999]

Then I think this crash was caused by mysql_pquery. I changed everything to mysql_tquery and look's like works.

E: I forgot! Thank you very much!

[maddinat0r]

That's indeed an interesting crash. How many parallel connections were you using? Did you notice any RAM shortages before the server crashed? Did you fetch really big results from the MySQL server?

[kurta999]

I used 2 connections, pareller query for everything. In gamemode load, I sent ~10 query to load a lot of thing, like houses, biznis, bans, etc etc etc into memory. But now with tquery everything are okey.

[maddinat0r]

Sounds like a memory shortage. I'll add some more safety measurements into R40.
A rule of thumb: never use mysql_pquery unless you really know that you need it. mysql_pquery is evil.