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,
MaxLen46; 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@smi.stanford.edu