• 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!

TFS 1.X+ Lost connection to server during query

peteralto

Member
Joined
Nov 1, 2020
Messages
93
Solutions
1
Reaction score
19
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