[kr0tchy]

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?

[Restorer]

Server.log ?

[$Indian$]

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.

[kr0tchy]

Код:

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

[ColdFly]

any idea?

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

[kr0tchy]

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.

[kr0tchy]

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

[AndreT]

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

[kr0tchy]

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?