Re: major database breakdown

Hi Tom,

I did delete everything from pg_statistic. It helped somewhat but
still there is something strange. Please see the transcript of my
session below. How can I fix these broken indexes? I can't drop and
recreate them.

Would be nice to get back online.

Thanks

Ulrich




bash-2.05b$ postgres -D /var/lib/pgsql/data-broken/ -O -P CLIX1
LOG:  database system was shut down at 2004-08-16 11:21:57 CEST
LOG:  checkpoint record is at 11C/363F610C
LOG:  redo record is at 11C/363F610C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 51039682; next oid: 128363647
LOG:  database system is ready

POSTGRES backend interactive interface
$Revision: 1.307.2.1 $ $Date: 2003/01/01 21:57:18 $

backend> delete from pg_statistic
blank
          1: ctid        (typeid = 27, len = 6, typmod = -1, byval = f)
         ----
backend> vacuum full analyze verbose
ERROR:  _mdfd_getrelnfd: cannot open relation
pg_statistic_relid_att_index: No such file or directory
backend> drop index pg_statistic_relid_att_index
ERROR:  Cannot drop index pg_statistic_relid_att_index because it is
required by the database system
backend> reindex table pg_statistic force
WARNING:  cannot unlink 16977/128363646: No such file or directory
backend> reindex table pg_statistic force
backend> vacuum full analyze verbose
WARNING:  Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(0) IS NOT THE SAME AS HEAP' (182).
         Recreate the index.
WARNING:  Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(0) IS NOT THE SAME AS HEAP' (182).
         Recreate the index.
WARNING:  Index pg_toast_16408_index: NUMBER OF INDEX' TUPLES (0) IS NOT
THE SAME AS HEAP' (5).
         Recreate the index.
backend>
backend> reindex index pg_statistic_relid_att_index force
backend> reindex index pg_toast_16408_index force
ERROR:  Relation "pg_toast_16408_index" does not exist
backend> vacuum full analyze verbose
WARNING:  Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(159) IS NOT THE SAME AS HEAP' (341).
         Recreate the index.
WARNING:  Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(146) IS NOT THE SAME AS HEAP' (341).
         Recreate the index.
WARNING:  Index pg_toast_16408_index: NUMBER OF INDEX' TUPLES (6) IS NOT
THE SAME AS HEAP' (11).
         Recreate the index.