• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

TFS 1.X+ Lost connection to server during query

peteralto

Active Member
Joined
Nov 1, 2020
Messages
130
Solutions
1
Reaction score
33
I've been getting two connection loss errors during query.

Code:
[Error - mysql_real_query] Query: INSERT INTO `player_killers` (`death_id`, `killed_by`, `level`, `is_player`) VALUES (77289, '2x Orc Spearman', 0, 0)
Message: Lost connection to server during query

[Error - mysql_real_query] Query: INSERT INTO `market_history` (`player_id`, `sale`, `itemtype`, `amount`, `price`, `expires_at`, `inserted`, `state`) VALUES (39179,0,8869,1,200000,1693783305,1691239028,255)
Message: Lost connection to server during query

I used this to go from 10s to 120s:
SET GLOBAL connect_timeout = 120;
And this to go from 30s to 120s:
SET GLOBAL net_read_timeout = 120;

I don't know if I would need to restart mysql to do it, but just running and updating the values I didn't see any results.

TFS 1.3 Downgrade
 
Back
Top