Linux Mysql Problem

[5mok3]

Every once in a while my server suddenly stops working.. the server is online but players can't log back in-game

I once saw this error in my screen

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

Obviously it has something to do with it..

I already tried shit i found in other forums.. upgrading the packages, increasing mysql cache.. etc but i this shit keeps fucking happening

If anyone knows something.. anything please let me know ASAP!!!!

 

[5mok3]

hey?

 

[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.

 

[5mok3]

i get this error..

mysql_real_query(): UPDATE `accounts` SET `premdays` = 58, `warnings` = 0, `lastday` = 1280116330 WHERE `id` = 2 LIMIT 1; - MYSQL ERROR: Lost connection to MySQL server during query (2013)

 

[Rexxar]

Did you try increasing the timeout to 24 hours?

 

[Don Daniello]

Where is your mysql server ? Is it localhost'ed or somewhere away ?

 

[5mok3]

@Rexxar i did tried that.. even set max_allow_packets or watever

@up
In a dedicated server

 

[Rexxar]

Do you host on your computer while the database is on a remote server somewhere else? Or is the server located on the same physical machine as the MySQL server?

 

[5mok3]

Are you kidding me? i know you are trying to help..

but obviously.. mysql server.. apache.. my game files are all in the same server

 

[Rexxar]

Are you kidding me? i know you are trying to help..

but obviously.. mysql server.. apache.. my game files are all in the same server

Not that obvious considering I've hosted plenty of servers and websites where the database were on a different location than the (web)server. Hell that's one of the main reasons people use MySQL rather than local DB solutions.

And if the MySQL server was hosted remotely, an outgoing firewall could be blamed.

Anyways... I'm starting to run out of ideas for now, either it's an issue with MySQL itself, or somekind of inter-connectivity problem between MySQL and the server.
I could ask you to check your IPtables, but I'm not Linux ace so I have no idea if they have anything to do with connections made through localhost.
You could however turn on MySQL logging and examine the logs made during the time of the error, see if they reveal some error of somekind related to why MySQL decides to suddenly drop its connection with your server.

 

[Don Daniello]

1. Come back to default values in config.lua

sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10

2. Get rid of any scripts you've added that use mysql (some added recently that you might consider to be buggy)
3. Reinstall mysql server with default configuration

aptitude purge mysql-server-5.1
aptitude install mysql-server-5.1

 

[MxSoft]

i got the same issue in my ot, i hate it! did u get a solution for that?

 

[5mok3]

nop.. no solution yet