major database breakdown - Mailing list pgsql-general

From Ulrich Wisser
Subject major database breakdown
Date
Msg-id 41206EFB.5020705@relevanttraffic.se
Whole thread Raw
Responses Re: major database breakdown
List 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 by date:

Previous
From: "Reko Turja"
Date:
Subject: Re: postgres in freebsd jail
Next
From: Vinay Jain
Date:
Subject: distinct and equal operator