Thread: reindexdb and "could not open relation" error message

reindexdb and "could not open relation" error message

From
Aleksander Kmetec
Date:
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