Re: [HACKERS] regression test failed when enabling checksum

2013-04-03 Thread Jeff Davis
On Mon, 2013-04-01 at 19:51 -0700, Jeff Janes wrote: > I've reproduced the problem, this time in block 74 of relation > base/16384/4931589, and a tarball of the data directory is here: > > > https://docs.google.com/file/d/0Bzqrh1SO9FcELS1majlFcTZsR0k/edit?usp=sharing > > > > (the table is in

Re: [HACKERS] regression test failed when enabling checksum

2013-04-03 Thread Jeff Davis
On Wed, 2013-04-03 at 09:48 -0700, Jeff Janes wrote: > And why did those uninitialized pages trigger warnings when they were > autovacced, but not when they were seq scanned in a query? > A scan won't trigger that warning. Empty pages are sometimes the expected result of a crash when the file is

Re: [HACKERS] regression test failed when enabling checksum

2013-04-03 Thread Andres Freund
On 2013-04-03 09:48:54 -0700, Jeff Janes wrote: > On Wed, Apr 3, 2013 at 2:31 AM, Andres Freund wrote: > > > > > > I just checked and unfortunately your dump doesn't contain all that much > > valid WAL: > > ... > > > > > > So just two checkpoint records. > > > > Unfortunately I fear that won't

Re: [HACKERS] regression test failed when enabling checksum

2013-04-03 Thread Jeff Janes
On Wed, Apr 3, 2013 at 2:31 AM, Andres Freund wrote: > > I just checked and unfortunately your dump doesn't contain all that much > valid WAL: > ... > > So just two checkpoint records. > > Unfortunately I fear that won't be enough to diagnose the problem, > could you reproduce it with a higher

Re: [HACKERS] regression test failed when enabling checksum

2013-04-03 Thread Andres Freund
On 2013-04-01 19:51:19 -0700, Jeff Janes wrote: > On Mon, Apr 1, 2013 at 10:37 AM, Jeff Janes wrote: > > > On Tue, Mar 26, 2013 at 4:23 PM, Jeff Davis wrote: > > > >> > >> Patch attached. Only brief testing done, so I might have missed > >> something. I will look more closely later. > >> > > > >

Re: [HACKERS] regression test failed when enabling checksum

2013-04-02 Thread Andres Freund
On 2013-04-01 19:51:19 -0700, Jeff Janes wrote: > On Mon, Apr 1, 2013 at 10:37 AM, Jeff Janes wrote: > > > On Tue, Mar 26, 2013 at 4:23 PM, Jeff Davis wrote: > > > >> > >> Patch attached. Only brief testing done, so I might have missed > >> something. I will look more closely later. > >> > > > >

Re: [HACKERS] regression test failed when enabling checksum

2013-04-02 Thread Simon Riggs
On 2 April 2013 02:53, Jeff Davis wrote: >> Any idea >> what is going on? > > Not right now. Since I'm now responsible for the quality of this patch, I need to say this before someone else does: we have until the end of the week to fix this conclusively, or I will need to consider whether to rev

Re: [HACKERS] regression test failed when enabling checksum

2013-04-01 Thread Jeff Janes
On Monday, April 1, 2013, Jeff Davis wrote: > On Mon, 2013-04-01 at 10:37 -0700, Jeff Janes wrote: > > > Over 10,000 cycles of crash and recovery, I encountered two cases of > > checksum failures after recovery, example: > > > > > > 14264 SELECT 2013-03-28 13:08:38.980 PDT:WARNING: page verificat

[HACKERS] regression test failed when enabling checksum

2013-04-01 Thread Jeff Janes
On Mon, Apr 1, 2013 at 10:37 AM, Jeff Janes wrote: > On Tue, Mar 26, 2013 at 4:23 PM, Jeff Davis wrote: > >> >> Patch attached. Only brief testing done, so I might have missed >> something. I will look more closely later. >> > > After applying your patch, I could run the stress test described he

Re: [HACKERS] regression test failed when enabling checksum

2013-04-01 Thread Jeff Davis
On Mon, 2013-04-01 at 10:37 -0700, Jeff Janes wrote: > Over 10,000 cycles of crash and recovery, I encountered two cases of > checksum failures after recovery, example: > > > 14264 SELECT 2013-03-28 13:08:38.980 PDT:WARNING: page verification > failed, calculated checksum 7017 but expected 1098

Re: [HACKERS] regression test failed when enabling checksum

2013-04-01 Thread Jeff Janes
On Tue, Mar 26, 2013 at 4:23 PM, Jeff Davis wrote: > On Tue, 2013-03-26 at 02:50 +0900, Fujii Masao wrote: > > Hi, > > > > I found that the regression test failed when I created the database > > cluster with the checksum and set wal_level to archive. I think that > > there are some bugs around ch

Re: [HACKERS] regression test failed when enabling checksum

2013-03-26 Thread Simon Riggs
On 26 March 2013 23:23, Jeff Davis wrote: > Patch attached. Only brief testing done, so I might have missed > something. I will look more closely later. Thanks, I'll look at that tomorrow. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Trai

Re: [HACKERS] regression test failed when enabling checksum

2013-03-26 Thread Simon Riggs
On 25 March 2013 17:50, Fujii Masao wrote: > I found that the regression test failed when I created the database > cluster with the checksum and set wal_level to archive. I think that > there are some bugs around checksum feature. Attached is the regression.diff. Apologies for not responding to

Re: [HACKERS] regression test failed when enabling checksum

2013-03-26 Thread Jeff Davis
On Tue, 2013-03-26 at 02:50 +0900, Fujii Masao wrote: > Hi, > > I found that the regression test failed when I created the database > cluster with the checksum and set wal_level to archive. I think that > there are some bugs around checksum feature. Attached is the regression.diff. Thank you for

[HACKERS] regression test failed when enabling checksum

2013-03-25 Thread Fujii Masao
Hi, I found that the regression test failed when I created the database cluster with the checksum and set wal_level to archive. I think that there are some bugs around checksum feature. Attached is the regression.diff. Regards, -- Fujii Masao regression.diffs Description: Binary data -- Sen