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

GuruQA · **Author**

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

**Arkshine**

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

GuruQA

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

GuskiS

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 :/

GuruQA

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

**Arkshine**

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

GuruQA

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

joropito

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.

GuruQA

Does anyone have a solution to the problem?

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

GuruQA

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