2025-10-29 11:22:10.053842 | info | HashService | Hashing took - 3ms | 2025-10-29 11:22:10.049847 | info | HashService | Starting hashing of assets | 2025-10-29 11:22:08.037730 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:22:08.036749 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:22:06.637460 | info | DeviceSyncService | Device sync took - 7ms | 2025-10-29 11:22:06.631118 | info | SyncStreamService | Remote sync request for user | 2025-10-29 11:22:06.005856 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-29 11:21:37.947895 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:21:37.946892 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:21:36.688934 | info | SyncStreamService | Remote sync request for user | 2025-10-29 11:21:35.360311 | info | HashService | Hashing took - 4ms | 2025-10-29 11:21:35.355699 | info | HashService | Starting hashing of assets | 2025-10-29 11:21:33.345103 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:21:33.343854 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:21:31.953203 | info | DeviceSyncService | Device sync took - 34ms | 2025-10-29 11:21:31.918813 | info | SyncStreamService | Remote sync request for user | 2025-10-29 11:20:57.611449 | info | HashService | Hashing took - 4ms | 2025-10-29 11:20:57.607282 | info | HashService | Starting hashing of assets | 2025-10-29 11:20:55.596905 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:20:55.595577 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 11:20:53.454947 | info | DeviceSyncService | Device sync took - 79ms | 2025-10-29 11:20:53.375164 | info | SyncStreamService | Remote sync request for user | 2025-10-29 10:26:05.001902 | info | HashService | Hashing took - 4ms | 2025-10-29 10:26:04.997297 | info | HashService | Starting hashing of assets | 2025-10-29 10:26:02.982961 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:26:02.981470 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:26:01.329893 | info | DeviceSyncService | Device sync took - 18ms | 2025-10-29 10:26:01.311442 | info | SyncStreamService | Remote sync request for user | 2025-10-29 10:26:00.733787 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-29 10:22:06.005065 | info | HashService | Hashing took - 395546ms | 2025-10-29 10:18:19.901935 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:18:19.899029 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:18:17.731222 | info | SyncStreamService | Remote sync request for user | 2025-10-29 10:17:48.693519 | 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 _PreparingStatusState._startPollingIfNeeded. (package:immich_mobile/pages/backup/drift_backup.page.dart:427) 2025-10-29 10:17:47.057986 | warning | DriftBackupPage | Remote sync did not complete successfully, skipping backup | 2025-10-29 10:15:30.446424 | info | HashService | Starting hashing of assets | 2025-10-29 10:15:11.643086 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:15:11.643046 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:15:11.642970 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:15:10.100452 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:15:10.099382 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:15:08.726640 | info | SyncStreamService | Remote sync request for user | 2025-10-29 10:14:28.866911 | info | HashService | Hashing took - 0ms | 2025-10-29 10:14:28.866385 | info | HashService | Starting hashing of assets | 2025-10-29 10:14:26.852257 | severe | IsolateLogger | Error in runInIsolateGentle for remote-sync | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:14:26.850714 | severe | DriftSyncStreamRepository | Error: updateAssetFacesV1 | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787) Causing statement: INSERT INTO "asset_face_entity" ("id", "asset_id", "person_id", "image_width", "image_height", "bounding_box_x1", "bounding_box_y1", "bounding_box_x2", "bounding_box_y2", "source_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("id") DO UPDATE SET "asset_id" = ?, "person_id" = ?, "image_width" = ?, "image_height" = ?, "bounding_box_x1" = ?, "bounding_box_y1" = ?, "bounding_box_x2" = ?, "bounding_box_y2" = ?, "source_type" = ?, parameters: e6302c5a-38bc-480d-b0f6-8df7c05ba9d9, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning, 212cbd6f-9e5b-4f21-996f-64fe8e475752, 61bba906-023c-44bd-9727-521bc64cef9c, 1600, 1200, 108, 432, 205, 553, machine-learning | 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 556 SyncStreamRepository.updateAssetFacesV1 package:immich_mobile/domain/services/sync_stream.service.dart 67 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 58 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 105 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 57 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 36 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-29 10:14:17.890250 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:17.890198 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:17.890131 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:17.794676 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:17.769532 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:17.768885 | severe | ThumbnailWidget | Error loading image: Exception: Invalid image data | Exception: Invalid image data | #0 _futurize (dart:ui/painting.dart:7991) #1 ImageDescriptor.encoded (dart:ui/painting.dart:7785) #2 instantiateImageCodecWithSize (dart:ui/painting.dart:2558) #3 PaintingBinding.instantiateImageCodecWithSize (package:flutter/src/painting/binding.dart:147) #4 RemoteImageRequest._decodeBuffer (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:164) #5 RemoteImageRequest.load (package:immich_mobile/infrastructure/loaders/remote_image_request.dart:32) #6 CancellableImageProviderMixin.loadRequest (package:immich_mobile/presentation/widgets/images/image_provider.dart:59) #7 ImageStreamCompleter.setImage (package:flutter/src/painting/image_stream.dart:724) 2025-10-29 10:14:01.917781 | info | SyncStreamService | Remote sync request for user | 2025-10-29 10:13:59.891103 | info | DeviceSyncService | Device sync took - 3953ms | 2025-10-29 10:13:59.891071 | info | DeviceSyncService | Full device sync took - 3953ms | 2025-10-29 10:13:29.896828 | severe | ApiService | Error while checking server availability | ApiException 400: Socket operation failed: GET /server/ping (Inner exception: ClientException with SocketException: Connection failed (OS Error: No route to host, errno = 65), address = immich.koplon.duckdns.org, port = 443, uri=https://immich.koplon.duckdns.org/api/server/ping) #0 IOClient.send (package:http/src/io_client.dart:154) #1 BaseClient._sendUnstreamed (package:http/src/base_client.dart:93) #2 ApiClient.invokeAPI (package:openapi/api_client.dart:101) #3 ServerApi.pingServer (package:openapi/api/server_api.dart:595) #4 Future.timeout. (dart:async/future_impl.dart:1061) #5 ApiService._isEndpointAvailable (package:immich_mobile/services/api.service.dart:124) #6 ApiService.resolveEndpoint (package:immich_mobile/services/api.service.dart:109) #7 ApiService.resolveAndSetEndpoint (package:immich_mobile/services/api.service.dart:85) #8 AuthService.validateServerUrl (package:immich_mobile/services/auth.service.dart:59) #9 LoginForm.build.getServerAuthSettings (package:immich_mobile/widgets/forms/login/login_form.dart:98) | #0 ApiClient.invokeAPI (package:openapi/api_client.dart:104) #1 ServerApi.pingServer (package:openapi/api/server_api.dart:595) #2 Future.timeout. (dart:async/future_impl.dart:1061) #3 ApiService._isEndpointAvailable (package:immich_mobile/services/api.service.dart:124) #4 ApiService.resolveEndpoint (package:immich_mobile/services/api.service.dart:109) #5 ApiService.resolveAndSetEndpoint (package:immich_mobile/services/api.service.dart:85) #6 AuthService.validateServerUrl (package:immich_mobile/services/auth.service.dart:59) #7 LoginForm.build.getServerAuthSettings (package:immich_mobile/widgets/forms/login/login_form.dart:98) 2025-10-29 10:13:10.882111 | severe | SplashScreenPage | Missing crucial offline login info - Logging out completely |