Server crash :S - Printable Version

Server crash :S - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Server crash :S (/showthread.php?tid=294180)

Server crash :S - kr0tchy - 31.10.2011

So, I have a SA-MP server with an RP game mode (not GF). I use mysql R6, foreach, sscanf2, Incognito's streamer, mapandreas inc, Double-O-Seven's textdraw streamer, OPVD, OPSP, and sniperfix includes.
I start the server, and a few hours later the server is crashing. But it's not a usually crash, the server is running, I see the 50 people who are playing in the SAMP Client, but nobody can connect.
I see the log and there are a lots of "Incoming connection" with the players ip's who was on the server, and the CPU usage is 100%

Any ideas?

Re: Server crash :S - Restorer - 31.10.2011

Server.log ?

Re: Server crash :S - $Indian$ - 31.10.2011

Hi, your host needs to restart the server.
Your script takes too much CPU, so it needs to be restarted.

Try it, Good Luck!
Give me reputation if my post helped you out.

Re: Server crash :S - kr0tchy - 31.10.2011

Код:

server_log:

....nothing special
[2011/10/31 19:10:30] Incoming connection: 82.131.200.163:2417
[2011/10/31 19:11:07] Incoming connection: 78.92.12.132:1659
[2011/10/31 19:11:11] Incoming connection: 89.134.246.189:51109
[2011/10/31 19:11:13] Incoming connection: 85.119.12.10:1433
[2011/10/31 19:11:16] Incoming connection: 89.132.74.13:55613
[2011/10/31 19:11:25] Incoming connection: 84.3.245.177:4066
[2011/10/31 19:11:25] Incoming connection: 62.201.116.35:3654
[2011/10/31 19:11:29] Incoming connection: 78.139.21.8:1547
[2011/10/31 19:12:04] Incoming connection: 188.143.56.196:59338
[2011/10/31 19:12:08] Incoming connection: 78.92.12.132:1665
[2011/10/31 19:12:13] Incoming connection: 89.132.76.173:1348
[2011/10/31 19:12:14] Incoming connection: 86.101.199.203:54426
[2011/10/31 19:12:18] Incoming connection: 62.201.116.35:3660
[2011/10/31 19:12:25] Incoming connection: 188.36.192.183:1884
[2011/10/31 19:12:29] Incoming connection: 80.98.3.154:11922
[2011/10/31 19:12:36] Incoming connection: 89.134.246.189:59204
[2011/10/31 19:12:51] Incoming connection: 91.114.210.37:57709
[2011/10/31 19:12:56] Incoming connection: 87.242.29.252:4600
[2011/10/31 19:13:04] Incoming connection: 62.201.116.35:3667
[2011/10/31 19:13:05] Incoming connection: 62.77.240.150:64107
[2011/10/31 19:13:12] Incoming connection: 84.3.245.177:4132
[2011/10/31 19:13:12] Incoming connection: 78.92.12.132:1672

These are the players's IP who was on the server.
And the CPU and the Memory usage is perfect before these happen

Re: Server crash :S - ColdFly - 03.11.2011

any idea?

Re: Server crash :S - AndreT - 03.11.2011

I've battled a similar (or the same) issue in the past a lot. The server isn't crashed, more proper terminology would be "locked up" or frozen.

I traced it down to the MySQL plugin (R6-2) and threading all queries fixed the issue.

Re: Server crash :S - kr0tchy - 03.11.2011

Quote:

Originally Posted by AndreT

I've battled a similar (or the same) issue in the past a lot. The server isn't crashed, more proper terminology would be "locked up" or frozen.

I traced it down to the MySQL plugin (R6-2) and threading all queries fixed the issue.

I will try it, thanks.

Re: Server crash :S - kr0tchy - 04.11.2011

I need to thread UPDATE, INSERT, DELETE queries too?

Re: Server crash :S - AndreT - 05.11.2011

It won't hurt and should even be recommended to do so, yes.

Re: Server crash :S - kr0tchy - 06.11.2011

Quote:

Originally Posted by AndreT

It won't hurt and should even be recommended to do so, yes.

Yes i see, when I didn't thread all queries, I got a lots of "Commands out of sync; you can't run this command now" errors.
How can I thread a query with return value?