Postgres Pro
Downloads
Home   >   mailing lists

Thread: vacuum problems

vacuum problems

From
Sebestyen Zoltan
Date:
Hi,
 I'm writing a logfile processing app.
 everytime I processed a logfile and moved the information into a
relation, I try to vacuum it. But after a while (after the nth logfile)
vacuum freezes with the following message:

NOTICE:  BlowawayRelationBuffers(annex_log, 7): block 7 is referenced
(private 0, last 0, global 1)
FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

 What went wrong?

    Thanks in advance

--------------------------------------------------------------------------------
Sebestyén Zoltán <szoli@netvisor.hu>    I'm believing that the Holy Spirit is
                    gonna allow the hand, and the foot, and
MAKE INSTALL NOT WAR            the mouth, just to begin to speak, and
                                        to minister, and to heal coordinated by
                    the head.

I use UNIX because reboots are for hardware upgrades.

           -- Waiting for FreeBSD 3.1, not Godot --

Re: [GENERAL] vacuum problems

From
"Giovanni Floridia"
Date:
> Hi,
>  I'm writing a logfile processing app.
>  everytime I processed a logfile and moved the information into a
> relation, I try to vacuum it. But after a while (after the nth logfile)
> vacuum freezes with the following message:
>
> NOTICE:  BlowawayRelationBuffers(annex_log, 7): block 7 is referenced
> (private 0, last 0, global 1)
> FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
>
>  What went wrong?

I had the same problem. First I had to dump and recover and all was
OK. As this procedure is not convenient the next time that hapened I
tryed to discover wich table had the problem. I made a
vacuum verbose table_X
for each table in the database. For my surprise I was not able to find
a table with a problem. Then I tried
vacuum
in all tables again and all was OK.

I have no idea what was going on...
and I haven't repetead the procedure yet, but
it was not necessary to dump/recover to make vacuum again!

Giovanni Floridia

====================================

Re: [GENERAL] vacuum problems

From
Sebestyen Zoltan
Date:
> I had the same problem. First I had to dump and recover and all was
...
> vacuum
> in all tables again and all was OK.
I did what you told me and it helped... I experienced the same.

> I have no idea what was going on...
Neither I :)
It's still a bit messy because all the output of the app is logged and the
operators (not that trained ones) will complain to me about it :(

--------------------------------------------------------------------------------
Sebestyén Zoltán <szoli@netvisor.hu>    I'm believing that the Holy Spirit is
                    gonna allow the hand, and the foot, and
MAKE INSTALL NOT WAR            the mouth, just to begin to speak, and
                                        to minister, and to heal coordinated by
                    the head.

I use UNIX because reboots are for hardware upgrades.

           -- Waiting for FreeBSD 3.1, not Godot --