Perrin:

Thank you for your response.

You say that it's unlikely. I'm attempting to determine the likelihood of this occuring. In other words, is it worth the effort to correct the problem.

The first scenario that comes to mind is a momentary network outage from the web server to the database server. Using my example from the original question:

1. Immediately before the 8th call to _mk_db_closure, there is a momentary network outage to the database server.

2. $dbh->ping is called (which on DBD::Oracle, does a 'select sysdate from dual')
I 'think' this is an immediate, no timeout operation. ping would return false.

3. A new connection would attempted to be made.
With DBI->connect (on Oracle), I'm pretty sure that it tries a few times to connect before timing out and erroring. Before the timeout, the network comes back up. A new dbh is created and transactions are lost.

Another scenario is that our primarly database server fails over to the secondary node. Depending on how quickly the fail over happened, this could be a similar situation as the momentary network outage.

With your experience, would you agree that the above scenarios could result in the lost transaction problem?

Thank you, Perrin.

In reply to Re^2: Class::DBI, connect_cached and possible lost transactions? by Anonymous Monk
in thread Class::DBI, connect_cached and possible lost transactions? by Anonymous Monk

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.