After the update to 1.136.0 Beta Sync doesn't work #20196

s-martin · 2025-07-25T03:47:24Z

s-martin
Jul 25, 2025

The new timeline sure is a lot faster! Thanks for that.

The Beta Sync does not work for me though. Of 8000 assets on my phone (Pixel 7, Android 16) which are already on immich, the Beta Sync wants to reupload 7000 assets again and again up to the point that the sync hangs completely. Restarting the app didn't help.

In addition there are no albums on my phone in immich from the server.

Found some errors in the logs

Error: updateAssetsV1 - user

SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null

package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

Error processing stream

SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null

package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

Error in runInIsolateGentle 

SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null

package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

These errors repeat every 1-2 minutes.

alextran1502 · 2025-07-25T03:48:46Z

alextran1502
Jul 25, 2025
Maintainer

Can you help get the mobile app logs?

5 replies

s-martin Jul 25, 2025
Author

Yes, already working on it.

s-martin Jul 25, 2025
Author

I edited the original message in the thread

jrasm91 Jul 25, 2025
Maintainer

Do you by chance use external libraries? Do you have more than one?

@alextran1502 the unique constraint is wrong and needs to take library id into account, and I'm guessing this is the cause.

alextran1502 Jul 25, 2025
Maintainer

Yep, data isn't synced so no matching hash

s-martin Jul 25, 2025
Author

I have one external library configured.

s-martin · 2025-07-25T04:11:35Z

s-martin
Jul 25, 2025
Author

Ok, copied the whole log here

2025-07-25 06:09:29.958515 | info     | DEV                  | Hashing took - 166ms |
2025-07-25 06:09:29.958349 | info     | HashService          | Hashing took - 166ms |
2025-07-25 06:09:29.941433 | severe   | IsolateLogger        | Error in runInIsolateGentle  | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null |
package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2025-07-25 06:09:29.941063 | severe   | SyncApiRepository    | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null |
package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2025-07-25 06:09:29.926559 | severe   | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null |
package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2025-07-25 06:09:27.554526 | info     | DEV                  | Device sync took - 125ms |
2025-07-25 06:09:27.554436 | info     | DeviceSyncService    | Device sync took - 125ms |
2025-07-25 06:09:27.554317 | info     | DEV                  | No media changes detected. Skipping sync |
2025-07-25 06:09:27.430699 | info     | DEV                  | Remote sync request for user |
2025-07-25 06:09:27.430426 | info     | SyncStreamService    | Remote sync request for userr |
2025-07-25 06:08:22.040773 | info     | DEV                  | Hashing took - 24ms |
2025-07-25 06:08:22.040625 | info     | HashService          | Hashing took - 24ms |
2025-07-25 06:08:21.708265 | severe   | IsolateLogger        | Error in runInIsolateGentle  | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null |
package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAssetsV1
package:immich_mobile/domain/services/sync_stream.service.dart 112                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 103                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 101     SyncApiRepository.streamChanges
package:immich_mobile/utils/isolate.dart 51                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2025-07-25 06:08:21.708165 | severe   | SyncApiRepository    | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.checksum, remote_asset_entity.owner_id, constraint failed (code 2067)
  Causing statement: INSERT INTO "remote_asset_entity" ("name", "type", "created_at", "updated_at", "duration_in_seconds", "id", "checksum", "is_favorite", "owner_id", "local_date_time", "thumb_hash", "deleted_at", "live_photo_video_id", "visibility", "stack_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "name" = ?, "type" = ?, "created_at" = ?, "updated_at" = ?, "duration_in_seconds" = ?, "checksum" = ?, "is_favorite" = ?, "owner_id" = ?, "local_date_time" = ?, "thumb_hash" = ?, "deleted_at" = ?, "live_photo_video_id" = ?, "visibility" = ?, "stack_id" = ?, parameters: IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, 8b6a98da-0ff7-4456-9683-b0e1ecfc5286, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null, IMG_20220819_134946180_MP.mp4, 2, 2022-08-19T11:49:47.000Z, 2025-07-04T07:31:57.328Z, 1, QdwmcwAztrO9CRgFPV7dbq2Y0m8=, 0, f6882898-66e7-42a9-a63c-9fc3c815ffe1, 2022-08-19T11:49:47.000Z, null, null, null, 1, null |
package:sqlite3/src/implementation/exception.dart 87                               throwException
package:sqlite3/src/implementation/statement.dart 109                              StatementImplementation._execute
package:sqlite3/src/implementation/statement.dart 289                              StatementImplementation.executeWith
package:sqlite3/src/statement.dart 81                                              CommonPreparedStatement.execute
package:drift/src/sqlite3/database.dart 131                                        Sqlite3Delegate.runBatchSync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 125  SyncStreamRepository.updateAsset

0 replies

s-martin · 2025-07-25T04:15:40Z

s-martin
Jul 25, 2025
Author

This looks related:
#20195

I probably also have duplicates, because I managed assets in the past in Synology Photos (my external library), which are still on my phone and are now synched:
#20174

0 replies

glauberboom · 2025-07-25T16:20:18Z

glauberboom
Jul 25, 2025

Eu fiz a atualização para essa nova versão v1.136.0, agora estou com vários bugs. Alterei a veriável do meu arquivo ".env" e "docker-compose.yml" de "UPLOAD_LOCATION" para "Immich_media_location" e segui os passos nas notas da versão para atualizar o "UPLOAD_LOCATION" (https://github.com/immich-app/immich/releases/tag/v1.136.0), agora estou com vários busgs.
Fiz atualização dos metadados mas continua com erro.1. Não aparece mais a imagem de perfil no topo (avatar), agora só possui cores.
2. fotos não carregam ao adar zoom ( aparece uma "!") e imagem quebrada, erro ao carregar imagem.
3. não consigo compartilhar fotos pelo app.
Poderiam me ajudar?
Vou precisar reinstalar do zero?

1 reply

bo0tzz Jul 25, 2025
Maintainer

I changed the verifiable of my ".env" and "docker-compose.yml" file from "UPLOAD_LOCATION" to "Immich_media_location"

This is not what the release notes said to do, you should undo this and then read the instructions again carefully.

Uh oh!

After the update to 1.136.0 Beta Sync doesn't work #20196

Uh oh!

Uh oh!

s-martin Jul 25, 2025

Replies: 4 comments · 6 replies

Uh oh!

alextran1502 Jul 25, 2025 Maintainer

Uh oh!

s-martin Jul 25, 2025 Author

Uh oh!

s-martin Jul 25, 2025 Author

Uh oh!

jrasm91 Jul 25, 2025 Maintainer

Uh oh!

alextran1502 Jul 25, 2025 Maintainer

Uh oh!

s-martin Jul 25, 2025 Author

Uh oh!

s-martin Jul 25, 2025 Author

Uh oh!

Uh oh!

s-martin Jul 25, 2025 Author

Uh oh!

glauberboom Jul 25, 2025

Uh oh!

bo0tzz Jul 25, 2025 Maintainer

s-martin
Jul 25, 2025

Replies: 4 comments 6 replies

alextran1502
Jul 25, 2025
Maintainer

s-martin Jul 25, 2025
Author

s-martin Jul 25, 2025
Author

jrasm91 Jul 25, 2025
Maintainer

alextran1502 Jul 25, 2025
Maintainer

s-martin Jul 25, 2025
Author

s-martin
Jul 25, 2025
Author

s-martin
Jul 25, 2025
Author

glauberboom
Jul 25, 2025

bo0tzz Jul 25, 2025
Maintainer