Re: FATAL: could not open relation xxx: No such file or directory

------=_Part_3581_11206518.1208429062241
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Thu, Apr 17, 2008 at 1:36 PM, Pavan Deolasee <pavan.deolasee@[EMAIL PROTECTED]
>
wrote:

> On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio <mpartio@[EMAIL PROTECTED]
> wrote:
>
> >
> > 2008-04-17 13:05:30 EEST [8435]: [32-1] ERROR:  could not open
relation
> > 1663/16386/359232: No such file or directory
> >
>
> Looks like a corrupt index to me. DId you try REINDEX on the table ?
>


Hi Pavan and thanks for your reply.

I tried to reindex the individual indexes in the table:

# reindex index xxx_idx;
ERROR:  could not open relation 1663/16386/359232: No such file or
directory

Since I thought the trouble may lie in the system catalogue indexes I
issued
a REINDEX SYSTEM db, which went through with no errors. After that I tried
to remove indexes from the table in question:

# drop index xxx_idx;
ERROR:  could not read block 0 of relation 1663/16386/2673: read only 0 of
8192 bytes

Hmm.. this is a different oid

# select 2673::regclass;
         regclass
--------------------------
 pg_depend_depender_index
(1 row)

But I just reindexed it!

# reindex table pg_depend;
WARNING:  could not remove relation 1663/16386/2673: No such file or
directory
REINDEX

When I fire pg_dump to take a last minute backup I see this error:

pg_dump: Error message from server: ERROR:  could not open relation
1663/16386/544529: No such file or directory
pg_dump: The command was: SELECT tgname, tgfoid::pg_catalog.regproc as
tgfname, tgtype, tgnargs, tgargs, tgenabled, tgisconstraint, tgconstrname,
tgdeferrable, tgconstrrelid, tginitdeferred, tableoid, oid,
tgconstrrelid::pg_catalog.regclass as tgconstrrelname from
pg_catalog.pg_trigger t where tgrelid = '294134'::pg_catalog.oid and
tgconstraint = 0

# reindex table pg_catalog.pg_trigger;
WARNING:  could not remove relation 1663/16386/544529: No such file or
directory
REINDEX

Seems like the whole db is falling apart.

Regards

Mikko

------=_Part_3581_11206518.1208429062241
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br><div class="gmail_quote">On Thu, Apr 17, 2008 at 1:36 PM, Pavan
Deolasee &lt;<a
href="mailto:pavan.deolasee@[EMAIL PROTECTED]
">pavan.deolasee@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio &lt;<a
href="mailto:mpartio@[EMAIL PROTECTED]
">mpartio@[EMAIL PROTECTED]
>&gt; wrote:<br>
<br>
&gt;<br>
&gt; 2008-04-17 13:05:30 EEST [8435]: [32-1] ERROR: &nbsp;could not open
relation<br>
&gt; 1663/16386/359232: No such file or directory<br>
&gt;<br>
<br>
</div>Looks like a corrupt index to me. DId you try REINDEX on the table
?<font color="#888888"><br>
</font></blockquote></div><br><br>Hi Pavan and thanks for your
reply.<br><br>I tried to reindex the individual indexes in the
table:<br><br># reindex index xxx_idx;<br>ERROR:&nbsp; could not open
relation 1663/16386/359232: No such file or directory<br>
<br>Since I thought the trouble may lie in the system catalogue indexes I
issued a REINDEX SYSTEM db, which went through with no errors. After that
I tried to remove indexes from the table in question:<br><br># drop index
xxx_idx;<br>
ERROR:&nbsp; could not read block 0 of relation 1663/16386/2673: read only
0 of 8192 bytes<br><br>Hmm.. this is a different oid<br><br># select
2673::regclass;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
regclass<br>--------------------------<br>&nbsp;pg_depend_depender_index<br>
(1 row)<br><br>But I just reindexed it!<br><br># reindex table
pg_depend;<br>WARNING:&nbsp; could not remove relation 1663/16386/2673: No
such file or directory<br>REINDEX<br><br>When I fire pg_dump to take a last
minute backup I see this error:<br>
<br>pg_dump: Error message from server: ERROR:&nbsp; could not open
relation 1663/16386/544529: No such file or directory<br>pg_dump: The
command was: SELECT tgname, tgfoid::pg_catalog.regproc as tgfname, tgtype,
tgnargs, tgargs, tgenabled, tgisconstraint, tgconstrname, tgdeferrable,
tgconstrrelid, tginitdeferred, tableoid, oid,
tgconstrrelid::pg_catalog.regclass as tgconstrrelname from
pg_catalog.pg_trigger t where tgrelid = &#39;294134&#39;::pg_catalog.oid
and tgconstraint = 0<br>
<br># reindex table pg_catalog.pg_trigger;<br>WARNING:&nbsp; could not
remove relation 1663/16386/544529: No such file or
directory<br>REINDEX<br><br>Seems like the whole db is falling
apart.<br><br>Regards<br><br>Mikko<br>

------=_Part_3581_11206518.1208429062241--