| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: while vacuum: pq_flush: send() failed: Broken pipe |
| Date: | 2001-01-29 06:57:29 |
| Message-ID: | 20611.980751449@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Thomas T. Thai" <tom(at)minnesota(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-29 07:04:47 | Re: increase WAL_FILES |
| Previous Message | Tom Lane | 2001-01-29 06:49:32 | Re: Re[4]: SPI_getvalue problem |