Troubleshooting corrupt indexes

Jens Alfke <jens-mAcipnqRhZf2eFz/[email protected]> Mon, 6 Apr 2020 12:29:57 -0700
Newsgroups gmane.comp.db.sqlite.general
Message-ID <[email protected]>
V2UndmUgZm91bmQgYSBmZXcgZGF0YWJhc2UgaW5zdGFuY2VzIHdpdGggaW5kZXggY29ycnVwdGlv
biwgYW5kIEknbSB1bnN1cmUgaG93IHRvIHRyb3VibGVzaG9vdCBpdC4KClRoZSBzeW1wdG9tIGlz
IFNFTEVDVCBxdWVyaWVzIGZhaWxpbmcgd2l0aCBTUUxJVEVfQ09SUlVQVC4gSSd2ZSBsb29rZWQg
YXQgdGhlIGRhdGFiYXNlIGZpbGVzLCBhbmQgYHByYWdtYSBpbnRlZ3JpdHlfY2hlY2tgIHNwaXRz
IG91dCBmaXZlICJyb3cgbWlzc2luZyBmcm9tIGluZGV4IiBlcnJvcnMgb24gb25lIGluZGV4LCBh
bmQgIndyb25nICMgb2YgZW50cmllcyIgb24gdGhhdCBzYW1lIGluZGV4IGFuZCB0aHJlZSBvdGhl
cnMuIFJ1bm5pbmcgYFJFSU5ERVhgIHNlZW1zIHRvIHJlcGFpciBldmVyeXRoaW5nLCBhdCBsZWFz
dCBpbnRlZ3JpdHlfY2hlY2sgcmVwb3J0cyBubyBtb3JlIHByb2JsZW1zLgoKVGhlIGluZGV4ZXMg
YXJlbid0IGZhbmN5LiBUaGUgb25lIHdpdGggdGhlIHJvdy1taXNzaW5nIGVycm9ycyBpcyBzaW1w
bHkKCUNSRUFURSBVTklRVUUgSU5ERVggc2VxIE9OIHRhYmxlIChzZXF1ZW5jZSkKd2hlcmUgdGhl
IGBzZXF1ZW5jZWAgY29sdW1uIGlzIHNpbXBseSBkZWZpbmVkIGFzIGBzZXF1ZW5jZSBJTlRFR0VS
YC4KClRoZSBvdGhlciBpbmRleGVzIGFyZSBhbGwgb2YgdGhlIGZvcm0KCUNSRUFURSBJTkRFWCDi
gKYgT04gdGFibGUgKGN1c3RvbWZuKGJvZHksICdrZXkxJyksIGN1c3RvbWZuKGJvZHksICdrZXky
JyksIOKApikKd2hlcmUgYGN1c3RvbWZuYCBpcyBhIGN1c3RvbSBmdW5jdGlvbiB0aGF0IGV4dHJh
Y3RzIGtleS12YWx1ZSBkYXRhIGZyb20gdGhlIHN0cnVjdHVyZWQgYmxvYiBpbiBgYm9keWAsIHNv
bWV3aGF0IGxpa2UgdGhlIHJlZ3VsYXIgYGpzb25fZXh0cmFjdGAgZnVuY3Rpb24uIAoKSSdtIHN1
cmUgdGhpcyBjdXN0b20gZnVuY3Rpb24gY291bGQgY29uY2VpdmFibHkgY2F1c2UgdGhpcyBzb3J0
IG9mIGVycm9yIGlmIGl0IHdlcmVuJ3QgcHJvcGVybHkgZGV0ZXJtaW5pc3RpYywgYnV0IGl0J3Mg
YmVlbiBpbiB1c2UgZm9yIGEgZmV3IHllYXJzIGFuZCBwcmV0dHkgd2VsbCB0ZXN0ZWQsIGFuZCBJ
J3ZlIG5ldmVyIHNlZW4gYSBidWcgd2l0aCBpbmRleCBjb3JydXB0aW9uIGxpa2UgdGhpcy4KCkFu
ZCBJJ20gYmFmZmxlZCBob3cgc29tZXRoaW5nIGFzIHNpbXBsZSBhcyB0aGUgYHNlcWAgaW5kZXgg
Y291bGQgZ28gYXdyeeKApgoK4oCUSmVucyBbZG9nZ2VkbHkgZGVueWluZyB0aGUgZXhpc3RlbmNl
IG9mIHRoZSBuZXcgZm9ydW1dCgpQUzogV2UncmUgdXNpbmcgU1FMaXRlIDMuMjgsIHN0YXRpY2Fs
bHkgbGlua2VkIGludG8gdGhlIGFwcCwgb24gQW5kcm9pZC4KX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxp
dGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxp
dGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK