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" <cjarman@source.com.au>) |
Ответы |
Re: corrupt pg_language index >
|
Список | 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, 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
В списке pgsql-admin по дате отправления: