Running 8.2.4 on Debian stable (Etch). I'm having this issue where once or twice per day (out of ~100,000 queries) the table doesn't reflect a committed update immediately. Usually when this problem occurs the update takes 1-3 minutes to be reflected in SELECT queries. Occasionally, it has taken more than 10 minutes.
The session could go something like this: UPDATE mytable SET myattribute=1 WHERE id=14; COMMIT; SELECT myattribute FROM mytable WHERE id=14; (Query returns myattribute with a value of 0) (Wait 5 minutes) SELECT myattribute FROM mytable WHERE id=14; (Query returns myattribute with a value of 1) Does anybody have any idea why this would be happening? Watching the query logs, it is clear that nothing is overwriting the value in the interim. Simply, the update is taking an arbitrary amount of time to be reflected in selects to the table. Thanks, Erik Peterson
