[GENERAL] Re: [ADMIN] Would like to below scenario is possible for getting page/block corruption

2016-12-10 Thread Sreekanth Palluru
queries. On Fri, Dec 9, 2016 at 6:16 AM, Sreekanth Palluru wrote: > 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 f

Re: [GENERAL] Would like to below scenario is possible for getting page/block corruption

2016-12-08 Thread Sreekanth Palluru
from WAL records it wrote recptr as part of step 4) during the recovery process . -Sreekanth On Fri, Dec 9, 2016 at 2:09 PM, Sreekanth Palluru wrote: > Michael, > Thanks for your prompt reply > > In my environment those two parameters are enabled . Just give you brief >

Re: [GENERAL] Would like to below scenario is possible for getting page/block corruption

2016-12-08 Thread Sreekanth Palluru
) during the recovery process . -Sreekanth On Fri, Dec 9, 2016 at 12:44 PM, Michael Paquier wrote: > (Please top-post that's annoying) > > On Fri, Dec 9, 2016 at 10:28 AM, Sreekanth Palluru > wrote: > > Can I generalize that, if after step 4) page ( new page or old page)

Re: [GENERAL] Would like to below scenario is possible for getting page/block corruption

2016-12-08 Thread Sreekanth Palluru
we are OK lose data in the affected blocks? I am also looking at ways of reproducing the issue ? appreciate your advice on it ? On Fri, Dec 9, 2016 at 12:01 PM, Michael Paquier wrote: > On Fri, Dec 9, 2016 at 9:46 AM, Sreekanth Palluru > wrote: > > Hi , > > I am working

[GENERAL] Would like to below scenario is possible for getting page/block corruption

2016-12-08 Thread Sreekanth Palluru
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 Relat

Re: [GENERAL] [ADMIN] ERROR invalid page header in block xxx of relation base/xxxxx/xxxxx/

2016-12-07 Thread Sreekanth Palluru
here any way I can reproduce this error ? Appreciate your comments and suggestions on this ? -Sreekanth On Thu, Dec 8, 2016 at 12:55 PM, Sreekanth Palluru wrote: > > Forgot to loop community > > > Hi Jorge/All, > Thanks for the reply. > As per the documentation , I think