Windows [MySQL] Error randomly.

[Loney]

I have a big problem in MySQL and i don't expect what's the problem of this. MySQL is losing connection randomly like 2-24 hours.
Here's a screen of the problem:

Thank you.

 

[Sirion_Mido]

i think problem on tfs try to change it or restart database

 

[Loney]

Isn't TFS, I already tested it.
I know that's a db problem, but maybe execute some query or missing table, something like that?

Thanks anyways.

 

[Cronox]

Try put this values in your config.lua
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

 

[sn3ejk]

Is it latest trunk?

 

[Loney]

@Cronox; Not working, but Thanks anyways
@up: 3771

Thanks in advance

 

[Cronox]

You have attacks Ddos? or other UDPS, ETC?

 

[Loney]

I don't think so, because only the server lose connection to MySQL, and the players can't save when logout, so in the lapse that the server didn't reseted, the players lose the level advanced, etc.

Thanks

 

[Cronox]

Yes why lost conection database.. attacks Ddos or UDP reduce your internet conection and have lost conection database..
or have this error.. in database player ID 451 have in online - more 0 - 1, etc.. try add

update players set online = 0;

need have shutdown server.. for save
or

UPDATE players SET online = 0 WHERE player_id = '451' LIMIT 1

-- edit bad line in account need edit player_id why are player_id 451.. update players in set online 0 ;p

 

[Sirion_Mido]

Yes why lost conection database.. attacks Ddos or UDP reduce your internet conection and have lost conection database..
or have this error.. in database player ID 451 have in online - more 0 - 1, etc.. try add

update players set online = 0;

need have shutdown server.. for save
or

UPDATE players SET online = 0 WHERE name = 'accountname' LIMIT 1

search ID 451 in players.. and player look account and see what account have for changed accountname in query

@Cronox My Dream See You Help Member And Solve His Problem

 

[Loney]

Thanks for your advice Cronox, I will try it soon.