FlushRelationBuffers returned -2

From: Magnus Hagander <mha(at)sollentuna(dot)net>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: FlushRelationBuffers returned -2
Date: 2000-07-18 13:59:44
Message-ID: 215896B6B5E1CF11BC5600805FFEA82103D9791C@sirius.edu.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I noticed my nightly vacuum process has started dying on a certain relation
last night. When I try to vaccum verbose it, I get the following output.

I can still do "SELECT * FROM filelist".

filelist is a table which has 12146 rows in it, with some 15 columns. Two
fields in approx 8-9000 of these rows are updated each night. No other
activity in the database while I vacuum (nobody even connected).

Restarting the postmaster corrected the problem.

Database is version 7.0.2 running on Linux 2.2.16/libc5. Started with
parameter "-B 512".

//Magnus

NOTICE: --Relation filelist--
NOTICE: Pages 847: Changed 0, reaped 821, Empty 0, New 0; Tup 12146: Vac
10733, Keep/VTL 0/0, Crash 0, UnUsed 11548, MinLen 92, MaxLen 1165;
Re-using: Free/Avail. Space 4329756/5420; EndEmpty/Avail. Pages 537/50. CPU
0.36s/0.09u sec.
NOTICE: Index filelist_date_index: Pages 129; Tuples 12146: Deleted 0. CPU
0.04s/0.12u sec.
NOTICE: Index filelist_dirid_index: Pages 134; Tuples 12146: Deleted 0. CPU
0.03s/0.18u sec.
NOTICE: Index filelist_id_index: Pages 129; Tuples 12146: Deleted 0. CPU
0.06s/0.16u sec.
NOTICE: Index filelist_name_index: Pages 247; Tuples 12146: Deleted 0. CPU
0.17s/0.15u sec.
NOTICE: Rel filelist: Pages: 847 --> 310; Tuple(s) moved: 0. CPU
0.10s/0.07u sec.
NOTICE: FlushRelationBuffers(filelist, 310): block 0 is referenced (private
0, global 5)
FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-07-18 14:43:47 Re: TOAST vs arrays
Previous Message ts 2000-07-18 12:12:07 Re: Untrusted PL/Tcl?