major database breakdown
От | Ulrich Wisser |
---|---|
Тема | major database breakdown |
Дата | |
Msg-id | 41206EFB.5020705@relevanttraffic.se обсуждение исходный текст |
Ответы |
Re: major database breakdown
|
Список | pgsql-general |
Hi, last night I tried to reindex my database with some really ugly results. I can no longer use the database. backend> REINDEX DATABASE "CLIX1" NOTICE: relation 16416 was reindexed NOTICE: relation 1255 was reindexed NOTICE: relation 16410 was reindexed NOTICE: relation 1247 was reindexed NOTICE: relation 1249 was reindexed NOTICE: relation 1259 was reindexed NOTICE: relation 16388 was reindexed NOTICE: relation 16390 was reindexed NOTICE: relation 16392 was reindexed NOTICE: relation 16394 was reindexed NOTICE: relation 16396 was reindexed NOTICE: relation 16398 was reindexed NOTICE: relation 16400 was reindexed NOTICE: relation 16402 was reindexed NOTICE: relation 16404 was reindexed NOTICE: relation 16406 was reindexed NOTICE: relation 16412 was reindexed NOTICE: relation 16418 was reindexed NOTICE: relation 16594 was reindexed NOTICE: relation 16596 was reindexed NOTICE: relation 16598 was reindexed NOTICE: relation 16384 was reindexed NOTICE: relation 16386 was reindexed ERROR: Cannot create unique index. Table contains non-unique values backend> Which relation is that? How can I find that relation? When I try to use the database this error shows up: -bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1 LOG: database system was shut down at 2004-08-15 23:04:53 CEST LOG: checkpoint record is at 11C/19619E54 LOG: redo record is at 11C/19619E54; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 51038367; next oid: 128363530 LOG: database system is ready POSTGRES backend interactive interface $Revision: 1.307.2.1 $ $Date: 2003/01/01 21:57:18 $ backend> vacuum full analyze verbose WARNING: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (278) IS NOT THE SAME AS HEAP' (281). Recreate the index. WARNING: Index pg_class_relname_nsp_index: NUMBER OF INDEX' TUPLES (278) IS NOT THE SAME AS HEAP' (281). Recreate the index. ERROR: _mdfd_getrelnfd: cannot open relation pg_statistic_relid_att_index: No such file or directory backend> TIA Ulrich
В списке pgsql-general по дате отправления: