Help with mysql/Y_INI / crashing on 350+ players! - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Help with mysql/Y_INI / crashing on 350+ players! (/showthread.php?tid=564291)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: Help with mysql/Y_INI / crashing on 350+ players! (/showthread.php?tid=564291)
Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 20.02.2015
Well, me again...
So, in last three days server crashed precisely @ 8~9PM when there is like 400 players online. Crashdetect log shows NOTHING, like it didnt crash at all, but server just stopped working. No, its not due to dedicated or y_ini`, becuse i have only user accounts on mysql, and my vehicles n stuff are on Y_INI.
If anyone has any suggestion why server is working FINE around 250-300 players and CRASHES @ 400 players, i'd pay him give him advertisement ANYTHING...
Is it because MYSQL overloads / crashes? Why crashdetect is not showing anything, like it nothing happened?
Please help...
Re: Help with mysql/Y_INI / crashing on 350+ players! - arakuta - 20.02.2015
Why do you think MySQL is causing the problem?
Check it latest errors.
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 20.02.2015
Because gamemode couldnt just crash without any log, error...
Re: Help with mysql/Y_INI / crashing on 350+ players! - Divergent - 20.02.2015
Check your mysql_log.txt to see if it's a MYSQL error. I highly doubt that though, your server probably can't handle that much traffic.
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 20.02.2015
Server crashed exactly @ [20:01:17]
[20:01:17] [DEBUG] Calling callback "OnPlayerDataLoad"..
[20:01:17] [DEBUG] orm_setkey - orm_id: 357, varname: "ID"
[20:01:17] [DEBUG] orm_errno - orm_id: 357
[20:01:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:01:17] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 88.265 milliseconds
[20:01:17] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[20:01:17] [DEBUG] CMySQLQuery::Execute[OnPlayerDataLoad] - starting query execution
[20:01:17] [DEBUG] CMySQLQuery::Execute[OnPlayerDataLoad] - query was successfully executed within 0.543 milliseconds
[20:01:17] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:01:17] [DEBUG] CMySQLQuery::Execute[] - starting query execution
MYSQL Log there ends, starts new log after i restarted.
Server log
[20:00:43] Incoming connection: 178.223.12.74:21392
[20:00:43] [join] Nikola_Pantic has joined the server (11:178.223.12.74)
[20:00:47] [part] Elvir_Vendetta has left the server (167:2)
[20:00:47] [part] Mume_Corely has left the server (331:1)
[20:00:51] Incoming connection: 62.193.135.96:60544
[20:00:52] [join] Srdjan_Seneo has joined the server (67:62.193.135.96)
[20:00:56] Incoming connection: 24.135.76.225:4223
[20:00:56] [join] Laki_Novosel has joined the server (167:24.135.76.225)
[20:00:58] Incoming connection: 109.92.34.222:2181
[20:00:58] [join] Ljubo_Jevtic has joined the server (193:109.92.34.222)
[20:00:59] [part] Aca_Arsic has left the server (241:1)
[20:01:00] [part] Marko_Carousi has left the server (33:1)
[20:01:01] [part] Almin_Williams has left the server (309:0)
[20:01:02] [part] Jovann_Jevtic has left the server (280:1)
[20:01:03] Incoming connection: 178.149.112.218:61326
[20:01:04] [join] Vuk_Bjelinic has joined the server (33:178.149.112.21
[20:01:04] [part] Bojan_Trajkovski has left the server (148:1)
[20:01:06] Incoming connection: 109.163.155.33:14636
[20:01:06] [join] Almin_Williams has joined the server (148:109.163.155.33)
[20:01:07] [part] Miloss_Jevtic has left the server (180:2)
[20:01:11] Incoming connection: 31.176.153.75:59646
[20:01:12] [join] Elvir_Vendettaa has joined the server (180:31.176.153.75)
[20:01:13] [part] Laki_Novosel has left the server (167:2)
[20:01:14] [part] Ciro_Corleone has left the server (279:1)
[20:01:15] Incoming connection: 95.86.16.214:64425
[20:01:16] [join] Bojan_Trajkovski has joined the server (167:95.86.16.214)
[20:01:16] [part] Bojan_Trajkovski has left the server (167:2)
So i dont see anywhere any error.
This can't be possible..
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 21.02.2015
still no error, of course crashdetect "crashed due to an unknown error"..
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 23.02.2015
bump..
Re: Help with mysql/Y_INI / crashing on 350+ players! - DannielCooper - 26.02.2015
It always happens that will arrive this that amount of players or only sometimes? It is when a player enters ?
Can be caused by cheaters..
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 28.02.2015
.... Still crashing
Re: Help with mysql/Y_INI / crashing on 350+ players! - DeitY - 02.03.2015
Bump.. I think its due to streamer or some linux lobraries.. Could anyone tell me what requirements are needed for mysql/sscanf/streamer? This server restarting will drive me crazy... Iwill pay to anyone who can figure out why crash is happening..