4.3.4 v11 issue

[felarrond]

I've had a server running for a little over 24 hours without issue. Myself and a friend from Australia were playing. I modified the AHBOTOPTIONS to produce a large auctionhouse pool to select from. Upon rebooting the server I realized I hadn't correctly configured AHBOT to have a GUID and accountID so I did that and cleared the auctionhouse table in the database. The server booted normally and I was able to login, but after about a minute the server became unresponsive in game. I saw the following in the server console window:

ERROR [spells] Player::addSpell: Non-existed in SpellStore spell #810 request.
ERROR [sql.sql] Enchantment id #289 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #284 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #275 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #285 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [server.worldserver] World Thread hangs, kicking out server!

d:\zealotpureblizzlike\v11\core-v11\src\server\worldserver\master.cpp:107 in FreezeDetectorRunnable::run ASSERTION FAILED:
  false
[0x5cf4fe]
ACE_OS_Thread_Adapter::invoke()+0xa1 [0x0]
o_iswdigit()+0x5f [0x0]
BaseThreadInitThunk()+0x19 [0x0]
RtlGetAppContainerNamedObjectPath()+0xe4 [0x0]
RtlGetAppContainerNamedObjectPath()+0xb4 [0x0]

ERROR [sql.sql] Enchantment id #273 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #289 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #274 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #277 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #276 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #288 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #280 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #290 used but it doesn't have records in 'ItemRandomProperties.dbc'
ERROR [sql.sql] Enchantment id #285 used but it doesn't have records in 'ItemRandomProperties.dbc'

The sql errors I'm assuming aren't that serious, but the error in the middle is what I believe is making me unable to play now. Any help with this would be appreciated.

EDIT: I should note that I can auth with the server but it stays stuck on Connected. I can no longer enter the game world. Also, the worldserver.exe continues to list the sql errors ad nauseam, and a control-c does not sequence break the daemon, you have to click on the red x to close the window.

 

[felarrond]

Found this in crash logs folder, so thought I'd add.

Revision: EmuCoach ver. 5a53aed8bc72+ 2019-08-05 23:29:48 +0200 (master branch) (Win32, Release)
Date 26:10:2019. Time 14:3 
//=====================================================
*** Hardware ***
Processor: AMD Ryzen Threadripper 1950X 16-Core Processor 
Number Of Processors: 32
Physical Memory: 4194303 KB (Available: 4194303 KB)
Commit Charge Limit: 4194303 KB

*** Operation System ***
Windows 8 Professional (Version 6.2, Build 9200)

//=====================================================
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 004312B3 01:000302B3 C:\EmuCoach\worldserver.exe

Registers:
EAX:00000152
EBX:00046501
ECX:8D97384C
EDX:7601F350
ESI:000004B1
EDI:3A747A70
CS:EIP:0023:004312B3
SS:ESP:002B:5351E780 EBP:5351F88C
DS:002B ES:002B FS:0053 GS:002B
Flags:00010212

Call stack:
Address Frame Function SourceFile
004312B3 00000000 0001:000302B3 C:\EmuCoach\worldserver.exe
009CF4FE 00000000 0001:005CE4FE C:\EmuCoach\worldserver.exe
623F7EE1 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+A1
75F5248F 00000000 _o_iswdigit+5F
760D6359 00000000 BaseThreadInitThunk+19
77CD7B74 00000000 RtlGetAppContainerNamedObjectPath+E4
77CD7B44 00000000 RtlGetAppContainerNamedObjectPath+B4
========================
Local Variables And Parameters

Call stack:
Address Frame Function SourceFile
004312B3 00000000 0001:000302B3 C:\EmuCoach\worldserver.exe

009CF4FE 00000000 0001:005CE4FE C:\EmuCoach\worldserver.exe

623F7EE1 00000000 ?invoke@ACE_OS_Thread_Adapter@@UAEKXZ+A1

75F5248F 00000000 _o_iswdigit+5F

760D6359 00000000 BaseThreadInitThunk+19

77CD7B74 00000000 RtlGetAppContainerNamedObjectPath+E4

77CD7B44 00000000 RtlGetAppContainerNamedObjectPath+B4

========================
Global Variables

 

[liberator35856]

How many items do you have the ahbot add per cycle? its the AuctionHouseBot.ItemsPerCycle = 200 line in the config? This was happening to me when I changed it to 500 and the min and max items in the world server. I can still play though just by letting the server do its thing for a few minutes after starting it before I try to login though

 

[felarrond]

How many items do you have the ahbot add per cycle? its the AuctionHouseBot.ItemsPerCycle = 200 line in the config? This was happening to me when I changed it to 500 and the min and max items in the world server. I can still play though just by letting the server do its thing for a few minutes after starting it before I try to login though

Can't rememberr exactly what I set it to, but it was pretty high. My mins and maxes are high in game but that didn't seem to cause a problem. When I reverted the accout and guid back to 0 and itemspercycle back to 200 it's now letting us in, so it's probably just something i caused customizing the config.

Still getting a ton of sql.sql errors but I think those are fairly normal.

 

[liberator35856]

The sql errors do seem to be normal, especially the ones about the enchantments. Glad it let you back you though, I have never changed the account guid since I first configured mine so that could be it