From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | David Ford <david(at)blue-labs(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [patch] helps fe-connect.c handle -EINTR more gracefully |
Date: | 2001-11-12 03:57:50 |
Message-ID: | 200111120357.fAC3voB13920@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> David Ford <david(at)blue-labs(dot)org> writes:
> > problem. Remember a month ago when I had a huge database that I had to
> > upgrade, I had no disk space to export it to and when the old version of
> > psql ran out of memory it crashed? The backend continued to push query
> > data out the closed pipe until the backend was forcibly closed or the
> > query completed. Naturally this caused considerable spammage on the
> > console.
>
> This has been discussed before. Don't bother proposing that backends
> should use the default handling of SIGPIPE, because that won't be
> accepted. A safe limited solution would be to keep backend libpq from
> emitting multiple consecutive "broken pipe" reports to stderr.
> A better-sounding solution that might have unforeseen side effects
> is to set QueryCancel as soon as we see a nonrecoverable-looking
> send() error. This is on the TODO list but no one's gotten round to
> doing anything about it yet.
Guys, can we come to a resolution this so I can mark it as completed?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-12 04:05:48 | Re: Triggered Data Change check |
Previous Message | Stephan Szabo | 2001-11-12 03:54:32 | Re: Triggered Data Change check |