Postgres Pro
Downloads
Home   >   mailing lists

reindexdb and "could not open relation" error message - Mailing list pgsql-general

From Aleksander Kmetec
Subject reindexdb and "could not open relation" error message
Date
Msg-id 44F4FB6A.30100@intera.si
Whole thread Raw
List pgsql-general
Tree view 
Hi!

For the past two days I've been getting the following errors from my cron scripts which connect to the database:

day 1, on a SELECT statement:
ERROR:  could not open relation 1663/35154/221872: No such file or directory

day 2, on a LOCK TABLE statement:
ERROR:  could not open relation 1663/35154/222823: No such file or directory

These errors are sent at the exact same time when reindexdb is also started and I cannot replicate them by executing
the 
same SQL statements at a different time. Should I be worried about this?

I'm running:
  PostgreSQL 8.1.4 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 4.1.0 20060304 (Red Hat
4.1.0-3)

Regards,
Aleksander

pgsql-general by date:

Previous
From: Michael Loftis
Date:
Subject: Santa Clara Pg Training Event (resent to -general)
Next
From: "Jasbinder Bali"
Date:
Subject: Version 1 Calling convention