Corrupted db?

Поиск
Список
Период
Сортировка
От Michael Brusser
Тема Corrupted db?
Дата
Msg-id DEEIJKLFNJGBEMBLBAHCEEMAECAA.michael@synchronicity.com
обсуждение исходный текст
Ответы Re: Corrupted db?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We got a problem ticket from the customer.
Messages in the error_log indicated problem trying to insert
a duplicate value into a table.
Looking at the database (v.7.3.2 on Solaris) I'm puzzled with this:

syncdb=# \d
ERROR:  Cache lookup failed for relation 17075

syncdb=# \di
ERROR:  Cache lookup failed for relation 17081

syncdb=# \d property_types;
ERROR:  Cache lookup failed for relation 17075

syncdb=# \d public.property_types          Table "public.property_types"  Column    |          Type           |
Modifiers
 
-------------+-------------------------+-----------id          | integer                 | not nullname        |
charactervarying(256)  | not nullstamp       | date                    | not nulldescription | character varying(1024)
|
 
Indexes: pt_pk primary key btree (id),        pt_name_uid_uk unique btree (name)


syncdb=# SET search_path = public, pg_catalog;
SET
syncdb=# \d property_types;
ERROR:  Cache lookup failed for relation 17075

syncdb=# select * from pg_namespace ; nspname   | nspowner | nspacl 
------------+----------+--------pg_catalog |        1 | {=U}pg_toast   |        1 | {=}public     |        1 |
{=UC}pg_temp_1 |        1 | 
 
(4 rows)

syncdb=# select * from property_types;id | name | stamp | description 
----+------+-------+-------------
(0 rows)

INSERT INTO property_types (id, name, description, stamp)
VALUES (nextval('pt_seq'), 'FROM_RELATIONSHIP',       'Describes the relationship of ...', date('today'));

ERROR:  Cannot insert a duplicate key into unique index pt_name_uid_uk
---------------------------------------------

I can only guess that something is corrupted.
What could lead to that?
Can this can be prevented or repaired?

Thank you,
Mike.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Disaster!
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: 7.5 change documentation