Re: [HACKERS] 9.4 btree index corruption

2014-05-25 Thread Andres Freund
Hi, On 2014-05-25 14:45:38 -0700, Jeff Janes wrote: > You're welcome. If only I was as good at fixing things as at breaking > them. At the moment there seems to be a bigger shortage of folks being good at breaking stuff - before the release! - than of people fixing the resulting breakage... Gre

Re: [HACKERS] 9.4 btree index corruption

2014-05-25 Thread Heikki Linnakangas
On 05/25/2014 05:45 PM, Jeff Janes wrote: On Sun, May 25, 2014 at 7:16 AM, Heikki Linnakangas wrote: On 05/21/2014 10:22 PM, Jeff Janes wrote: Testing partial-write crash-recovery in 9.4 (e12d7320ca494fd05134847e30) with foreign keys, I found some btree index corruption. ... https://d

Re: [HACKERS] 9.4 btree index corruption

2014-05-25 Thread Jeff Janes
On Sun, May 25, 2014 at 7:16 AM, Heikki Linnakangas wrote: > On 05/21/2014 10:22 PM, Jeff Janes wrote: > >> Testing partial-write crash-recovery in 9.4 (e12d7320ca494fd05134847e30) >> with foreign keys, I found some btree index corruption. >> >> ... > >> https://drive.google.com/folderview?id=0B

Re: [HACKERS] 9.4 btree index corruption

2014-05-25 Thread Heikki Linnakangas
On 05/21/2014 10:22 PM, Jeff Janes wrote: Testing partial-write crash-recovery in 9.4 (e12d7320ca494fd05134847e30) with foreign keys, I found some btree index corruption. 28807 VACUUM 2014-05-21 15:33:46.878 PDT:ERROR: right sibling 4044 of block 460 is not next child 23513 of block 1264 in ind

[HACKERS] 9.4 btree index corruption

2014-05-21 Thread Jeff Janes
Testing partial-write crash-recovery in 9.4 (e12d7320ca494fd05134847e30) with foreign keys, I found some btree index corruption. 28807 VACUUM 2014-05-21 15:33:46.878 PDT:ERROR: right sibling 4044 of block 460 is not next child 23513 of block 1264 in index "foo_p_id_idx" 28807 VACUUM 2014-05-21 15