Log in

View Full Version : Question on zone crashes


Irreverent
10-08-2011, 02:08 PM
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.