Re: pqReadData() -- read() failed: errno=32

On Thursday 18 December 2003 14:30, Craig Stratton wrote:
> > > I get this error, as in subject:-
> > > pqReadData() -- read() failed: errno=32
> > > and then followed by this
> > > pqReadData() -- backend closed the channel unexpectedly.
> > >
> > > I can find no reference to errno=32 in the mailing lists.
> >
> > From memory and google, it's a broken pipe, traditionally from php's
> > persistent connections. Assuming a backend isn't dying, I'm a bit
> > puzzled. Check your logs and see if all is OK.
>
> This is running as a cgi script, not php. The backend dies afterwards.
> I think it is dbi/thread/child related, so i modified the code, but still
> no joy.
> I am fairly sure its dbi thread related still though.

> 3) connect outside, connect inside if not defined (in case missed by thread
> fork)

What threads and forking? Are you re-using the same connection in different
threads/processes?

--
  Richard Huxton
  Archonet Ltd