Just wanting to add some technical details here. After losing about a month's worth of catalog data, I have realized Lightroom has been saving corrupt backups since February. If I save a backup (with the optimize box checked), then immediately open the backup catalog using a SqLite reader, I see the following slew of errors:
*** in database main ***
Main freelist: free-page count in header is too small
On tree page 104 cell 0: 2nd reference to page 10559
On tree page 104 cell 5: 2nd reference to page 7579
On tree page 104 cell 4: 2nd reference to page 7535
On tree page 104 cell 3: 2nd reference to page 8090
On tree page 104 cell 2: 2nd reference to page 3650
On tree page 104 cell 1: 2nd reference to page 3771
On tree page 104 cell 0: 2nd reference to page 3728
On tree page 321 cell 0: 2nd reference to page 4204
On tree page 321 cell 5: 2nd reference to page 4172
On tree page 321 cell 4: 2nd reference to page 4155
On tree page 321 cell 3: 2nd reference to page 4153
On tree page 321 cell 2: 2nd reference to page 3766
On tree page 321 cell 1: 2nd reference to page 3725
On tree page 321 cell 0: 2nd reference to page 3724
On tree page 320 cell 0: 2nd reference to page 4221
On tree page 320 cell 5: 2nd reference to page 4220
On tree page 320 cell 4: 2nd reference to page 4173
On tree page 320 cell 3: 2nd reference to page 4152
On tree page 320 cell 2: 2nd reference to page 4163
On tree page 320 cell 1: 2nd reference to page 3727
On tree page 320 cell 0: 2nd reference to page 3726
On tree page 105 cell 0: 2nd reference to page 4937
On tree page 105 cell 2: 2nd reference to page 4750
On tree page 105 cell 1: 2nd reference to page 3730
On tree page 105 cell 0: 2nd reference to page 3729
On tree page 80 cell 0: 2nd reference to page 17059
On tree page 80 cell 42: Rowid 461738 out of order
On tree page 11 cell 136: Rowid 463919 out of order
On tree page 11 cell 135: Rowid 462404 out of order
On tree page 10 cell 375: Rowid 464237 out of order
On tree page 10 cell 374: Rowid 463736 out of order
On tree page 17356 cell 8: Rowid 464237 out of order
On tree page 89 cell 0: 2nd reference to page 8217
On tree page 12297 cell 32: Rowid 464252 out of order
On tree page 8158 cell 41: Rowid 463400 out of order
On tree page 21 cell 0: 2nd reference to page 10389
On tree page 21 cell 378: Rowid 460608 out of order
On tree page 3852 cell 9: Rowid 460613 out of order
On tree page 51 cell 321: Rowid 464300 out of order
On tree page 51 cell 320: Rowid 463913 out of order
On tree page 51 cell 320: 2nd reference to page 17087
On tree page 51 cell 47: Rowid 290131 out of order
On tree page 51 cell 46: Rowid 289704 out of order
On tree page 14366 cell 10: Rowid 290551 out of order
On tree page 51 cell 36: Rowid 285599 out of order
On tree page 51 cell 35: Rowid 285203 out of order
On tree page 19299 cell 9: Rowid 285997 out of order
Page 12377 is never used
Page 18330 is never used
When I generate a backup with the optimize box unchecked, I only see the following errors:
*** in database main ***
On tree page 18296 cell 6: Rowid 384 out of order
On tree page 18295 cell 7: Rowid 377 out of order
When I try and open the first (optimized) backup Lightroom immediately encounters an error and must quit. The second (unoptimized) backup is at least functional as far as I can tell. I can still import photos from it, which is my main use case. I'll still be manually copying my catalog periodically until this is resolved.
Running Lightroom 7.2 on Windows 10.
66
Replies
AdChoices