Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[PORTS] Port Bug Report: vacuum failed.

0 views
Skip to first unread message

Unprivileged user

unread,
Jul 31, 1998, 3:00:00 AM7/31/98
to pgsql...@postgresql.org

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name : Bill Kirkpatrick
Your email address : wk...@snip.net

Category : runtime: back-end
Severity : non-critical

Summary: vacuum failed.

System Configuration
--------------------
Operating System : Linux 2.0.34 ELF

PostgreSQL version : 6.3.2

Compiler used : gcc version 2.7.2


Hardware:
---------
PII, 64MB, SMP

Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
NOTICE: BlowawayRelationBuffers(edsys, 103): block 547 is referenced (private 0
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

--------------------------------------------------------------------------

Test Case:
----------
Using the database as a single user, with only one copy of psql
running. Doing general data manipulation work, select, insert,
updates, select into's, then decide to do a vacuum.
Get error and won't vacuum anymore because of the lock file.

Third time this has happened.

I'm keeping lots of pg_dump files now, but recreating
databases as a matter of course is, well, bad.

Any ideas?

BK

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------

Vadim Mikheev

unread,
Jul 31, 1998, 3:00:00 AM7/31/98
to Bill Kirkpatrick
Unprivileged user wrote:
>
> Problem Description:
> --------------------
> NOTICE: BlowawayRelationBuffers(edsys, 103): block 547 is referenced (private 0
> FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
>
> Using the database as a single user, with only one copy of psql
> running. Doing general data manipulation work, select, insert,
> updates, select into's, then decide to do a vacuum.
> Get error and won't vacuum anymore because of the lock file.
>
> Third time this has happened.
>
> I'm keeping lots of pg_dump files now, but recreating
> databases as a matter of course is, well, bad.

Not required.

>
> Any ideas?

No one. It seems that there is some buffer leak in code.
Vacuum can't truncate referenced data blocks.

Vadim


0 new messages