SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

If HLDS lose the connection to the database and I go to change the map, lock the HLDS

Does anyone have a solution to the problem?

I tried using this fix, but did not solve the problem: https://forums.alliedmods.net/showthread.php?t=177759

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

Windows? Linux ? What AMXX version? How to reproduce exactly the problem.
Please give concrete informations.

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

Tested on Windows, Linux and all versions of AMXX

All of them have this bug


If HLDS send a query to the mysql offline and then I change the map, lock the server


You can take the test

Disconnect the mysql server and try to send a mysql query HLDS and then change the map

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

I'm having issues with MySQL module, too, but not sure this is related to OP issue.
My issue is that when map changes and mods are changed (using polymorph) server crashes, but when mod is kept running for nextmap it works fine. Not sure why, but I think it is my fault :/

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

I think the problem is in mysql_amxx

If your server loses connection with the database
you send a query
then you try to change the map
will crash your server
amx_map and restart
not closes the threads waiting

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

This should be fixed in latest build. You may want to give a try.

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

1.8.3-dev-git4474 still has problems
Are attacking my server with DDOS attack
When stop attacking
Has no connection to the database
After restart or amx_map
The server crashes

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

Maybe AMXX core is waiting for module unload, and the module get stuck because the thread is not finishing.

There's a call to MF_RemoveLibraries() at OnAmxxDetach().
Sometimes when you try to unload any library, you may get stuck if it's threads are not closed.

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

Does anyone have a solution to the problem?

Who want to test
Disconnect the mysql
Send queries using: SQL_ThreadQuery
Then change the map

Re: SQL_ThreadQuery stop server in restart or amx_map if mysql server goes offline
 

Other bugs:

When I take ddos attacks or I restart the iptables, the SQL_ThreadQuery also stops working

If I connect multiple servers with different IPs on the same server, they all use only 1 IP

When the mysql server block this single IP
The mod mysql for work on all servers