Re: Re: [GENERAL] libpq error codes

From: Denis Perchine <dyp(at)perchine(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Re: [GENERAL] libpq error codes
Date: 2000-06-22 15:40:40
Message-ID: 0006222257170C.00479@dyp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

> > db=> select count(*) from pg_class;
> > pqReadData() -- backend closed the channel unexpectedly.
> > This probably means the backend terminated abnormally
> > before or while processing the request.
> > The connection to the server was lost. Attempting reset: Failed.
> > !>
>
> > Looks much more reasonable. But I do not get messages about shutdown.
> > With a patch enclosed it will perform like with ECONNRESET.
> > Shouldn't I emulate EOF when EPIPE?
>
> You *are* emulating EOF --- with that check in place, pqReadData
> should respond to EPIPE just like it does to a normal EOF. I don't
> understand why you aren't seeing the same results I do.

Hmmm... Looks like I get EPIPE just after connection reset, but you are able
to read the rest of the data... Looks like Linux kernel problem again...

> How exactly are you testing this? I'm doing it with a plain "kill"
> on the connected backend process. If you were using "kill -9"
> or some such, that'd explain it --- the backend doesn't have an
> opportunity to send the "I'm shutting down" message in that case.

kill -TERM for sure.

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Grimshaw 2000-06-22 16:16:29 PHP Install with Postgres support.
Previous Message Tom Lane 2000-06-22 15:17:35 Re: Re: [GENERAL] libpq error codes

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2000-06-22 20:11:56 Re: Big 7.1 open items
Previous Message Tom Lane 2000-06-22 15:27:30 Re: Big 7.1 open items