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
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
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
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
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.
> >>
> >
> >
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.
> >>
> >
> >
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
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
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
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
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
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
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
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
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
15 matches
Mail list logo