I am running Postgres 8.1.4 on Windows XP Professional Service Pack 3.
Yesterday when attempting to select from one particular database I repeatedly
encountered errors such as the following:
2009-08-18 10:49:54 ERROR: could not open relation 1663/51796/1247: No such
file or directory
2009-08-18 10:49:54 STATEMENT: SELECT typname FROM pg_type WHERE oid = 1043
1247 is pg_type. In Explorer I could see the file 51796/1247, and the timestamp
indicated that it had not recently been updated. I had never previously seen
this error.
As that database is used only for testing, I dropped it and loaded a new one
from a dump. However, earlier today a colleague working against this new
database experienced a slightly different error on several occasions:
2009-08-19 03:06:45 ERROR: could not read block 0 of relation
1663/52752/52896: No such file or directory
2009-08-19 03:06:45 STATEMENT: SELECT * FROM "RP"."RP_ATTRIBUTE" WHERE rp_id =
(('MM100')::text)
52752/52896 is the Primary Key index on the referenced table. Again, I can see
the file in Explorer, and it has not been updated since the database was
created. When I try the same Select statement now I get no error.
Clearly something is amiss, but I don't know what. I should be grateful for any
suggestions as to what I should check.
