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
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? |