Postgres Pro
Downloads
Home   >   mailing lists

Re: while vacuum: pq_flush: send() failed: Broken pipe - Mailing list pgsql-general

From Tom Lane
Subject Re: while vacuum: pq_flush: send() failed: Broken pipe
Date
Msg-id 20611.980751449@sss.pgh.pa.us
Whole thread Raw
In response to while vacuum: pq_flush: send() failed: Broken pipe  ("Thomas T. Thai" <tom@minnesota.com>)
Responses Re: while vacuum: pq_flush: send() failed: Broken pipe
List pgsql-general
Tree view 
"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?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: increase WAL_FILES
Next
From: Tom Lane
Date:
Subject: Re: while vacuum: pq_flush: send() failed: Broken pipe