Lost connection to MySQL server during query - CRASH

[Kaboo]

Hey guys, my server has started to crash frequently in the last days, and today this was in the console, when it crashed:

mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)

Is there any solution for this? I'm using TFS 0.3.5 (Crying Damson), and my MySQL version is 5.1.42.
Here's my config.lua, if it's needed:

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "USER"
sqlPass = "XXXXXXXXX"
sqlDatabase = "otserv"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
passwordType = "plain"

Thank you!

 

[Rozinx]

try setting all timeouts to 0

 

[Kaboo]

try setting all timeouts to 0

Thanks, I've changed the following lines:

sqlKeepAlive = [B]1[/B]
mysqlReadTimeout = [B]0[/B]
mysqlWriteTimeout = [B]0[/B]

Now I'm going to see what happens in the next hours...

If anyone knows something else, post it, please!

 

[Kaboo]

Thanks, I've changed the following lines:

sqlKeepAlive = [B]1[/B]
mysqlReadTimeout = [B]0[/B]
mysqlWriteTimeout = [B]0[/B]

Now I'm going to see what happens in the next hours...

If anyone knows something else, post it, please!

Didn't work, it is still crashing.

 

[Kaboo]

Today I've updated my MySQL to the last version - 5.1.48, but my server is still crashing.

If someone knows something about it, please post it! :thumbup:

 

[Kaboo]

Bump...

 

[5mok3]

bring this up..

it happens to a lot of us

 

[BeniS]

happened to me a lot too

 

[Rexxar]

sqlKeepAlive = 1
mysqlReadTimeout = 600
mysqlWriteTimeout = 600

Try that and see if it makes anything better... If not you may have to start messing around with the MySQL database settings regarding timeouts.

 

[5mok3]

still..

any help?

 

[Kaboo]

sqlKeepAlive = 1
mysqlReadTimeout = 600
mysqlWriteTimeout = 600

Try that and see if it makes anything better... If not you may have to start messing around with the MySQL database settings regarding timeouts.

I've tried to reinstall Windows, tried to use a backup of my database of two weeks ago, and I also tried to open the server without apache but without success

 

[Fallen]

make a script to restart apache after connection lose:
sudo /etc/init.d/apache2 restart

 

[Rexxar]

Hm... Are you sure the MySQL service/process is still running when this error occurs?

 

[Kaboo]

Hm... Are you sure the MySQL service/process is still running when this error occurs?

Yes, look:

# mysqladmin -u root -p version
Enter password: *
mysqladmin  Ver 8.42 Distrib 5.1.48, for Win32 on ia32
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.48-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
[B]Uptime:                 17 hours 24 min 2 sec[/B]

Threads: 1  Questions: 497159  Slow queries: 9  Opens: 1631  Flush tables: 1  Op
en tables: 28  Queries per second avg: 7.936

 

[Rexxar]

MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away

Maybe this can give you some clues as to what happens?
I'd suggest increasing the timeout to 24 hours or more, that way it should essentially never time out.

Suggested this in another similar topic, maybe it would be of relevance to you?

 

[Kaboo]

Suggested this in another similar topic, maybe it would be of relevance to you?

Thanks, i'll read it.

 

[5mok3]

I'm reading it too.. ill let you guys know if it helped

you le tme know too kaboo

 

[Kaboo]

I'm reading it too.. ill let you guys know if it helped

you le tme know too kaboo

Ok, i'll post anything! Thanks!

 

[Rufo]

Any help? happens to me a lot too, and when i restart the server it starts randomly to crash, but suddenly stops and continue working...

 

[MxSoft]

always happens this to me, and then says error saving player, and i cant log in, saying that i have and invalid acc