Re: System crash and trying to run vacuum getting errors
От | Dave Smith |
---|---|
Тема | Re: System crash and trying to run vacuum getting errors |
Дата | |
Msg-id | 1068050027.3021.43.camel@playpen обсуждение исходный текст |
Ответ на | Re: System crash and trying to run vacuum getting errors (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: System crash and trying to run vacuum getting errors
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: