Error syncing keywords from the primary photo to multiple photos

Report · Aug 19, 2024

Problem: When syncing keywords in Library Module from the primary photo to multiple photos, I get this error:

An internal error has occurred: Database "C:\Users......LR Classic Master Catalog-v13- 3.lrcat": Unique constraint failed: AgLibraryKeywordImage.id_local sql: insert into AgLibraryKeywordImage.id_local(id_local, imagae, tag) values(?,?,?);

Result: No keywords are copied to multiple photos metadata. I must copy/paste manually.

SYSTEM INFO:

Lightroom Classic version: 13.5 [ 202408062022-6258095b ]
License: Creative Cloud
Language setting: en
Operating system: Windows 11 - Home Premium Edition
Version: 11.0.22631
Application architecture: x64
System architecture: x64
Logical processor count: 16
Processor speed: 3.6GHz
SqLite Version: 3.36.0
CPU Utilisation: 1.0%
Power Source: Plugged In
Built-in memory: 32702.0 MB
Dedicated GPU memory used by Lightroom: 3133.4MB / 8006.0MB (39%)
Real memory available to Lightroom: 32702.0 MB
Real memory used by Lightroom: 9214.9 MB (28.1%)
Virtual memory used by Lightroom: 15954.6 MB
GDI objects count: 1251
USER objects count: 3976
Process handles count: 4280
Memory cache size: 0.0MB
Internal Camera Raw version: 16.5 [ 1953 ]
Maximum thread count used by Camera Raw: 5
Camera Raw SIMD optimization: SSE2,AVX,AVX2
Camera Raw virtual memory: 1286MB / 16351MB (7%)
Camera Raw real memory: -1207MB / 32702MB (-3%)

Cache1:
NT- RAM:0.0MB, VRAM:0.0MB, Combined:0.0MB

Cache2:
m:0.0MB, n:0.0MB

U-main: 121.0MB

System DPI setting: 96 DPI
Desktop composition enabled: Yes
Standard Preview Size: 1920 pixels
Displays: 1) 1920x1200, 2) 1920x1200
Input types: Multitouch: No, Integrated touch: No, Integrated pen: No, External touch: No, External pen: No, Keyboard: No

Graphics Processor Info:
DirectX: NVIDIA GeForce RTX 2060 SUPER (31.0.15.5244)
Init State: GPU for Export supported by default
User Preference: GPU for Display Enabled
Enable HDR in Library: OFF

Application folder: C:\Program Files\Adobe\Adobe Lightroom Classic
Library Path: C:\Users\cjs84\Lightroom CC\CSP_LR Classic Master Catalog-v13-3.lrcat
Settings Folder: C:\Users\cjs84\AppData\Roaming\Adobe\Lightroom

Installed Plugins:
1) AdobeStock

Report · Aug 19, 2024

Sounds like a error in the SQLite database, the catalog. Possibly a corrupt catalog.

If you create a new catalog, import some photos, and apply some keywords, and then attempt the sync, does the new catalog behave?

and, perhaps, see:

https://helpx.adobe.com/lightroom-classic/kb/troubleshoot-corrupt-catalog.html

P.S. (1)

If you decide to check the integrity:

I would highly recommend making sure that you have a backup of the catalog. Even before checking the integrity
I would recommend that you check the integrity, not as a part of backing up, but as a part of opening a catalog. With LrC closed, hold down on and hold the ALT key and click on the LrC startup Shortcut Icon in the Taskbar. In the Catalog Prompt that shows up, select the catalog and check on the test integrity box.

P.S. (2)

Graphics Processor Info:
DirectX: NVIDIA GeForce RTX 2060 SUPER (31.0.15.5244)

Nothing to do with your error message, but your GPU driver appears to be out of date. Windows Store v 31.0.15.5244, so NVIDIA v552.44. At the NVIDIA Driver site the current one is listed as v560.81 (both Studio and GameReady)

https://www.nvidia.com/en-us/drivers/