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

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Craig Stratton" <craig(at)avnet(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: pqReadData() -- read() failed: errno=32
Date: 2003-12-18 16:41:19
Message-ID: 200312181641.19917.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-18 16:46:19 Re: Function Returning SETOF Problem
Previous Message Tom Lane 2003-12-18 16:28:27 Re: authentication failed