Well I found the source of my problem, and now I want to go bang my head against a wall. It seems PodMaster was closer than I thought in his private messages to me. On the assumption he doesn't mind, I'll quote him here:

PodMaster says reading your various troubles with DBI under mod_perl I can't help but get the screaming feeling that you really haven't learned scoping basics -- I hope i'm wrong, but it doesn't look that way (and them problems aren't generic enough to be resolve, much less properly diagnosed without proper disclosure)

perrin also mentioned the possibility here.

Both were pretty close, I had overlooked one thing. I had declared $state with my as could be seen in the code snippet I posted here. Until now, it hasn't made much of a difference where I declared it because each sub declared it's own $state, preventing $state from being cloned into it... I had recently added 2 new subs one of which did not need $state, and so it was not declared there... thus it was cloned in. In order to fix it, I modified the scope of $state, eliminating the chance that could happen again, and changed a few other variables while I was at it.

Thank you to those who offered advice and assistance.


My code doesn't have bugs, it just develops random features.

Flame ~ Lead Programmer: GMS (DOWN) | GMS (DOWN)

In reply to Solution: mysql, locked databases, Apache::DBI and mod_perl by Flame
in thread mysql, locked databases, Apache::DBI and mod_perl by Flame

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.