[CDBI] Inconsistent reads from database when using web interface

Carlos Vicente <cvicente-zZ82ZiX1S8l+u43qRgrggVnYRNhDb3e+9nwVQlTi/[email protected]> Thu, 28 Aug 2008 15:01:07 -0700
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
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:

http://perl.apache.org/docs/1.0/guide/databases.html#Transactions_Not_Committed_with_MySQL_InnoDB_Tables

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.

cv