| From: | "Tony Harper" <trharper5(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | RelationBuildDesc Notice (corrupt DB?) |
| Date: | 2003-04-03 12:57:05 |
| Message-ID: | b6hb2u$193v$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
DB appears to be corrupted but cannot isolate cause, it has happened
multiple times after recreating database. The system seems stable otherwise
The message when trying to do
psql name_of_database:
NOTICE: RelationBuildDesc: can't open pg_statistic: No such file or
directory
ERROR: cannot open pg_statistic: No such file or directory
if I do a \d
The message is:
cannot open pg_statistic: No such file or directory
if I do a verbose vacuum, things go fine till the end....a sample:
NOTICE: RelationBuildDesc: can't open pg_group: No such file or directory
NOTICE: RelationBuildDesc: can't open pg_group_name_index: No such file or
directory
NOTICE: RelationBuildDesc: can't open pg_group_sysid_index: No such file or
directory
Error: _mdfd_getreInfd: cannot open relation pg_group: No such file or
director
if I do a REINDEX from a backend:
NOTICE: RelationBuildDesc: can't open pg_group: No such file or directory
NOTICE: RelationBuildDesc: can't open pg_inherits: No such file or
directory
NOTICE: RelationBuildDesc: can't open pg_inherits_rlid_seqno_index: No such
file or directory
Anyone know what the real issue is or how to fix?
Thanks,
TRH
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-04-03 12:59:21 | Re: images in database |
| Previous Message | Pep | 2003-04-03 12:46:33 | Re: Anyone know of a news group for mysql? |