VACUUM problem
Hello.
Recently some users started to complain about:
Warning: PostgresSQL query failed: FATAL 1: btree: lost page in the chain of duplicates
I noticed that VACUUM removes this problem, but no making
VACUUM I've got:
NOTICE: BlowawayRelationBuffers(confread, 45): block 154 is referenced (private 0, last 0,
global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
What it can be? I'm using 6.3.2
Andrey
On Tue, 2 Feb 1999, XXXXXX XXXXXXX wrote:
Hello.
Recently some users started to complain about:
Warning: PostgresSQL query failed: FATAL 1: btree: lost page in the chain of duplicatesI noticed that VACUUM removes this problem, but no making
VACUUM I've got:
NOTICE: BlowawayRelationBuffers(confread, 45): block 154 is referenced (private 0, last 0,
global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2What it can be? I'm using 6.3.2
A relatively old version of PostgreSQL...upgrade to v6.4.2, as I
believe this was fixed several months ago, in v6.4...
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org