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.