© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•3mo ago•
5 replies
stealydan

Can’t sync from iOS mobile app due to SqliteException from updateMemoryAssetsV1?

Hello all, hoping I can get some help with getting my Immich mobile app syncing properly again! This might have started happening around the 2.0 update, it’s been happening for a few weeks and I just haven’t gotten around to debugging it 😅

When trying to sync new images on mobile I get a “Sync failed. Cannot process backup.” The iOS logs show two severe errors whenever the app tries to start an upload, I attached an export of the logs. The first comes from the “DriftSyncStreamRepository” with the following
Error: updateMemoryAssetsV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "memory_asset_entity" ("asset_id", "memory_id") VALUES (?, ?) ON CONFLICT("asset_id", "memory_id") DO NOTHING, parameters: a809c788-3d59-4c13-821f-d865b13e009c, 203e812a-a556-4655-b6b4-15a368bb2053
Error: updateMemoryAssetsV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "memory_asset_entity" ("asset_id", "memory_id") VALUES (?, ?) ON CONFLICT("asset_id", "memory_id") DO NOTHING, parameters: a809c788-3d59-4c13-821f-d865b13e009c, 203e812a-a556-4655-b6b4-15a368bb2053


Then a second severe error is logged from “IsolateLogger | Error in runInIsolateGentle for remote-sync” with the same Sqlite exception.
Immich server is on the latest version, deployed via Docker following the install guide, and accessed using Tailscale serve.
Immich_log_2025-11-08T104405.123908.log198.37KB
Compose.yml.md2.7KB
database_integrity_cmds.txt901B
env.md1.02KB
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Immich Mobile iOS Error: updateMemoryAssetsV1
ImmichIImmich / help-desk-support
3mo ago
Can’t search from Mobile App (IOS)
ImmichIImmich / help-desk-support
3w ago
Mobile app no longer sync'ing (updateMemoryAssetsV1: foreign key constraint failed)
ImmichIImmich / help-desk-support
4mo ago
iOS App - library sync
ImmichIImmich / help-desk-support
7mo ago