Re: Question regarding Perl, DBI, and fork()

When grilled further on (Mon, 27 Oct 2003 09:40:40 +1100),
Martijn van Oosterhout <kleptog(at)svana(dot)org> confessed:

> On Sun, Oct 26, 2003 at 03:04:29PM -0500, Allen Landsidel wrote:
> > Can the children (safely) use this handle to run database queries, or
> > should I just consider the handle garbage? I didn't want to "just try and
> > see" because there's always the possibility it could work "by accident"
> > during the low-load testing, and fail at some other time.
>
> No, you can't. Even multithread programs can't use the same connection at
> the same time (they can if serialised or if they use different connections).
>
> Now, getting rid of the handle without it closing the connection would be a
> trick.

I've had good success setting InactiveDestroy (as Allen found), and in my
children, I re-connect to the db. Works for me, although I'm only using up to
16 children + parent.

Cheers,
Rob

--
17:35:03 up 86 days, 10:58, 4 users, load average: 2.09, 2.04, 2.00