Jump to content
TrinityCore

[SOLVED]Worldserver crashes on database update


Pettson
 Share

Recommended Posts

Hi,

I just started messing about with TrinityCore (mostly out of nostalgia, and I thought it'd be a good learning experience), and for some reason, there's something going wrong every single time I try to get it working.

I've followed the guide to the letter, and I get to the point where the worldserver executable is importing/updating the MySQL database (I think).
The last message I get before the crash is (running a debug build, the "abort()" line is where the crash would otherwise happen):


Updating World database...
[1146] Table 'world.updates_include' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
abort() has been called


There are no .txt files beyond the DBErrors.log and the Server.log (as follows):

TrinityCore rev. e4dfbb60fd85 2016-02-19 15:03:21 +0100 (3.3.5 branch) (Win32, Debug) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org \/__/

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2f  28 Jan 2016 (library: OpenSSL 1.0.2f  28 Jan 2016)
Using Boost version: 1.60.0
Database "auth" does not exist, do you want to create it? [yes (default) / no]:
Creating database "auth"...
mysql: [Warning] Using a password on the command line interface can be insecure.


Done.
Database "characters" does not exist, do you want to create it? [yes (default) / no]:
Creating database "characters"...
mysql: [Warning] Using a password on the command line interface can be insecure.


Done.
Database Auth is empty, auto populating it...
>> Applying 'E:/Prvsrv/Trinity2/sql/base/auth_database.sql'...
mysql: [Warning] Using a password on the command line interface can be insecure.


>> Done!
Database Character is empty, auto populating it...
>> Applying 'E:/Prvsrv/Trinity2/sql/base/characters_database.sql'...
mysql: [Warning] Using a password on the command line interface can be insecure.


>> Done!
Updating Auth database...
>> Reapplying update "2015_11_07_00_auth.sql" 'BAF9F6B' -> '0ACDD35' (it changed)...
mysql: [Warning] Using a password on the command line interface can be insecure.


>> Applied 1 query. Containing 2 new and 8 archived updates.
Updating Character database...
>> Reapplying update "2015_11_07_00_characters.sql" 'BAF9F6B' -> '0ACDD35' (it changed)...
mysql: [Warning] Using a password on the command line interface can be insecure.


>> Applied 1 query. Containing 2 new and 12 archived updates.
Updating World database...


I've tried running 5.7 and 5.6 of MySQL, and I've tried compiling both x64 and x86 versions (of course I've made sure to use x64 or x86 versions of all the other applications and libraries where applicable) and I get no error messages whatsoever up to that specific point. I've tried googling around a bit, and the only thing I've come across is to import the databases manually - but how do I do that from a single .sql file, that my MySQL wont open? (MySQL Workbench crashes and HeidiSQL wont recognize the file.)
How do I make sure the right stuff goes into the right databases (that aren't created before running the worldserver.exe)?
Used the CLI to create a test database - just for the heck of it - and managed to import the TDB_full_world_335.60_2015_11_07.sql contents into it. Is it just a matter of the file size, and if so, where do I set it so the MySQL server can handle it through the worldserver.exe application? (Isn't that using batches for the CLI as well?) My experience with MySQL is highly limited, and I apologize for that - I hope someone can give me a pointer or two! (Or five. ^^)

Applications used:
MS Visual Studio 14 (2015) Community Ed.
Boost 1.60.0 for MSVS 14 (x86 and x64, as applicable)
MySQL 5.7.11 (tried with 5.6 as well, both x86 and x64 versions - always correctly detected in CMake)
OpenSSL 1.0.2f (x86 and x64, as applicable - detection in CMake works perfectly)
ZeroMQ 4.0.4 (x86 and x64, as applicable)
CMake 3.4.3
TrinityCore repository cloned 2016-02-19 around 1100CET, should be after commit f2ab246?


Hope someone could help me out here, and I do apologize if I may have missed the solution somewhere else in the forums!
Thanks a bunch in advance!
/Chris

UPDATE: Managed to work around the issue, by importing the SQL dump via the MySQL CLI (I used the source command to import the TDB_ file into the 'world' database). Everything seems to be running fine after that, all the updates ran perfectly, the auth and world servers fire up, and I can connect with the 3.3.5a game client. :)

Edited by Pettson
Added temporary workaround
Link to comment
Share on other sites

Been busy with work - sorry for the slow reply! Will try recompiling as soon as I can find time, looks like I removed the debug build when I got it working with the release build and the method mentioned above. Seems like Naios got it nailed though, thanks for the replies! :)

Link to comment
Share on other sites

  • 1 year later...
Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By xgamerninjax
      Hello all, first time posting here and it's really got me scratching my head.
      I've compiled everything on my own computer, and then transferred everything to a host computer so the server can stay live. The server was running fine for a month or so and then suddenly it just crashes when it hits "Loading C++ scripts", exiting saying "caught signal 22"
      I tried setting up the host computer from scratch and transferred everything over fresh and it's still happening for some reason. (Note, I can run the server perfectly on my personal pc where I compiled it.)
      Any help would be greatly appreciated, thanks!
      3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].dmp 3d7e3a40e2b3+_worldserver.exe_[1-4_15-19-45].txt
    • By shroom
      Hi,
      Following one recent commit officially adding MariaDB 10.4 support, I took this opportunity to update my database server (from MariaDB 10.1 to MariaDB 10.4) and compiled the game server with the corresponding libraries instead of MySQL 5.7.
      Everything went fine and the server runs properly.
      I had one tiny little issue though: I had to fill the MySQLExecutable variable in the conf file otherwise the worldserver executable wouldn't launch:
      Didn't find any executable MySQL binary at '/Server/Release/bin/Release' or in path, correct the path in the *.conf ("MySQLExecutable").
      I never had to fill this variable before and it was still working fine with this commit: https://github.com/TrinityCore/TrinityCore/commit/48c700347c91b1748427a8c5b09b8d4099c9a105
      I'm running with this commit at the moment: https://github.com/TrinityCore/TrinityCore/commit/43d9ffd1bc127768882711a47d5e2bae92845d04
      It's not that big of deal obviously, but the worldserver conf file states for this variable:
      If the path is left empty, built-in path from cmake is used.
      Alas, while being properly set in CMake, the path isn't used anymore.
      Is this the new expected behavior or is this a bug?
    • By Deer_Hunter
      Hello all,
      I just updated from the latest Git 
      Trinity Core REV. ac6baa547376 + 2020-02-21  3.3.5 Branch.
      I'm getting this error after crash.
      Problem signature:
        Problem Event Name:    APPCRASH
        Application Name:    worldserver.exe
        Application Version:    0.0.0.0
        Application Timestamp:    5e50a462
        Fault Module Name:    StackHash_f12f
        Fault Module Version:    6.3.9600.19629
        Fault Module Timestamp:    5e2fdc0d
        Exception Code:    c0000374
        Exception Offset:    PCH_9E_FROM_ntdll+0x0000000000090D0A
        OS Version:    6.3.9600.2.0.0.272.7
        Locale ID:    1033
        Additional Information 1:    f12f
        Additional Information 2:    f12f0934d3e965f73c68e60f20f2cd40
        Additional Information 3:    7595
        Additional Information 4:    7595e4d8d703db9dcd3d2f6ea540e357
      the exception code says its a Heap error,  I'm not sure how to troubleshoot this.
      Thanks
    • By 939h
      Hi,

      The chat channel Lookup for group is not available when a player isn't in a city. I tried to modify the worldserver.conf file with:
      #
      #    Channel.RestrictedLfg
      #        Description: Restrict LookupForGroup channel to characters registered in the LFG tool.
      #        Default:     1 - (Enabled, Allow join to channel only if registered in LFG)
      #                     0 - (Disabled, Allow join to channel in any time)
      Channel.RestrictedLfg = 0

      I restarted the server but it didn't help.

      Thanks
    • By Probie_Wan_Kenobi
      I believe everything I have done up to this point has been correct. When I go to launch worldserver.exe a console window opens up for a second and closes right away and nothing else seems to have happened. I skipped a head a little in the instructions to see what is left and step 5 seems skippable since I am running this only for this computer and step 6 has me launch to a log in screen which I can not get to. I tried going to the faq but the page was not loading properly so I am forced to post here.
×
×
  • Create New...