[BUG] Zone starting, cannot connect

[John Adams]

I thought this was a fluke, but maybe not. I have a toon in mid-zone transfer now, left Alfa in Antonica holding that zone open, and logged in a 3rd toon to Queen's Colony.
Butcherblock is trying to load, and halting due to the excessive spawns in that zone. Queen's Colony therefore cannot start. The toon bound in that zone is getting a "something preventing you from logging in" error in the client. I see no data hitting the console during this attempt.
Are we single-threaded? Can't spawn more than one zone at a time?

[John Adams]

Actually, even with Alfa standing in Antonica holding that zone from closing, I cannot connect a second toon to Antonica at all during this Butcherblock zone load. Not sure what's going on here.

[alfa]

When you have zone my game disconnect from server. Still in game but no interaction with server was possible

[John Adams]

Literally, the moment Butcherblock finished loading, both clients resumed their connections appropriately. So this is the same thing I was yapping about in the other thread, I think. Only, I am BUGging it as a show-stopper should a zone take too long to load, it kinda renders the server inert.
From the console:
Loading new Zone 'butcherblock'
Loading 23465 spawn entries...
AddAuth: 89 Key: 1207093723
AddAuth: 89 Key: 1207093724
AddAuth: 150 Key: 1207093724
AddAuth: Unhandled command: 89 Key: afk
Zone: Removing client from ip:1207093724XXX.XXX.XXX.XXX
p[Error] Error in GetCharacterAdminStatus query 'SELECT admin_status from chara
cters where account_id=89 and id=394':
AddAuth: 89 Key: 1207093724OP_ReadyToZone: Player
JohnAddAuth: zoning to 86 Key: 1207093724butcherblock
AddAuth: 86 Key: 1207093724
Removing connection
Shutting Down Zone 'butcherblock'
1909915 New client from ip: 192.168.1.1 port: 4661
1909915 New client from ip: 192.168.1.100 port: 4311
ZoneAuth: Access Key, 1207093723, Character Name, Hanta, Account ID, 89, TimeStamp, 1207093723
Loading new Zone 'tutorial_island_good'
Resending packet #: 444
Resending packet #: 444
Resending packet #: 444
Resending packet #: 444
Resending packet #: 444
Loading 1202 spawn entries...
ZoneAuth: Access Key, 1207093724, Character Name, John, Account ID, 150, TimeStamp, 1207093724
Loading new Zone 'butcherblockZone: Removing client from ip:'
192.168.1.1 port:4311
The 89 and 150 are me, the XXX IP is alfa being booted. You cannot see the time this transpired, but it was about 15 mins, and even now almost 30 mins later, I am not in either zone. I am resetting the server.
I think I'll need to dump the spawns in those bigger zones for now, but I'd like LE to take a look if he wants to see what's going on (aside from the obvious heh).
PS: Oh, LE? The server just (cough) crashed, btw. haha... j/k. It did, but I am fairly sure I know why.

[LethalEncounter]

OK, originally the main thread was handling the loading of the spawns from the db. I'll transfer that authority to the individual zone so that it doesnt cause the server to lag. Eventually I will need to speed up the loading of the huge number of spawns to prevent zones from taking forever to load, but at least this will band aid it for now.

[John Adams]

With the index fix we discussed, this also might not be necessary... unless you can think of another scenario that might cause a bottleneck during connections?