Lost connection with database

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
doulos9
This is my homepage
This is my homepage
Posts: 200
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Sun Sep 15, 2013 9:44 pm

Lost connection with database

Post by doulos9 »

I have been getting this error repeatedly. Sourcebans in running of NFO webhosting. Any suggestions to resolve this would be appreciated.

Code: Select all

L 04/14/2018 - 16:34:09: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/10/2018 - 13:51:32: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/11/2018 - 16:47:55: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/11/2018 - 17:31:03: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/11/2018 - 17:49:10: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 00:27:40: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 00:35:08: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 12:38:20: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 12:54:20: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 13:49:22: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 14:21:58: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 23:04:37: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/12/2018 - 23:27:13: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 13:25:30: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 13:46:37: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 14:04:42: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 14:22:39: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 16:51:28: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 17:20:35: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/13/2018 - 23:27:25: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/14/2018 - 22:44:24: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/15/2018 - 16:04:45: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/15/2018 - 22:33:53: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/16/2018 - 22:06:42: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/16/2018 - 22:53:36: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/17/2018 - 15:26:24: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/17/2018 - 22:30:43: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/18/2018 - 16:21:13: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/18/2018 - 17:16:22: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/19/2018 - 15:54:19: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/19/2018 - 23:51:39: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/20/2018 - 11:16:50: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
L 05/21/2018 - 14:15:34: [sbpp_main.smx] Verify Ban Query Failed: Lost connection to MySQL server during query
User avatar
Vanderburg
Former staff
Former staff
Posts: 1253
Joined: Sat Nov 13, 2010 7:27 am
Location: Dallas, TX

Re: Lost connection with database

Post by Vanderburg »

What is the physical location of your server? This would generally only happen if the connection times out, usually from sending/requesting a large number of rows, or if there was some connection issue between the locations, mid-transmission.
doulos9
This is my homepage
This is my homepage
Posts: 200
Joined: Sun Sep 15, 2013 9:44 pm

Re: Lost connection with database

Post by doulos9 »

Game server is in Chicago, I guess NFO hosting is in Seattle:

Code: Select all

11    16 ms    23 ms    15 ms  inap-b1.e2.router.seattle.nfoservers.com [72.5.53.254]
12    18 ms    15 ms    14 ms  hosted32.nfoservers.com [208.146.35.41]
Is NFO hosting only in Seattle?
speedvoltage
New to forums
New to forums
Posts: 2
Joined: Fri Sep 29, 2017 1:45 pm

Re: Lost connection with database

Post by speedvoltage »

I am having the same problem here with a VDS (InterNAP Germany). I have an on-going ticket and am waiting for John to reply as the ticket was forwarded to him.

I will paste the information that I wrote on Sourcemod earlier:

I am encountering issues with some of the MySQL plugins installed on my server. I have 5 total databases installed and all work fine, but often, I will get this in my error logs:
L 05/24/2018 - 10:21:01: [admin-sql-threaded.smx] SQL error receiving user: Lost connection to MySQL server during query
L 05/24/2018 - 10:21:01: [admin-sql-threaded.smx] Query dump: SELECT a.id, a.authtype, a.identity, a.password, a.flags, a.name, COUNT(ag.group_id), immunity FROM sm_admins a LEFT JOIN sm_admins_groups ag ON a.id = ag.admin_id WHERE (a.authtype = 'ip' AND a.identity = '143.176.23.122') OR (a.authtype = 'name' AND a
L 05/24/2018 - 11:33:23: [paranoiaiptracker.smx] SQL Error: Lost connection to MySQL server during query
These lost connections are not specific to those MySQL plugins as it happens with my own MySQL ban system and it is completely random when it happens.

Is there anything I can do on my side because I never had much issues in the past?

Current Metamod version:
Metamod:Source version 1.10.7-dev
Built from: https://github.com/alliedmodders/metamo ... it/f255fa5
Build ID: 961:f255fa5
Loaded As: Valve Server Plugin
Compiled on: May 22 2018
Plugin interface version: 15:14
SourceHook version: 5:5
http://www.metamodsource.net/
Current Sourcemod version:
SourceMod Version Information:
SourceMod Version: 1.10.0.6276
SourcePawn Engine: 1.10.0.6276, jit-x86 (build 1.10.0.6276)
SourcePawn API: v1 = 4, v2 = 12
Compiled on: May 24 2018 14:00:23
Built from: https://github.com/alliedmodders/source ... t/2904c87b
Build ID: 6276:2904c87b
http://www.sourcemod.net/
Current installed plugins (Sourcemod):
[SM] Listing 41 plugins:
01 "Admin File Reader" (1.10.0.6276) by AlliedModders LLC
02 "SQL Admins (Threaded)" (1.10.0.6276) by AlliedModders LLC
03 "Admin Help" (1.10.0.6276) by AlliedModders LLC
04 "Admin List" (1.2) by Fredd
05 "Admin Menu" (1.10.0.6276) by AlliedModders LLC
06 "Admin Say" (1.0.2) by Peter Brev
07 "Admin logging" (1.0.0.0) by Peter Brev
08 "Advanced HL2 Movement" (0.2.4) by Chanz
09 "Anti-Flood" (1.10.0.6276) by AlliedModders LLC
10 "Auto Recorder" (1.3.0) by Stevo.TVR
11 "Basic Ban Commands" (1.10.0.6276) by AlliedModders LLC
12 "Basic Chat" (1.10.0.6276) by AlliedModders LLC
13 "Basic Comm Control" (1.10.0.6276) by AlliedModders LLC
14 "Basic Commands" (1.10.0.6276) by AlliedModders LLC
15 "Basic Info Triggers" (1.10.0.6276) by AlliedModders LLC
16 "Basic Votes" (1.10.0.6276) by AlliedModders LLC
17 "Block game chat spam" (1.1) by Alienmario
18 "Chat Fixer/WorkAround" (1.1b) by Kyle Sanderson
19 "CIDR Blocker" (1.1.4) by Fishy
20 "Client Commands" (1.2.1.0) by Peter Brev
21 "Client Preferences" (1.10.0.6276) by AlliedModders LLC
22 "Client Connect Messages" (1.1) by Peter Brev
23 "ExtendedComm" (3.0.8b) by Twisted|Panda
24 "Fun Commands" (1.10.0.6276) by AlliedModders LLC
25 "Fun Votes" (1.10.0.6276) by AlliedModders LLC
26 "Sublime | Game Description" (1.0.0.0) by Peter Brev
27 "gameME Plugin" (4.7.2) by TTS Oetzel & Goerz GmbH
28 "HL2DM hands animation fix" (1.0) by toizy
29 "Sublime | Info Display" (1.0.0.0) by Peter Brev
30 "Frag Sprite/Trail Fix" (69) by sidezz
31 "Nextmap" (1.10.0.6276) by AlliedModders LLC
32 "[Any] Paranoia IP Tracker" (1.0.1) by DarthNinja
33 "[ANY] Rcon Password Protect" (1.1.0) by DarthNinja
34 "Player Commands" (1.10.0.6276) by AlliedModders LLC
35 "Restart" (1.2) by Peter Brev
36 "Player-Teleport by Dr. HyperKiLLeR" (1.2.0.0) by Dr. HyperKiLLeR
37 "Sound Commands" (1.10.0.6276) by AlliedModders LLC
38 "SQL Admin Manager" (1.10.0.6276) by AlliedModders LLC
39 "Sublime | SQL Ban System" (1.0.1.0) by Peter Brev
40 "tAutoDemoUpload" (0.0.4) by Thrawn
41 "tEasyFTP" (0.0.2) by Thrawn
Current running extensions(Sourcemod):
[SM] Displaying 15 extensions:
[01] Automatic Updater (1.10.0.6276): Updates SourceMod gamedata files
[02] Webternet (1.10.0.6276): Extension for interacting with URLs
[03] Top Menus (1.10.0.6276): Creates sorted nested menus
[04] Regex (1.10.0.6276): Provides regex natives for plugins
[05] SDK Tools (1.10.0.6276): Source SDK Tools
[06] BinTools (1.10.0.6276): Low-level C/C++ Calling API
[07] MySQL-DBI (1.10.0.6276): MySQL driver implementation for DBI
[08] SDK Hooks (1.10.0.6276): Source SDK Hooks
[09] Client Preferences (1.10.0.6276): Saves client preference settings
[10] SQLite (1.10.0.6276): SQLite Driver
[11] SteamTools (0.10.0+54fdc51): SteamWorks for SourceMod
[12] Socket (3.0.1): Socket extension for SourceMod
[13] GeoIP (1.10.0.6276): Geographical IP information
[14] SMbz2 (0.0.3): Very basic extension to de/compress bz2 files
[15] cURL Extension (1.3.0.0): cURL Extension
User avatar
Edge100x
Founder
Founder
Posts: 12945
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Lost connection with database

Post by Edge100x »

I troubleshooted this extensively with a few customers and determined that the MySQL connection interruptions were caused by an issue with the 4.16.x series kernel that we updated our webhosting machines to. We have now switched all them over to the most recent 4.14.x series kernel, and this has reportedly eliminated the problem.
Post Reply