Skip site navigation (1) Skip section navigation (2)

Re: auto vacuum errors

From: Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: auto vacuum errors
Date: 2012-07-05 14:55:39
Message-ID: 4FF5AAEB.6040103@nrc-cnrc.gc.ca (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Tom ,
  Here is my error  , the missing files were removed by mistake , I have 
another similar db cfg with this tables:spherrtmp% and no issues.
I 'm thinking to  restore  this tables content from this second db , 
will this  eliminate the auto vacuum error ?

07:45:59.770 PDT,,,31112,,4ff5a8a7.7988,5,,2012-07-05 07:45:59 
PDT,19/2479,0,ERROR,58P01,"could not open relation 26384/247389/248165: 
No such file or directory",,,,,"automatic vacuum of table 
""contrib_regression.public.spheretmp5""",,,
2012-07-05 07:45:59.770 PDT,,,31112,,4ff5a8a7.7988,6,,2012-07-05 
07:45:59 PDT,19/2481,0,ERROR,58P01,"could not open relation 
26384/247389/248174: No such file or directory",,,,,"automatic vacuum of 
table ""contrib_regression.public.spheretmp6""",,,


On 07/04/2012 09:18 PM, Tom Lane wrote:
> Isabella Ghiurea<isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca>  writes:
>> I'm seeing a issue with some temp tables in contrib_regression db , the
>> auto vacuum job will not run for this tables  due some files/QID's
>> missing  how can I fix this  ?
> Um ... in general, autovacuum just silently ignores temp tables, because
> it doesn't have any way to access their contents.  (One of the reasons
> that temp tables are fast is that the backend owning a temp table keeps
> its data in local buffers, not in shared buffers that another process
> could access.)  I wouldn't expect any "missing file" complaints though.
> What exactly were you seeing?
>
> 			regards, tom lane


-- 
-----------------------------------------------------------
Isabella A. Ghiurea

Isabella(dot)Ghiurea(at)nrc-cnrc(dot)gc(dot)ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2012-07-05 16:03:21
Subject: Re: auto vacuum errors
Previous:From: Craig RingerDate: 2012-07-05 12:22:47
Subject: Re: Delay in completion of aggregation inserts when run in a single commit - PG 9.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group