Received: from mail2.panix.com (mail2.panix.com [166.84.0.213]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA98081 for ; Fri, 27 Aug 1999 13:04:21 -0400 (EDT) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (mailhost.nrnet.org [166.84.192.39]) by mail2.panix.com (Postfix) with ESMTP id 6748318C8A; Fri, 27 Aug 1999 13:04:18 -0400 (EDT) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.8.7/8.8.4) with UUCP id NAA00768; Fri, 27 Aug 1999 13:01:02 -0400 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.8.7/8.8.7) with SMTP id NAA30760; Fri, 27 Aug 1999 13:03:34 -0400 Date: Fri, 27 Aug 1999 13:03:34 -0400 (EDT) From: Thomas Good To: Frank Joerdens Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] vacuum fails In-Reply-To: <37C6BD4C.E81C0B21@x9media.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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 */