EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Question on zone crashes (https://www.eqemulator.org/forums/showthread.php?t=34303)

Irreverent 10-08-2011 02:08 PM

Question on zone crashes
 
Going through my logs, i don't see much but one thing I haven't noticed before is in the quest log I get a last line of

"Loading perl commands..."
"Terminating on signal SIGHUP(1)"

I know its a signal hang up, so guessing this is what is causing the crash? I'm using 2022 db/code + perl 5.10(1008) on C++ 2008 Express

Irreverent 10-08-2011 03:27 PM

Additionally, when a zone crashes...you quickly see a "Zone connect:whateverzonecrashed"

Could this have something to do with instancing?

Since I did the DB merge with 2022 this started...the code didn't change. So guessing its something db related. Zone are from any of the expansions.

Irreverent 10-08-2011 03:50 PM

I noticed a lot of hung queries on my db server.

select ml.npcid, ml.slot, ml.itemid, ml.charges from merchantlist_temp ml, spawnentry se, spawn2 s2 where ml.npcid=se.npcid and se.spawngroupid-s2spawngroupid and s2.zone = 'whateverzoneitwasin'

Irreverent 10-08-2011 04:48 PM

Purging the temp merchlist seems to have done the trick...crossing fingers.

But, strange find if anyone has had issues with a sync.


All times are GMT -4. The time now is 04:32 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.