Thanks for the input. I believe I have it fixed.. at least, after much effort, i've not been able to reproduce the problem. The lesson was: Don't load your Maypole Driver class using PerlRequire. I moved the use statement for my driver into the <perl> block where I set up my model base class and class::dbi. Also added a Model->db_Main->disconnect() at the end of that block, but that didn't seem to solve the problem by itself.
I haven't added in the bit to turn off mysql_auto_reconnect. The other changes seem to have solved the problem. Is it really necessary? Don't I want my db connections to reconnect when they time out? Also, I saw in http://wiki.class-dbi.com/wiki/Using_with_mod_perl that you have overridden db_Main. Is that all still necessary? So far, simply changing where I load my driver from seems to have fixed the problem, so I'm wondering if the fix you have there addresses an issue that may have been fixed in later versions of Ima::DBI or Apache::DBI. Thanks again for the help ;) On Mon, 2006-02-13 at 19:14 -0800, Perrin Harkins wrote: > Ron McClain wrote: > > I've been trying both with and without Apache::DBI, and it doesn't > seem > > to matter. The behaviour is easy to replicate, but > non-deterministic. > > If I just click on the links to my list views for my models quickly > in > > succession, I can trigger the error every time. Usually after it > fails, > > I have to restart apache, or I just continue to get the fetch() > without > > execute() error on every request. I'm going crazy here.. Am I the > only > > one having these sorts of issues? > > 1) Turn off mysql_auto_reconnect. > > 2) Make sure you disconnect your database handle before apache > forks. > Sharing a database handle between child processes can lead to this > kind > of error. > > There is information on the wiki about how to use Class::DBI safely > with > mod_perl. > > - Perrin > ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Maypole-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/maypole-users
