Re: [ADMIN] What does this error mean ?

> Hi
>
> during a vacuum i got this error :
>
> NOTICE: BlowawayRelationBuffers(aluno, 119): block 221 is referenced (private
> 0, last 0, global 1)
> FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
>
> what exactly does it mean ?
>

I searched through the source code and found the function you are speaking of and
here is the documentation before the BlowawayRelationBuffers() function:/*
---------------------------------------------------------------------wawayRelationBuffers

*
* This function blowaway all the pages with blocknumber >= passed
* of a relation in the buffer pool. Used by vacuum before truncati
on...
*
* Returns: 0 - Ok, -1 - DIRTY, -2 - PINNED
*
* XXX currently it sequentially searches the buffer pool, should b
e
* changed to more clever ways of searching.
* --------------------------------------------------------------------
*/

Reading that, tells me that Vacuum called this function and it returned a -2
meaning "PINNED". Now I am not sure what "PINNED" means, but I don't have time
write now to really look at the source code. For your edification, though, the
source code file is:

$PGSQLSRCROOT/src/backend/storage/buffer/bufmgr.c

If you look in this file you will find the source for the
BlowawayRelationBuffers() function, and can probably figure out whats going on
from there...james