pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Invalid page header in block 25561983 of relation pg_tblspc 2+ messages / 2 participants [nested] [flat]
* Invalid page header in block 25561983 of relation pg_tblspc @ 2016-12-27 09:24 Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> 2016-12-27 11:01 ` Re: Invalid page header in block 25561983 of relation pg_tblspc Michael Paquier <michael.paquier@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Dinesh Chandra 12108 @ 2016-12-27 09:24 UTC (permalink / raw) To: pgsql-performance; +Cc: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> Dear Expert, I am getting the below error in my database. ERROR: invalid page header in block 25561983 of relation pg_tblspc/55703433/PG_9.1_201105231/55703436/113490260 Can you please suggest me how to resolve it? I think its related to block corruption. How can I find particular block in which table? And how to resolve that particular block issue. Thanks in adwance Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. ------------------------------------------------------------------ Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com<mailto:%7Cdinesh.chandra@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. ________________________________ DISCLAIMER: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Check all attachments for viruses before opening them. All views or opinions presented in this e-mail are those of the author and may not reflect the opinion of Cyient or those of our affiliates. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Invalid page header in block 25561983 of relation pg_tblspc 2016-12-27 09:24 Invalid page header in block 25561983 of relation pg_tblspc Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> @ 2016-12-27 11:01 ` Michael Paquier <michael.paquier@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael Paquier @ 2016-12-27 11:01 UTC (permalink / raw) To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>; +Cc: pgsql-performance On Tue, Dec 27, 2016 at 6:24 PM, Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> wrote: > Can you please suggest me how to resolve it? I think its related to block > corruption. You may want to roll in a backup, and move to a different server: https://wiki.postgresql.org/wiki/Corruption > How can I find particular block in which table? And how to resolve that > particular block issue. pg_filenode_relation() is your friend: https://www.postgresql.org/docs/9.6/static/functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT > DISCLAIMER: > > This email message is for the sole use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized review, > use, disclosure or distribution is prohibited. If you are not the intended > recipient, please contact the sender by reply email and destroy all copies > of the original message. Check all attachments for viruses before opening > them. All views or opinions presented in this e-mail are those of the author > and may not reflect the opinion of Cyient or those of our affiliates. #fail. This is a public mailing list. -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-12-27 11:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2016-12-27 09:24 Invalid page header in block 25561983 of relation pg_tblspc Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> 2016-12-27 11:01 ` Michael Paquier <michael.paquier@gmail.com>
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