Thread: System crash and trying to run vacuum getting errors
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 -- Dave Smith CANdata Systems Ltd 416-493-9020
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