From: | Sreekanth Palluru <sree4pg(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Would like to below scenario is possible for getting page/block corruption |
Date: | 2016-12-09 00:46:07 |
Message-ID: | CAP+fnpj3J_6dczUvmGvjQoc=-zYhg2YiKFXCHLrvWLo7MM53_A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi ,
I am working on page corruption issue want to know if below scenario is
possible
1) Insert command from client , I understand heap_insert is called
from heampam.c
2) Let us say table is full and relation is extended and added a new block
3) Tuple is inserted into new page for the block RelationPutHeapTuple/hio.c
4) Later WAL record is inserted through recptr = XLogInsert(RM_HEAP_ID,
info);
5) Then backend update the PageHeader with WAL LSN details
PageSetLSN(page, recptr);
If my server got crashed after step 4) is there a possibility that after
postgres database restart I get below error when I access the relation or
vacuum is run on this relation or taking backup through pg_dump ?
*ERROR: invalid page header in block 204 of relation base/16413/16900 ?*
or
Postgres can automatically recover the page without throwing any error ?
Appreciate your valuable response on this
--
Regards
Sreekanth
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2016-12-09 01:01:15 | Re: Would like to below scenario is possible for getting page/block corruption |
Previous Message | Peter Eisentraut | 2016-12-08 13:55:20 | Re: Are dns CNAME's allowed or useable in pg_hba.conf hostname specification |
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2016-12-09 00:47:56 | Re: Importing SQLite database |
Previous Message | Adrian Klaver | 2016-12-09 00:45:39 | Re: Looking for an online mentor |