Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
Hello Monks!

I have a mod_perl-enabled web application that I'm working with. Most of the time it Does The Right Thing(tm).

However sometimes the result isn't so nice and I find that the Class::DBI-based model occasionally returns objects that don't correlate with the database as it is at that time.

For instance, 80 out of 100 times I get a result that is consistent with the database, but 20 out of a 100 times I get objects out of Class::DBI searches that reflect how the database *used* to look like. (Okay, I made these numbers up but this is a rough approximation of what happens).

It would appear to me that there is some sort of caching going on at some level. I've employed Data::Dumper and have determined that is is most certainly NOT the browsers fault: Class::DBI is really giving me results that don't reflect the current contents of my database but rather older values from tables and so on.

My problem is that I'm not sure where to look to pin down which component is responsible for caching.

FWIW, I'm using MySQL, and the latest versions of the DBD, DBI and Class::DBI modules with Apache 1.3.x and mod_perl 1.29

Any suggestions or thoughts as to why this is happening would be GREATLY appreciated!


In reply to mod_perl/Class::DBI application returning inconsistent results by Booger

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others contemplating the Monastery: (4)
    As of 2018-08-18 08:06 GMT
    Find Nodes?
      Voting Booth?
      Asked to put a square peg in a round hole, I would:

      Results (185 votes). Check out past polls.