X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 421DE475A45 for ; Tue, 11 Feb 2003 11:27:11 -0500 (EST) Received: from mail.interchange.ca (ns.interchange.ca [216.126.79.2]) by postgresql.org (Postfix) with ESMTP id C541B475925 for ; Tue, 11 Feb 2003 11:27:10 -0500 (EST) Received: by mail.interchange.ca (Fastmailer, from userid 555) id 9383688EB; Tue, 11 Feb 2003 11:27:24 -0500 (EST) Received: from 24.43.130.193 by www.fastmail.ca with HTTP; Tue, 11 Feb 2003 16:27:24 +0000 (UTC) MIME-Version: 1.0 Message-Id: <3E49246C.000009.72557@ns.interchange.ca> To: tgl@sss.pgh.pa.us Subject: Re: vacuum failure... Cc: pgsql-sql@postgresql.org Date: Tue, 11 Feb 2003 11:27:24 -0500 (EST) From: "Michael Richards" X-Fastmail-IP: [24.43.130.193] X-Virus-Scanned: by AMaViS new-20020517 Content-Transfer-Encoding: 7bit Content-Type: Text/Plain X-Archive-Number: 200302/217 X-Sequence-Number: 11615 > "Michael Richards" writes: >> ERROR: No one parent tuple was found > > Postgres version? > > AFAIR, all known causes of this are fixed in 7.2.4. Oops, sorry: version --------------------------------------------------------------------- PostgreSQL 7.2.3 on i386-unknown-freebsd4.5, compiled by GCC 2.95.3 If I upgrade to 7.2.4 will that fix the problem or just fix a bug that would cause that problem? -Michael _________________________________________________________________ http://fastmail.ca/ - Fast Secure Web Email for Canadians From pgsql-sql-owner@postgresql.org Tue Feb 11 11:29:52 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 98F4F475A45 for ; Tue, 11 Feb 2003 11:29:51 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id E606C475843 for ; Tue, 11 Feb 2003 11:29:50 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1BGTt5u026094; Tue, 11 Feb 2003 11:29:55 -0500 (EST) To: "Michael Richards" Cc: pgsql-sql@postgresql.org Subject: Re: vacuum failure... In-reply-to: <3E49246C.000009.72557@ns.interchange.ca> References: <3E49246C.000009.72557@ns.interchange.ca> Comments: In-reply-to "Michael Richards" message dated "Tue, 11 Feb 2003 11:27:24 -0500" Date: Tue, 11 Feb 2003 11:29:54 -0500 Message-ID: <26093.1044980994@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/218 X-Sequence-Number: 11616 "Michael Richards" writes: > If I upgrade to 7.2.4 will that fix the problem or just fix a bug > that would cause that problem? It should make the problem go away --- the on-disk configuration is legitimate, it's just VACUUM that's getting confused. (Unless you have some new variant of this issue that we haven't seen before.) regards, tom lane