I think the problem is not your code, but rather an interaction between Perl 5.8.1 and Apache::Session. When your CGI ends, Perl tries to destroy all the objects. Some of the Apache::Session objects have DESTROY methods that get triggered when this happens. In Perl 5.8.1, you can no longer count on the order in which these get called, and I think that somehow the object holding the database handle is getting destroyed before another object that wants to use it. One way to find out would be to go into the A::S source code and add warning messages to all the DESTROY methods so you can see what order they get called in.

Unfortunately, the simplest fix for you would probably be to go back to 5.6.1. It has better performance anyway, so it might be a better choice. The only reasons to use 5.8.x are unicode and threads.

In reply to Re: Re: Re: Re: Re: Re: Re: Apache Session problem after update by perrin
in thread Apache Session problem after update by mkenney

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.