reindexdb and "could not open relation" error message

From: Aleksander Kmetec <aleksander(dot)kmetec(at)intera(dot)si>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: reindexdb and "could not open relation" error message
Date: 2006-08-30 02:43:54
Message-ID: 44F4FB6A.30100@intera.si
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Jasbinder Bali 2006-08-30 04:25:28 Version 1 Calling convention
Previous Message Michael Loftis 2006-08-30 00:55:41 Santa Clara Pg Training Event (resent to -general)