Re: [CDBI] DB connection lost? Program ABENDs on PING?
"Perrin Harkins" <[email protected]> Mon, 18 Feb 2008 15:05:47 -0500
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
On Feb 18, 2008 6:52 AM, Tom <[email protected]> wrote: > However I have found that there appears to be some kind of DB connection > timeout occurring, which causes the daemon to stop completely. That's correct. The DBI handles in the parent eventually timeout and tell MySQL to clean up, which then kills your connections in the child processes. To prevent this, either avoid forking with open connections as Edward suggested or set InactiveDestroy on the handles before forking. Also, make sure you have the latest Ima::DBI installed. Older versions would break even if you did set InactiveDestroy. - Perrin