If you are using DBI, you can insert the following statement for debugging:

DBI->trace(3, "trace.txt");
[download]

trace.txt is a file that is opened in append mode for DBI to write to. The number is the level of trace you desire:

  0 - Trace disabled.
  1 - Trace DBI method calls returning with results or errors.
  2 - Trace method entry with parameters and returning with results.
  3 - As above, adding some high-level information from the driver and
+ some internal information from the DBI.
  4 - As above, adding more detailed information from the driver. Also
+ includes DBI mutex information when using threaded Perl.
  5 - As above but with more and more obscure information.
[download]

I personally find that trace level 3 gives me all of the information that I need. It produces a lot of output that can take a while to wade through, but I almost always find "tough to track down" errors that way.

Cheers,
Ovid

Join the Perlmonks Setiathome Group or just go the the link and check out our stats.