From: | Ken Caruso <ken(at)ipl31(dot)net> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: 9.0.4 Data corruption issue |
Date: | 2011-07-16 19:42:47 |
Message-ID: | CAMg8r_rbdiQDe+Vr3M0PdxSKHmmxM42C1gWAwx6uObPoXEJiJQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sat, Jul 16, 2011 at 8:59 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Ken Caruso <ken(at)ipl31(dot)net> writes:
> > Had a DB that had bloated due to lots of updates and insuffcient auto
> vacuum
> > settings. Attempted the following in the following order:
>
> > VACUUM VERBOSE full tablename;
> > CLUSTER tablename;
>
> > Did the full first to ensure that the cluster had enough space to run.
> > The db had already been previously clustered to an index. At some point
> > during the VACUUM I started seeing the following errors in the logs:
>
> > CONTEXT: writing block 12125253 of relation base/2651908/652397108
>
> > WARNING: could not write block 12125253 of base/2651908/652397108
>
> > DETAIL: Multiple failures --- write error might be permanent.
>
> Ummm .... what's the actual ERROR?
>
Sorry, the actual error reported by CLUSTER is:
gpup=> cluster verbose tablename;
INFO: clustering "dbname.tablename"
WARNING: could not write block 12125253 of base/2651908/652397108
DETAIL: Multiple failures --- write error might be permanent.
ERROR: could not open file "base/2651908/652397108.1" (target block
12125253): No such file or directory
CONTEXT: writing block 12125253 of relation base/2651908/652397108
Thanks
-Ken
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-07-16 21:30:30 | Re: 9.0.4 Data corruption issue |
Previous Message | Tom Lane | 2011-07-16 15:59:52 | Re: 9.0.4 Data corruption issue |