Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2019, 03:24 PM
Huppy
Dragon
 
Join Date: Oct 2010
Location: Canada
Posts: 940
Default World crash with Aug 13 peq dump

This is not related to my past issue, but tested it out 3 times today to make sure, before I posted this. It's only happening with the peq daily dump of Aug 13 (today's). I have been performing these steps 100's of times when sourcing in a fresh DB.

1. Source in peqbeta.sql
2. Source in player_tables.sql
3. Source in load_login.sql
4. Run shared_memory
5. Run world.exe for updates ........world crashes.

If I repeat these steps with any previous dumps, (including Aug 12th), it works fine. Everything I have, (server related) is fully updated. VS, source code,(aug 11), etc. The problem is isolated to that Aug 13 daily dump. This was in the crash log, if it's of any use. Only thing that stood out to me:
[08-13-2019 :: 13:08:28] [Crash] e:\source test\common\database.cpp (1058 ): Database::LoadZoneNames
[08-13-2019 :: 13:08:28] [Crash] e:\source test\world\net.cpp (319): main
__________________
Don't hate the dev...hate the game ....
Reply With Quote
  #2  
Old 08-13-2019, 05:04 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,025
Default

Quote:
Originally Posted by Huppy View Post
This is not related to my past issue, but tested it out 3 times today to make sure, before I posted this. It's only happening with the peq daily dump of Aug 13 (today's). I have been performing these steps 100's of times when sourcing in a fresh DB.

1. Source in peqbeta.sql
2. Source in player_tables.sql
3. Source in load_login.sql
4. Run shared_memory
5. Run world.exe for updates ........world crashes.

If I repeat these steps with any previous dumps, (including Aug 12th), it works fine. Everything I have, (server related) is fully updated. VS, source code,(aug 11), etc. The problem is isolated to that Aug 13 daily dump. This was in the crash log, if it's of any use. Only thing that stood out to me:
[08-13-2019 :: 13:08:28] [Crash] e:\source test\common\database.cpp (1058 ): Database::LoadZoneNames
[08-13-2019 :: 13:08:28] [Crash] e:\source test\world\net.cpp (319): main
Very interesting, I imported a ton of DoN zones last night and we had a zone entry that was null that must have made it into the dump

Run this

Code:
delete from zone where short_name is null;
These were the zones imported

https://docs.google.com/spreadsheets...it?usp=sharing

I also recorded the import process incase we need to go back and see which one we imported from whether it was Norrath Keepers or Dark Reign

https://www.youtube.com/watch?v=1ZSPkBp6uqQ
__________________
Reply With Quote
  #3  
Old 08-13-2019, 05:05 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,025
Default

I've also just re-ran the dump which includes deleting the errant zone entry
__________________
Reply With Quote
  #4  
Old 08-13-2019, 06:28 PM
Huppy
Dragon
 
Join Date: Oct 2010
Location: Canada
Posts: 940
Default

Oh, good, at least we know what was going on now, Thank You.
__________________
Don't hate the dev...hate the game ....
Reply With Quote
  #5  
Old 08-13-2019, 06:38 PM
Huppy
Dragon
 
Join Date: Oct 2010
Location: Canada
Posts: 940
Default

I see, the ID for that null zone was 5922
__________________
Don't hate the dev...hate the game ....
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:27 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3