Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Links mod_perl cpanel MySQL- inconsistancy/unstable

Quote Reply
Links mod_perl cpanel MySQL- inconsistancy/unstable
I'm in the midde of using the GT modules to write a mmorpg browser based online game for our links install. It's really amazing just how flexable the codebase is, even after all these years.

I'm running into some really strange issues that I've never run across before working with the GT code. I'm pretty much beating my head into a wall at this point trying to figure out what's gone wrong.... Figured I'd ask here before I commit myself to the loony bin.

In a nutshell, the data in the MySQL database seems to randomly revert back to older data, after successful updates.

For example, a player flys all 25 of his characters to a different country. To do that, a player has to click on each characters shortcut, then click the "Fly" to button. I'll have this done while I watch the debug logs, and I'll see the update statement for each character with no errors. After all the characters have been updated, a query will show that 1/3 of them still have the old location data. It's pretty random though... the non-update could happen to anywhere between no characters and 10 characters.

It's not just that scenario either... it's pretty much any update to the character's data...

Has anyone ever had anything like this happen before? Our live install (not where this game is being developed) is running on a dedicated server with no cp and we've never had any problems remotely like this. The development environment is running under Cpanel and mod_perl. Could Cpanel be part of the problem?

Any tips/ideas at all would be much appreciated!

Thanks!

AlexJ
Subject Author Views Date
Thread Links mod_perl cpanel MySQL- inconsistancy/unstable AlexJ 4929 Jul 16, 2010, 8:19 AM
Post Re: [AlexJ] Links mod_perl cpanel MySQL- inconsistancy/unstable
Andy 4757 Jul 16, 2010, 9:52 AM
Post Re: [AlexJ] Links mod_perl cpanel MySQL- inconsistancy/unstable
brewt 4745 Jul 16, 2010, 2:18 PM
Post Re: [AlexJ] Links mod_perl cpanel MySQL- inconsistancy/unstable
AlexJ 4541 Oct 8, 2010, 10:33 AM
Post Re: [AlexJ] Links mod_perl cpanel MySQL- inconsistancy/unstable
AlexJ 4527 Oct 8, 2010, 5:51 PM