[CDBI] Inconsistent reads from database when using web interface

Carlos Vicente cvicente at network-services.uoregon.edu
Thu Aug 28 23:01:07 BST 2008

I'm hoping someone can give me some hints on this.  My CDBI application
has a web interface using mod_perl and Mason.  I'm currently using MySQL
with InnoDB. 

The problem I'm running into is that after updating the DB using a web
form, it keeps showing the previous values for a while.  Also, reloading
the page shows the value intermittently, as if some of the Apache
processes were returning a cached result, and some weren't.  This is
very annoying to the user, who thinks that something is definitely
broken in the application.

I thought I had found the problem when I saw this:


However, after following their directions (setting
|transaction-isolation to READ-COMMITTED|, it is still happening.

The question is, what else could be causing this?  Could it be something
in CDBI, and if not, where should I look?

Thanks a lot for your help.


More information about the ClassDBI mailing list