pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedauto vacuum errors
4+ messages / 2 participants
[nested] [flat]
* auto vacuum errors
@ 2012-07-04 19:30 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Isabella Ghiurea @ 2012-07-04 19:30 UTC (permalink / raw)
To: pgsql-admin
HI Gurus
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 ?
The temp tables are growing too fast and they don't get
empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on RHES.
Isabella
--
-----------------------------------------------------------
Isabella A. Ghiurea
Isabella.Ghiurea@nrc-cnrc.gc.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: auto vacuum errors
@ 2012-07-05 04:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2012-07-05 04:18 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: auto vacuum errors
@ 2012-07-05 14:55 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Isabella Ghiurea @ 2012-07-05 14:55 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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.ghiurea@nrc-cnrc.gc.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.Ghiurea@nrc-cnrc.gc.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: auto vacuum errors
@ 2012-07-05 16:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2012-07-05 16:03 UTC (permalink / raw)
To: isabella.ghiurea@nrc-cnrc.gc.ca; +Cc: pgsql-admin
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> writes:
> 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 ?
What you ought to do is drop the tables that are reported as causing the
error. Or the whole database --- are you actually doing something
useful in contrib_regression, or is that just left over from testing?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-07-05 16:03 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-07-04 19:30 auto vacuum errors Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2012-07-05 04:18 ` Re: auto vacuum errors Tom Lane <tgl@sss.pgh.pa.us>
2012-07-05 14:55 ` Re: auto vacuum errors Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
2012-07-05 16:03 ` Re: auto vacuum errors Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox