Good afternoon all, I'm wondering how to begin trying to deal with a strange bug that occurs maybe three to four times a month w/ PERL. first, the error: 
DBD::mysql::db do failed: You have an error in your SQL syntax near ''
+ at line 1 at /usr/local/subqueue/upps_ret.pl line 103.
ERROR: update upps_ret_q set state="C", message='Merch: Succeeded,Term
+: Succeeded' where seq_n=

[download]
next the code, 
      my $st = sprintf "update upps_ret_q set state=\"%s\", message=%s
+ where seq_n=%5d",$state,$dbh->quote($msg),int($key);

[download]
now, the box details 
Red Hat Linux release 7.0 (Guinness)
Kernel 2.2.16-22 on an i686
perl 5.6.0

[download]
As I said, this problem occurs every so often, on no predictable basis that I've been able to discern. But the code runs hundreds of times a day. The input data is as expected, nothing out of wack there, and int returns 0 on undef and non-numeric input, so technically that statement should end with seq_n=0 in a better world. But it doesn't. As such, I'm starting to wonder if this is a bug in 5.6.0? If so, should I consider upgrading to 5.8.x or within the 5.6.X series? Any suggestion on where I can find a bug list for either releases? I'd like to upgrade to 5.8.x (yay unicode), but I'd also like to not run into any known bugs with our code in the 5.8.x series as this is a production box...

In reply to Strange experiences w/ perl 5.6.0 on linux 2.2.16-22 by The Ninja K

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.