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

Re: Vacuumdb error - corruption

From: "Eric Comeau" <Eric(dot)Comeau(at)signiant(dot)com>
To: "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>,"Subbiah Stalin-XCGF84" <SSubbiah(at)Motorola(dot)com>
Subject: Re: Vacuumdb error - corruption
Date: 2008-04-25 21:39:29
Message-ID: 35FABCF85D99464FB00BC5123DC2A70A03F096E1@s228130hz1ew09.apptix-01.savvis.net (view raw or flat)
Thread:
Lists: pgsql-admin

> -----Original Message-----
> From: Bhella Paramjeet-PFCW67 [mailto:PBhella(at)Motorola(dot)com]
> Sent: Thursday, April 24, 2008 1:13 PM
> To: Tom Lane
> Cc: pgsql-admin(at)postgresql(dot)org; Subbiah Stalin-XCGF84
> Subject: Re: Vacuumdb error - corruption
> 
> 
> According to our sysadmin there are no bad disks on the emc storage.
So

EMC Storage? Is the Database sitting on NFS storage?


> what do you suggest we should do to narrow out the problem. Any help
> will be highly appreciated. I have looked into the postgres archives
and
> people have reported this problem but there were no responses as to
how
> they resolved this issue. Do you still think it is due to block
> corruption on disk? Please advice.
> 
> Thanks
> Paramjeet Kaur
> 
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Thursday, April 17, 2008 5:18 PM
> To: Bhella Paramjeet-PFCW67
> Cc: pgsql-admin(at)postgresql(dot)org; Subbiah Stalin-XCGF84
> Subject: Re: [ADMIN] Vacuumdb error
> 
> "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> writes:
> > We have our production postgres 8.0.10 database running on linux
> > x86_64 machine. Recently we have started getting an error from one
of
> > our database while running vacuumdb. We are not getting this error
> > during backups just only during vacuuming of a database. Can anyone
> > please help us figure out why we are getting this error and how we
can
> 
> > get rid of it. Any help will be appreciated.
> 
> > Here is the error:
> > tst_021 ERROR:  invalid page header in block 8 of relation
> > "securityevent_pkey"
> 
> Well, since it's just an index, you should be able to fix it by
> reindexing.  But I'd worry a bit about what caused the corruption.
> 8.0.10 is not exactly current --- you should update to 8.0.latest.
> And running some memory and disk diagnostics might not be wasted
effort.
> 
> 			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Bhella Paramjeet-PFCW67Date: 2008-04-25 22:03:12
Subject: Re: Vacuumdb error - corruption
Previous:From: Márcio Aguiar RibeiroDate: 2008-04-25 15:39:35
Subject: Re: Server format and recovery

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