Server stopped responding

It seems to be working on my server, however, I'm seeing a consistent error.

"Database<3790/1>: [Warning] Connection lost <MySQL server has gone away> during MySQLQuery SQL: 'SELECT 1', retrying...."

seems like it may need some additional testing, but it is working alright.
 
That's a warning, not an error.
Errors are marked with [Error]
After that warning you should have a "Reconnected with..." message that says everything is back on track
This is caused by the wait_timeout being too low in your mysql server configuration
 
Of course it's a warning, that's what its labelled as. What would you recommend that value be set to? Mine is currently set to 15. Would 30 be an acceptable timeout?
 
The default is 28800 seconds, which is 8 hours...
Set it to amount of time you think your server will be empty for + 20%
10 minutes is ok so make it like 600
 
Alright, I will give that a try and see what happens. However, I have a new issue... when starting the server it hangs at "Executing spawn script...". If I hit Ctrl+C, and do not terminate the batch job it seems to start fine. It also seems to be running the spawn script, as I can delete a line in the object data and it still gets created. In the past when I had changed default vehicle values, it had done this, but I haven't changed anything so it is a mystery.
 
So the only thing that changed was the updated hivefiles and the spawn script doesn't start. Does this just magically happen? Is there a log file showing what the script could be stopping on that I could even start troubleshooting with?
 
put a bug fix comes out -2012-11-26 17:00:58 Database: [Warning] Error 1406 (Data too long for column 'Medical' at row 1) in MySQLQuery SQL: 'UPDATE `Character_DATA` SET `Backpack` = '[\"DZ_ALICE_Pack_EP1\",[[],[]],[[\"ItemSodaPepsi\",\"ItemSodaCoke\",\"FoodCanFrankBeans\",\"FoodCanSardines\",\"30Rnd_762x39_AK47\",\"30Rnd_556x45_Stanag\",\"FoodCanBakedBeans\",\"ItemBloodbag\",\"ItemMorphine\",\"ItemJerrycanEmpty\",\"HandChemGreen\"],[1,1,2,1,1,1,2,2,3,1,1]]]' , `CurrentState` = '[\"Winchester1866\",\"adthppnemstpsraswrfldnon_1\",100]' , `Inventory` = '[[\"Binocular\",\"Makarov\",\"ItemFlashlight\",\"ItemWatch\",\"ItemMatchbox\",\"ItemCompass\",\"ItemMap\",\"ItemKnife\",\"ItemToolbox\",\"Winchester1866\"],[\"10x_303\",\"10x_303\",\"10x_303\",\"ItemSodaCoke\",\"ItemPainkiller\",\"10x_303\",\"10x_303\",\"ItemSodaPepsi\",\"ItemSodaCoke\",\"ItemPainkiller\",\"Skin_Survivor2_DZ\",\"8Rnd_9x18_Makarov\",\"ItemBandage\",\"ItemBandage\",\"6Rnd_45ACP\",\"8Rnd_9x18_Makarov\",\"6Rnd_45ACP\",\"6Rnd_45ACP\",\"8Rnd_9x18_Makarov\"]]' , `Medical` = '[false,false,false,true,true,false,true,312.219,[\"aimpoint\",\"RightFoot\",\"LeftFoot\",\"neck\",\"pilot\"],[11.328,0],0,[849.922,523.77]]' , `Model` = 'Sniper1_DZ' , `Worldspace` = '[81,[9411.09,8922.81,0.001]]' WHERE `CharacterID` = 7955' , retrying...
 
You are using an ancient SQL schema, see opendayz.net/index.php?threads/dayz-private-server-files-pack-1-7-4-4-all-current-maps-not-updated.28/page-2#post-4246
Increasing the field lengths for entries marked IMPORTANT will fix it.
 
Getting crashes again, here's the end of my report file.

Fault address: 766FC41F 01:0000B41F C:\Windows\syswow64\KERNELBASE.dll
file: dayz_1_spec
world: Chernarus
Prev. code bytes: 0C EB 03 89 45 C0 8D 45 B0 50 FF 15 5C 11 6F 76
Fault code bytes: C9 C2 10 00 CC CC CC CC CC 8B FF 55 8B EC 56 8B

Registers:
EAX:0097EF28 EBX:111FD870
ECX:00000003 EDX:00000000
ESI:067984E0 EDI:00000000
CS:EIP:0023:766FC41F
SS:ESP:002B:0097EF28 EBP:0097EF78
DS:002B ES:002B FS:0053 GS:002B
Flags:00000216
=======================================================
error: Minidump is unavailable, dlghelp.dll load error...
Click to expand...

Everything above that was from my server loading.
 
Stapo, your fix is working great so far. several houra uptime, lets see if it holds overnight
 
I'm away from my PC but my server is down so probably crashed. I will check the logs when I'm home but I know it was empty for atleast 1 hour; however overnight it didn't crash when i left myself idle in the lobby (coincidence?). Next time i'll leave myself lobbied again and see what happens.

I'm also going to start using KNAS restarter 2.0 to execute a server restart script if arma2server.exe stops responding. I will paste my restart.bat file below once I am home so you can see what I've done.

KNAS restarter 2.0: w w w.knas.se/Applications/Restarter.aspx




EDIT: Nevermind, it was shitty windows forcing a restart for update. Turned that crap off now. Your patch works Stapo, +10000000!
 
Latest version of HiveExt which should fix all these hangs and crashes (and also adds some features too):
github.com/downloads/R4Z0R49/DayZMod/HiveExt_f0.9.6.10_p0.8.0.4.zip
(also mentioned on the issue page of github.com/R4Z0R49/DayZMod/issues/115)
 
rajkosto said:
Latest version of HiveExt which should fix all these hangs and crashes (and also adds some features too):
github.com/downloads/R4Z0R49/DayZMod/HiveExt_f0.9.6.10_p0.8.0.4.zip
(also mentioned on the issue page of github.com/R4Z0R49/DayZMod/issues/115)
Click to expand...

to my present this error

solucionar.png


triying reconect the server but fail HiveExt
with the new Fixed :( please help!
 
dayzphban said:
no I have not, but how could I?
Click to expand...

Make sure you edit the file with your settings for the server...

Code: 
[Database]
;Hostname or IP of the server to connect to
;You can use the value "." (without quotes) to indicate named-pipe localhost connection
;If you leave this line commented or blank, HiveExt will connect to the OFFICIAL Hive, which requires registration
;See support.dayzmod.com for more information on what OFFICIAL Hive means, what are the rules, etc.
;If using OFFICIAL hive, the rest of the settings in this section have no effect
Host = 127.0.0.1
 
;Currently, only MySQL is supported
Type = MySQL
 
;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = 3316
 
;Database name to connect to.
Database = hivemind
 
;Username to connect with
Username = root
;Password to authenticate with (default is blank)
Password = root
 
You must log in or register to reply here.
Back
Top