User Pass
Home Sign Up Contact Log In
Page:
 
steellithium
offline
Link
 
Umm... so the database is corrupt? If this is the case, why are the the weights loading properly into the character screen? I have never noticed an error on the player page. Wouldn't these be pulling from the same database? Whatever, I guess.
 
Maksim
offline
Link
 
This is an outrage!
 
heuristik
offline
Link
 
Probably already something you've tried, but my client just went through a similar problem with peculiar "corruption" type results when doing large db reads and transfers between its production and test servers. I wouldn't mention it except for the similarity of the failure events: random occurrence but same tables affected each time, less than 5% of records impacted, and the audit logs were less than helpful.

Some suggestions based on what worked for us:

1) If the data resides on a server remote from the sim server (sounds like this is the case), use something like rsync to bring it local. (Minimize the "latency" part of the equation.)

2) use a separate vlan exclusively for the the db transactions between the sim server and the (now local) db mirror. (Minimize the "noise" part of the equation.)

3) consider using virtual file systems on the same SAN for each server. (Minimize the "transport" part of the equation.)

Just food for thought....
 
steellithium
offline
Link
 
Originally posted by Maksim
This is an outrage!


My concern from Bort's explanation is I'm not sure the dot we build is always the dot on the field. It sounds like data not making it to the sim is just being replaced with generic values from some abstraction script. If this is only a few players, there would have to be some common factor at creation, which corrupted the record.
 
Maksim
offline
Link
 
Originally posted by steellithium
My concern from Bort's explanation is I'm not sure the dot we build is always the dot on the field. It sounds like data not making it to the sim is just being replaced with generic values from some abstraction script. If this is only a few players, there would have to be some common factor at creation, which corrupted the record.


I honestly always thought that players being good or bad depended on their height/weight for their position.
 
steellithium
offline
Link
 
Originally posted by heuristik
Probably already something you've tried, but my client just went through a similar problem with peculiar "corruption" type results when doing large db reads and transfers between its production and test servers. I wouldn't mention it except for the similarity of the failure events: random occurrence but same tables affected each time, less than 5% of records impacted, and the audit logs were less than helpful.

Some suggestions based on what worked for us:

1) If the data resides on a server remote from the sim server (sounds like this is the case), use something like rsync to bring it local. (Minimize the "latency" part of the equation.)

2) use a separate vlan exclusively for the the db transactions between the sim server and the (now local) db mirror. (Minimize the "noise" part of the equation.)

3) consider using virtual file systems on the same SAN for each server. (Minimize the "transport" part of the equation.)

Just food for thought....


How can the same 5% be effected each time? I've had a similar problem with a large read, and in the end I found using a different kernel scheduler as well as a different fs solved the problem. This sounds more like an error in the pulling code to me.
 
Bogleg
offline
Link
 
Originally posted by steellithium
Umm... so the database is corrupt? If this is the case, why are the the weights loading properly into the character screen? I have never noticed an error on the player page. Wouldn't these be pulling from the same database? Whatever, I guess.


Originally posted by Bogleg
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.


... but going back and re-reading Bort's initial comments, I now feel less sure about wtf is going on. But it sounds like it's an error condition that nobody yet fully understands.
 
RandomBeast
offline
Link
 
a data transport error that happens only to some tables, some records, sometimes is a difficult explanation for a x-factor result that occurs every sim, every time.
 
steellithium
offline
Link
 
Originally posted by RandomBeast
a data transport error that happens only to some tables, some records, sometimes is a difficult explanation for a x-factor result that occurs every sim, every time.


Unless there was a corrupt sector of the database. Without knowing the details it is hard to say. We would need to know who is faster than they ought to be, and then try to find some common element to that record.
 
Bogleg
offline
Link
 
Originally posted by RandomBeast
a data transport error that happens only to some tables, some records, sometimes is a difficult explanation for a x-factor result that occurs every sim, every time.


http://goallineblitz.com/game/forum_thread.pl?thread_id=3214072&page=69#27860591
 
RandomBeast
offline
Link
 
corrupt table that reads correctly for profile page?

only answer is same data stored multiple places, as mentioned a few times, or a sync process that corrupts the same way each time it moves data to the sim server
 
steellithium
offline
Link
 
Originally posted by RandomBeast
corrupt table that reads correctly for profile page?

only answer is same data stored multiple places, as mentioned a few times, or a sync process that corrupts the same way each time it moves data to the sim server


Well that wouldn't be reasonable. While I would break a big database into smaller databases, there would be no way to have separate databases for the entire 24 GB. It would have to be updating constantly.
 
Link
 
this whole thing is a fustercluck, I still have zero confidence that there is not a random attribute that makes players better and even less confidence that one won't be added in the future. I guess I have to rethink spending money on a game if the designer/programmer thinks it might be 'cool' to add in a random unknown factor that makes a player consistently better than his build. Bort is well within his right to do so, it is his game, I just don't have a burning desire to waste another grand in cash on a game like that, but maybe I am in the minority. I don't mind randomness from play to play but I can't pay money for a game were out of the box your player is either destined to be great or just average.
 
Bogleg
offline
Link
 
Originally posted by steellithium
Originally posted by RandomBeast

corrupt table that reads correctly for profile page?

only answer is same data stored multiple places, as mentioned a few times, or a sync process that corrupts the same way each time it moves data to the sim server


Well that wouldn't be reasonable. While I would break a big database into smaller databases, there would be no way to have separate databases for the entire 24 GB. It would have to be updating constantly.


It would absolutely be reasonable (and smart) to have separate db servers for the sims vs the UI that share data via MySQL replication or some other synchronization tech.
 
Bogleg
offline
Link
 
Originally posted by trancegression
this whole thing is a fustercluck, I still have zero confidence that there is not a random attribute that makes players better and even less confidence that one won't be added in the future. I guess I have to rethink spending money on a game if the designer/programmer thinks it might be 'cool' to add in a random unknown factor that makes a player consistently better than his build. Bort is well within his right to do so, it is his game, I just don't have a burning desire to waste another grand in cash on a game like that, but maybe I am in the minority. I don't mind randomness from play to play but I can't pay money for a game were out of the box your player is either destined to be great or just average.


Sounds like you can count yourself among the tinfoil hat wearers. He wouldn't introduce something that just plain doesn't make sense on purpose. He's not that kind of guy.
 
Page:
 


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