Could you please let me know the exact version of Lightroom installed on your computer?
Also where are you trying to backup the Catalog, try to change the backup location once and then backup the Catalog.
1 person found this helpful
I am experiencing the same issue on my PC and it's still there despite LR 6.x updates.
Catalogue backup process starts at LR exit, the progress bar moves ahead and the dialogue displays "Optimizing Catalogue..." and then the progress bar freezes forever. Clicking the Cancel button does not interrupt the process and the only way to exit is to kill the LR process.
No working solution found on the web, only the same question asked!
I cross-checked several things within this LR catalogue:
- Catalogue optimization successfully works from the "File" menu
- The "Export as a catalogue" from the "File" menu does not react (no message, no dialogue box)
- The "Export this folder as a catalogue" when right-clicking a folder does not react (no message, no dialogue box)
All features work using another catalogue (14,000 photographs, 159 MB catalogue file)...
- Data volumes: 75,000 photographs, 1.4 GB catalogue file, locations and face recognition enabled
- Lightroom: Latest version 6.7 (French) installed
- OS: Windows 10 Pro (French) with latest updates, no anti-virus
- User rights: user with administrator rights
- File System rights: System and user accounts have full access rights on Lightroom folder, Backup folder and below (inheritance)
- Hardware health: 3 TB hard-disk: brand new, no bad sectors, plenty of free space (500 GB)
- Hardware compatibility: Intel PC, 4 GB RAM
Reminder of the catalogue backup process according to progress bar:
1 person found this helpful
Message to Adobe Dev team:
Please add this VACCUM command to your Optimization/Integrity check features since it obviously does not fix the LR catalogue the same way.
Diagnosis: Catalogue file is corrupted!
Obviously based on the above observations the .lrcat file is corrupted in some way :
Every time you need to export or backup the catalogue you are stuck even if you can still open/use it.
Clue: I also understood based on this link that the Lightroom.lrcat file was actually a SQLite 3 database file!
Working solution found!
I opened the .lrcat file with a SQLite Manager and ran a VACUUM command, --which "realigns" data structure without touching contents-- and it WORKED!
Long version of how to fix a partially corrupted Lightroom catalogue:
- Ensure Lightroom is closed
- Make a copy your .lrcat catalogue file and keep it apart
- Change the extension of your original catalogue file to .sqlite
- Open it with the SQLite Manager (download one here or there)
- Run a VACCUM command onto the database and wait for it to finish
- Close the SQLite Manager and change the file extension back to .lrcat
- Launch Lightroom again (remove the .lock file if necessary)
- Try to launch an immediate backup while exiting (with integrity check and optimization enabled)
- It should go through all 4 steps (see previous post) and exit Lightroom
- Open your catalogue again, check it all
- Delete your copy of the catalogue file once you checked everything is correct
Additional fix: Video cache
Problem: I was also not able to flush the video cache in Lightroom settings.
- Delete cache files in the following folders:
- Edit the associated LightroomPlayback.db file and VACCUM it the same way as described above