2026-03-14 22:48:42.280302 | info     | AppLifeCycleNotifier | Using server URL: null |
2026-03-14 22:48:43.224113 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:48:43.223111 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:48:42.817538 | info     | DeviceSyncService    | Device sync took - 5ms |
2026-03-14 22:48:42.817481 | info     | DeviceSyncService    | Full device sync took - 5ms |
2026-03-14 22:48:42.812415 | info     | SyncStreamService    | Remote sync request for user |
2026-03-14 22:48:37.258308 | info     | HashService          | Hashing took - 0ms |
2026-03-14 22:48:37.257842 | info     | HashService          | Starting hashing of assets |
2026-03-14 22:48:35.253053 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:48:35.252175 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:48:34.835748 | info     | DeviceSyncService    | Device sync took - 5ms |
2026-03-14 22:48:34.835707 | info     | DeviceSyncService    | Full device sync took - 5ms |
2026-03-14 22:48:34.830556 | info     | SyncStreamService    | Remote sync request for user |
2026-03-14 22:48:34.272287 | info     | AppLifeCycleNotifier | Using server URL: null |
2026-03-14 22:47:52.709834 | info     | HashService          | Hashing took - 0ms |
2026-03-14 22:47:52.709611 | info     | HashService          | Starting hashing of assets |
2026-03-14 22:47:50.700491 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:50.699577 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:50.322653 | info     | DeviceSyncService    | Device sync took - 6ms |
2026-03-14 22:47:50.322586 | info     | DeviceSyncService    | Full device sync took - 6ms |
2026-03-14 22:47:50.315996 | info     | SyncStreamService    | Remote sync request for user |
2026-03-14 22:47:49.771961 | info     | AppLifeCycleNotifier | Using server URL: null |
2026-03-14 22:47:47.054361 | info     | HashService          | Hashing took - 0ms |
2026-03-14 22:47:47.054111 | info     | HashService          | Starting hashing of assets |
2026-03-14 22:47:45.046524 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:45.041975 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:44.593275 | info     | DeviceSyncService    | Device sync took - 5ms |
2026-03-14 22:47:44.593221 | info     | DeviceSyncService    | Full device sync took - 5ms |
2026-03-14 22:47:44.587744 | info     | SyncStreamService    | Remote sync request for user |
2026-03-14 22:47:44.032074 | info     | AppLifeCycleNotifier | Using server URL: null |
2026-03-14 22:47:34.608300 | info     | HashService          | Hashing took - 0ms |
2026-03-14 22:47:34.608069 | info     | HashService          | Starting hashing of assets |
2026-03-14 22:47:32.601197 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:32.596366 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:47:32.197983 | info     | DeviceSyncService    | Device sync took - 8ms |
2026-03-14 22:47:32.197897 | info     | DeviceSyncService    | Full device sync took - 8ms |
2026-03-14 22:47:32.188792 | info     | SyncStreamService    | Remote sync request for user |
2026-03-14 22:47:31.627188 | info     | AppLifeCycleNotifier | Using server URL: null |
2026-03-14 22:45:41.365957 | info     | HashService          | Hashing took - 0ms |
2026-03-14 22:45:41.365093 | info     | HashService          | Starting hashing of assets |
2026-03-14 22:45:39.348527 | 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 "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:45:39.347489 | severe   | DriftSyncStreamRepository | Error: updateAssetsExifV1 - user | SqliteException(787): while executing statement, FOREIGN KEY constraint failed, constraint failed (code 787)
  Causing statement: INSERT INTO "remote_exif_entity" ("asset_id", "city", "state", "country", "date_time_original", "description", "height", "width", "exposure_time", "f_number", "file_size", "focal_length", "latitude", "longitude", "iso", "make", "model", "lens", "orientation", "time_zone", "rating", "projection_type") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ON CONFLICT("asset_id") DO UPDATE SET "city" = ?, "state" = ?, "country" = ?, "date_time_original" = ?, "description" = ?, "height" = ?, "width" = ?, "exposure_time" = ?, "f_number" = ?, "file_size" = ?, "focal_length" = ?, "latitude" = ?, "longitude" = ?, "iso" = ?, "make" = ?, "model" = ?, "lens" = ?, "orientation" = ?, "time_zone" = ?, "rating" = ?, "projection_type" = ?, parameters: 8ba8ad33-d6c4-4ea0-af1a-b2ff6ba4460d, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, null, null, Hollange, Wallonia, Belgium, 2025-04-16T16:45:43.936Z, , 3000, 4000, 1/50, 1.7, 4844541, 6.3, 49.9080299722222, 5.693614, 640, samsung, Galaxy S23 Ultra, null, 6, UTC+2, 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.<fn>
dart:async/future.dart 315                                                         new Future.sync
package:drift/native.dart 373                                                      _NativeDelegate.runBatched
package:drift/src/runtime/executor/helpers/engines.dart 128                        _BaseExecutor.runBatched.<fn>
package:drift/src/runtime/executor/helpers/engines.dart 62                         _BaseExecutor._synchronized
package:drift/src/runtime/executor/helpers/engines.dart 122                        _BaseExecutor.runBatched
package:drift/src/remote/server_impl.dart 170                                      ServerImplementation._runBatched
package:drift/src/remote/communication.dart 165                                    DriftCommunication.setRequestHandler.<fn>
===== asynchronous gap ===========================
package:drift/src/remote/communication.dart 113                                    DriftCommunication.request
package:drift/src/remote/client_impl.dart 84                                       _BaseExecutor.runBatched
package:drift/src/runtime/api/batch.dart 215                                       Batch._runWith
package:drift/src/runtime/api/batch.dart 199                                       Batch._commit
package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 221  SyncStreamRepository.updateAssetsExifV1
package:immich_mobile/domain/services/sync_stream.service.dart 169                 SyncStreamService._processBatch
package:immich_mobile/domain/services/sync_stream.service.dart 150                 SyncStreamService._handleEvents
package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 115     SyncApiRepository.streamChanges
package:immich_mobile/domain/services/sync_stream.service.dart 85                  SyncStreamService.sync
package:immich_mobile/utils/isolate.dart 58                                        runInIsolateGentle.<fn>.<fn>
package:immich_mobile/utils/isolate.dart 37                                        runInIsolateGentle.<fn>
package:worker_manager/src/worker/worker_io.dart 106                               WorkerImpl._anotherIsolate.<fn>

2026-03-14 22:45:38.906504 | info     | DeviceSyncService    | Device sync took - 17ms |
2026-03-14 22:45:38.906390 | info     | DeviceSyncService    | Full device sync took - 17ms |
2026-03-14 22:45:38.891562 | info     | SyncStreamService    | Remote sync request for user |