MySQL server has gone away

[Marik]

Hi folks,

I've tried the modified ScriptDev2 from RSA (http://github.com/rsa/scriptdev2/commits/master), where the spells are saved in a table.

The framework loads all spellentrys at runtime.

Unfortunatelly, sometimes (i cannot find some kind of order, it just happens sometimes [maybe the server runs for a too long time?]) i get an mysql error:

2010-10-11 11:16:39 SQL: SELECT entry, spellID_N10, spellID_N25, spellID_H10, spellID_H25, timerMin_N10, timerMin_N25, timerMin_H10, timerMin_H25, timerMax_N10, timerMax_N25, timerMax_H10, timerMax_H25, data1, data2, data3, data4, locData_x, locData_y, locData_z, varData, StageMask_N, StageMask_H, CastType, isVisualEffect, isBugged, textEntry FROM `boss_spell_table` WHERE entry = 34796;

2010-10-11 11:16:39 query ERROR: MySQL server has gone away

The server runs without other errors.

If i type the query in a mysql console (e.g. navicat), the query works fine.

The reason, why i've created a thread in this forum, is because the framework from RSA uses the standard database access from mangos. So I expect the error in the mangos software not in the scriptdev framework.

Maybe someone has an Idea.

Thanks in Advice

Marik

Edit: I Use the standard Mangos Core with some Modification to run rsa's sd2:

http://www.file-upload.net/download-2882159/muh.patch.html

[iRelax]

Mysql server has gone away = to long no sql ping to mangos.exe I had often when my server had only little people

Use the Game Event checker to ping your sql server.

[Marik]

So, whats the solution to let the mysql server "come back" ?

I Mean what code can I use too test it and thus reconnect the mysql server with the gameserver?

I would add this code beforce every Query.

[Marik]

Hi,

now i've changed the wait_timeout system variable (in my mysqlserver) from 8 houts to 7 Days.

I guess that will prevent my "server gone away" problem.

Thanks

[Kroket]

lmfao 7 days, gf

[Whyarp]

im getting the same thing, but not with any modifications other than ahbot..

could you explain how to change the wait_timeout setting?

i have checked the c:\\windows\\my.ini and there is no wait_timeout there or in the program files directory for mysql...

thanks