Participating Frequently

Question

Lightroom Classic CC Backup Catalog Corrupted

Forum|Forum|8 years ago
February 1, 2018
9 replies
10856 views

This problem is noticed by me recently, and I find that all the backup catalogs created by Lightroom Classic CC (“Lightroom”) after 14 January 2018 was corrupted (as Lightroom said). The most recent backup catalog which I can use is the one created on 14 January 2018.

However, Lightroom is working normally and seems no problem at all. I can edit photos as usual. I have set Lightroom to back up the catalog every time when I quit Lightroom, and it seems everything alright. However, when I try to use the backup catalog, it fails. Lightroom said they are corrupted. I don't know why.

Last night, I have done an experiment. I backed up my catalog as usual when I quitted Lightroom. Immediately after I quitted Lightroom, I unzipped the backup catalog and copied the catalog to the default folder which Lightroom uses. I reran Lightroom and Lightroom said my catalog is corrupted. This copy was just created by Lightroom when I quitted Lightroom last time. I then removed the backup catalog and putted back the current catalog in default folder. Lightroom just works fine. It seems that Lightroom does not correctly back up the catalog. Very strange!

Is there any method to solve the above problem? Please help.

This topic has been closed for replies.

D

D Roeder

Known Participant

I have just started having the same problems. Mine started with 7.3.1. From reading here, it seems as though the problems were in Windows OS. I am using Mac OS, so it has crossed over. Or maybe it has existed for a while and just now reared its ugly head. Mine started with a LR 7.3.1 backup when it failed the integrity test.

Distraught

ryantate314

Participant

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.

HenryCHWongAuthor

Participating Frequently

Your discovered issue is exactly what I found.

Sent from my iPhone

S

Sonja Metius

Participating Frequently

I am a very naive user of all programs generally. It's gotta work period or I am lost in a void. I have no backups. They've disappeared. Reading this thread looks like it's Adobe and not my computer (Mac - High Sierra 10.13.3).

All the above is gobbled gook. I'm just figuring out LR. Panic Attack indeed. Going to have a drink now. Will keep an eye on this thread to read solutions.

Oh - I did do a Time Machine back-up 21 days ago.

JP Hess

Inspiring

I have done two test restorations. The one restoration was done to the desktop and I tried to start Lightroom with that catalog on the desktop. Lightroom indicated that the catalog needed to be repaired. There were no other files associated with Lightroom on the desktop. Lightroom repaired the catalog successfully and eventually opened it. The second restoration was placed in the folder with the other files where the original catalog was. That catalog opened without a problem, no repair was needed. Using Lightroom Classic CC 7.2 on Windows 10.

karenloudon

Participant

Been dealing with "assertion failed" and corrupt catalogs in LightroomCC for the past week, sometimes I can repair it, sometimes not. This is unacceptable! I just got off a 2hr phone call with Adobe customer support, and all we figured out was that my catalog is corrupt (duh!) and I should check my winzip? I'm tired of losing my hard work and I'm just going to go back to my previous version Lightroom 5.7! I want my money back for my CC subscription!

B

bob frost

Inspiring

What are you unzipping your backup catalog with? Is this causing the corruption?

Bob Frost

J

johnshore

Known Participant

https://forums.adobe.com/people/bob+frost wrote
What are you unzipping your backup catalog with? Is this causing the corruption?
Bob Frost

Thanks for the suggestion, but that's not it. I move the zipped folder to the desktop (without unzipping), then unzip with the standard Windows 10 utility (right click -> extract all....).

js

A

annw212125

Participant

I have posted all over this site by this time -- your story is my story. Catalogue ZIP files will not unzip in an uncorrupted format, and will not load in LR CC Classic. Tech Support is no help. I do not think this is a problem on my computer:I think it is a problem in the software, and I suspect that many people are using the program generated backup to store their catalogue, and should they ever need to restore their backup file they will discover, as I did, that it is not a good file. I have started randomly testing my LR generated backup files, and none of them, so far, work. The files I back up manually do work, so I have started doing that as my preferred backup system. Thank goodness that a few weeks ago, when my catalogue would not load after a program update from Adobe, I found a fairly recent manual backup to turn to or I would have lost all my data. Can you spell Panic Attack?

I suspect this is a much more serious issue for the many LR users than has been shown to date, and that it is more common than we think.

John W

theoriginaljimbo

Participant

Just wanted to add that I also had this issue, not as severe as it was only 1 of my backups (of course the only one I wanted though). I back up nearly every day and have the option to test integrity. I also have all of these backups duplicated in Google Drive. I tried downloading the backup from Google Drive in case there was a hard drive issue but it seems like this backup was corrupted from the start. I understand that there are other ways to double check the integrity of the backups, but being I'm doing them so frequently it seemed like a hassle to run another check on them. From now on I'll periodically make sure most of my backups open. This is one of the first times I've seriously considered jumping ship from Adobe, it's good to know they have such great customer service when something like this happens after 5pm /sarcasm. Seriously though, why don't they have a direct email option for support? I have to wait until normal working hours when I'm working at my other job to chat or call them? I'm not even looking for anymore help I just want them to be aware that they should look into fixing their backup system.

J

johnshore

Known Participant

Hi theoriginaljimbo - Thanks for chiming in. Obviously this issue doesn't affect everyone, but the cost is so high when it happens that you'd think Adobe would be more responsive.

js

cfransw

Inspiring

New LR version 7.2 opens all backups without any problem.

Frans

elie_dinur

Participating Frequently

By me too.

cfransw

Inspiring

Same problem here. Windows 10, LR Classic 7.1

No way to make it work. Assertion failed message.

T

Tensas

Participating Frequently

Yup

If you haven't tested your backups, then you are risking losing all of your work in that catalog.

5 copies of a corrupt catalog backup is still a corrupt backup.

D

Just Shoot Me

Legend

IMHO if you are having a problem with extracting and using backed up catalog files and your main working catalog file is corrupted you have a Computer Problem. It is not LR.

I've been using LR since 2007 on at least 5 different computers and have never had a catalog become corrupted. I just tested my latest backup, made 2/5/2018, and it opens fine. But then my main catalog, which has been upgraded with almost every version of LR since V1, opens and works fine also.

If you have problems with corrupted files it is a Hardware problem.

Start by checking all your hardware.

Michael J. Hoffman

Community Expert

Can you try opening up the unzipped catalog in its original location?

If you're moving the unzipped backup into the default location, where there could be .lock and .journal files, that could be causing the corruption. Try opening in place in your backup location by just double clicking, or by going in Lightroom to File > Open Catalog and browsing to the backup location.

Mike

HenryCHWongAuthor

Participating Frequently

Thanks for your advice. Mike.

I followed your instructions last night. It's really a nightmare. The program was even crashed and I needed to reinstall the software before I can use it. The message shown when I tried to run the software is "assertion failed".

For your information, I noticed that the size of my current catalog is different from the backup one. I suppose they are to be the same size. It appears to me that the only way I can do at the moment is to back up the catalog manually by using window explorer.

Thanks again for your advice.

T

Tensas

Participating Frequently

Hi Henry

I have the exact same problem and find that ALL of my backups are corrupt. I have tried Mikes suggestions but no luck.

I highly recommend checking back up integrity every time and not relying on any zipped backups. I have checked every zipped back up file for 2 months and have not found a single one which was not corrupt.

Copy your unzipped catalog to a separate drive and make a duplicate of that drive if you really can't afford to lose your work.

D

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded