pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVACUUM failing ??!!
5+ messages / 4 participants
[nested] [flat]
* VACUUM failing ??!!
@ 2004-11-05 15:15 Sally Sally <dedeb17@hotmail.com>
2004-11-05 15:21 ` Re: [GENERAL] VACUUM failing ??!! Devrim GUNDUZ <devrim@gunduz.org>
2004-11-05 16:04 ` Re: VACUUM failing ??!! Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: Sally Sally @ 2004-11-05 15:15 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org
After running for more than 24 hrs (I have a large db), vacuum failed with
this message:
ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
Has anybody encountered this before?
Thanks much
Sally
_________________________________________________________________
Check out Election 2004 for up-to-date election news, plus voter tools and
more! http://special.msn.com/msn/election2004.armx
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] VACUUM failing ??!!
2004-11-05 15:15 VACUUM failing ??!! Sally Sally <dedeb17@hotmail.com>
@ 2004-11-05 15:21 ` Devrim GUNDUZ <devrim@gunduz.org>
1 sibling, 0 replies; 5+ messages in thread
From: Devrim GUNDUZ @ 2004-11-05 15:21 UTC (permalink / raw)
To: Sally Sally <dedeb17@hotmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Fri, 5 Nov 2004, Sally Sally wrote:
> After running for more than 24 hrs (I have a large db), vacuum failed with
> this message:
> ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
> Has anybody encountered this before?
AFAIR, you have to REINDEX pg_type to get rid of this error.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBi5pmtl86P3SPfQ4RAtUDAJ4jyT6MMU3b7R/C4xVm918QsSTmkQCfZdCw
AQ6DWpdXhkhVM6jFKUQCQK0=
=GH8N
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM failing ??!!
2004-11-05 15:15 VACUUM failing ??!! Sally Sally <dedeb17@hotmail.com>
@ 2004-11-05 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-11-05 16:04 UTC (permalink / raw)
To: Sally Sally <dedeb17@hotmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org
"Sally Sally" <dedeb17@hotmail.com> writes:
> After running for more than 24 hrs (I have a large db), vacuum failed with
> this message:
> ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
What PG version?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM failing ??!!
@ 2004-11-05 17:19 Salem Berhanu <salemb4@hotmail.com>
2004-11-05 19:45 ` Re: VACUUM failing ??!! Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Salem Berhanu @ 2004-11-05 17:19 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; dedeb17@hotmail.com; +Cc: pgsql-admin; pgsql-general@postgresql.org
Version 7.4
(I just re-indexed and I'm running vacuum again)
>From: Tom Lane <tgl@sss.pgh.pa.us>
>To: "Sally Sally" <dedeb17@hotmail.com>
>CC: pgsql-admin@postgresql.org, pgsql-general@postgresql.org
>Subject: Re: [ADMIN] VACUUM failing ??!! Date: Fri, 05 Nov 2004 11:04:00
>-0500
>
>"Sally Sally" <dedeb17@hotmail.com> writes:
> > After running for more than 24 hrs (I have a large db), vacuum failed
>with
> > this message:
> > ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
>
>What PG version?
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: VACUUM failing ??!!
2004-11-05 17:19 Re: VACUUM failing ??!! Salem Berhanu <salemb4@hotmail.com>
@ 2004-11-05 19:45 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2004-11-05 19:45 UTC (permalink / raw)
To: Salem Berhanu <salemb4@hotmail.com>; +Cc: dedeb17@hotmail.com; pgsql-admin; pgsql-general@postgresql.org
"Salem Berhanu" <salemb4@hotmail.com> writes:
> Version 7.4
> (I just re-indexed and I'm running vacuum again)
I wonder if this is a variant of the concurrent-page-split
problem Joe Conway found. That's fixed in 7.4.5 and later.
Was this a plain vacuum, or vacuum full?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2004-11-05 19:45 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-05 15:15 VACUUM failing ??!! Sally Sally <dedeb17@hotmail.com>
2004-11-05 15:21 ` Devrim GUNDUZ <devrim@gunduz.org>
2004-11-05 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-05 17:19 Re: VACUUM failing ??!! Salem Berhanu <salemb4@hotmail.com>
2004-11-05 19:45 ` Tom Lane <tgl@sss.pgh.pa.us>
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