major database breakdown

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

Responses

Browse pgsql-general by date

  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?