massive Zone Unavalable errors +more

[ChaosSlayer]

ok found something what could be interesting, and prety much cuases the error, however I am at a loos how to fix it.
Apparetnly it desperatly looking for specific spawn2 ID which however is not used in any other table. I am not mySQl expert - but the local IDs of spawn2 table are mapping to anywhere? Is there a pattern to this numbers?
I was under impression they could be deleted at will or changed.

---------------------------------------------
[02.08. - 01:45:18] Starting Log: logs/eqemu_error_zone_2212.log
[02.08. - 01:45:18] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:18] Loading zone state failed.
[02.08. - 01:45:32] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:32] Loading zone state failed.
[02.08. - 01:45:34] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:34] Loading zone state failed.
[02.08. - 01:45:35] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:35] Loading zone state failed.
[02.08. - 01:45:36] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:36] Loading zone state failed.
[02.08. - 01:45:37] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:37] Loading zone state failed.
[02.08. - 01:45:39] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:39] Loading zone state failed.
[02.08. - 01:45:40] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:45:40] Loading zone state failed.
[02.08. - 01:46:14] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:46:14] Loading zone state failed.
[02.08. - 01:46:16] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:46:16] Loading zone state failed.
[02.08. - 01:47:48] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=332456':
[02.08. - 01:47:48] Loading zone state failed.
[02.08. - 01:48:34] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=16451159':
[02.08. - 01:48:34] Loading zone state failed.

[ChaosSlayer]

ok this getting ridiculus I am got a brand new PEQ DB, copied over my own spawn info (spawn2, spawnentry and spawngroup) from my old backedup DB, and I am still getign the same stupid error!

---------------------------------------------
[02.09. - 00:56:04] Starting Log: logs/eqemu_error_zone_1244.log
[02.09. - 00:56:04] Error in LoadSpawn2 query 'SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=332456':
[02.09. - 00:56:04] Loading zone state failed.

I have no idea WHY in the world I woudl get this error if in my original DB these values never existed to begin with.
The program keep trying to pull up something which is not referenced ANYWHERE!

[ChaosSlayer]

ok i did some mySQl manual reading - it seesm that problem is with the spawn2 table.

The table is InnoDB type - and from I understand this thing CANNOT BE just backed up, cuase the IDs of the primary key writen into file are not REAL IDs.
And if you EVER do any changes - like delete an entry and then back up the DB And if DB is later restored from backup - the whole thing (since it uses internal index table which is not shown to the user) and discover than enetry that supose to follow does nto exist - the whole thing crashes...

This mayby not very accurate (I am not mySQl expert), but i belive the problem is how to PROPERLY backup spawn2 table which was in any way altered so it will actualy WORK after restore..

Any mySQl experts can help with this????

[ChaosSlayer]

ok, this cost me a few grey hair (well few hair...), but with little mySQl expert help we solved this one....

PEOPLE!!! If you EVER delete or move ANY values in spawn2 tables using 1090 server build (INCLUDING using GeorgeS spawn editing tool) TURN OFF zone persistant state! Otherwise you will spend next 5 days drawing in error codes....

[Yeormom]

Thanks for sharing!

I spent longer than I should have looking for why the zone was trying to load a spawn with an id in the billions...