2025-09-12 23:28:45.310697 | info | HashService | Hashing took - 14ms | 2025-09-12 23:28:45.296604 | info | HashService | Starting hashing of assets | 2025-09-12 23:28:43.271963 | info | SyncApiRepository | Remote Sync completed in 3937ms | 2025-09-12 23:28:43.202484 | fine | SyncStreamService | Processing sync data for SyncCompleteV1 of length 1 | 2025-09-12 23:28:43.149163 | fine | SyncStreamService | Processing sync data for UserMetadataV1 of length 2 | 2025-09-12 23:28:43.019788 | fine | SyncStreamService | Processing sync data for AssetFaceV1 of length 1886 | 2025-09-12 23:28:42.960640 | fine | SyncStreamService | Processing sync data for PersonV1 of length 110 | 2025-09-12 23:28:42.904683 | fine | SyncStreamService | Processing sync data for MemoryToAssetV1 of length 201 | 2025-09-12 23:28:42.846717 | fine | SyncStreamService | Processing sync data for MemoryV1 of length 72 | 2025-09-12 23:28:42.797932 | fine | SyncStreamService | Processing sync data for MemoryDeleteV1 of length 63 | 2025-09-12 23:28:42.656515 | fine | SyncStreamService | Processing sync data for AlbumAssetExifCreateV1 of length 1023 | 2025-09-12 23:28:42.557927 | fine | SyncStreamService | Processing sync data for SyncAckV1 of length 1 | 2025-09-12 23:28:42.369498 | fine | SyncStreamService | Processing sync data for AssetExifV1 of length 1507 | 2025-09-12 23:28:41.803284 | fine | SyncStreamService | Processing sync data for AssetExifV1 of length 3227 | 2025-09-12 23:28:41.729849 | fine | SyncStreamService | Processing sync data for AlbumToAssetV1 of length 1023 | 2025-09-12 23:28:41.677081 | fine | SyncStreamService | Processing sync data for AlbumToAssetDeleteV1 of length 2 | 2025-09-12 23:28:41.625474 | fine | SyncStreamService | Processing sync data for AlbumUserV1 of length 1 | 2025-09-12 23:28:41.576777 | fine | SyncStreamService | Processing sync data for AlbumV1 of length 1 | 2025-09-12 23:28:41.524505 | fine | SyncStreamService | Processing sync data for AlbumDeleteV1 of length 1 | 2025-09-12 23:28:41.375453 | fine | SyncStreamService | Processing sync data for AlbumAssetCreateV1 of length 758 | 2025-09-12 23:28:41.157937 | fine | SyncStreamService | Processing sync data for AlbumAssetCreateV1 of length 265 | 2025-09-12 23:28:41.110444 | fine | SyncStreamService | Processing sync data for SyncAckV1 of length 1 | 2025-09-12 23:28:40.560743 | fine | SyncStreamService | Processing sync data for AssetV1 of length 4734 | 2025-09-12 23:28:40.510175 | fine | SyncStreamService | Processing sync data for AssetDeleteV1 of length 5 | 2025-09-12 23:28:40.443841 | fine | SyncStreamService | Processing sync data for PartnerV1 of length 1 | 2025-09-12 23:28:40.373773 | fine | SyncStreamService | Processing sync data for UserV1 of length 4 | 2025-09-12 23:28:40.312038 | fine | SyncStreamService | Processing sync data for UserDeleteV1 of length 1 | 2025-09-12 23:28:40.128180 | fine | SyncStreamService | Processing sync data for AuthUserV1 of length 4 | 2025-09-12 23:28:39.334120 | info | SyncStreamService | Remote sync request for user | 2025-09-12 23:28:37.286482 | info | DeviceSyncService | Device sync took - 25ms | 2025-09-12 23:28:37.286440 | info | DeviceSyncService | Full device sync took - 25ms | 2025-09-12 23:28:37.283726 | fine | DeviceSyncService | Device album Download has not changed. Skipping sync. | 2025-09-12 23:28:37.283715 | fine | DeviceSyncService | Syncing device album Download | 2025-09-12 23:28:37.283681 | fine | DeviceSyncService | Device album WhatsApp Animated Gifs has not changed. Skipping sync. | 2025-09-12 23:28:37.283670 | fine | DeviceSyncService | Syncing device album WhatsApp Animated Gifs | 2025-09-12 23:28:37.283634 | fine | DeviceSyncService | Device album ScreenRecorder has not changed. Skipping sync. | 2025-09-12 23:28:37.283622 | fine | DeviceSyncService | Syncing device album ScreenRecorder | 2025-09-12 23:28:37.283580 | fine | DeviceSyncService | Device album WhatsApp Images has not changed. Skipping sync. | 2025-09-12 23:28:37.283569 | fine | DeviceSyncService | Syncing device album WhatsApp Images | 2025-09-12 23:28:37.283536 | fine | DeviceSyncService | Device album Camera has not changed. Skipping sync. | 2025-09-12 23:28:37.283524 | fine | DeviceSyncService | Syncing device album Camera | 2025-09-12 23:28:37.283490 | fine | DeviceSyncService | Device album Pictures has not changed. Skipping sync. | 2025-09-12 23:28:37.283474 | fine | DeviceSyncService | Syncing device album Pictures | 2025-09-12 23:28:37.283439 | fine | DeviceSyncService | Device album WhatsApp has not changed. Skipping sync. | 2025-09-12 23:28:37.283424 | fine | DeviceSyncService | Syncing device album WhatsApp | 2025-09-12 23:28:37.283383 | fine | DeviceSyncService | Device album Immich has not changed. Skipping sync. | 2025-09-12 23:28:37.283363 | fine | DeviceSyncService | Syncing device album Immich | 2025-09-12 23:28:37.283247 | fine | DeviceSyncService | Device album WhatsApp Video has not changed. Skipping sync. | 2025-09-12 23:28:37.281675 | fine | DeviceSyncService | Syncing device album WhatsApp Video | 2025-09-12 23:28:37.281566 | fine | DeviceSyncService | Device album Screenshots has not changed. Skipping sync. | 2025-09-12 23:28:37.281519 | fine | DeviceSyncService | Syncing device album Screenshots | 2025-09-12 23:28:37.260931 | fine | DeviceSyncService | Full sync request from user | 2025-09-12 23:28:08.087612 | fine | socket_io_client:engine.Socket | socket closing - telling transport to close | 2025-09-12 23:28:08.087607 | fine | socket_io_client:Manager | cleanup | 2025-09-12 23:28:08.087601 | fine | socket_io_client:Manager | onclose | 2025-09-12 23:28:08.087585 | fine | socket_io_client:engine.Socket | socket close with reason: "forced close" | 2025-09-12 23:28:08.087297 | fine | socket_io:parser.Encoder | encoded {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} as 2["disconnecting","io client disconnect"] | 2025-09-12 23:28:08.087284 | fine | socket_io:parser.Encoder | encoding packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:28:08.087281 | fine | socket_io_client:Manager | writing packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:28:08.087270 | fine | socket_io_client:Socket | close (io client disconnect) | 2025-09-12 23:28:08.087259 | fine | socket_io_client:Manager | disconnect | 2025-09-12 23:28:08.087129 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:28:08.087124 | fine | socket_io:parser.Encoder | encoded {type: 1, nsp: /} as 1 | 2025-09-12 23:28:08.087117 | fine | socket_io:parser.Encoder | encoding packet {type: 1, nsp: /} | 2025-09-12 23:28:08.087115 | fine | socket_io_client:Manager | writing packet {type: 1, nsp: /} | 2025-09-12 23:28:08.087103 | fine | socket_io_client:Socket | performing disconnect (/) | 2025-09-12 23:28:08.049427 | fine | DriftSyncStreamRepository | SyncResetV1 received. Resetting remote entities | 2025-09-12 23:27:55.493160 | info | HashService | Hashing took - 20ms | 2025-09-12 23:27:55.472623 | info | HashService | Starting hashing of assets | 2025-09-12 23:27:53.433983 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:27:53.432974 | severe | SyncApiRepository | Error processing stream | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:27:53.426457 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - album asset create | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:27:53.407457 | fine | SyncStreamService | Processing sync data for AlbumAssetCreateV1 of length 21 | 2025-09-12 23:27:53.209032 | fine | SyncStreamService | Processing sync data for SyncAckV1 of length 1 | 2025-09-12 23:27:52.991944 | info | SyncStreamService | Remote sync request for user | 2025-09-12 23:27:50.949131 | info | DeviceSyncService | Device sync took - 4ms | 2025-09-12 23:27:50.949057 | fine | DeviceSyncService | No media changes detected. Skipping sync | 2025-09-12 23:27:50.746011 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_new_release",{"isAvailable":true,"checkedAt":"2025-09-12T19:38:31.489Z","serverVersion":{"major":1,"minor":141,"patch":1},"releaseVersion":{"major":1,"minor":142,"patch":0}}]" | 2025-09-12 23:27:50.745672 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_server_version",{"options":{},"loose":false,"includePrerelease":false,"raw":"1.141.1","major":1,"minor":141,"patch":1,"prerelease":[],"build":[],"version":"1.141.1"}]" | 2025-09-12 23:27:50.745283 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "0{"sid":"Ebdbm_NBD2XywYf3AAAd"}" | 2025-09-12 23:27:50.642708 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:27:50.642700 | fine | socket_io:parser.Encoder | encoded {type: 0, data: null, nsp: /} as 0 | 2025-09-12 23:27:50.642690 | fine | socket_io:parser.Encoder | encoding packet {type: 0, data: null, nsp: /} | 2025-09-12 23:27:50.642685 | fine | socket_io_client:Manager | writing packet {type: 0, data: null, nsp: /} | 2025-09-12 23:27:50.642675 | fine | socket_io_client:Socket | transport is open - connecting | 2025-09-12 23:27:50.642665 | fine | socket_io_client:Manager | cleanup | 2025-09-12 23:27:50.642664 | fine | socket_io_client:Manager | open | 2025-09-12 23:27:50.642661 | fine | socket_io_client:engine.Socket | socket open | 2025-09-12 23:27:50.642626 | fine | socket_io_client:engine.Socket | socket receive: type "open", data "{"sid":"mxX4cQdwca1J4hbiAAAc","upgrades":[],"pingInterval":25000,"pingTimeout":20000,"maxPayload":1000000}" | 2025-09-12 23:27:50.429057 | fine | socket_io_client:Manager | readyState opening | 2025-09-12 23:27:50.429045 | fine | socket_io_client:Manager | connect attempt will timeout after 20000 | 2025-09-12 23:27:50.429038 | fine | socket_io_client:engine.Socket | setting transport websocket | 2025-09-12 23:27:50.428875 | fine | socket_io_client:engine.Socket | creating transport "websocket" | 2025-09-12 23:27:50.428820 | fine | socket_io_client:Manager | opening https://immc.derblindemann.de | 2025-09-12 23:27:50.428810 | fine | socket_io_client:Manager | readyState closed | 2025-09-12 23:27:50.428798 | fine | socket_io_client | ignoring socket cache for https://immc.derblindemann.de | 2025-09-12 23:27:50.275401 | info | AppLifeCycleNotifier | Using server URL: https://immc.derblindemann.de/api | 2025-09-12 23:26:34.974667 | fine | socket_io_client:engine.Socket | socket closing - telling transport to close | 2025-09-12 23:26:34.974648 | fine | socket_io_client:Manager | cleanup | 2025-09-12 23:26:34.974647 | fine | socket_io_client:Manager | onclose | 2025-09-12 23:26:34.974618 | fine | socket_io_client:engine.Socket | socket close with reason: "forced close" | 2025-09-12 23:26:34.973414 | fine | socket_io:parser.Encoder | encoded {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} as 2["disconnecting","io client disconnect"] | 2025-09-12 23:26:34.973361 | fine | socket_io:parser.Encoder | encoding packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:26:34.973355 | fine | socket_io_client:Manager | writing packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:26:34.973336 | fine | socket_io_client:Socket | close (io client disconnect) | 2025-09-12 23:26:34.973330 | fine | socket_io_client:Manager | disconnect | 2025-09-12 23:26:34.973049 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:26:34.973045 | fine | socket_io:parser.Encoder | encoded {type: 1, nsp: /} as 1 | 2025-09-12 23:26:34.973041 | fine | socket_io:parser.Encoder | encoding packet {type: 1, nsp: /} | 2025-09-12 23:26:34.973039 | fine | socket_io_client:Manager | writing packet {type: 1, nsp: /} | 2025-09-12 23:26:34.973012 | fine | socket_io_client:Socket | performing disconnect (/) | 2025-09-12 23:26:22.685346 | info | HashService | Hashing took - 8ms | 2025-09-12 23:26:22.676887 | info | HashService | Starting hashing of assets | 2025-09-12 23:26:20.665175 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:26:20.664626 | severe | SyncApiRepository | Error processing stream | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:26:20.662432 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - album asset create | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:26:20.657282 | fine | SyncStreamService | Processing sync data for AlbumAssetCreateV1 of length 21 | 2025-09-12 23:26:20.425961 | fine | SyncStreamService | Processing sync data for SyncAckV1 of length 1 | 2025-09-12 23:26:20.140620 | info | SyncStreamService | Remote sync request for user | 2025-09-12 23:26:18.325960 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_new_release",{"isAvailable":true,"checkedAt":"2025-09-12T19:38:31.489Z","serverVersion":{"major":1,"minor":141,"patch":1},"releaseVersion":{"major":1,"minor":142,"patch":0}}]" | 2025-09-12 23:26:18.325514 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_server_version",{"options":{},"loose":false,"includePrerelease":false,"raw":"1.141.1","major":1,"minor":141,"patch":1,"prerelease":[],"build":[],"version":"1.141.1"}]" | 2025-09-12 23:26:18.322384 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "0{"sid":"OgvPYOh7yp1RuWnbAAAb"}" | 2025-09-12 23:26:18.266310 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:26:18.266282 | fine | socket_io:parser.Encoder | encoded {type: 0, data: null, nsp: /} as 0 | 2025-09-12 23:26:18.266194 | fine | socket_io:parser.Encoder | encoding packet {type: 0, data: null, nsp: /} | 2025-09-12 23:26:18.266170 | fine | socket_io_client:Manager | writing packet {type: 0, data: null, nsp: /} | 2025-09-12 23:26:18.266152 | fine | socket_io_client:Socket | transport is open - connecting | 2025-09-12 23:26:18.266097 | fine | socket_io_client:Manager | cleanup | 2025-09-12 23:26:18.266096 | fine | socket_io_client:Manager | open | 2025-09-12 23:26:18.266091 | fine | socket_io_client:engine.Socket | socket open | 2025-09-12 23:26:18.266051 | fine | socket_io_client:engine.Socket | socket receive: type "open", data "{"sid":"wD2hqsluJ9x_VyNgAAAa","upgrades":[],"pingInterval":25000,"pingTimeout":20000,"maxPayload":1000000}" | 2025-09-12 23:26:18.125789 | info | DeviceSyncService | Device sync took - 9ms | 2025-09-12 23:26:18.125665 | fine | DeviceSyncService | No media changes detected. Skipping sync | 2025-09-12 23:26:18.108110 | fine | socket_io_client:Manager | readyState opening | 2025-09-12 23:26:18.108089 | fine | socket_io_client:Manager | connect attempt will timeout after 20000 | 2025-09-12 23:26:18.108066 | fine | socket_io_client:engine.Socket | setting transport websocket | 2025-09-12 23:26:18.107758 | fine | socket_io_client:engine.Socket | creating transport "websocket" | 2025-09-12 23:26:18.107683 | fine | socket_io_client:Manager | opening https://immc.derblindemann.de | 2025-09-12 23:26:18.107679 | fine | socket_io_client:Manager | readyState closed | 2025-09-12 23:26:18.107638 | fine | socket_io_client | ignoring socket cache for https://immc.derblindemann.de | 2025-09-12 23:26:17.925405 | info | SplashScreenPage | Resuming session at https://immc.derblindemann.de/api | 2025-09-12 23:21:17.592982 | info | HashService | Hashing took - 42698ms | 2025-09-12 23:21:17.581286 | fine | HashService | Hashed 2/2 assets | 2025-09-12 23:21:17.527941 | fine | HashService | Hashing 2 files | 2025-09-12 23:21:17.399946 | fine | HashService | Hashed 83/83 assets | 2025-09-12 23:21:16.435955 | fine | HashService | Hashing 83 files | 2025-09-12 23:21:12.319550 | fine | HashService | Hashed 1/1 assets | 2025-09-12 23:21:12.285925 | fine | HashService | Hashing 1 files | 2025-09-12 23:21:12.206954 | fine | HashService | Hashed 103/103 assets | 2025-09-12 23:21:11.533622 | fine | HashService | Hashing 103 files | 2025-09-12 23:21:09.829858 | fine | HashService | Hashed 256/256 assets | 2025-09-12 23:21:08.520670 | fine | HashService | Hashing 256 files | 2025-09-12 23:20:58.275928 | fine | HashService | Hashed 256/256 assets | 2025-09-12 23:20:54.925114 | fine | HashService | Hashing 256 files | 2025-09-12 23:20:41.364908 | fine | HashService | Hashed 4/4 assets | 2025-09-12 23:20:41.257587 | fine | HashService | Hashing 4 files | 2025-09-12 23:20:41.028042 | fine | HashService | Hashed 9/9 assets | 2025-09-12 23:20:40.861591 | fine | HashService | Hashing 9 files | 2025-09-12 23:20:40.368983 | fine | HashService | Hashed 6/6 assets | 2025-09-12 23:20:40.146638 | fine | HashService | Hashing 6 files | 2025-09-12 23:20:39.836443 | fine | HashService | Hashed 61/61 assets | 2025-09-12 23:20:37.549964 | fine | HashService | Hashing 61 files | 2025-09-12 23:20:35.739417 | fine | HashService | Hashed 25/25 assets | 2025-09-12 23:20:35.411937 | fine | HashService | Hashing 25 files | 2025-09-12 23:20:34.894153 | info | HashService | Starting hashing of assets | 2025-09-12 23:20:32.882256 | severe | IsolateLogger | Error in runInIsolateGentle | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:20:32.881647 | severe | SyncApiRepository | Error processing stream | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:20:32.878021 | severe | DriftSyncStreamRepository | Error: updateAssetsV1 - album asset create | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) 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: IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, c409db8e-6212-49a4-bc65-4a585d5cf058, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, null, 0, null, null, IMG_20250912_083318.jpg, 1, 2025-09-12T06:33:18.843Z, 2025-09-12T06:33:19.000Z, 0, HKmc4YfWWoh3NOvsfogex0YyldQ=, 0, a25190cf-a278-4ea6-9c49-6025acf8d9ac, 2025-09-12T08:33:18.843Z, XhgSDAB+92iYZ3h3d4fnn0SsCQ==, null, 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 23:20:32.874863 | fine | SyncStreamService | Processing sync data for AlbumAssetCreateV1 of length 21 | 2025-09-12 23:20:32.708927 | fine | SyncStreamService | Processing sync data for SyncAckV1 of length 1 | 2025-09-12 23:20:32.498412 | info | SyncStreamService | Remote sync request for user | 2025-09-12 23:20:30.483805 | info | DeviceSyncService | Device sync took - 11ms | 2025-09-12 23:20:30.483666 | fine | DeviceSyncService | No media changes detected. Skipping sync | 2025-09-12 23:20:30.264374 | info | SplashScreenPage | Resuming session at https://immc.derblindemann.de/api | 2025-09-12 23:20:27.861786 | fine | socket_io:parser.Encoder | encoded {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} as 2["disconnecting","io client disconnect"] | 2025-09-12 23:20:27.861489 | fine | socket_io:parser.Encoder | encoding packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:20:27.861476 | fine | socket_io_client:Manager | writing packet {type: 2, data: [disconnecting, io client disconnect], options: {compress: false}, nsp: /} | 2025-09-12 23:20:27.861386 | fine | socket_io_client:Socket | close (io client disconnect) | 2025-09-12 23:20:27.861367 | fine | socket_io_client:Manager | disconnect | 2025-09-12 23:20:27.860218 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:20:27.860185 | fine | socket_io:parser.Encoder | encoded {type: 1, nsp: /} as 1 | 2025-09-12 23:20:27.860169 | fine | socket_io:parser.Encoder | encoding packet {type: 1, nsp: /} | 2025-09-12 23:20:27.860156 | fine | socket_io_client:Manager | writing packet {type: 1, nsp: /} | 2025-09-12 23:20:27.859969 | fine | socket_io_client:Socket | performing disconnect (/) | 2025-09-12 23:20:19.769474 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:20:19.769394 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:19:54.576525 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:19:54.576466 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:19:29.385660 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:19:29.385546 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:19:04.293796 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:19:04.293729 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:18:39.106278 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:18:39.106200 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:18:13.915894 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:18:13.915855 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:17:48.821176 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:17:48.821127 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:17:23.635017 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:17:23.634956 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:16:58.545768 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:16:58.545726 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:16:33.356904 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:16:33.356867 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:16:07.957287 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:16:07.957183 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:15:42.766297 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:15:42.766259 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:15:17.577235 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:15:17.577156 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:14:52.386454 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:14:52.386397 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:14:27.296250 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:14:27.296175 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:14:02.105899 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:14:02.105838 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:13:36.918226 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:13:36.918128 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:13:11.722625 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:13:11.722435 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:12:46.533116 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:12:46.533077 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:12:21.338227 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:12:21.338191 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:11:56.253117 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:11:56.253074 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:11:31.061468 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:11:31.061403 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:11:05.871320 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:11:05.871281 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:10:40.684819 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:10:40.684767 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:10:15.488345 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:10:15.488304 | fine | socket_io_client:engine.Socket | socket receive: type "ping", data "null" | 2025-09-12 23:09:52.404649 | severe | IsolateLogger | Error in runInIsolateGentle | Invalid argument(s): No host specified in URI /sync/stream | #0 _HttpClient._openUrl (dart:_http/http_impl.dart:3019) #1 _HttpClient.openUrl (dart:_http/http_impl.dart:2875) #2 IOClient.send (package:http/src/io_client.dart:117) #3 SyncApiRepository.streamChanges (package:immich_mobile/infrastructure/repositories/sync_api.repository.dart:77) #4 SyncStreamService.sync (package:immich_mobile/domain/services/sync_stream.service.dart:30) #5 runInIsolateGentle.. (package:immich_mobile/utils/isolate.dart:55) #6 runInIsolateGentle. (package:immich_mobile/utils/isolate.dart:34) #7 WorkerImpl._anotherIsolate. (package:worker_manager/src/worker/worker_io.dart:106) 2025-09-12 23:09:52.404448 | severe | SyncApiRepository | Error processing stream | Invalid argument(s): No host specified in URI /sync/stream | #0 _HttpClient._openUrl (dart:_http/http_impl.dart:3019) #1 _HttpClient.openUrl (dart:_http/http_impl.dart:2875) #2 IOClient.send (package:http/src/io_client.dart:117) #3 SyncApiRepository.streamChanges (package:immich_mobile/infrastructure/repositories/sync_api.repository.dart:77) #4 SyncStreamService.sync (package:immich_mobile/domain/services/sync_stream.service.dart:30) #5 runInIsolateGentle.. (package:immich_mobile/utils/isolate.dart:55) #6 runInIsolateGentle. (package:immich_mobile/utils/isolate.dart:34) #7 WorkerImpl._anotherIsolate. (package:worker_manager/src/worker/worker_io.dart:106) 2025-09-12 23:09:52.403667 | info | SyncStreamService | Remote sync request for user | 2025-09-12 23:09:50.462252 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_new_release",{"isAvailable":true,"checkedAt":"2025-09-12T19:38:31.489Z","serverVersion":{"major":1,"minor":141,"patch":1},"releaseVersion":{"major":1,"minor":142,"patch":0}}]" | 2025-09-12 23:09:50.461943 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "2["on_server_version",{"options":{},"loose":false,"includePrerelease":false,"raw":"1.141.1","major":1,"minor":141,"patch":1,"prerelease":[],"build":[],"version":"1.141.1"}]" | 2025-09-12 23:09:50.461460 | fine | socket_io_client:engine.Socket | socket receive: type "message", data "0{"sid":"xPiGvcw3gN2hzzYhAAAP"}" | 2025-09-12 23:09:50.394291 | fine | socket_io_client:engine.Socket | flushing 1 packets in socket | 2025-09-12 23:09:50.394274 | fine | socket_io:parser.Encoder | encoded {type: 0, data: null, nsp: /} as 0 | 2025-09-12 23:09:50.394225 | fine | socket_io:parser.Encoder | encoding packet {type: 0, data: null, nsp: /} | 2025-09-12 23:09:50.394206 | fine | socket_io_client:Manager | writing packet {type: 0, data: null, nsp: /} | 2025-09-12 23:09:50.394194 | fine | socket_io_client:Socket | transport is open - connecting | 2025-09-12 23:09:50.394138 | fine | socket_io_client:Manager | cleanup | 2025-09-12 23:09:50.394136 | fine | socket_io_client:Manager | open | 2025-09-12 23:09:50.394133 | fine | socket_io_client:engine.Socket | socket open | 2025-09-12 23:09:50.394110 | fine | socket_io_client:engine.Socket | socket receive: type "open", data "{"sid":"BXU9xLXyi6mzEzCrAAAO","upgrades":[],"pingInterval":25000,"pingTimeout":20000,"maxPayload":1000000}" | 2025-09-12 23:09:50.387977 | info | DeviceSyncService | Device sync took - 512ms |