Doing an update then CRUSH!

[rlie_0]

Hey guys, so I did the update to get buffs to hold when you zone vs losing the buffs when you zoned each time. after getting my server backed up, i did the update, loaded it up, logged in everything about my server bysides accounts, names, items on players was gone / altered/ changed.

I went in and droped the tables (mobs, starting items, starting zones, grid entries, items, and loot tables) and replaced them with my servers, and this happened when i attempted to reload the server with my server settings.


[07.18. - 13:32:20] Starting Log: logs/crash_shared_memory_3808.log
[07.18. - 13:32:20] EXCEPTION_ACCESS_VIOLATION
[07.18. - 13:32:20] SymInit: Symbol-SearchPath: '.;C:\EQ\EQEmuServer;C:\EQ\EQEmuServer;C:\Windows; C:\Windows\system32;SRV*C:\websymbols*http://msdl.microsoft.com/download/symbols;', symOptions: 530, UserName: 'Meself'
[07.18. - 13:32:20] OS-Version: 6.1.7601 (Service Pack 1) 0x300-0x1
[07.18. - 13:32:20] C:\EQ\EQEmuServer\shared_memory.exe:shared_memory. exe (00D80000), size: 4853760 (result: 0), SymType: 'PDB', PDB: 'C:\EQ\EQEmuServer\shared_memory.exe'
[07.18. - 13:32:20] C:\Windows\SysWOW64\ntdll.dll:ntdll.dll (77E50000), size: 1572864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\ntdll.dll', fileVersion: 6.1.7601.18247
[07.18. - 13:32:20] C:\Windows\syswow64\kernel32.dll:kernel32.dll (77940000), size: 1114112 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\kernel32.dll', fileVersion: 6.1.7601.18409
[07.18. - 13:32:20] C:\Windows\syswow64\KERNELBASE.dll:KERNELBASE.dll (76230000), size: 290816 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\KERNELBASE.dll', fileVersion: 6.1.7601.18409
[07.18. - 13:32:20] C:\Windows\syswow64\WS2_32.dll:WS2_32.dll (75FC0000), size: 217088 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\WS2_32.dll', fileVersion: 6.1.7601.17514
[07.18. - 13:32:20] C:\Windows\syswow64\msvcrt.dll:msvcrt.dll (77510000), size: 704512 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\msvcrt.dll', fileVersion: 7.0.7601.17744
[07.18. - 13:32:20] C:\Windows\syswow64\RPCRT4.dll:RPCRT4.dll (77850000), size: 983040 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\RPCRT4.dll', fileVersion: 6.1.7601.18205
[07.18. - 13:32:20] C:\Windows\syswow64\SspiCli.dll:SspiCli.dll (75860000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SspiCli.dll', fileVersion: 6.1.7601.18496
[07.18. - 13:32:20] C:\Windows\syswow64\CRYPTBASE.dll:CRYPTBASE.dll (75850000), size: 49152 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\CRYPTBASE.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\SysWOW64\sechost.dll:sechost.dll (771E0000), size: 102400 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\SysWOW64\sechost.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\syswow64\NSI.dll:NSI.dll (758C0000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\NSI.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\system32\VERSION.dll:VERSION.dll (75780000), size: 36864 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\VERSION.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\syswow64\USER32.dll:USER32.dll (75C30000), size: 1048576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USER32.dll', fileVersion: 6.1.7601.17514
[07.18. - 13:32:20] C:\Windows\syswow64\GDI32.dll:GDI32.dll (773E0000), size: 589824 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\GDI32.dll', fileVersion: 6.1.7601.18275
[07.18. - 13:32:20] C:\Windows\syswow64\LPK.dll:LPK.dll (76EF0000), size: 40960 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\LPK.dll', fileVersion: 6.1.7601.18177
[07.18. - 13:32:20] C:\Windows\syswow64\USP10.dll:USP10.dll (76F00000), size: 643072 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\USP10.dll', fileVersion: 1.626.7601.18454
[07.18. - 13:32:20] C:\Windows\syswow64\ADVAPI32.dll:ADVAPI32.dll (76FA0000), size: 655360 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\ADVAPI32.dll', fileVersion: 6.1.7601.18247
[07.18. - 13:32:20] C:\Windows\system32\IMM32.DLL:IMM32.DLL (77680000), size: 393216 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\IMM32.DLL', fileVersion: 6.1.7601.17514
[07.18. - 13:32:20] C:\Windows\syswow64\MSCTF.dll:MSCTF.dll (776F0000), size: 835584 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\MSCTF.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\system32\NLAapi.dll:NLAapi.dll (735C0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\NLAapi.dll', fileVersion: 6.1.7601.17761
[07.18. - 13:32:20] C:\Windows\system32\napinsp.dll:napinsp.dll (735B0000), size: 65536 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\napinsp.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\system32\pnrpnsp.dll:pnrpnsp.dll (73590000), size: 73728 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\pnrpnsp.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL:WLIDNSP.DLL (73560000), size: 159744 (result: 0), SymType: '-exported-', PDB: 'C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL', fileVersion: 7.250.4311.0
[07.18. - 13:32:20] C:\Windows\syswow64\PSAPI.DLL:PSAPI.DLL (76000000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\PSAPI.DLL', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\syswow64\SHLWAPI.dll:SHLWAPI.dll (774B0000), size: 356352 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\syswow64\SHLWAPI.dll', fileVersion: 6.1.7601.17514
[07.18. - 13:32:20] C:\Windows\System32\mswsock.dll:mswsock.dll (73520000), size: 245760 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\mswsock.dll', fileVersion: 6.1.7601.18254
[07.18. - 13:32:20] C:\Windows\system32\DNSAPI.dll:DNSAPI.dll (734D0000), size: 278528 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\DNSAPI.dll', fileVersion: 6.1.7601.17570
[07.18. - 13:32:20] C:\Windows\System32\winrnr.dll:winrnr.dll (734C0000), size: 32768 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\winrnr.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\system32\rasadhlp.dll:rasadhlp.dll (72F70000), size: 24576 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\rasadhlp.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\System32\wshtcpip.dll:wshtcpip.dll (734B0000), size: 20480 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\System32\wshtcpip.dll', fileVersion: 6.1.7600.16385
[07.18. - 13:32:20] C:\Windows\system32\dbghelp.dll:dbghelp.dll (73FC0000), size: 962560 (result: 0), SymType: '-exported-', PDB: 'C:\Windows\system32\dbghelp.dll', fileVersion: 6.1.7601.17514
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\strtol.c (100): strtoxl
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\strtol.c (232): strtol
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\atox.c (56): atol
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\atox.c (100): atoi
[07.18. - 13:32:20] c:\eq\source\common\shareddb.cpp (1743): SharedDatabase::LoadSpells
[07.18. - 13:32:20] c:\eq\source\shared_memory\spells.cpp (41): LoadSpells
[07.18. - 13:32:20] c:\eq\source\shared_memory\main.cpp (154): main
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (240): __tmainCRTStartup
[07.18. - 13:32:20] f:\dd\vctools\crt_bld\self_x86\crt\src\crt0.c (164): mainCRTStartup
[07.18. - 13:32:20] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 7795338A)
[07.18. - 13:32:20] 7795338A (kernel32): (filename not available): BaseThreadInitThunk
[07.18. - 13:32:20] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77E89F72)
[07.18. - 13:32:20] 77E89F72 (ntdll): (filename not available): RtlInitializeExceptionChain
[07.18. - 13:32:20] ERROR: SymGetLineFromAddr64, GetLastError: 487 (Address: 77E89F45)
[07.18. - 13:32:20] 77E89F45 (ntdll): (filename not available): RtlInitializeExceptionChain

Ive never seen this before or ran into this problem did i do something wrong or should I have not droped any tables, and just attempted to override what was already there?

[rlie_0]

I can still load the server, see it, enter server, still see my char, with items on, just cant load into game...its very odd.

[Kingly_Krab]

It seems that your shared_memory.exe is crashing when loading spells, is your spells_new table corrupt or does it have any incorrect values such as an outrageously high ID or and id of 0 or anything that would throw an error and cause shared_memory.exe to crash? I had a similar issue earlier because I cleared my entire loot table so I couldn't log in due to shared_memory.exe crashing before finishing.

Here are the errors related to spells crashing it:
[07.18. - 13:32:20] c:\eq\source\common\shareddb.cpp (1743): SharedDatabase::LoadSpells
[07.18. - 13:32:20] c:\eq\source\shared_memory\spells.cpp (41): LoadSpells
[07.18. - 13:32:20] c:\eq\source\shared_memory\main.cpp (154): main

[rlie_0]

Them dang spells.

I reverted back to old server to allow folks to play again (even without buffs every time you buff!)

Ill work on building a new server and sql again and not update the spell file and let you know how it goes.

[rlie_0]

It appears it all works fine, before I place my tables in there, the server loads in just fine no errors nothing. works well...

After applying my tables(droping current ones and using mysql to place the table back in there), skills caps, mobs, loot drops, and tables, merchants etc suddenly The zone is unavailable Appears no matter what....What cures this problem?

Looking at World.exe and usc.exe they both say the same thing, [Status] Using database 'my db name here' at 127.0.0.1 : 3306 While the 3rd window just saying sleeping (since im not logged in.)

[Nightrider84]

It is a database issue with your old tables versus the new ones. chances are there are some missing brackets ect in some of those tables or the modifications you made to your previous table may be having an impact on the current mobs ect.

[rlie_0]

You're right, Currently I cant get 2 tables to work right and would like to since its the core of what my project is those 2 tables are

Spawngroup (with this old table, I cant no longer load any zones)
NPC_type (with this old table, mobs dont appear in ANY zone)

These 2 tables Id like to get back up and running what should I do?

[lerxst2112]

Check your logs for query errors, then look at the updates you might have missed that add/modify the fields from the errors.

[rlie_0]

I just drop the whole table completely, and source in the old one, if fails to load just drop the old and place back in the new updated one...how would i combine the two tables updating my table with the new ones(with the applied updates)?

Sorta hard to keep my work when it can all be lost each update...would like to know how to do for other updates that stop other tables from loading.

Any help would be great!

[demonstar55]

Try sourcing 2014_05_04_SlowMitigationFix.sql