Banksiagirl Posted February 23, 2017 Share Posted February 23, 2017 Hi, my LR catalog is corrupt apparently. Its huge. WIn 10 64 bit. I have a backup - from two days before - there was little extra done. I copied the backup to another drive and renamed it. It opened OK by clicking on the renamed catalog. I backed that up too. I get this message about Lightroom Fatal SQLite corruption any time I attempt to access LR through the LR Icon. its also attempting to open the original catalog not the renamed one last used. I have googled the error and the info that came up was way out of my comfort zone. Any help greatfully received! Link to comment Share on other sites More sharing options...
Damien Symonds Posted February 23, 2017 Share Posted February 23, 2017 I have called in the LR cavalry, and hopefully they'll be able to help you with your question. Take a deep breath and remember that your images are safe. They're still on your hard drive. And you can still use Bridge to browse and edit them any time you like. Link to comment Share on other sites More sharing options...
Banksiagirl Posted February 23, 2017 Author Share Posted February 23, 2017 Thanks Damien, not worried about the photos or edits - they are all ok and backed up but i want my collections back!!! Link to comment Share on other sites More sharing options...
Jason Posted February 23, 2017 Share Posted February 23, 2017 I'm not familiar with the error, but if your backup loads fine then maybe you're okay? Go to edit>preferences and in the general tab look for "default catalog" and see if you can change it to "Load most recent catalog". Then it should open the backup catalog if it was the last thing open in lightroom. You can also move the corrupt catalog to a different location so you have it if you need for some odd reason, but if you don't move it, lightroom will always know it's there. Or you can just delete it, again if the backup catalog doesn't show the same corruption. Link to comment Share on other sites More sharing options...
Banksiagirl Posted February 23, 2017 Author Share Posted February 23, 2017 I have that setting already Jason - load most recent. The backup opened then when i closed it and on restarting that error came back so that copy of the backup was then a dud. After that I attempted to open other backups - by clicking on the actual lrcat file - no good. I'm currently trying various dates of backups on my laptop. Im dark - I spent hours last week setting up smart collections - they will only be in the last back up. At this stage Feb 11th works on the lappy Could be worse I guess- but so much for the current suggestion going around to forget all folder structure and just use collections - what a disaster that would be! Link to comment Share on other sites More sharing options...
Brian Posted February 24, 2017 Share Posted February 24, 2017 I'm curious, just how large is your corrupted catalog file? Right-Click and do a properties on the catalog. Link to comment Share on other sites More sharing options...
Damien Symonds Posted February 24, 2017 Share Posted February 24, 2017 1 hour ago, Banksiagirl said: I spent hours last week setting up smart collections You can do those in Bridge too. Just sayin'. Link to comment Share on other sites More sharing options...
Banksiagirl Posted February 24, 2017 Author Share Posted February 24, 2017 Can you now! Didn't know that. Have you any info ? Interesting! Link to comment Share on other sites More sharing options...
Banksiagirl Posted February 24, 2017 Author Share Posted February 24, 2017 22 hours ago, Brian said: I'm curious, just how large is your corrupted catalog file? Right-Click and do a properties on the catalog. It's 3.6 G and the previews are 9G Brian. Link to comment Share on other sites More sharing options...
Damien Symonds Posted February 24, 2017 Share Posted February 24, 2017 28 minutes ago, Banksiagirl said: Can you now! Didn't know that. Have you any info ? Interesting! Google will give you heaps of hits. Link to comment Share on other sites More sharing options...
Brian Posted February 25, 2017 Share Posted February 25, 2017 15 hours ago, Banksiagirl said: It's 3.6 G and the previews are 9G Brian I suspected this. You really don't want your catalog file to get that large. Not only will it make LR slower, if you try to backup your catalog to a Thumb Drive or another device that has a FAT32 Filesystem, it won't copy over or actually could corrupt itself. FAT32 has a 4GB file size limit, but in reality it's more like 3.5GB. You are at 3.6G. NTFS on the other hand, which most of us have these days, goes much higher, just under 256TB. That said, I still wouldn't ever go that high for a single file. In either case, it's one of those "rules" that I stick to, once something gets above 3GB for a single file, I start worrying. Especially a LR catalog. Bad things could happen with a large LR catalog around 4GB. Link to comment Share on other sites More sharing options...
Sue Morris Posted February 25, 2017 Share Posted February 25, 2017 HI Brian - mine has gone over 4GB so would you suggest breaking it down into a catalogue a year? Link to comment Share on other sites More sharing options...
Brian Posted February 25, 2017 Share Posted February 25, 2017 4 hours ago, Sue Morris said: HI Brian - mine has gone over 4GB so would you suggest breaking it down into a catalogue a year? YES. Besides, LR has a tendency to get really cranky when the catalog file gets that big. It's good practice to keep it below 3GB at all times. Once you cross that threshold, you start venturing into unknown territory. It's so funny how people get so worked up about having "too many images" on one CF / SD card, but have no issues with having tens-of-thousands of images in a single LR catalog file! Something to think about. Link to comment Share on other sites More sharing options...
Banksiagirl Posted March 1, 2017 Author Share Posted March 1, 2017 I finally have my catalog back! I was able to use the last backup thankfully. I used LR on my laptop to check - first I set the preferences on its catalog not to open the last catalog used - I was worried that trying the dodgy files may corrupt the laptop catalog. I opened older backups - I had 4 for February - all ok and gradually opened the latest backup and it worked! That latest backup had problems closing down on the laptop - integrity test failed but LR asked if I wanted it to repair it. Eventually after much nailbiting waiting it came up with a new good catalog. When I used a copy of this catalog on the PC I had the same corrupt error so I logged out of CC, unistalled and downloaded again. All good thank heavens! Now to separate up these images into smaller catalogs. Thanks for the support! i Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now