pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedvacuum failure...
3+ messages / 2 participants
[nested] [flat]
* vacuum failure...
@ 2003-02-11 15:01 Michael Richards <michael@fastmail.ca>
2003-02-11 15:43 ` Re: vacuum failure... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Richards @ 2003-02-11 15:01 UTC (permalink / raw)
To: pgsql-sql
I've got a problem vacuuming a table and can't seem to find a way to
fix it...
vacuum full verbose analyze folders;
NOTICE: --Relation folders--
NOTICE: Pages 18598: Changed 0, reaped 18598, Empty 0, New 0; Tup
69849: Vac 0, Keep/VTL 0/0, UnUsed 1870572, MinLen 64, MaxLen 88; Re-
using: Free/Avail. Space 139159408/139159408; EndEmpty/Avail. Pages
0/18598.
CPU 0.34s/0.09u sec elapsed 0.51 sec.
ERROR: No one parent tuple was found
-Michael
_________________________________________________________________
http://fastmail.ca/ - Fast Secure Web Email for Canadians
From pgsql-sql-owner@postgresql.org Tue Feb 11 10:34:16 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
by postgresql.org (Postfix) with ESMTP id B8543475AAC
for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 10:34:15 -0500 (EST)
Received: from trill.maridan.net (unknown [217.6.52.210])
by postgresql.org (Postfix) with ESMTP id 4148F475A9E
for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 10:34:13 -0500 (EST)
Received: from polonium.de ([212.121.156.162])
by trill.maridan.net (8.9.3/8.9.3) with ESMTP id QAA24667
for <pgsql-sql@postgresql.org>; Tue, 11 Feb 2003 16:34:12 +0100
Message-ID: <3E491854.9080401@polonium.de>
Date: Tue, 11 Feb 2003 16:35:48 +0100
From: Rafal Kedziorski <rafcio@polonium.de>
Organization: POLONIUM
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: constrains questios ..
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/214
X-Sequence-Number: 11612
Hi,
is better to create constrains while creating table or after the table
is created? I'm working on sql script which should create about 40 tables.
Best Regards,
Rafal
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: vacuum failure...
2003-02-11 15:01 vacuum failure... Michael Richards <michael@fastmail.ca>
@ 2003-02-11 15:43 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2003-02-11 15:43 UTC (permalink / raw)
To: Michael Richards <michael@fastmail.ca>; +Cc: pgsql-sql
"Michael Richards" <michael@fastmail.ca> writes:
> ERROR: No one parent tuple was found
Postgres version?
AFAIR, all known causes of this are fixed in 7.2.4.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: vacuum failure...
@ 2003-02-11 16:27 Michael Richards <michael@fastmail.ca>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Richards @ 2003-02-11 16:27 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; +Cc: pgsql-sql
> "Michael Richards" <michael@fastmail.ca> 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 <pgsql-sql@postgresql.org>; 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 <pgsql-sql@postgresql.org>; 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" <michael@fastmail.ca>
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" <michael@fastmail.ca>
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 <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/218
X-Sequence-Number: 11616
"Michael Richards" <michael@fastmail.ca> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-02-11 16:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-11 15:01 vacuum failure... Michael Richards <michael@fastmail.ca>
2003-02-11 15:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-02-11 16:27 Re: vacuum failure... Michael Richards <michael@fastmail.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox