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

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