THE PROBLEM – LIGHTROOM CATALOG CORRUPTION

For the first time since owning Lightroom, I have experienced a Lightroom catalog becoming corrupted. Fortunately under File>Catalog settings>Metadata, I have been writing my metadata to my .xmp side car files. Unfortunately, I did not realize when a .lrcat file becomes corrupted, the metadata does not include virtual copies of the images, or references to what catalog sets they are in. I hope Adobe changes this in the next release of Lightroom.

To back up a step, I am running a MacBook Pro on 10.5.1, working with Lightroom version 1.3.1 and working off of external hard drives where my library of images lives. Virtual copies and catalog sets are critical parts of my workflow, and I would rather scrub down my bathroom walls with comet than manually reconstruct both of those aspects of a major edit. My .lrcat files reside on the external hard drives, as I don’t have space for them on my laptop, and the particular catalog that became corrupted was comprised entirely of .TIFF film scans. I believe what caused the corruption was going to the Photo>Edit in Adobe Photoshop CS3… command, choosing “Edit Original ” file in Photoshop CS3, applying a rotational change in Photoshop and then saving the file in CS3. When the edited image returned back to LR, it would not display correctly on the screen, and appeared mashed. Upon quitting and re-opening LR, the images displayed correctly on the screen, however the .lrcat file became corrupted.

WHAT DID I DO TO FIX IT?

After testing the integrity of the catalog several times, and trying unsuccessfully to use the built in utility to repair the .lrcat file, Lightroom recommended I visit a website that kindly informed me I was screwed and needed to revert to a backup .lrcat file. I am fairly fastidious about my backups, but the most recent .lrcat file I had on hand was a few days old and would mean loosing three full days of editing. I knew there must be a better way.

Fortunately for me, I was still able to open the corrupted .lrcat database even though it was unable to properly display all of the images in the library. After a lot of trial and error, I came up with a simple, elegant solution for recovering all of the virtual copies and catalog sets from the corrupted database.

THE SOLUTION:

1. If you are still able to open the corrupted .lrcat database, do so. If you can’t get past this step, you are screwed and the following steps will not help you.

2. Click “All Photographs” in the Library module, make sure all filters are turned off, and and choose Edit>Select All from the menu.
3. Go to File>Export as Catalog….
4. From the dialogue box that drops down, choose your desktop as the destination for the exported catalog file, give it a meaningful name (like “corrupted”) and be sure to uncheck the box at the bottom of the window that says “Export negative files” as this will physically duplicate all of the images that are currently in your catalog. NOTE: Whenever I import images into Lightroom, I ALWAYS “Import photos at their current location”.

Lightroom Export Corrupted Catalog

5. Go to File>New Catalog and choose a meaningful destination and name for the new catalog.
6. Go to File>Import from Catalog, navigate to the corrupted catalog you saved to the desktop, locate and highlight the .lrcat file and click “choose”.
7. Lightroom will present you with the familiar import dialogue box, be sure to select “Import photos at their current location” and click “Import”.

Lightroom import from catalog dialogue box

8. Lightroom will think for a while, then most likely give you an error message that reads something like “Lightroom was unable to successfully import the catalog” … Ignore this.
9. If the computer gods are smiling on you, you now have a new, non corrupt, almost fully functional catalog, complete with virtual copies and catalog sets.
10. Go through the new catalog and check for anything that may be missing. There will be some missing images, but in my case, three or four missing virtual copies pales in comparison to having to go back and re-create hundreds of virtual copies.

If any of you have experienced or are experiencing a similar problem, and have a similar workflow of always “Importing photos at their current location”, I hope you find this material helpful, and that it helps you recover your database!

Text © Jonathan Kingston 2007

22 thoughts on “THE PROBLEM – LIGHTROOM CATALOG CORRUPTION”

  1. Yep I just went through this myself. I love light room, but come on, really?

    To add to this fun, I could figure out why my harddrive was bogging down. Then I discovered I had 40gigs of image previews.

    Do you keep you previews on a drive of thier own?

  2. I have been using lightroom about a month. I had a problem with the files in downloading. First the compact flash card ‘s files got corrupted. Then I could burn a cd without all kinds of dire notices popping up. I spent 12 hours yesterday downloading through my camera via the canon software and could finally burn a disc. Lightroom may be wonderful but I’ll never know. I lost 4gb of an overnight sailing race and consider myself lucky. Thanks for your post though. they made me relize how much there is to learn. Any recommendation for books or other materials. tw

  3. Hi Tom,

    Sorry to hear about your image travails. Corrupted cards do happen from time to time, but there are a couple things you can do to minimize the risk of them happening in the future.

    1. Every time after you download your card to your computer, put the card in back in the camera and format it (this is different from “delete all”). There should be a “format card” option somewhere in the menu of your camera.

    2. Avoid editing in the camera and deleting individual shots during the shoot. Wait until your home on your computer to do this. The evidence against this is more anecdotal at this point, but it is worth avoiding.

    If and when you do get in a bind, like you just went through, there are some great recovery utilities out there that can help you recover information off of your card. I use the file recovery utility provided by San Disk called “RescuePRO”. It comes with every purchase of one of their cards and has saved me a couple of times.

  4. My issue is a little different but Adobe can’t even figure it out and I’m desperate. One by one every photo in my catalog is being ruined. Whether it’s an untouched Raw photo that I imported minutes earlier or a previously edited photo from months ago, Lightroom is changing my entire library to some default setting that I did not create. I troubleshot with Adobe for 3.5 hours with no prevail and have been troubleshooting myself online for another five hours today. Someone please HELP me!! Countless hours of my work are going down the drain, I don’t see how to get my old designs back, I mean isn’t that the entire point of Lightroom, to save your designs without having to change the original file?!?!?

  5. Hi Kelly, It sounds to me like Lightroom is applying the auto tone adjustments to your images. You can turn this function off by going to Lightroom Preferences, and clicking on the “Presets” button. Under the “Default Develop Settings” box, be sure to uncheck the “Apply auto tone adjustments” box. This will prevent LR from changing your file. The other possibility that may be happening is you are seeing the thumbnails from the camera as the images are imported into the LR catalog. But as LR has time to render these thumbnails, it over writes them with the default camera raw render settings. You may want to consider creating a custom DNG profile using the information here.

  6. You saved me! I can’t thank you enough. I tried so many different things to save my catalog and Years worth of work. The backup wasn’t working (and I’ve backed up a lot) but your blog post here saved me. THANK YOU!

  7. To revisit Joseph’s post and question from above… my hard drive reacts at a snails pace when LR is open. I’ve been chalking it up to the volume of photos I have, but know that LR is built to manage large volumes of photos. I’m wondering the same thing, do you save all previews? if so, where do I find those? Maybe that’s part of my problem. Also… I just started getting the corrupt catalog messages too. I will follow your recommended solution above… TODAY!

  8. Hi Erika,

    What version of LR are you running? If you are still on version 1 or 2, then the slowness is a known problem. I would recommend upgrading to version 3. My largest catalog in V3 currently has over 100,000 images and is very quick.

    Regards – Jonathan

  9. Oh bless you!!!!! I am so thankful to have found this! I have just had this issue since upgrading to lightroom 3. I had 30,781 images on this ehd so far…first it ran slow then I started getting the corrupt message. I do have a couple of questions. 1. Should I now delete the file it says is corrupt? 2. How do I move the location from my desktop to my external hard drive without making Lightroom crazy? 3. Do you recommend offsite backups with a service in addition to external hard drives?

    Before I upgraded to Lightroom 3 my catalog was backed up to my external hd, after I upgraded, I must not have designated where to back up because it puts it in my pictures, I went to catalog settings to change it but it didn’t give the option to change it?

    Thanks again for this post!!!

    Leisa

  10. Hi Leisa, Offsite backup over the net is still problematic due to the large size of RAW files. Photoshelter is one of the best service out there for this – but know it will take time to upload the info. For myself, I have my top 1000 photos backed up in the cloud and everything else in triplicate – with one of the drives physically off site.

  11. My 640 GB Mac HD was getting full — mostly from RAW files imported into Lightroom3. I had this HD cloned to a 2TB drive to give me more “elbow room”. When I booted the Mac Pro up and opened Lightroom3, my current catalog was not there! When I opened with a different catalog, most of my photos (previews) are there in Library but almost all have “?” in the corner and LR3 can’t seem to find them. I back up to my HD2 and to an external LaCie drive, but can’t seem to locate the catalog that I last used. I admit not being a computer whiz but I do back-up regularly. Any thoughts on how to rectify this mess and get my catalog / photos back in play?

  12. Hi Jay, Don’t panic. LR simply thinks the photos are on the old hard drive. Right click on the folder with the question mark on it (or the photo with the question mark on it) and re-link the photo to the original on the new drive. Check out THIS link.

  13. Thanks so much for posting this process. It saved me from a crashing slug of a catalog and worked just as described.

  14. Lightroom 3 won’t even open I have now uninstalled it. I was using and closed out came back a few hours later NOTHING…. “program is not responding windows is looking for solution”

Comments are closed.