Corrupted Lightroom Classic CC Catalog (problems with SQLite solution)

Report · Jun 10, 2018

Hi All,

I was merging a panorama in my Lightroom Classic CC (the latest one), when all of a sudden it quit the program, and when reopened, told me that couldn't open the catalog because it was "not valid".

I've tried to go through the SQLITE process on my Mac, that many recommend (i.e. here Recover from a corrupt Adobe Lightroom catalog file | The world according to Gerhard ).

On the final step of "-init", it gave me this text below, and the new .lrcat file in the folder is 0 bytes large.

Does anyone know what I did wrong and how to fix it?

I can also provide the .lrcat file itself if there is anyone who knows how to fix it.

Thank you very much in advance!

Text from sqlite:

Error: near line 325698: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325699: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325700: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325701: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325702: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325703: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325704: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325705: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325706: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325707: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325708: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325709: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325710: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325711: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325712: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325713: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325714: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325715: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325716: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325717: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325718: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325719: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325720: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325721: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325722: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325723: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325724: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325725: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325726: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325727: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325728: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325729: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325730: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325731: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325732: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325733: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325734: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325735: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325736: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325737: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325738: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325739: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325740: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325741: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325742: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325743: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325744: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325745: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325746: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325747: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325748: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325749: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325750: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325751: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325752: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325753: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325754: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325755: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325756: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325757: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325758: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325759: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325760: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325761: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325762: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325763: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325764: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325765: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325766: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325767: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325768: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325769: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325770: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325771: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325772: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325773: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325774: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325775: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325776: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325777: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325778: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325779: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325780: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325781: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325782: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325783: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325784: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325785: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325786: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325787: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325788: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325789: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325790: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325791: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325792: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325793: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325794: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325795: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325796: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325797: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325798: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325799: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325800: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325801: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325802: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325803: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325804: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325805: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325806: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325807: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325808: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325809: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325810: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325811: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325812: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325813: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325814: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325815: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325816: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325817: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325818: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325819: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325820: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325821: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325822: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325823: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325824: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325825: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325826: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325827: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325828: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325829: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325830: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325831: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325832: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325833: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325834: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325835: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325836: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325837: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325838: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325839: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325840: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325841: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Error: near line 325842: NOT NULL constraint failed: AgLibraryImageSyncedAssetData.image

Report · Jun 11, 2018

If on Windows try the free trial of SQLite Expert Professional 5 and use it's 'Integrity Check' and 'Repair' utilities. Very easy to use GUI based Sqlite3 app. It worked for me with a corrupt LR 7.3 catalog file.

SQLite administration | SQLite Expert

Report · Jun 11, 2018

Thank you very much, Todd!

I've got Mac, will try to find a Mac version of that Expert Professional

Adobe Community

Corrupted Lightroom Classic CC Catalog (problems with SQLite solution)