reindexdb and "could not open relation" error message

Aleksander Kmetec <aleksander.kmetec@xxxxxxxxx> · Wed, 30 Aug 2006 04:43:54 +0200

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