TFS 1.X+ SQL error ?

[Lbtg]

Hello, i got this error pops up, very randm, and basicaly while 0 players is online

Error:

[Error - mysql_store_result] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE `ip` = 3586606524
Message: The client was disconnected by the server because of inactivity. See wait_timeout and interactive_timeout for configuring this behavior.

How i can fix it ? Can anyome help me out please
Im using 8.6 tfs 1.3-1.4

 

[Rombadr]

Google is your friend!
You have to increase interactive_timeout in the mysql config

interactive_time is for interactive sessions, whereas wait_timeout is for non-interactive sessions.

What's an interactive session? It's one with a human at the keyboard.

When your code connects to MySQL, runs a query and then spends 3 seconds processing that query before disconnecting, that's 3 seconds of the wait_timeout.

When you use the mysql command line client to connect, run a command and spend 10 seconds reading the output, that's 10 seconds of interactive_timeout. If you walk away and have lunch, that's 3600 seconds of interactive_timeout.

In both cases, when you or your code runs another query, the waiting time is reset back to 0.

You can see the values for all the current sessions by typing show processlist. The values in the sleep(5) function is the number of seconds since that connection last did anything.

1. Edit my.cnf (the MySQL configuration file).
   

   sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

   
   
2. Locate the timeout configuration and adjust it to fit your server.

3. [mysqld]
   wait_timeout = 31536000
   interactive_timeout = 31536000

4. 
   
   
5. Save the changes and exit the editor.
6. Restart MySQL to apply the changes as follows:
   

   sudo /etc/init.d/mysql restart

Taken form:

What is the difference between wait_timeout and interactive_timeout?

What is actual difference between wait_timeout and interactive_timeout?

serverfault.com

How do I set wait_timeout to unlimited in mysql?

How do I set wait_timeout to unlimited in mysql?

askubuntu.com

 

[zyzz7omg]

Increasing wait_timeout / interactive_timeout is a common workaround and may reduce how often this happens, but it doesn’t actually fix the root cause.

The real issue is that TFS keeps a long-lived MySQL connection and assumes it will never die. When MySQL drops an idle connection (timeout, socket reset, reload, etc.), TFS keeps reusing a dead MYSQL handle, which leads to errors like:

"The client was disconnected by the server because of inactivity", even with high timeout values.

The proper fix is to add reconnect logic in database.cpp:

• Detect reconnectable MySQL errors (CR_SERVER_GONE_ERROR, CR_SERVER_LOST, etc.)
• Close the dead connection
• Reconnect using the stored DB config
• Retry the query once

This makes the server resilient to idle disconnects, MySQL restarts, and network hiccups, instead of relying on very large timeout values.

Many TFS versions (1.3–1.4 included) retry queries but never reconnect, which causes infinite retry loops or random errors while 0 players are online.

If people are interested, I can:

• post a generic reconnect pattern (no server-specific code), or
• prepare a clean PR that adds safe reconnect handling to the DB layer.

TL;DR:
MySQL timeouts are a band-aid.
Proper reconnect logic is the real fix.