Tom Lane wrote:
"Wyatt Tellis" <wtellis@xxxxxxxxxxxxxxxxxx> writes:
I'm running 8.1.4 on W2K3 R2. I occasionally get errors of the type:
ERROR: could not open relation 1663/856689/856777: Invalid argument
Is there a command or way to determine if an index is corrupt? Is there
anyway to discern this info from the error message itself (i.e. are the
numbers a pointer to a specific index)?
856689 references a database OID (try "select datname from pg_database
where oid = 856689") and then 856777 is a relfilenode (in that database,
do "select relname from pg_class where relfilenode = 856777").
As for what "Invalid argument" on a file open might mean, my personal
advice is to get a real operating system. W2K is by far the weakest
link in your platform.
I was able to figure out the table name, but is there a way to figure
out which file caused this error?
-Wyatt
