Mangos freeze on Loading Creature Data

[Iowahc]

Hy there. I trying to start my mangos-worldd.

It gets stuck on following:

Loading Creature Data...

[3 ms] SQL: SELECT creature.guid, id, map, modelid,equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint,curhealth, curmana, DeathState, MovementType, spawnMask, phaseMask, event, pool_entry FROM creature LEFT OUTER JOIN game_event_creature ON creature.guid = game_event_creature.guid LEFT OUTER JOIN pool_creature ON creature.guid = pool_creature.guid

Yesterday everything went fine

EDIT: Damn... wrong forum Mod could you move this?

[Iowahc]

Nevermind, just applied a backup and updated again. Works like a charm

[False.Genesis]

this can happen for example if you test on a slow and not properly configured localhost mysql installation. if mysql doesnt have enough ram simple update queries can take 100ms or more to execute, and such ones... long.

if this happens again try giving mysql a bit more ram (edit conf) and check for innodb datafiles fragmentation.

(had this problem on my notebook and got it solved like this)