Thread: vacuum fails
vacuum fails with the following error: NOTICE: Rel beruf: Pages 18: Changed 0, Reapped 18, Empty 0, New 0; Tup 900: Vac 565, Crash 0, UnUsed 441, MinLen 60, . NOTICE: Ind idx_b: Pages 17; Tuples 900: Deleted 0. Elapsed 0/0 sec. NOTICE: Rel beruf: Pages: 18 --> 10. NOTICE: BlowawayRelationBuffers(beruf, 10): block 11 is referenced (private 0, last 0, global 1) FATAL 1: VACUUM (vc_vacheap): BlowawayRelationBuffers returned -2 what exactly does that mean? how do you recover from this? would i lose data if i dump the data from this table and recreate it? thanks frank
On Fri, 27 Aug 1999, Frank Joerdens wrote: > vacuum fails with the following error: > > NOTICE: Rel beruf: Pages 18: Changed 0, Reapped 18, Empty 0, New 0; Tup > 900: Vac 565, Crash 0, UnUsed 441, MinLen 60, . > NOTICE: Ind idx_b: Pages 17; Tuples 900: Deleted 0. Elapsed 0/0 sec. > NOTICE: Rel beruf: Pages: 18 --> 10. > NOTICE: BlowawayRelationBuffers(beruf, 10): block 11 is referenced > (private 0, last 0, global 1) > FATAL 1: VACUUM (vc_vacheap): BlowawayRelationBuffers returned -2 > > what exactly does that mean? how do you recover from this? would i lose > data if i dump the data from this table and recreate it? > > thanks > > frank Frank - That is what I did and it was fine. But Vadim told me later that all I really had to do was shutdown the server, restart it and re-vacuum. You might try that first (you may also have to rm the pesky pg_vlock in the ../data/base/whatever directory. BlowawayRelationBuffers sounds ominous doesn't it? It turned out not to be so bad in my case! Cheers, Tom ------- North Richmond Community Mental Health Center ------- Thomas Good MIS Coordinator Vital Signs: tomg@ { admin | q8 } .nrnet.org Phone: 718-354-5528 Fax: 718-354-5056 /* Member: Computer Professionals For Social Responsibility */
yep. restarting the server does the trick! cheers frank On Fri, Aug 27, 1999 at 01:03:34PM -0400, Thomas Good wrote: > On Fri, 27 Aug 1999, Frank Joerdens wrote: > > > vacuum fails with the following error: > > > > NOTICE: Rel beruf: Pages 18: Changed 0, Reapped 18, Empty 0, New 0; Tup > > 900: Vac 565, Crash 0, UnUsed 441, MinLen 60, . > > NOTICE: Ind idx_b: Pages 17; Tuples 900: Deleted 0. Elapsed 0/0 sec. > > NOTICE: Rel beruf: Pages: 18 --> 10. > > NOTICE: BlowawayRelationBuffers(beruf, 10): block 11 is referenced > > (private 0, last 0, global 1) > > FATAL 1: VACUUM (vc_vacheap): BlowawayRelationBuffers returned -2 > > > > what exactly does that mean? how do you recover from this? would i lose > > data if i dump the data from this table and recreate it? > > > > thanks > > > > frank > > Frank - > > That is what I did and it was fine. But Vadim told me later > that all I really had to do was shutdown the server, restart it and > re-vacuum. You might try that first (you may also have to rm the > pesky pg_vlock in the ../data/base/whatever directory. > > BlowawayRelationBuffers sounds ominous doesn't it? It turned out > not to be so bad in my case! > > Cheers, > Tom > > > ------- North Richmond Community Mental Health Center ------- > > Thomas Good MIS Coordinator > Vital Signs: tomg@ { admin | q8 } .nrnet.org > Phone: 718-354-5528 > Fax: 718-354-5056 > > /* Member: Computer Professionals For Social Responsibility */