corrupt pg_language index <?>
От
Jon Dugan
Тема
corrupt pg_language index <?>
Дата
Msg-id
20011029112057.A26303@bowser.Stanford.EDU
Ответ на
Error: Relation 'testdb' does not exist (Craig Jarman)
Список
Дерево обсуждения
Error: Relation 'testdb' does not exist "Craig Jarman" <cjarman@source.com.au>
corrupt pg_language index <?> Jon Dugan <dugan@smi.stanford.edu>
Re: corrupt pg_language index <?> Tom Lane <tgl@sss.pgh.pa.us>
Re: Error: Relation 'testdb' does not exist Jean-Michel POURE <jm.poure@freesurf.fr>
Re: Error: Relation 'testdb' does not exist "Nick Fankhauser" <nickf@ontko.com>
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@smi.stanford.edu
В списке pgsql-admin по дате отправления
От: Ross J. Reedstrom
Дата: