System crash and trying to run vacuum getting errors

Dave Smith <dave.smith@candata.com> writes:

After a abnormal system shutdown I am trying to run a
vacuum full verbose ANALYZE and getting the following error.

NOTICE: Analyzing classification
NOTICE: RelationBuildDesc: can't open pg_temp_5821_0: No such file or
directory
NOTICE: --Relation pg_temp_5821_0--
ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_5821_0: No such
file or directory

You should be able to DROP that table even though it doesn't have an
underlying file. My guess is that you are running atop a non-crash-safe
filesystem and it lost the directory entry for the just-created file.
You might want to think about switching to a journaling file system.

regards, tom lane

Yup that's what happened. Dropped them and all is good. I really should
get a list of all of the underling files for each index and table and
see if any others are missing.

On Wed, 2003-11-05 at 11:30, Tom Lane wrote:

Dave Smith <dave.smith@candata.com> writes:

After a abnormal system shutdown I am trying to run a
vacuum full verbose ANALYZE and getting the following error.

NOTICE: Analyzing classification
NOTICE: RelationBuildDesc: can't open pg_temp_5821_0: No such file or
directory
NOTICE: --Relation pg_temp_5821_0--
ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_5821_0: No such
file or directory

You should be able to DROP that table even though it doesn't have an
underlying file. My guess is that you are running atop a non-crash-safe
filesystem and it lost the directory entry for the just-created file.
You might want to think about switching to a journaling file system.

regards, tom lane

--
Dave Smith
CANdata Systems Ltd
416-493-9020

Dave Smith <dave.smith@candata.com> writes:

Yup that's what happened. Dropped them and all is good. I really should
get a list of all of the underling files for each index and table and
see if any others are missing.

If VACUUM ran to completion without complaints then there aren't any
other missing files.

regards, tom lane

Tom Lane <tgl@sss.pgh.pa.us> writes:

You should be able to DROP that table even though it doesn't have an
underlying file. My guess is that you are running atop a non-crash-safe
filesystem and it lost the directory entry for the just-created file.
You might want to think about switching to a journaling file system.

In which case you might find them in /lost+found

--
greg