| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dave Smith <dave(dot)smith(at)candata(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: System crash and trying to run vacuum getting errors |
| Date: | 2003-11-05 16:30:12 |
| Message-ID: | 2879.1068049812@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dave Smith <dave(dot)smith(at)candata(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Smith | 2003-11-05 16:33:48 | Re: System crash and trying to run vacuum getting errors |
| Previous Message | Michael Glaesemann | 2003-11-05 15:50:06 | Re: Help on update that subselects other records in table, uses joins |