Incomplete Databases and Invisible Toons
Posted: Sat Mar 20, 2010 8:52 pm
This fix is just for those new servers starting out who notice issues with getting a new database setup.
I've finally realized what's happening on those few reports we've been getting about logging into the world, and you cannot see your toon. There is a connectivity problem with our DB Update Service (long standing problem) that is more likely internet latency than anything to do with LE's servers... if you know what you're looking for, you can see a "Connection reset by peer" error message.
What this means is that while the bulk data is downloading to your clean DB, a connection is getting reset and you are not getting the entire table (in this case, Appearances). This also happens with visual_states, reference_spell_effects, and sadly, opcodes. These are currently our largest tables, so it takes a fairly robust and steady connection to download that much data.
The solution (for now) is to download the attached full DB sql file, source it in, then run your EQ2World.exe to update it passed Public SVN Rev 415. Crappy solution, but this will fix those of you who keep getting partial databases.
Note: This will drop ALL your tables, so don't apply it if you care about your world data...
A (better) long-term solution is in the works to deliver not only the core database, but our (hopefully) first release of EQ2Emulator data to the public. It'll likely be in the form of a massive SQL file to source in, because there is no way with these current problems we will be able to continue delivering data via our DB Update service. ~very sad face~
Unless LE returns with a miracle save, this is the direction we're going with our data delivery; SVN.
This fix is just for those new servers starting out who notice issues with getting a new database setup.
Edit: Made it more clear who this post is directed at
sorry
I've finally realized what's happening on those few reports we've been getting about logging into the world, and you cannot see your toon. There is a connectivity problem with our DB Update Service (long standing problem) that is more likely internet latency than anything to do with LE's servers... if you know what you're looking for, you can see a "Connection reset by peer" error message.
What this means is that while the bulk data is downloading to your clean DB, a connection is getting reset and you are not getting the entire table (in this case, Appearances). This also happens with visual_states, reference_spell_effects, and sadly, opcodes. These are currently our largest tables, so it takes a fairly robust and steady connection to download that much data.
The solution (for now) is to download the attached full DB sql file, source it in, then run your EQ2World.exe to update it passed Public SVN Rev 415. Crappy solution, but this will fix those of you who keep getting partial databases.
Note: This will drop ALL your tables, so don't apply it if you care about your world data...
A (better) long-term solution is in the works to deliver not only the core database, but our (hopefully) first release of EQ2Emulator data to the public. It'll likely be in the form of a massive SQL file to source in, because there is no way with these current problems we will be able to continue delivering data via our DB Update service. ~very sad face~
Unless LE returns with a miracle save, this is the direction we're going with our data delivery; SVN.
This fix is just for those new servers starting out who notice issues with getting a new database setup.
Edit: Made it more clear who this post is directed at
sorry