Troubleshooting iCloud Photos on PC Not Syncing

Question

Level 1

4 points

Troubleshooting iCloud Photos on PC Not Syncing

Found quite a few ERROR entries in the iCloudPhotos.xxx.log

Anyone seen these issues and have a resolution or additional debug steps?

_errorLogCallback	SQLite[1555]: abort at 20 in [INSERT INTO 'fingerprint_paths_snaptshot' SELECT fingerprint_paths.fingerprint, fingerprint_paths.path FROM 'fingerprint_paths']: UNIQUE constraint failed: fingerprint_paths_snaptshot.fingerpri

WP::LogSqlError	DB ...\AppleInc.iCloud_nzyj5cx40ttqa\LocalCache\Local\Apple Inc\iCloudPhotoLibrary\client.db: Code 19: SQL error (19,1555): UNIQUE constraint failed: fingerprint_paths_snaptshot.fingerprint.  Executing statement 'INSERT INTO 'fingerprint_paths_snaptshot' SELECT fingerprint_paths.fingerprint, fingerprint_paths.path FROM 'fingerprint_paths''

WP::Deleter::MakeFingerprintPathsTableSnapshot	Error when trying to take paths table snapshot: SQL error (19,1555): UNIQUE constraint failed: fingerprint_paths_snaptshot.fingerprint.  Executing statement 'INSERT INTO 'fingerprint_paths_snaptshot' SELECT fingerprint_paths.fingerprint, fingerprint_paths.path FROM 'fingerprint_paths''.

Posted on May 5, 2024 9:25 PM

Reply

Answer 1

jaredfordham Author

Level 1

4 points

May 5, 2024 9:52 PM in response to jaredfordham

Connecting a sqlite client and looking at the table definition it looks like the insert statement doesn't handle the scenario where the same fingerprint exists twice in the fingerprint_paths table, which appears to be valid according to the schema:

CREATE TABLE IF NOT EXISTS 'fingerprint_paths' (fingerprint TEXT NOT NULL, asset_key TEXT, path TEXT NOT NULL, downloaded_manually INTEGER DEFAULT 0, PRIMARY KEY(fingerprint, path));

The snapshot table doesn't appear to be able to handle a path in the primary key like the source table.

CREATE TABLE IF NOT EXISTS 'fingerprint_paths_snaptshot' (fingerprint TEXT NOT NULL, path TEXT NOT NULL, PRIMARY KEY(fingerprint));

This query shows me one record that has the same fingerprint with two paths.

sqlite> select fingerprint, count(*) from fingerprint_paths group by fingerprint having count(*) > 1;

Reply

Answer 2

jaredfordham Author

Level 1

4 points

May 5, 2024 9:54 PM in response to jaredfordham

Looks like maybe the fingerprint algorithm returns the same value on an image that is rotated 90 degrees.

Reply