Help with mysql/Y_INI / crashing on 350+ players!
#1

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...
Reply
#2

Why do you think MySQL is causing the problem?

Check it latest errors.
Reply
#3

Because gamemode couldnt just crash without any log, error...
Reply
#4

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.
Reply
#5

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..
Reply
#6

still no error, of course crashdetect "crashed due to an unknown error"..
Reply
#7

bump..
Reply
#8

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..
Reply
#9

.... Still crashing
Reply
#10

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..
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)