Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Vacuumdb er...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 7 Topic 4923 of 5407
Post > Topic >>

Re: Vacuumdb error - corruption

by PBhella@[EMAIL PROTECTED] ("Bhella Paramjeet-PFCW67") Apr 24, 2008 at 01:12 PM

=20
Hi Tom,

We recreated the index and that fixed it last week. We also had similar
failure few days back on a table but fortunately we had the luxury of
recreating it as the data was not so im****tant, so we survived.
Yesterday we upgraded our postgres databases to 8.0.15 as suggested and
again we got error while vacuum analayze was run on the database and
this time it is on a different database and different table. I am not
able to access the table in question. Here is the error I get while
accessing the table. How do we recover this table from the error.

ectest=3D# select count(*) from securityevent;
ERROR:  could not access status of transaction 33554431
DETAIL:  could not open file "/pgdata/ec/data/pg_clog/001F": No such
file or directory

Error in the database vacuum log.
INFO:  vacuuming "public.securityevent"
WARNING:  relation "securityevent" TID 21/3: OID is invalid
vacuumdb: vacuuming of database "ectest" failed: ERROR:  could not
access status of transaction 33554431
DETAIL:  could not open file "/pgdata/ec/data/pg_clog/001F": No such
file or directory

Here are the machine specifics on which this database is running:=20
Platform: Linux x86_64
OS:  Red Hat Enterprise Linux ES release 4 Kernel version: 2.6.9-34

According to our sysadmin there are no bad disks on the emc storage. So
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 re****ted 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=20

-----Original Message-----
From: Tom Lane [mailto:tgl@[EMAIL PROTECTED]
 Thursday, April 17, 2008 5:18 PM
To: Bhella Paramjeet-PFCW67
Cc: pgsql-admin@[EMAIL PROTECTED]
 Subbiah Stalin-XCGF84
Subject: Re: [ADMIN] Vacuumdb error=20

"Bhella Paramjeet-PFCW67" <PBhella@[EMAIL PROTECTED]
> writes:
> We have our production postgres 8.0.10 database running on linux=20
> x86_64 machine. Recently we have started getting an error from one of=20
> our database while running vacuumdb. We are not getting this error=20
> during backups just only during vacuuming of a database. Can anyone=20
> 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=20
> "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

--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 7 Posts in Topic:
Vacuumdb error
PBhella@[EMAIL PROTECTED]  2008-04-17 19:21:47 
Re: Vacuumdb error
tgl@[EMAIL PROTECTED] (T  2008-04-17 20:18:05 
Re: Vacuumdb error - corruption
PBhella@[EMAIL PROTECTED]  2008-04-24 13:12:53 
Re: Vacuumdb error - corruption
tgl@[EMAIL PROTECTED] (T  2008-04-24 13:36:12 
Re: Vacuumdb error - corruption
PBhella@[EMAIL PROTECTED]  2008-04-25 18:03:12 
Re: Vacuumdb error - corruption
ajs@[EMAIL PROTECTED] (A  2008-04-26 08:56:09 
Re: Vacuumdb error - corruption
Eric.Comeau@[EMAIL PROTEC  2008-04-25 16:39:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Oct 10 23:28:51 CDT 2008.