I've created a small web application/form to allow clients to input DNS requests. It is written in CGI::Application and has 3 modes... "summary" (main_handler), "submit" (submit_req), and "approval" (mail). Via inheritence, I'm also using HTML::Template to segregate the html.

Here's the problem... this script works great when run via standard CGI/perl. However, whenever I try to run it via mod_perl, it appears that the DBI responses are being cached in a mod_perl thread (or whatever it uses). This is a bad thing. FWIW, using (or not using) Apache::DBI doesn't make a difference.

Here's the pattern I've noticed when creating a series of sequential records (1st is A, 2nd is B, etc.). After restarting the named processes, everything works ok up until the 5th instance (E)...

a b c d
a a b c d e
a b a b c d e f
a a b c d e a b c d e f g
a b a b c d e f a b c d e f g h

As you can see, the data is "in there", but it's being prepended by some sort of random(?) cached data. The database does not reflect this odd behavior... everything is kosher in the table.

I've added the entire package to fuzzyping's scratchpad. If there are specific portions of the code, or of the base cgi, HTML templates, or database structure that anyone would like posted here, please let me know. Thanks in advance for everyone's help!

-fuzzyping

In reply to perl_mod caching DBI responses by fuzzyping

Title:
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, details, 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, summary, 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.