11.12.2019, 12:59
Hi, I don't even know where to start. Server crashes due to mysql troubles, but I don't even know how it crashes. I have optimized the code, everything looks fine, it should run without problems, but the server crashes. I turn on the server and it just crashes after about 2-3 hours. Sometimes it just breaks down as soon as you connect the server. As much as you watched the server logs, it crashes due to a mysql problem. I'll put logos here, please help, I need a lot of help.
An example:
[19:51:28] [TRANSPORTAS] Kraunamos zaidejo Bulca_Tacos masinos.
[19:51:29] [connection] incoming connection: 78.62.113.8:63470 id: 5
[19:51:29] [join] Cha_Cho has joined the server (5:78.62.113.
[19:51:29] [TRANSPORTAS] Kraunamos zaidejo Cha_Cho masinos.
[19:51:33] [connection] 83.189.196.79:55073 requests connection cookie.
[19:51:34] [connection] incoming connection: 83.189.196.79:55073 id: 6
[19:51:35] [join] Armoro_Penetracija has joined the server (6:83.189.196.79)
[19:51:35] [debug] Server crashed while executing sang.amx
[19:51:35] [debug] AMX backtrace:
[19:51:35] [debug] #0 native cache_get_field_content_int () from mysql_static.so
[19:51:35] [debug] #1 0024c740 in public OnLoadPlayerData (6) from sang.amx
The second example:
[20:10:56] [SANG.lt] Vartotojas Bron_Son panaudojo [ /sms sand tai kokià klaidà padariau? ] komanda
[20:10:56] [chat] [Abra_Cadabra]: scottai
[20:10:56] [chat] [Tremell_Santos]: xdd
[20:10:57] [chat] [Vilius_Gigantas]: Sveiki.
[20:10:58] [SANG.lt] Vartotojas James_Crazy panaudojo [ / jo ] komanda
[20:10:58] [chat] [Bulca_Tacos]: vielos
[20:10:58] [SANG.lt] Vartotojas Armoro_Penetracija panaudojo [ /r tau dar per anksti zinot apie mergos pataikymus ] komanda
[20:10:58] [chat] [Michael_Scott]: nu
[20:10:59] [debug] Server crashed while executing sang.amx
[20:10:59] [debug] AMX backtrace:
[20:10:59] [debug] #0 native mysql_format () from mysql_static.so
[20:10:59] [debug] #1 003a9048 in ?? (1) from sang.amx
[20:10:59] [debug] #2 003a8758 in public cmd_direktoriai (20, 25252416) from sang.amx
[20:10:59] [debug] #3 native CallLocalFunction () from samp03svr
[20:10:59] [debug] #4 000026fc in public OnPlayerCommandText (20, 25252364) from sang.amx
An example:
[19:51:28] [TRANSPORTAS] Kraunamos zaidejo Bulca_Tacos masinos.
[19:51:29] [connection] incoming connection: 78.62.113.8:63470 id: 5
[19:51:29] [join] Cha_Cho has joined the server (5:78.62.113.
[19:51:29] [TRANSPORTAS] Kraunamos zaidejo Cha_Cho masinos.
[19:51:33] [connection] 83.189.196.79:55073 requests connection cookie.
[19:51:34] [connection] incoming connection: 83.189.196.79:55073 id: 6
[19:51:35] [join] Armoro_Penetracija has joined the server (6:83.189.196.79)
[19:51:35] [debug] Server crashed while executing sang.amx
[19:51:35] [debug] AMX backtrace:
[19:51:35] [debug] #0 native cache_get_field_content_int () from mysql_static.so
[19:51:35] [debug] #1 0024c740 in public OnLoadPlayerData (6) from sang.amx
The second example:
[20:10:56] [SANG.lt] Vartotojas Bron_Son panaudojo [ /sms sand tai kokià klaidà padariau? ] komanda
[20:10:56] [chat] [Abra_Cadabra]: scottai
[20:10:56] [chat] [Tremell_Santos]: xdd
[20:10:57] [chat] [Vilius_Gigantas]: Sveiki.
[20:10:58] [SANG.lt] Vartotojas James_Crazy panaudojo [ / jo ] komanda
[20:10:58] [chat] [Bulca_Tacos]: vielos
[20:10:58] [SANG.lt] Vartotojas Armoro_Penetracija panaudojo [ /r tau dar per anksti zinot apie mergos pataikymus ] komanda
[20:10:58] [chat] [Michael_Scott]: nu
[20:10:59] [debug] Server crashed while executing sang.amx
[20:10:59] [debug] AMX backtrace:
[20:10:59] [debug] #0 native mysql_format () from mysql_static.so
[20:10:59] [debug] #1 003a9048 in ?? (1) from sang.amx
[20:10:59] [debug] #2 003a8758 in public cmd_direktoriai (20, 25252416) from sang.amx
[20:10:59] [debug] #3 native CallLocalFunction () from samp03svr
[20:10:59] [debug] #4 000026fc in public OnPlayerCommandText (20, 25252364) from sang.amx