Re: pqReadData() -- read() failed: errno=32 - Mailing list pgsql-general

From Richard Huxton
Subject Re: pqReadData() -- read() failed: errno=32
Date
Msg-id 200312181339.44857.dev@archonet.com
Whole thread Raw
In response to pqReadData() -- read() failed: errno=32  ("Craig Stratton" <craig@avnet.co.uk>)
Responses Re: pqReadData() -- read() failed: errno=32  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thursday 18 December 2003 12:23, Craig Stratton wrote:
> Hi,
>
> cobalt 2.2.16
> psql 7.2.3
> DBI 1.32
>
> 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.

> If i define and connect the database handle within the function that does
> my processing, then i get no errors (but very slow processing due to
> connecting on each event).
>
>  If i define and connect the database handle as a global variable outside
> of the function, then i get that error on the first insert.

Can you give a short example of what works and what doesn't.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: How to navigate tree without CONNECT BY?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Which file system do i have to choose?