LOST CONNECTION TO MYSQL- SOURCEBANS

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
lobo
New to forums
New to forums
Posts: 1
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Mon Jan 27, 2020 9:05 pm

LOST CONNECTION TO MYSQL- SOURCEBANS

Post by lobo »

Hi, I have a New York VDS, the panel install the sourcebans and a VDS in another country where I have the game servers, in the logs folder I get it in the file sourcebans.log
which for now lets the banned players in and then reconnects

1.- VDS NEW YORK - UBUNTU 18.04 - PANEL WEB SOURCEBANS
2.-VDS ANOTHER COUNTRY - UBUNTU 16.04 SERVER - SERVERGAMES

ERROR:
L 01/26/2020 - 19:16:07: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 19:37:29: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 20:59:01: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:04:53: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:31:16: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 22:49:22: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/26/2020 - 23:07:20: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 00:09:50: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 02:02:33: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 11:03:34: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 01/27/2020 - 21:33:03: [sourcebans/sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during quer
User avatar
Edge100x
Founder
Founder
Posts: 12947
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: LOST CONNECTION TO MYSQL- SOURCEBANS

Post by Edge100x »

That information doesn't say too much, unfortunately -- you'll need further data.

Is the MySQL daemon up the entire time?
Do you have any mechanism that would kill the connection on the MySQL side?
In long-term ping or MTR tests, are you seeing any packet loss between the two endpoints?
Is the game server or MySQL server experiencing high CPU or memory usage, or is it struggling in any other way?
Are the specific queries involved taking too long to execute, such that they time out?
Post Reply