corrupt pg_language index <?>

From: Jon Dugan <dugan(at)smi(dot)stanford(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: corrupt pg_language index <?>
Date: 2001-10-29 19:20:57
Message-ID: 20011029112057.A26303@bowser.Stanford.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi all-

I have a problem with pg_language_oid_index on one db.

This problem makes vacuum fail, both from the command line (vacuumdb)
and within the DB, but therwise the db is still working ok.

prompt> /usr/bin/vacuumdb -a -z -q

... several other db vacuum ok.

on db iscb ...

NOTICE: Rel pg_class: TID 0/46: OID IS INVALID. TUPGONE 0.
ERROR: cannot find attribute 1 of relation pg_language_oid_index
vacuumdb: vacuum iscb failed

--

alternatly,
entering the db with "psql iscb" works,

iscb=# vacuum verbose;

...
...
...

NOTICE: --Relation pg_amproc--
NOTICE: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 54: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 46, MaxLen 46; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
NOTICE: --Relation pg_language--
NOTICE: Pages 1: Changed 0, reaped 0, Empty 0, New 0; Tup 3: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 79, MaxLen 84; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec.
ERROR: cannot find attribute 1 of relation pg_language_oid_index
iscb=#

iscb=# SELECT * from pg_language ;
ERROR: cannot find attribute 1 of relation pg_language_oid_index
iscb=#

iscb=# \d pg_language_oid_index
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentation fault

prompt>

ACK!

any suggestions?

running Mandrake 8 / Linux
uname = Linux bowser.Stanford.EDU 2.4.3-20mdksmp #1 SMP Sun Apr 15 22:32:27 CEST 2001 i686 unknown

rpm -qa | grep -i postgr
postgresql-libs-7.1.2-19mdk
postgresql-7.1.2-19mdk
postgresql-devel-7.1.2-19mdk
postgresql-server-7.1.2-19mdk
postgresql-contrib-7.1.2-19mdk

Thanks,
Jon

dugan(at)smi(dot)stanford(dot)edu

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sean Chittenden 2001-10-29 20:30:55 Re: FreeBSD upgrade causes performance degredation
Previous Message Ross J. Reedstrom 2001-10-29 19:18:15 Re: Code to automatically refresh sequences after loading data?