That Zone is Unavailable

nosfentora · #1 04-27-2009, 02:21 PM

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.

Code:

[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:
[code]
[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

Code:

---------------------------------------------
[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 · #2 04-27-2009, 03:13 PM

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 · #3 04-27-2009, 03:28 PM

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 · #4 04-27-2009, 03:47 PM

Quote:

Originally Posted by 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....

read my post in this thread and see if this fixes it for you.

nosfentora · #5 04-27-2009, 03:52 PM

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/200

nosfentora · #6 04-27-2009, 04:19 PM

Still getting the same thing when using a remote db -

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