That Zone is Unavailable

[nosfentora]

Just built Rev444, did a fresh install of db Rev438.
Only changes i've made were I moved my sql to a different server.
updated my xml with db changes.

World runs and loads fine
EQLaunch runs and loads fine, although the zones stop and restart frequently.


[04.27. - 13:56:30] [WORLD__LAUNCH] zones: dynamic_01 reported state STARTED (1 starts)
[04.27. - 13:56:52] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (1 starts)
[04.27. - 13:56:54] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (1 starts)
[04.27. - 13:56:58] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (1 starts)
[04.27. - 13:57:00] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (1 starts)
[04.27. - 14:01:54] [WORLD__LAUNCH] zones: dynamic_02 reported state STOPPED (1 starts)
[04.27. - 14:01:56] [WORLD__LAUNCH] zones: dynamic_03 reported state STOPPED (1 starts)
[04.27. - 14:02:00] [WORLD__LAUNCH] zones: dynamic_04 reported state STOPPED (1 starts)
[04.27. - 14:02:02] [WORLD__LAUNCH] zones: dynamic_05 reported state STOPPED (1 starts)
[04.27. - 14:02:06] [WORLD__LAUNCH] zones: dynamic_02 reported state STARTED (2 starts)
[04.27. - 14:02:10] [WORLD__LAUNCH] zones: dynamic_03 reported state STARTED (2 starts)
[04.27. - 14:02:14] [WORLD__LAUNCH] zones: dynamic_04 reported state STARTED (2 starts)
[04.27. - 14:02:18] [WORLD__LAUNCH] zones: dynamic_05 reported state STARTED (2 starts)


I am also unable to zone in from charselect - constantly getting 'that zone is unavailable'

the logs show:

[04.27. - 13:58:48] [WORLD__CLIENT] sgaggerj: Attempting autobootup of fearplane (72)
[04.27. - 13:58:48] [WORLD__CLIENT_ERR] sgaggerj: No zoneserver available to boot up.
[code]

[code]
---------------------------------------------
[04.27. - 13:56:25] Starting Log: logs/eqemu_debug_4756.log
[04.27. - 13:56:25] [LAUNCHER__INIT] Loading server configuration..
[04.27. - 13:56:25] [LAUNCHER__INIT] Starting main loop...
[04.27. - 13:56:25] [NET__WORLD] Connected to World: localhost:9000
[04.27. - 13:56:30] [LAUNCHER__WORLD] World told us to start zone dynamic_01.
[04.27. - 13:56:30] [LAUNCHER__WORLD] World told us to start zone dynamic_02.
[04.27. - 13:56:30] [LAUNCHER__WORLD] World told us to start zone dynamic_03.
[04.27. - 13:56:30] [LAUNCHER__WORLD] World told us to start zone dynamic_04.
[04.27. - 13:56:30] [LAUNCHER__WORLD] World told us to start zone dynamic_05.
[04.27. - 13:56:30] [LAUNCHER__ERROR] World told us to start zone dynamic_01, but it is already running.
[04.27. - 13:56:30] [LAUNCHER__ERROR] World told us to start zone dynamic_02, but it is already running.
[04.27. - 13:56:30] [LAUNCHER__ERROR] World told us to start zone dynamic_03, but it is already running.
[04.27. - 13:56:30] [LAUNCHER__ERROR] World told us to start zone dynamic_04, but it is already running.
[04.27. - 13:56:30] [LAUNCHER__ERROR] World told us to start zone dynamic_05, but it is already running.
[04.27. - 13:56:30] [LAUNCHER__STATUS] Starting zone dynamic_01
[04.27. - 13:56:30] [LAUNCHER__STATUS] Zone dynamic_01 has been started.
[04.27. - 13:56:30] [LAUNCHER__STATUS] Waiting 20000 milliseconds before booting the second zone.
[04.27. - 13:56:52] [LAUNCHER__STATUS] Starting zone dynamic_02
[04.27. - 13:56:52] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[04.27. - 13:56:52] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 13:56:54] [LAUNCHER__STATUS] Starting zone dynamic_03
[04.27. - 13:56:54] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[04.27. - 13:56:54] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 13:56:58] [LAUNCHER__STATUS] Starting zone dynamic_04
[04.27. - 13:56:58] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[04.27. - 13:56:58] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 13:57:00] [LAUNCHER__STATUS] Starting zone dynamic_05
[04.27. - 13:57:00] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[04.27. - 13:57:00] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:01:54] [LAUNCHER__STATUS] Zone dynamic_02 has gone down. Restart timer started.
[04.27. - 14:01:56] [LAUNCHER__STATUS] Zone dynamic_03 has gone down. Restart timer started.
[04.27. - 14:02:00] [LAUNCHER__STATUS] Zone dynamic_04 has gone down. Restart timer started.
[04.27. - 14:02:02] [LAUNCHER__STATUS] Zone dynamic_05 has gone down. Restart timer started.
[04.27. - 14:02:06] [LAUNCHER__STATUS] Starting zone dynamic_02
[04.27. - 14:02:06] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[04.27. - 14:02:06] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:02:10] [LAUNCHER__STATUS] Starting zone dynamic_03
[04.27. - 14:02:10] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[04.27. - 14:02:10] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:02:14] [LAUNCHER__STATUS] Starting zone dynamic_04
[04.27. - 14:02:14] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[04.27. - 14:02:14] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:02:18] [LAUNCHER__STATUS] Starting zone dynamic_05
[04.27. - 14:02:18] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[04.27. - 14:02:18] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:07:08] [LAUNCHER__STATUS] Zone dynamic_02 has gone down. Restart timer started.
[04.27. - 14:07:12] [LAUNCHER__STATUS] Zone dynamic_03 has gone down. Restart timer started.
[04.27. - 14:07:16] [LAUNCHER__STATUS] Zone dynamic_04 has gone down. Restart timer started.
[04.27. - 14:07:20] [LAUNCHER__STATUS] Zone dynamic_05 has gone down. Restart timer started.
[04.27. - 14:07:20] [LAUNCHER__STATUS] Starting zone dynamic_02
[04.27. - 14:07:20] [LAUNCHER__STATUS] Zone dynamic_02 has been started.
[04.27. - 14:07:20] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:07:24] [LAUNCHER__STATUS] Starting zone dynamic_03
[04.27. - 14:07:24] [LAUNCHER__STATUS] Zone dynamic_03 has been started.
[04.27. - 14:07:24] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:07:28] [LAUNCHER__STATUS] Starting zone dynamic_04
[04.27. - 14:07:28] [LAUNCHER__STATUS] Zone dynamic_04 has been started.
[04.27. - 14:07:28] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.
[04.27. - 14:07:32] [LAUNCHER__STATUS] Starting zone dynamic_05
[04.27. - 14:07:32] [LAUNCHER__STATUS] Zone dynamic_05 has been started.
[04.27. - 14:07:32] [LAUNCHER__STATUS] Waiting 2000 milliseconds before booting the next zone.


I know that since i've moved my db to a remote host, the world takes around 3 minutes to boot - rather than the 50 seconds it did when local.

peeking in some of the other logs i found a couple of these

---------------------------------------------
[04.27. - 13:56:58] Starting Log: logs/eqemu_debug_zone_5660.log
[04.27. - 13:56:58] [ZONE__INIT] Loading server configuration..
[04.27. - 13:56:58] [ZONE__INIT] Log settings loaded from log.ini
[04.27. - 13:56:58] [ZONE__INIT] Connecting to MySQL...
[04.27. - 13:56:58] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[04.27. - 13:56:58] [ZONE__INIT] Log settings loaded from ./log.ini
[04.27. - 13:56:58] [ZONE__INIT] Mapping Incoming Opcodes
[04.27. - 13:56:58] [ZONE__INIT] Loading Variables
[04.27. - 13:56:58] [ZONE__INIT] Loading zone names
[04.27. - 13:56:58] [ZONE__INIT] Loading items
[04.27. - 13:56:58] [ZONE__INIT] Loading npc faction lists
[04.27. - 13:56:58] [ZONE__INIT] Loading loot tables
[04.27. - 14:01:59] [ZONE__INIT_ERR] Loading loot FAILED!


any ideas?

[BWStripes]

Edit: Ignore the reply; my apologies, I thought it was referencing another error. Only thing I can suggest is to try looking at the loot entries in the database, failing that, drop it and redo from start.

[nosfentora]

it's odd as the db i am using locally was freshly done as stated.
i dumped it with navicat and sourced it to my remote db.

it *should* be 100% identical...

I was just wondering now if it's possible that the zones are timing out waiting for data somewhere....

[leslamarch]

it's odd as the db i am using locally was freshly done as stated.
i dumped it with navicat and sourced it to my remote db.

it *should* be 100% identical...

I was just wondering now if it's possible that the zones are timing out waiting for data somewhere....
read my post in this thread (http://www.eqemulator.net/forums/showpost.php?p=164318&postcount=7) and see if this fixes it for you.

[nosfentora]

i swapped all db info in the xml and everything loads ok as with the remote db (albeit faster) and no "crashes" or zone-rebooting.
just downloaded and build 445 so we'll see if that changed anything.

i'll try that eqlaunch and see what happens. (mine's 134k from 12/17/2008)

[nosfentora]

Still getting the same thing when using a remote db -

seeing the same Loading Loot FAILED errors.... with the multiple zone restarts.