| View previous topic :: View next topic |
| Author |
Message |
MagnumMan
Joined: 01 Apr 2005
Posts: 8
Location: MA
|
 Posted: Mon Apr 30, 2007 14:30 Post subject: mysql caching errors, 5.0.37, Windows |
 |
|
| I've had some trouble after upgrading to mysql 5.0.37, both 32-bit and 64-bit. Specifically some UPDATE statements don't seem to actually get executed (and consequently people lose some of their gifts on the server). We're going back to 5.0.24 (x32) for now. I'm wondering if this is just an incompatibility with nwnx_odbc.dll which maybe needs a recompile with the latest client code? |
|
| Back to top |
|
 |
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Mon Apr 30, 2007 22:05 Post subject: |
|
|
Usually, they try to keep their API compatible within a major version (5.0 in this case), so I doubt this could be the case. But one never knows..
Do the same statements fail to update every time, or is it just random ? Can you give an example of an update statement that failed in the past ?
_________________
Papillon |
|
| Back to top |
|
|
Disco
Joined: 06 Dec 2006
Posts: 152
|
| Posted: Fri May 04, 2007 9:13 Post subject: |
|
|
They 'fail' at random, and also from the MySQL Query Browser, so I doubt it's NWNX' fault at all.
I suspect the fails to be delayed instead of dropped, but the duration of the delay itself is a mystery. Sometimes it works instantly, and sometimes not for 10 minutes at least. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Fri May 04, 2007 17:33 Post subject: |
|
|
You are not using a db engine that uses transactions, right ?
_________________
Papillon |
|
| Back to top |
|
|
Disco
Joined: 06 Dec 2006
Posts: 152
|
| Posted: Fri May 04, 2007 21:43 Post subject: |
|
|
| Well, this table used MyISAM, if I remeber correctly. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
