2025-09-12 17:51:23.364736 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:50:57.912051 | info | HashService | Hashing took - 75ms | 2025-09-12 17:50:57.835895 | info | HashService | Starting hashing of assets | 2025-09-12 17:50:55.791458 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:50:55.789901 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:50:55.778140 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:50:40.614940 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:50:38.553480 | info | DeviceSyncService | Device sync took - 23ms | 2025-09-12 17:50:38.505014 | severe | AuthenticationNotifier | Error getting user information from the server [CATCH ALL] | TimeoutException after 0:00:07.000000: Future not completed | #0 Future.timeout. (dart:async/future_impl.dart:1045) #1 AuthNotifier.saveAuthInfo (package:immich_mobile/providers/auth.provider.dart:134) #2 SplashScreenPageState.resumeSession. (package:immich_mobile/pages/common/splash_screen.page.dart:54) 2025-09-12 17:50:25.847266 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:50:19.437874 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:49:47.102502 | severe | ImmichErrorLogger | PlatformDispatcher - Catch all | Null check operator used on a null value | #0 AppLifeCycleNotifier.handleAppResume (package:immich_mobile/providers/app_life_cycle.provider.dart:68) 2025-09-12 17:49:47.051335 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 17:49:47.051322 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 17:49:47.039018 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 17:49:45.037169 | info | HashService | Hashing took - 28ms | 2025-09-12 17:49:45.008455 | info | HashService | Starting hashing of assets | 2025-09-12 17:49:42.993912 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:42.993266 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:42.989884 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:42.041386 | severe | ImmichErrorLogger | PlatformDispatcher - Catch all | Null check operator used on a null value | #0 AppLifeCycleNotifier.handleAppResume (package:immich_mobile/providers/app_life_cycle.provider.dart:68) 2025-09-12 17:49:42.010481 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 17:49:42.010468 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 17:49:42.002739 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 17:49:42.002730 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 17:49:41.994223 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 17:49:41.994167 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 17:49:40.922124 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:49:39.992311 | info | HashService | Hashing took - 31ms | 2025-09-12 17:49:39.960443 | info | HashService | Starting hashing of assets | 2025-09-12 17:49:38.901811 | info | DeviceSyncService | Device sync took - 9ms | 2025-09-12 17:49:38.146654 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:49:37.950547 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:37.949571 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:37.941011 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:49:32.358302 | info | DeviceSyncService | Device sync took - 10ms | 2025-09-12 17:49:31.573466 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:49:21.103678 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:49:19.092832 | info | DeviceSyncService | Device sync took - 8ms | 2025-09-12 17:49:18.363872 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:48:56.755815 | info | HashService | Hashing took - 29ms | 2025-09-12 17:48:56.726050 | info | HashService | Starting hashing of assets | 2025-09-12 17:48:54.696369 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:54.695755 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:54.693309 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:50.345414 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:48:49.446353 | info | DeviceSyncService | Device sync took - 15ms | 2025-09-12 17:48:45.261653 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:45.261104 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:45.257935 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 170 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 65 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 46 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 103 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 55 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 34 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:48:42.677961 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:48:40.637728 | info | DeviceSyncService | Device sync took - 19ms | 2025-09-12 17:48:30.092399 | info | HashService | Hashing took - 68ms | 2025-09-12 17:48:30.023901 | info | HashService | Starting hashing of assets | 2025-09-12 17:48:27.990839 | severe | IsolateLogger | Error in runInIsolateGentle | ApiException 502: Failed to get sync stream: | #0 SyncApiRepository.streamChanges (package:immich_mobile/infrastructure/repositories/sync_api.repository.dart:81) #1 SyncStreamService.sync (package:immich_mobile/domain/services/sync_stream.service.dart:30) #2 runInIsolateGentle.. (package:immich_mobile/utils/isolate.dart:55) #3 runInIsolateGentle. (package:immich_mobile/utils/isolate.dart:34) #4 WorkerImpl._anotherIsolate. (package:worker_manager/src/worker/worker_io.dart:106) 2025-09-12 17:48:27.989039 | severe | SyncApiRepository | Error processing stream | ApiException 502: Failed to get sync stream: | #0 SyncApiRepository.streamChanges (package:immich_mobile/infrastructure/repositories/sync_api.repository.dart:81) #1 SyncStreamService.sync (package:immich_mobile/domain/services/sync_stream.service.dart:30) #2 runInIsolateGentle.. (package:immich_mobile/utils/isolate.dart:55) #3 runInIsolateGentle. (package:immich_mobile/utils/isolate.dart:34) #4 WorkerImpl._anotherIsolate. (package:worker_manager/src/worker/worker_io.dart:106) 2025-09-12 17:48:27.341588 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:48:25.315226 | info | DeviceSyncService | Device sync took - 1444ms | 2025-09-12 17:48:23.858219 | severe | AuthenticationNotifier | Error getting user information from the server [CATCH ALL] | ParallelWaitError(2 errors): ApiException 502: | #0 UsersApi.getMyUser (package:openapi/api/users_api.dart:265) #1 FutureRecord2.wait. (dart:async/future_extensions.dart:88) #2 UserApiRepository.getMyUser (package:immich_mobile/infrastructure/repositories/user_api.repository.dart:14) #3 UserService.refreshMyUser (package:immich_mobile/domain/services/user.service.dart:38) #4 Future.timeout. (dart:async/future_impl.dart:1064) #5 AuthNotifier.saveAuthInfo (package:immich_mobile/providers/auth.provider.dart:134) #6 SplashScreenPageState.resumeSession. (package:immich_mobile/pages/common/splash_screen.page.dart:54) 2025-09-12 17:39:51.808793 | info | DeviceSyncService | Device sync took - 654ms | 2025-09-12 17:39:49.930825 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 17:37:51.232780 | info | BackgroundUploadBgService | Cleaning up background worker | 2025-09-12 17:37:51.232630 | info | BackgroundUploadBgService | Android background processing completed in 7s | 2025-09-12 17:37:45.633106 | info | DeviceSyncService | Device sync took - 1846ms | 2025-09-12 17:37:44.610167 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:37:44.608240 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:37:44.599508 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:37:44.572516 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 17:37:43.773780 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:37:43.712034 | info | BackgroundUploadBgService | Android background processing started | 2025-09-12 17:37:43.707996 | info | BackgroundUploadBgService | Acquired background worker lock | 2025-09-12 17:36:55.156332 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 17:36:55.156323 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 17:36:55.148860 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 17:36:53.147533 | info | HashService | Hashing took - 23ms | 2025-09-12 17:36:53.123999 | info | HashService | Starting hashing of assets | 2025-09-12 17:36:52.938925 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:52.938214 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:52.934507 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:52.930446 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 17:36:51.112368 | info | DeviceSyncService | Device sync took - 72ms | 2025-09-12 17:36:51.112284 | info | DeviceSyncService | Full device sync took - 72ms | 2025-09-12 17:36:51.038213 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:36:21.144761 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:21.144325 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:21.142348 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:21.132069 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 17:36:20.166218 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:36:18.580183 | info | HashService | Hashing took - 37ms | 2025-09-12 17:36:18.542534 | info | HashService | Starting hashing of assets | 2025-09-12 17:36:17.858478 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:17.857633 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:17.854362 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:36:17.850557 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 17:36:16.528395 | info | DeviceSyncService | Device sync took - 82ms | 2025-09-12 17:36:16.528314 | info | DeviceSyncService | Full device sync took - 82ms | 2025-09-12 17:36:16.442777 | info | SyncStreamService | Remote sync request for user | 2025-09-12 17:36:01.524480 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 17:36:01.524469 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 17:36:01.516903 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 17:35:59.515137 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:35:59.514512 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:35:59.511881 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 17:35:59.507860 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 17:35:59.415594 | info | HashService | Hashing took - 54ms | 2025-09-12 17:35:59.360810 | info | HashService | Starting hashing of assets | 2025-09-12 17:35:57.346255 | info | DeviceSyncService | Device sync took - 307ms | 2025-09-12 17:35:57.346168 | info | DeviceSyncService | Full device sync took - 307ms | 2025-09-12 17:35:57.040322 | info | SyncStreamService | Remote sync request for user | 2025-09-12 15:59:37.429752 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 15:59:37.429737 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 15:59:37.418945 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 15:59:35.414839 | info | HashService | Hashing took - 24ms | 2025-09-12 15:59:35.390450 | info | HashService | Starting hashing of assets | 2025-09-12 15:59:34.526123 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:59:34.525453 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:59:34.522657 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:59:34.518751 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 15:59:33.378903 | info | DeviceSyncService | Device sync took - 94ms | 2025-09-12 15:59:33.378821 | info | DeviceSyncService | Full device sync took - 94ms | 2025-09-12 15:59:33.291740 | info | SyncStreamService | Remote sync request for user | 2025-09-12 15:58:57.881949 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-12 15:58:57.881880 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-12 15:58:57.873365 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 15:58:55.870781 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:58:55.870045 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:58:55.866957 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:58:55.416621 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 15:58:54.482810 | info | SyncStreamService | Remote sync request for user | 2025-09-12 15:58:52.474085 | info | HashService | Hashing took - 28ms | 2025-09-12 15:58:52.445818 | info | HashService | Starting hashing of assets | 2025-09-12 15:58:50.430247 | info | DeviceSyncService | Device sync took - 5ms | 2025-09-12 15:58:49.247817 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-12 15:56:35.549677 | info | SyncStreamService | Successfully processed 2 assets in batch | 2025-09-12 15:56:35.537398 | info | SyncStreamService | Processing batch of 2 AssetUploadReadyV1 events | 2025-09-12 15:56:25.244467 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-09-12 15:56:25.230131 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-09-12 15:56:10.422166 | info | DriftBackupNotifier | Start a new backup queue | 2025-09-12 15:56:10.422133 | info | DriftBackupNotifier | Found 0 tasks | 2025-09-12 15:56:10.402202 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-12 15:56:08.395204 | info | HashService | Hashing took - 870ms | 2025-09-12 15:56:07.524508 | info | HashService | Starting hashing of assets | 2025-09-12 15:56:06.590314 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:56:06.589524 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:56:06.586457 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-12 15:56:06.082342 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-12 15:56:05.492220 | info | DeviceSyncService | Device sync took - 827ms | 2025-09-12 15:56:05.492151 | info | DeviceSyncService | Full device sync took - 827ms | 2025-09-12 15:56:04.664831 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:49:28.158930 | info | HashService | Hashing took - 39ms | 2025-09-11 14:49:28.120718 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:49:28.120013 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:49:28.119169 | info | HashService | Starting hashing of assets | 2025-09-11 14:49:28.117674 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:49:28.113654 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:49:26.096992 | info | DeviceSyncService | Device sync took - 142ms | 2025-09-11 14:49:26.096910 | info | DeviceSyncService | Full device sync took - 142ms | 2025-09-11 14:49:25.952506 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:48:21.802999 | severe | ImmichErrorLogger | PlatformDispatcher - Catch all | Bad state: Cannot use "ref" after the widget was disposed. | #0 ConsumerStatefulElement._assertNotDisposed (package:flutter_riverpod/src/consumer.dart:550) #1 ConsumerStatefulElement.read (package:flutter_riverpod/src/consumer.dart:619) #2 _DriftBackupPageState.startBackup (package:immich_mobile/pages/backup/drift_backup.page.dart:44) #3 _DriftBackupPageState.build. (package:immich_mobile/pages/backup/drift_backup.page.dart:93) 2025-09-11 14:48:19.801189 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:19.800406 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:19.794519 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:19.785626 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:48:18.522049 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:48:09.435643 | info | HashService | Hashing took - 24ms | 2025-09-11 14:48:09.410570 | info | HashService | Starting hashing of assets | 2025-09-11 14:48:06.198938 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:06.197215 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:06.189836 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:48:06.180466 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:48:05.342343 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:48:02.595397 | info | DeviceSyncService | Device sync took - 97ms | 2025-09-11 14:48:02.595284 | info | DeviceSyncService | Full device sync took - 96ms | 2025-09-11 14:47:39.641730 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-09-11 14:47:39.641721 | info | DriftBackupNotifier | Found 1 tasks | 2025-09-11 14:47:39.631521 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-11 14:47:37.627114 | info | HashService | Hashing took - 62ms | 2025-09-11 14:47:37.564594 | info | HashService | Starting hashing of assets | 2025-09-11 14:47:36.353231 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:36.352620 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:36.350142 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:36.347268 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:47:35.521281 | info | DeviceSyncService | Device sync took - 84ms | 2025-09-11 14:47:35.521198 | info | DeviceSyncService | Full device sync took - 84ms | 2025-09-11 14:47:35.434948 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:47:29.634403 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:29.633443 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:29.629800 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:47:29.624914 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:47:29.388444 | info | HashService | Hashing took - 52ms | 2025-09-11 14:47:29.335292 | info | HashService | Starting hashing of assets | 2025-09-11 14:47:27.294666 | info | DeviceSyncService | Device sync took - 390ms | 2025-09-11 14:47:27.294580 | info | DeviceSyncService | Full device sync took - 390ms | 2025-09-11 14:47:26.904340 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:41:16.501791 | info | DriftBackupNotifier | Tasks to resume: 3 | 2025-09-11 14:41:16.501783 | info | DriftBackupNotifier | Found 3 tasks | 2025-09-11 14:41:16.496145 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-11 14:41:14.494241 | info | HashService | Hashing took - 28ms | 2025-09-11 14:41:14.465495 | info | HashService | Starting hashing of assets | 2025-09-11 14:41:14.027344 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:41:14.026769 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:41:14.024374 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:41:13.288508 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:41:12.452416 | info | DeviceSyncService | Device sync took - 90ms | 2025-09-11 14:41:12.452324 | info | DeviceSyncService | Full device sync took - 90ms | 2025-09-11 14:41:12.361259 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:41:03.850047 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-09-11 14:41:03.840943 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-09-11 14:40:54.028220 | info | SyncStreamService | Successfully processed 3 assets in batch | 2025-09-11 14:40:53.994332 | info | SyncStreamService | Processing batch of 3 AssetUploadReadyV1 events | 2025-09-11 14:40:50.962237 | info | DriftBackupNotifier | Tasks to resume: 12 | 2025-09-11 14:40:50.962224 | info | DriftBackupNotifier | Found 12 tasks | 2025-09-11 14:40:50.952932 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-11 14:40:48.950511 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:40:48.949204 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:40:48.942670 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:40:43.776563 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:40:43.582448 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-09-11 14:40:43.507982 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-09-11 14:40:39.061976 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:40:37.048618 | info | HashService | Hashing took - 21ms | 2025-09-11 14:40:37.027198 | info | HashService | Starting hashing of assets | 2025-09-11 14:40:35.017783 | info | DeviceSyncService | Device sync took - 3ms | 2025-09-11 14:40:32.678487 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-11 14:40:26.557399 | info | DeviceSyncService | Device sync took - 9ms | 2025-09-11 14:40:26.536900 | warning | BackgroundWorkerLockManager | WARNING: [acquireLock] called more than once | 2025-09-11 14:40:25.929573 | info | AppLifeCycleNotifier | Using server URL: null | 2025-09-11 14:40:25.194472 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:40:23.837662 | info | SyncStreamService | Remote sync request for user | 2025-09-11 14:39:56.309865 | info | SyncStreamService | Successfully processed 4 assets in batch | 2025-09-11 14:39:56.286423 | info | SyncStreamService | Processing batch of 4 AssetUploadReadyV1 events | 2025-09-11 14:39:44.209583 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-09-11 14:39:44.204075 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-09-11 14:39:36.338886 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-09-11 14:39:36.319458 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-09-11 14:39:26.838991 | info | DriftBackupNotifier | Start a new backup queue | 2025-09-11 14:39:26.838979 | info | DriftBackupNotifier | Found 0 tasks | 2025-09-11 14:39:26.832778 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-11 14:39:24.829372 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:39:24.828524 | severe | SyncApiRepository | Error processing stream | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:39:24.825746 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - user | SqliteException(2067): while executing statement, UNIQUE constraint failed: remote_asset_entity.owner_id, remote_asset_entity.checksum, 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", "library_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" = ?, "library_id" = ?, parameters: 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, 094c840b-3d32-4571-b407-3c4dd0e2a1f1, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, null, 20240201_171830.mp4, 2, 2024-02-01T20:20:58.000Z, 2024-02-01T20:20:58.000Z, 147, +Ln3nNmaorproc4zbas2a9sPbno=, 0, c55a4215-8961-40fd-925f-326c036540ab, 2024-02-01T20:20:58.000Z, null, 2025-09-05T02:17:18.430Z, null, 0, null, 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. 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. 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. ===== 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 107 SyncStreamRepository.updateAssetsV1 package:immich_mobile/domain/services/sync_stream.service.dart 98 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 83 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 99 SyncApiRepository.streamChanges package:immich_mobile/utils/isolate.dart 53 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-09-11 14:39:24.355073 | warning | SyncApiRepository | Unknown type SyncCompleteV1 | 2025-09-11 14:39:24.222029 | info | HashService | Hashing took - 1026ms | 2025-09-11 14:39:23.195079 | info | HashService | Starting hashing of assets | 2025-09-11 14:39:21.181941 | info | DeviceSyncService | Device sync took - 1506ms | 2025-09-11 14:39:21.181849 | info | DeviceSyncService | Full device sync took - 1506ms | 2025-09-11 14:39:19.676458 | info | SyncStreamService | Remote sync request for user | 2025-09-10 16:38:09.590762 | info | DriftBackupNotifier | Start a new backup queue | 2025-09-10 16:38:09.590738 | info | DriftBackupNotifier | Found 0 tasks | 2025-09-10 16:38:09.567059 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-09-10 16:38:08.327532 | info | HashService | Hashing took - 1441ms |