pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
VACUUM failing ??!!
5+ messages / 4 participants
[nested] [flat]

* VACUUM failing ??!!
@ 2004-11-05 15:15  Sally Sally <dedeb17@hotmail.com>
  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:21  Devrim GUNDUZ <devrim@gunduz.org>
  parent: Sally Sally <dedeb17@hotmail.com>
  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 16:04  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Sally Sally <dedeb17@hotmail.com>
  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>
  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 19:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Salem Berhanu <salemb4@hotmail.com>
  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