3.3.5 Database

0 views

Skip to first unread message

Manric Hock

unread,

Aug 3, 2024, 5:41:23 PM8/3/24

to vedzytyre

So, I imported the world sql, dated 4/2, (april 4) configured the little things in the world server I like to change, and ran it. It started blowing up saying that update files were missing, but had been applied. Indeed, there are no update files on the 3.3.5 branch (where they normally are, (in my case, TrinityCore/sql/updates/world) but there are a few in TrinityCore/sql/updates/world/3.3.5. Going back to Jan of this year.
I am getting a ton of errors about missing colums, etc right before the server dies, as well.
So, what happens is
Start worldserver -
shows auth and char dbs are good to go
starts complaining about files missing for world db updates
does that for a couple seconds.
Dies and says there are missing colums/fields in the world db.

The two linked query files. You actually only need the 3.3.5 version, so it would have been clearer to say "one file". Edit the query file you download (if you want to), then run it with mysql, the way they do in the link above, to create the database user and the databases.

>I put the TDB_world.sql file in the .../bin folder where worldserver.exe is. I ran it with heidiSQL and am not sure if that is all I was suppose to do? I'm assuming worldserver binary means worldserver.exe?

I'm not sure where the 'yes' password is coming from. The database password(s) in the configuration files and the query file you use to create the databases must be the same. Note that you don't have to change them from the defaults. If you haven't run the query file yet, you haven't created the database user, so it would make sense that the program can't gain access.

Okay, literally all you have to do is copy paste this text into the command prompt for mysql: _mysql.sql

I wish the guide would've said that. I figured that out by a random guess. I feel dumb for not having figured that out sooner. As long as the TBD_world file is in the folder worldserver.exe is, after pasting that text into CMD, run worldserver.exe and it will do its thing automatically.

I log into to HeidiSQL using root and password. Then what? I tried copying the 3.3.5 stuff in the link in the query tab and running it but that just gave an error that "world" already existed. Granted I have very very little knowledge and this sections starts using terms that were not used in the last sections.

"It is possible that the database is overloaded or otherwise not running properly" - ignore this, fundamentally this error means Moodle's connection attempt to the database has failed which is typically caused by one of:

If this is your first time installing TrinityCore, you will ONLY need the file/s with the name starting by "TDB_full" on the directory where your worldserver binary (worldserver on linux or mac, worldserver.exe on windows) is located.

(the files inside updates are made to update from older TDB revisions without having to apply every file if you have autoupdater disabled and you don't update between TDB releases (NOT RECOMMENDED)).

You would need to use one MySQL root account with your MySQL client or with MySQL CLI before starting core to run one of those files (use MySQL root only to import one of those files, never run core as root or administrator).

By default Trinity needs three databases to run at 3.3.5 branch and four for master with the following names - Auth, Characters, World and hotfixes (the last one master only), if you already have those databases on use you will need to edit create_mysql.sql file and config files to avoid data loss or errors on setup of database to use different database names:

If you have plans to change default mysql usernames and passwords make sure you have set valid database login information and the table names you want to use in the same config files (authserver (3.3.5a only)/bnetserver (master branch only)/worldserver.conf) under "CONNECTIONS AND DIRECTORIES".

Both core and DB fixes will be committed to the TrinityCore repository, which you may also view in Git Extensions by following the "Fetch" instructions in Keeping the Source Up-to-Date Windows / Linux. Pending fixes can be found on our tracker with data from the developers and contributors.

Thanks to the automatic DB updater the single step you have to do, is to fetch a new revision (Keeping the Source Up-to-Date Windows / Linux) and the appropriate updates will we applied at server startup.

Our customisation database contains just about everything you might need to customise your phpBB board to your liking. In it you will find Extensions, MODs (for 3.0.x), Styles, Language Packs, BBCodes, as well as various tools.

All Development Discussion takes place at Area51. Bug tracker, development wiki, continuous integration and other development tools are located here. Find out how to get involved in phpBB development.

Search for the most recent version for the branch you are looking for. The naming follows a simple pattern - TDB (Short for TrinityCore Database), gameversion in numbers, year and month of creation attached with a release number for the month.

NOTICE: you don't need to import any databases by hand, only the file creating users. If you have plans to import databases manually you need to disable autoupdater on config files. Be aware that this is NOT recommended for new users.

Both core and DB fixes will be committed to the TrinityCore repository, you can browse them here for 3.3.5 or here for master. You may also view them in Git Extensions by following the "Fetch" instructions in Keeping the Source Up-to-Date under Windows / Linux Core Installation (### TODO Links needed).

Thanks to the automatic DB updater the single step you have to do, is to fetch a new revision (Keeping the Source Up-to-Date under Windows / Linux Core Installation) and the appropriate updates will be automatically applied at server startup.

I have done lots of research, and everyone is mentioning deduplication, but I am pretty sure that ids are unique as they have been generated from dataset with unique ID values per type, and each :ID in header marked with the node type it belongs to:

Can someone please clearly specify what is meant by deduplication (id/namespace combos are already unique), and how exactly do node ids need to be unique,
How to make neo4j-admin import perform reasonably well?

Also, I have noticed a huge slowdown from 3.3.5 to later versions, so I cannot even try to import on the neo4j 4+. I am sure I am doing something wrong again, but cannot find out what as commands have the exact same options on the same machine with same memory/disk.

as you've obscured the details I assume this isn't a dataset you could share with me, if you could I'd take a crack at loading it just for fun. Sounds like it is 10x the nodes, and 100x the rels I'm working with currently.

Thank you for confirmation that removing duplicates will work.
I went back and re-checked all of the data files, and there were indeed just a few duplicates in ID space. I've made necessary changes, and re-tested import with neo4j 3.3.5, and import worked fine - complete import of fairly large dataset:

Just to update - managed to find the issue with import on neo4j 4.1.3 - turns out that "--multiline-fields=true" parameter was causing a problem - number of nodes and relationships that import was showing was way overinflated by the factor of 100 with this parameter. It was there as a carryover from 3.3.5 import that needed it due to some errors before, and I thought that since I don't have any multiline fields it wouldn't cause trouble.

The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. Rather than rely on hardware to deliver high-availability, the library itself is designed to detect and handle failures at the application layer, so delivering a highly-available service on top of a cluster of computers, each of which may be prone to failures.

Users are encouraged to read the overview of major changes since release 3.3.5.For details of 117 bug fixes, improvements, and other enhancements since the previous 3.3.5 release,please check release notes and changelog.

Users of hadoop 2.x and hadoop 3.2 should also upgrade to the 3.3.x line.As well as feature enhancements, this is the sole branch currentlyreceiving fixes for anything other than critical security/data integrityissues.

Users are encouraged to read the overview of major changes since release 3.3.3.For details of bug fixes, improvements, and other enhancements since the previous 3.3.3 release,please check release notes and changelog.

Users are encouraged to read the overview of major changes since 3.2.3.For details of 153 bug fixes, improvements, and other enhancements since the previous 3.2.3 release,please check release notes and changelog.

Apache Hadoop, Hadoop, Apache, the Apache feather logo, and the Apache Hadoop project logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and other countries

No runtime model - Both GORM and Spring Data maintain a runtime metamodel that uses reflection to model relationships between entities. This model consumes significant memory and memory requirements grow as your application size grows. The problem is worse when combined with Hibernate which maintains its own metamodel as you end up with duplicate meta-models.