RelationBuildDesc Notice

From: "Tony Harper" <trharper5(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: RelationBuildDesc Notice
Date: 2003-04-03 12:56:38
Message-ID: b6hb22$192j$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-04-03 15:04:48 Re: Delete triggers
Previous Message Mathew Frank 2003-04-03 12:35:26 Delete triggers