Linux TFS 0.4 Mysql connection lost always in the mornings? around 7-8:00 CET

[Linken93]

Hello!

I've got this problem that my server is losing connection with the mysql database in the mornings. Im hosting at a VPS company. Could It be that?

 

[Linken93]

bump

 

[lizudus]

Mate A friend of me had this problem too he changed from 0.4 to 0.3.6pl1 and he have now more then 100hour uptime

 

[Linken93]

Mate A friend of me had this problem too he changed from 0.4 to 0.3.6pl1 and he have now more then 100hour uptime

Where can I download 0.3.6?

 

[Evil Puncker]

http://otland.net/f18/8-54-forgotten-server-0-3-6pl1-crying-damson-59924/

 

[Linken93]

I just saw that another guy who is hosting at same company as me , using 0.3.6 so it wont solve the problem anyway.

 

[Balicuss]

in config.lua change value on:

sqlKeepAlive = 0
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

 

[domelxp]

nooo man look

[22:2:04.489] mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[22:2:04.489] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: MySQL server has gone away (2006)

you delete from your database bans with tipe 1 becouse this is ban for ip always when ban expires you will lose conetction with database
solution >>>v
so enter to your database and detete all bans and remember to do not give more bans for ip
beafore delete bans make save becouse you will lose conection with database last time
an after you will no have this problem more

rep if im help

 

[Linken93]

I dont think it's anything with Ip ban , since I have just ip banned one person and this happend before it also. But I removed all type 1 bans now.

Should I try this also?

sqlKeepAlive = 0
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

 

[dgprado]

You heave to configure the mysql to work with a large number of connections, becouse the default settings are too small. Encrease max_allowed_connections, innodb buffer, max_allowed_packet and meybe another settings.

Dont do it:
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

if some query take much time you will loose the connection too, you just heave to increase you php settings, i had this problem too, but now only sometimes my server lost connection becouse i use windows, and win dont work very well with a lot of connections.

 

[domelxp]

yes try . its my solution ..... and its works . belive me

 

[Cykotitan]

increase you php settings

php

0/10

 

[Linken93]

yes try . its my solution ..... and its works . belive me

I believe this worked? Uptime: 41 hours and 32 minutes.

 

[TaurenLess]

MySQL Bugs: #1370: ERROR 2013: Lost connection to MySQL server during query.

Same problem my....

Xampp

cd ../../xampp/mysql/bin
mysql -uroot -p
you password
SET @@NET_READ_TIMEOUT=1000;
show variables like "%timeout%";

See if it solves :$

 

[dgprado]

0/10

If you are so cleaver why you dont give an solution for that man ?

 

[domelxp]

so u use my solution ? and its work ? yes ?

 

[Linken93]

so u use my solution ? and its work ? yes ?

Im not sure man , Can't answer if the hoster improved or this were working. It lost connection again after 58 hours..

 

[Lbtg]

well i use also cheapvps and dont have this problem like you guys.

 

[Pietia]

it's known problem of TFS somewhere the code must be messed up , when I changed to other engine in my case it was OTServ it has never happened again.

 

[Cykotitan]

then how come nobody knows what rev did it start happening at? yes, 0.4 is affected only

 

[Pietia]

then how come nobody knows what rev did it start happening at? yes, 0.4 is affected only

I had it on all 0.3 versions when I was using TFS ,0.2 isn't affected.