On Mon, 29 Jan 2001, Tom Lane wrote:
> Date: Mon, 29 Jan 2001 01:57:29 -0500
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Thomas T. Thai <tom@minnesota.com>
> Cc: PostgreSQL General <pgsql-general@postgresql.org>
> Subject: Re: [GENERAL] while vacuum: pq_flush: send() failed: Broken pipe
>
> "Thomas T. Thai" <tom@minnesota.com> writes:
> > while doing a vacuum, i got a 'broken pipe' error. is this serious?
> > ...
> > DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 0,
> > Keep/VTL 0/0, Crash 0, UnUsed
> > 2, MinLen 1206, MaxLen 1499; Re-using: Free/Avail. Space
> > 5444/0; EndEmpty/Avail. Pages 0/0. CPU
> > 0.00s/0.00u sec.
> > DEBUG: Index pg_toast_16600_idx: Pages 2; Tuples 2: Deleted 0. CPU
> > 0.00s/0.00u sec.
> > DEBUG: MoveOfflineLogs: remove 0000000300000072
> > DEBUG: MoveOfflineLogs: remove 0000000300000073
> > DEBUG: MoveOfflineLogs: remove 0000000300000074
> > DEBUG: MoveOfflineLogs: remove 0000000300000075
> > DEBUG: MoveOfflineLogs: remove 0000000300000076
> > DEBUG: MoveOfflineLogs: remove 0000000300000077
> > DEBUG: MoveOfflineLogs: remove 0000000300000078
> > DEBUG: MoveOfflineLogs: remove 0000000300000070
> > DEBUG: MoveOfflineLogs: remove 0000000300000071
> > pq_flush: send() failed: Broken pipe
> > pq_recvbuf: unexpected EOF on client connection
>
> Are you sure that's "while" doing the vacuum, and not "after"?
> In any case, what this indicates is ungraceful disconnection by the
> client. What client software was used to issue the vacuum command?
client was from psql. i saw that appear in the log by doing tail -f before
i saw the word VACUUM.. but it was right about the same time.