Re: [GENERAL] Vacuum Crash - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] Vacuum Crash
Date
Msg-id 37233BB7.7D2D8010@krs.ru
Whole thread Raw
In response to Vacuum Crash  (lynch@cognitivearts.com (Richard Lynch))
Responses pg_dump core dumps  (Ari Halberstadt <ari@shore.net>)
List pgsql-general
Richard Lynch wrote:
>
> PostgreSQL 6.3.2 said:
>
> NOTICE:  BlowawayRelationBuffers(places, 322): block 336 is referenced
> (private 0, last 0, global 1)
> FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
>
> And now I need to go find the vacuum lock file and blow it away, but I
> don't really understand the above message, so wanna ask if I need to worry
> about it...

Restart postmaster, remove pg_vlock file and run vacuum again.

Vadim

pgsql-general by date:

Previous
From: lynch@cognitivearts.com (Richard Lynch)
Date:
Subject: rel-vars?
Next
From: Ernst Lehmann
Date:
Subject: Status of group implementation