Re: BUG #10432: failed to re-find parent key in index - Mailing list pgsql-bugs
From | Greg Stark |
---|---|
Subject | Re: BUG #10432: failed to re-find parent key in index |
Date | |
Msg-id | CAM-w4HP34ppweGTCwjBZnWhQ0CmU-Lxna62vjKU8QRTWLOBuHw@mail.gmail.com Whole thread Raw |
In response to | Re: BUG #10432: failed to re-find parent key in index (Maciek Sakrejda <m.sakrejda@gmail.com>) |
Responses |
Re: BUG #10432: failed to re-find parent key in index
|
List | pgsql-bugs |
On Thu, May 29, 2014 at 6:44 PM, Maciek Sakrejda <m.sakrejda@gmail.com> wrote: > Yeah, makes sense. I don't suppose there's a simple way to periodically > "audit" index integrity? Heikki and Peter were starting work on a btree checking program at PGCon. But there would have to be a separate program for each type of index and the list of possible invalid states to check for is pretty long. I think it would actually be a pretty handy program to have if only to document the invariants that we believe btrees should hold which right now is spread throughout a lot of code. I pulled down WAL going back 11 days and haven't turned up anything referring to either of those blocks in this relation. Is it possible there's an off-by-one error in the error message (or xlogdump) though? I do find references to 175194 and 193741... # grep -h ' \(19374[01]\|17519[234]\)' *.1665280 rmgr: Btree len (rec/tot): 18/ 5434, tx: 85039158, lsn: 307/9E007260, prev 307/9E005E08, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 175194/30 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 175194; hole: offset: 304, length: 2832 rmgr: Btree len (rec/tot): 18/ 5510, tx: 85042421, lsn: 307/A90CC220, prev 307/A90CC1D0, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 175194/30 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 175194; hole: offset: 308, length: 2756 rmgr: Btree len (rec/tot): 18/ 6234, tx: 85624987, lsn: 30E/ED2F9870, prev 30E/ED2F8138, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 193741/45 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 193741; hole: offset: 432, length: 2032 rmgr: Btree len (rec/tot): 18/ 6294, tx: 85668302, lsn: 30F/4400F888, prev 30F/4400E138, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 193741/45 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 193741; hole: offset: 436, length: 1972 rmgr: Btree len (rec/tot): 18/ 5586, tx: 86227110, lsn: 315/D74C3D00, prev 315/D74C3CB0, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 175194/55 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 175194; hole: offset: 312, length: 2680 rmgr: Btree len (rec/tot): 18/ 5662, tx: 86235168, lsn: 315/ED01FFC0, prev 315/ED01FF70, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 175194/55 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 175194; hole: offset: 316, length: 2604 rmgr: Btree len (rec/tot): 4054/ 14306, tx: 86349912, lsn: 317/BC070968, prev 317/BC070918, bkp: 1100, desc: split_r: rel 1663/16385/1665280 left 20842, right 306675, next 193741, level 0, firstright 67 backup bkp #1; rel 1663/16385/1665280; fork: main; block: 193741; hole: offset: 436, length: 1972 rmgr: Btree len (rec/tot): 18/ 6354, tx: 86461004, lsn: 319/011987A8, prev 319/01198758, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 193741/103 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 193741; hole: offset: 440, length: 1912 rmgr: Btree len (rec/tot): 18/ 6414, tx: 86462619, lsn: 319/0919D338, prev 319/0919D2E8, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 193741/103 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 193741; hole: offset: 444, length: 1852 rmgr: Btree len (rec/tot): 74/ 106, tx: 86462626, lsn: 319/091B24B0, prev 319/091B2460, bkp: 0000, desc: insert: rel 1663/16385/1665280; tid 193741/103 rmgr: Btree len (rec/tot): 18/ 5738, tx: 98148324, lsn: 33B/C7E1CA08, prev 33B/C7E1C9B8, bkp: 1000, desc: insert: rel 1663/16385/1665280; tid 175194/48 backup bkp #0; rel 1663/16385/1665280; fork: main; block: 175194; hole: offset: 320, length: 2528 -- greg
pgsql-bugs by date: