SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline - Page 5

GuruQA · *Last edited by GuruQA; 02-20-2015 at 15:19.*

He did not stop because it has only one user

In a crowded server, lock and will only restarting

The solution would be to have something like this: https://forums.alliedmods.net/showthread.php?t=177759

claudiuhks

Are we talking Chinese?

The solution is BETA BUILD. Download the latest (git4627+) and install.

Is that so hard?

GuruQA

tested amxmodx-1.8.3-dev-git4627

and has the same problem
You need to have nerves
Even so thank you for trying to help

**Arkshine** · *Last edited by Arkshine; 02-20-2015 at 16:59.*

Just by curiosity, can you try this? (just mysql module for windows).

Make sure you replace properly the binary.

It may help to avoid crash at map change.

GuruQA

Gave the same problem

I did another test video: https://www.youtube.com/watch?v=yb9xpk1p0dM

**Arkshine** · *Last edited by Arkshine; 02-20-2015 at 19:18.*

Unless I'm wrong you did not crash. But got disconnected after a defined hlds server timeout (or client?). Also in such case where mysql server suddenly lost connection, there is timeout, which is now by default 60 seconds before it closes.

Did you set the mysql timeout to a short value like 5 seconds? Since you are using latest version you can add "mysql_timeout 5" in core.ini file (or you can explicit the value in plugin too). If you lost connection you should be albe to reconnect faster and avoiding hlds server being blocked until it (or client) hits a timeout.

Try again with that.

GuruQA

I just blocked my ip in mysql

Simulating a mysql offline

hlds kicked sv_timeout

when this problem in a crowded server, will only restarting the hlds

The video is bad on youtube, direct link to video in HD: http://chesspc.com/test2.wmv

**Arkshine**

You did not answer. Did you try with timeout of like 5 seconds defined in plugin?

GuruQA · *Last edited by GuruQA; 02-20-2015 at 19:40.*

Quote:

Originally Posted by Arkshine

You did not answer. Did you try with timeout of like 5 seconds defined in plugin?

Yes

Nothing changes

Code:

native Handle:SQL_MakeDbTuple(const host[], const user[], const pass[], const db[], timeout=5);

also dermora the old dll you passed me:

Code:

native Handle:SQL_MakeDbTuple(const host[], const user[], const pass[], const db[], timeout=5, rw_timeout=5);

**Arkshine**

Ok, I understand better. When you send thread queries to an offline mysql server and you change map, server is blocked the time all queries are processed and it takes like ~1 second (tested in local only) to figure out there is no connection. So 20 queries and server is locked for ~20 seconds. For sure it should not block the server while doing the job and could be lead to crash depending the context and plugin running. Will see if something can be improved.