Re: Multiple pq_flush: send() failed: Broken pipe

The truth of the matter is that I have queries that take too long to execute and I sometimes interrupt them with ^C. I assume the backend dies when the frontend receives this, correct?
So if that's the case, there is no harm other than that the logfile gets really fat (e.g. potential server crash at some point?)

t.

On Wed, 13 Jun 2001, Tom Lane wrote:

> "Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu> writes:
> > I have my logfile flooded with the message:
> > pq_flush: send() failed: Broken pipe
> > I went through the archives and I found plenty of (older) cases where
> > this was usually accompanied by a 'FATAL:' message and lead to a
> > crash. In my case there is only this by itself (*many* times) and it
> > doesn't lead to a crash. Any idea what could be causing it?
>
> Perhaps some backend churning away on a SELECT that produces gigabytes
> of output? (Not hard to do with a careless unqualified join ...)
> The client might have long since given up and disconnected, but right
> now the backend won't notice until it finishes the query.
>
> Send a SIGINT to the errant backend to get it to cancel the query.
>
> regards, tom lane
>