Received: from shark.x9media.com ([62.104.116.95]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA04043 for ; Fri, 27 Aug 1999 13:41:41 -0400 (EDT) (envelope-from frank@x9media.com) Received: (from frank@localhost) by shark.x9media.com (8.8.7/8.8.7) id TAA18438; Fri, 27 Aug 1999 19:56:54 +0200 Date: Fri, 27 Aug 1999 19:56:52 +0200 From: Frank Joerdens To: Thomas Good Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] vacuum fails Message-ID: <19990827195651.A18372@shark.x9media.com> References: <37C6BD4C.E81C0B21@x9media.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.6i In-Reply-To: ; from Thomas Good on Fri, Aug 27, 1999 at 01:03:34PM -0400 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 */