User Pass
Home Sign Up Contact Log In
Page:
 
Signalsgt
offline
Link
 
Originally posted by
BoglegBut, if it's a corrupt table, I don't see how a web server querying the same DB would not see the same symptoms. But stranger things have happened, I'm sure.


So for my education, when the web server pulls a dip it's bringing the data from a table into a form correct?

When the Sim server hits up the table for data it would be to put it into a formula and run an equation to get a sum right?

If the Web server is responding normally I'm thinking that the table it's populating is a fixed field.

I'm still trying to determine if Bort's magical moving decimal is even relevant to all of this.

Yes..no..maybe...close?
Edited by Signalsgt on Sep 1, 2009 20:39:47
 
MrHockey
chopped
offline
Link
 
Originally posted by Jack Del Rio
or could we eliminate height/weight's effect on the sim altogether? :|


uh oh
 
CapnEnnui
offline
Link
 
Originally posted by Jack Del Rio
or could we eliminate height/weight's effect on the sim altogether? :|


Is Bort even sure that this is the cause?
 
Dmac2008
offline
Link
 
Originally posted by CapnEnnui
Originally posted by Jack Del Rio

or could we eliminate height/weight's effect on the sim altogether? :|


Is Bort even sure that this is the cause?


Not really but, to calm the masses that is what we are going with
 
Bogleg
offline
Link
 
Originally posted by Bort

When the sim reads the data, it does a sanity check and makes sure it is not out of line of expected values.


This would be the preferred Band-Aid. If the error condition is causing crazy out-of-line values, a sanity check can at least tell you when something is way out of whack, and thus you've got an error, and you can either (a) retry the query, (b) fudge the value within acceptable range (though wrong), or (c) abort and then use humans to figure out exactly where the problem is and fix it.
 
Kevin Smith
offline
Link
 
Originally posted by CapnEnnui
Is Bort even sure that this is the cause?


well, if iwhther it is or not, we will know by tomorrow when certain players have some replays to watch.
Edited by Kevin Smith on Sep 1, 2009 20:43:00
 
RandomBeast
offline
Link
 
wouldn't a corrupted table report wrong values for height/weight when queried for player profile page info?
 
Signalsgt
offline
Link
 
Originally posted by RandomBeast
wouldn't a corrupted table report wrong values for height/weight when queried for player profile page info?


I think the player page is served from the web server, the one not having the problem....
 
pottsman
offline
Link
 
Originally posted by Bogleg
I have skimmed the last XX pages, and I have more than my share of Perl + MySQL (InnoDB, MyISAM, whatever) troubleshooting under my belt. Bort said somewhere back there that the table in question is so super-huge that a consistency check on it would take an unacceptable amount of time. And he said that MySQL is just saying "goodbye" mid-response.

And it always affects the same players.

I don't see how there's any way this can be anything but a corrupted table. If it were a networking problem, TCP would retransmit, and you should see a delay, but not any change in your query response. If TCP didn't correct the problem, you'd still not see the consistently wrong results -- it'd affect a more random set of players. If it were a bad RAM situation, you'd very likely see more random results (and probably software crashing here or there, too). Disk errors would be equivalent of either corrupt database/table or bad RAM in end-user experience, I'd think.

But, if it's a corrupt table, I don't see how a web server querying the same DB would not see the same symptoms. But stranger things have happened, I'm sure.

There are a few options to fixing broken tables, or at least finding out what's wrong.

The easiest way (to me) is to setup a slave MySQL server, run a mysqldump on the master with the master data intact, import that into the slave, and setup slave replication so that it'll catch up. That'll get a copy of the data as mysqldump sees it, but not the same on-disk image. Unfortunately, that mysqldump can take a damn long time, too. With a lot of careful work, it can be done one table at a time.

Or you can just bite the downtime and run the db check and get it fixed. And hope that's the problem.


That made no sense to me, but I think you should do that.
 
Bogleg
offline
Link
 
Originally posted by RandomBeast
wouldn't a corrupted table report wrong values for height/weight when queried for player profile page info?


That's the part that I don't get, as well. Are the height/weight stored in more than one place? Maybe there are dedicated tables / databases / db servers for sim purposes that don't share data byte-for-byte with those used in the web UI. That'd be the most likely situation if I had built this thing -- a few read-write database servers with several slaved read-only database servers for displaying/querying data.
 
49ers4Life52
offline
Link
 
Originally posted by pottsman
That made no sense to me, but I think you should do that.


lmfao. Agreed.
 
Squab
offline
Link
 
Originally posted by pottsman


That made no sense to me, but I think you should do that.


Word, that dude is legit, lol.
 
RIP Al Davis
offline
Link
 
damn you 49ers, I hated Aaron Brooks so much.
 
RandomBeast
offline
Link
 
Originally posted by Signalsgt
I think the player page is served from the web server, the one not having the problem....


well, unless Bort keeps multiple copies of player information in different databases, it would all need to query the (supposedly corrupted) source at some point. And it gets the correct value on the profile page query...
 
49ers4Life52
offline
Link
 
Originally posted by HALL OF FAMER Al Davis
damn you 49ers, I hated Aaron Brooks so much.


Jamarcus O_o
 
Page:
 


You are not logged in. Please log in if you want to post a reply.