Sql has gone away problem

[Fresh prince]

Hello rathena, im having this problem for quite some time now and it is just reallly aggrevating evrytime it happens. I had to restart my server to keep evrything up and running again. I have a few question or should i address it as i just want to have a second opinion cause a good friend of mine told me that my solution will pretty much corrupt my dbase.

Founded probable solution;

Lower "wait_timeout"

Heres the prob:

: DB error - MySQL server has gone away

[Debug]: at int_guild.c:247 - REPLACE INTO `guild_member` (`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,

Then we cannot connect. It says rejected from server(3).

The char server went down obviously. I have search to the best of my ability and found the solution of lowering the number on "wait_timeout" which ours has 28800.

My question is, is there a consequence on lowering that down? Would it affect my logs? Or better yet, would that ultimately resolve my char server disconnection problem?

PleAse give me a hand here guys. Thank you very much.

Edited May 6, 2013 by Fresh prince

[Jaburak]

trunk/src/common/sql.c

/// @return the keepalive timer id, or INVALID_TIMER
/// @private
static int Sql_P_Keepalive(Sql *self)
{
uint32 timeout, ping_interval;

// set a default value first
timeout = 3600; // lowest number I found that my server did not disconnect

// request the timeout value from the mysql server
//Sql_GetTimeout(self, &timeout); <removed this as it gave a higher number and kept disconnecting and you are already giving the variable.

if (timeout < 60)
timeout = 60;

[Fresh prince]

Sir ive seen this solution but what could possibly go wring if i change it to 3600? Woul the mess up by data base? Correct me if im wrong, it would try to check evry a few seconds that it might mistakenly be treated as DDOS attack?

Thanks for replying

Or could you kindly explain what your reply means? I really appreciate your help thank you!

_____________________________________

edit:

So i changed 28800 to 3600. Evrything went fine for about 5 hours or so then suddenly froze the server the a "reject from the server" when you log in. It kicked evryone out.

On the map server output, it says

session timeout#9

Could anyone possibly Please shed light on this kind of nightmare? Thank you

Edited May 7, 2013 by Fresh prince

[Jaburak]

Sir ive seen this solution but what could possibly go wring if i change it to 3600? Woul the mess up by data base? Correct me if im wrong, it would try to check evry a few seconds that it might mistakenly be treated as DDOS attack?

Thanks for replying

Or could you kindly explain what your reply means? I really appreciate your help thank you!

_____________________________________

edit:

So i changed 28800 to 3600. Evrything went fine for about 5 hours or so then suddenly froze the server the a "reject from the server" when you log in. It kicked evryone out.

On the map server output, it says

session timeout#9

Could anyone possibly Please shed light on this kind of nightmare? Thank you

What client are you using?

[Fresh prince]

2012-04-10

my Server administration goes like this after the change.

[Jaburak]

2012-04-10

my Server administration goes like this after the change.

 

Try to add this to your db/packet_db.txt

Find:

//2012-04-10aRagexeRE
packet_ver: 30

 

Add this below:

0x08c9,2

[Fresh prince]

Thanks! Could you please tell me what are those for?

bump