Skip site navigation (1) Skip section navigation (2)

Re: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Date: 2000-09-26 20:53:17
Message-ID: 1131.970001597@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
It looks like you are suffering from actual hardware failures:

%cd /pgsql/data/base/horde
%ls -l pg_attribute_relid_attnam_index
-rw-------  1 pgsql  pgsql  65536 Aug 21 12:27 pg_attribute_relid_attnam_index
%wc pg_attribute_relid_attnam_index
wc: pg_attribute_relid_attnam_index: read: Input/output error

%wc *
       1       1       4 PG_VERSION
wc: active_sessions: read: Input/output error
      13      50   16384 active_sessions_pkey
       0       0       0 auth_user
       0       0       0 auth_user_md5
       0       3   16384 auth_user_md5_pkey
       0       3   16384 auth_user_pkey
      51     806   32768 imp_addr
       0       5    8192 imp_logs
      97     468   16384 imp_pref
       0       3   16384 k_username
       0       3   16384 k_username_md5
       1     101    8192 pg_aggregate
       1      11   16384 pg_aggregate_name_type_index
       1      12    8192 pg_am
wc: pg_am_name_index: read: Input/output error
       3     220   16384 pg_amop
       3      31   16384 pg_amop_opid_index
       2      26   16384 pg_amop_strategy_index
       2      70    8192 pg_amproc
       0     136    8192 pg_attrdef
       0      10   16384 pg_attrdef_adrelid_index
      35     736   57344 pg_attribute
wc: pg_attribute_relid_attnam_index: read: Input/output error
      16     664   32768 pg_attribute_relid_attnum_index
      23     144   16384 pg_class
       2     112   16384 pg_class_oid_index
       2      17   16384 pg_class_relname_index
      58    3096   73728 pg_description
wc: pg_description_objoid_index: read: Input/output error
       2      84    8192 pg_index
       1      47   16384 pg_index_indexrelid_index
       0       0       0 pg_indexes
       0       0       0 pg_inheritproc
       0       0       0 pg_inherits
       0       3   16384 pg_inherits_relid_seqno_index
       0       4    1752 pg_internal.init
       0       0       0 pg_ipl
       0      10    8192 pg_language
       0       3   16384 pg_language_name_index
       0       8   16384 pg_language_oid_index
       0       0       0 pg_listener
wc: pg_listener_relname_pid_index: read: Input/output error
       1      39    8192 pg_opclass
       1      39   16384 pg_opclass_deftype_index
       1       9   16384 pg_opclass_name_index
wc: pg_operator: read: Input/output error
      11     652   32768 pg_operator_oid_index
      14      95   65536 pg_operator_oprname_l_r_k_index
     176    3305  212992 pg_proc
      71    1520   49152 pg_proc_oid_index
wc: pg_proc_proname_narg_type_index: read: Input/output error
       0       0       0 pg_relcheck
       0       3   16384 pg_relcheck_rcrelid_index
      28     351    8192 pg_rewrite
wc: pg_rewrite_oid_index: read: Input/output error
       0       3   16384 pg_rewrite_rulename_index
       0       0       0 pg_rules
      15     327   16384 pg_statistic
      10     232   16384 pg_statistic_relid_att_index
       0       0       0 pg_tables
       0       6    8192 pg_trigger
       0       4   16384 pg_trigger_tgconstrname_index
       0       5   16384 pg_trigger_tgconstrrelid_index
       0       5   16384 pg_trigger_tgrelid_index
       8     170   16384 pg_type
       3     150   16384 pg_type_oid_index
       2      20   16384 pg_type_typname_index
       0       0       0 pg_user
       0       0       0 pg_views
     655   13822 1132252 total


Do you know if there's a way to determine where these files are
physically stored?  I'm wondering if all the damaged indexes live
on the same disk track/cylinder/whatever ...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-09-26 21:07:28
Subject: Re: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Previous:From: The Hermit HackerDate: 2000-09-26 20:38:17
Subject: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group