From: | Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | major database breakdown |
Date: | 2004-08-16 08:23:23 |
Message-ID: | 41206EFB.5020705@relevanttraffic.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Vinay Jain | 2004-08-16 11:25:04 | distinct and equal operator |
Previous Message | Maurizio Merli | 2004-08-16 07:22:45 | PostgreSQL 8.0.0 - Win32 C-Language function how to? |