DBI seems to randomly dieby FitTrend (Pilgrim)
|on Jun 06, 2006 at 18:53 UTC||Need Help??|
FitTrend has asked for the
wisdom of the Perl Monks concerning the following question:
Before posting this I've made some effort searching the web and archives for something related to the issue I'm having. This issue is very random. Some times, the user can click link after link after link (web based app) and it works fine. Other times, a few clicks in it fails with no errors from Perl, apache or the mysql log.
To summarize what happens behind the scenes every time a user clicks a link:
This is the process that is repeated for every user request. It is done this way because the merge table COULD span multiple databases and tables. It all depends on the user. What is frustrating is no errors are generated and it always fails on the first drop table when it occurs (we drop a total of 3 tables).
I've done some testing with just MySQL and cannot reproduce the drop or premature connection termination behavior I believe I'm seeing. I've tested with MySQL 4.1.10a (and the latest), Apache 2.0.52 (and the latest), DBI 1.49 and 1.50, and Perl 5.8.7 and 5.8.8. This is all from a windows system.
Has anyone heard of this type of behavior before? Can any one give me some suggestions on how I should go about resolving my issue? I'm sure I'm missing something.
I've attached the sub I use to create the merge tables using DBI. code here
I appreciate your consideration.