Thanks for the comments. I did try perl debugger, but it sure buggers me. No hints detected down in that dirty dungeon. Of course, during my whole career of sysadmin/DBA who programs a bit, I have only once found that sort of debugger to like tell me anything useful, and that one time it was C. Guess I'll never be a real programmer.

I have barely touched the problem since then cuz it only makes the monthly run break, guess I better get busy. Anyway, I'm thinking now it is a subtle database corruption because I do have a lock problem sitting in the database.

So Perl & DBI are not apparently the problem after all except in that the error message is well, like most error messages, totally unhelpful.

That perl and TK debugger looks really interesting, Thanks! 

--
-ken rich       "I'm continually AMAZED at
                 th'breathtaking effects of
                 WIND EROSION!!"  (Zippy)

[download]

In reply to Re: DBI/module debugging? by kechari
in thread DBI/module debugging? by kechari

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.