2025-10-02 23:08:26.339284 | info | SyncApiRepository | Remote Sync completed in 11274ms | 2025-10-02 23:08:15.466985 | info | DeviceSyncService | Device sync took - 416ms | 2025-10-02 23:08:15.466943 | info | DeviceSyncService | Full device sync took - 416ms | 2025-10-02 23:08:15.062928 | info | SyncStreamService | Remote sync request for user | 2025-10-02 22:20:33.870496 | info | SyncApiRepository | Remote Sync completed in 176ms | 2025-10-02 22:20:33.695799 | info | DeviceSyncService | Device sync took - 6ms | 2025-10-02 22:20:33.693766 | info | SyncStreamService | Remote sync request for user | 2025-10-02 22:20:33.692923 | info | HashService | Hashing took - 0ms | 2025-10-02 22:20:33.692336 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 22:20:33.692166 | info | HashService | Starting hashing of assets | 2025-10-02 22:19:35.639794 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 22:19:35.616898 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:19:35.616893 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:19:35.615061 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:19:33.612650 | info | HashService | Hashing took - 0ms | 2025-10-02 22:19:33.612296 | info | HashService | Starting hashing of assets | 2025-10-02 22:19:33.589369 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:19:33.589359 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:19:33.586893 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:19:31.582986 | info | DeviceSyncService | Device sync took - 586ms | 2025-10-02 22:19:31.170457 | info | SyncApiRepository | Remote Sync completed in 173ms | 2025-10-02 22:19:30.996811 | info | SyncStreamService | Remote sync request for user | 2025-10-02 22:19:30.457592 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 22:17:36.186235 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 22:17:36.167752 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:17:36.167750 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:17:36.164829 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:17:34.162378 | info | HashService | Hashing took - 0ms | 2025-10-02 22:17:34.162066 | info | HashService | Starting hashing of assets | 2025-10-02 22:17:34.121649 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:17:34.121643 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:17:34.117281 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:17:32.113179 | info | SyncApiRepository | Remote Sync completed in 319ms | 2025-10-02 22:17:31.807118 | info | DeviceSyncService | Device sync took - 14ms | 2025-10-02 22:17:31.793051 | info | SyncStreamService | Remote sync request for user | 2025-10-02 22:17:31.242909 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 22:14:11.112506 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 22:14:11.088734 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:14:11.088729 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:14:11.087261 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:14:09.085066 | info | HashService | Hashing took - 104ms | 2025-10-02 22:14:08.980263 | info | HashService | Starting hashing of assets | 2025-10-02 22:14:08.953866 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:14:08.953862 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:14:08.951777 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:14:06.948457 | info | DeviceSyncService | Device sync took - 401ms | 2025-10-02 22:14:06.761226 | info | SyncApiRepository | Remote Sync completed in 213ms | 2025-10-02 22:14:06.547611 | info | SyncStreamService | Remote sync request for user | 2025-10-02 22:14:06.001760 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 22:10:17.547232 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 22:10:17.523833 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:10:17.523824 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:10:17.522076 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:10:15.555340 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 22:10:15.555336 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 22:10:15.518800 | info | HashService | Hashing took - 0ms | 2025-10-02 22:10:15.518430 | info | HashService | Starting hashing of assets | 2025-10-02 22:10:15.511467 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 22:10:13.492654 | info | SyncApiRepository | Remote Sync completed in 466ms | 2025-10-02 22:10:13.352222 | info | DeviceSyncService | Device sync took - 326ms | 2025-10-02 22:10:13.352179 | info | DeviceSyncService | Full device sync took - 326ms | 2025-10-02 22:10:13.025853 | info | SyncStreamService | Remote sync request for user | 2025-10-02 21:37:14.463638 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 21:37:12.454246 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-10-02 21:37:12.449528 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-10-02 21:37:10.059197 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 21:37:10.036968 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 21:37:10.036961 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 21:37:10.035087 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 21:37:08.032933 | info | HashService | Hashing took - 118ms | 2025-10-02 21:37:07.914197 | info | HashService | Starting hashing of assets | 2025-10-02 21:37:07.910953 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 21:37:07.910946 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 21:37:07.906023 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 21:37:05.902815 | info | DeviceSyncService | Device sync took - 391ms | 2025-10-02 21:37:05.672756 | info | SyncApiRepository | Remote Sync completed in 161ms | 2025-10-02 21:37:05.511524 | info | SyncStreamService | Remote sync request for user | 2025-10-02 21:37:04.948610 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 21:34:41.059907 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 21:34:41.038788 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 21:34:41.038782 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 21:34:41.036018 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 21:34:39.034602 | info | HashService | Hashing took - 568ms | 2025-10-02 21:34:38.486829 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 21:34:38.486818 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 21:34:38.465533 | info | HashService | Starting hashing of assets | 2025-10-02 21:34:38.437916 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 21:34:36.435693 | info | SyncApiRepository | Remote Sync completed in 412ms | 2025-10-02 21:34:36.393539 | info | DeviceSyncService | Device sync took - 370ms | 2025-10-02 21:34:36.393520 | info | DeviceSyncService | Full device sync took - 370ms | 2025-10-02 21:34:36.022666 | info | SyncStreamService | Remote sync request for user | 2025-10-02 21:34:24.985313 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 20:24:03.322446 | info | BackgroundWorkerBgService | Cleaning up background worker | 2025-10-02 20:24:03.322035 | warning | BackgroundWorkerBgService | Background worker cancelled | 2025-10-02 20:20:53.931867 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 20:20:53.931858 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 20:20:53.874765 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 20:20:51.870978 | info | DeviceSyncService | Device sync took - 4141ms | 2025-10-02 20:20:51.870878 | info | DeviceSyncService | Full device sync took - 4141ms | 2025-10-02 20:20:48.319642 | info | SyncApiRepository | Remote Sync completed in 589ms | 2025-10-02 20:20:47.730164 | info | SyncStreamService | Remote sync request for user | 2025-10-02 20:20:46.314135 | info | BackgroundWorkerBgService | iOS background upload started with maxSeconds: nulls | 2025-10-02 19:50:53.833603 | info | BackgroundWorkerBgService | Cleaning up background worker | 2025-10-02 19:50:53.833233 | info | BackgroundWorkerBgService | iOS background upload completed in 9s | 2025-10-02 19:50:52.896340 | info | DriftBackupNotifier | Tasks to resume: 1 | 2025-10-02 19:50:52.896268 | info | DriftBackupNotifier | Found 1 tasks | 2025-10-02 19:50:52.885812 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 19:50:51.906891 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 19:50:51.856674 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 19:50:51.856671 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 19:50:51.855109 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 19:50:50.750964 | info | HashService | Hashing took - 1ms | 2025-10-02 19:50:50.749874 | info | HashService | Starting hashing of assets | 2025-10-02 19:50:49.851454 | info | HashService | Hashing took - 415ms | 2025-10-02 19:50:49.478486 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 19:50:49.478479 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 19:50:49.435386 | info | HashService | Starting hashing of assets | 2025-10-02 19:50:49.421337 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 19:50:48.739321 | info | SyncApiRepository | Remote Sync completed in 166ms | 2025-10-02 19:50:48.572748 | info | SyncStreamService | Remote sync request for user | 2025-10-02 19:50:47.419160 | info | DeviceSyncService | Device sync took - 2033ms | 2025-10-02 19:50:47.419078 | info | DeviceSyncService | Full device sync took - 2033ms | 2025-10-02 19:50:46.561584 | info | DeviceSyncService | Device sync took - 2592ms | 2025-10-02 19:50:45.637987 | info | SyncApiRepository | Remote Sync completed in 249ms | 2025-10-02 19:50:45.388037 | info | SyncStreamService | Remote sync request for user | 2025-10-02 19:50:43.960840 | info | BackgroundWorkerBgService | iOS background upload started with maxSeconds: nulls | 2025-10-02 18:49:32.598424 | info | SyncApiRepository | Remote Sync completed in 192ms | 2025-10-02 18:49:32.412043 | info | DeviceSyncService | Device sync took - 6ms | 2025-10-02 18:49:32.405418 | info | SyncStreamService | Remote sync request for user | 2025-10-02 18:49:09.670092 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 18:49:09.647842 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 18:49:09.647835 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 18:49:09.643210 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 18:49:07.640266 | info | HashService | Hashing took - 623ms | 2025-10-02 18:49:07.017005 | info | HashService | Starting hashing of assets | 2025-10-02 18:49:07.013104 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 18:49:07.013098 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 18:49:07.010727 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 18:49:05.007510 | info | DeviceSyncService | Device sync took - 390ms | 2025-10-02 18:49:04.928833 | info | SyncApiRepository | Remote Sync completed in 311ms | 2025-10-02 18:49:04.617698 | info | SyncStreamService | Remote sync request for user | 2025-10-02 18:49:03.988111 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 18:41:14.501164 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 18:41:12.490551 | info | SyncStreamService | Successfully processed 7 assets in batch | 2025-10-02 18:41:12.482856 | info | SyncStreamService | Processing batch of 7 AssetUploadReadyV1 events | 2025-10-02 18:41:01.187711 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 18:40:59.127483 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-10-02 18:40:59.087494 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-10-02 18:40:54.706333 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 18:40:54.682970 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 18:40:54.682963 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 18:40:54.681805 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 18:40:52.679164 | info | HashService | Hashing took - 85ms | 2025-10-02 18:40:52.603380 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 18:40:52.603367 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 18:40:52.593443 | info | HashService | Starting hashing of assets | 2025-10-02 18:40:52.564945 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 18:40:50.562198 | info | SyncApiRepository | Remote Sync completed in 911ms | 2025-10-02 18:40:50.295542 | info | DeviceSyncService | Device sync took - 645ms | 2025-10-02 18:40:50.295505 | info | DeviceSyncService | Full device sync took - 645ms | 2025-10-02 18:40:49.650574 | info | SyncStreamService | Remote sync request for user | 2025-10-02 16:39:17.599750 | info | BackgroundWorkerBgService | Cleaning up background worker | 2025-10-02 16:39:17.599238 | warning | BackgroundWorkerBgService | Background worker cancelled | 2025-10-02 15:43:11.751977 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:43:09.672239 | info | SyncStreamService | Successfully processed 10 assets in batch | 2025-10-02 15:43:09.661260 | info | SyncStreamService | Processing batch of 10 AssetUploadReadyV1 events | 2025-10-02 15:42:58.235350 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:56.226716 | info | SyncStreamService | Successfully processed 8 assets in batch | 2025-10-02 15:42:56.221083 | info | SyncStreamService | Processing batch of 8 AssetUploadReadyV1 events | 2025-10-02 15:42:48.203189 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:46.193280 | info | SyncStreamService | Successfully processed 6 assets in batch | 2025-10-02 15:42:46.187251 | info | SyncStreamService | Processing batch of 6 AssetUploadReadyV1 events | 2025-10-02 15:42:37.877804 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:35.836434 | info | SyncStreamService | Successfully processed 9 assets in batch | 2025-10-02 15:42:35.740453 | info | SyncStreamService | Processing batch of 9 AssetUploadReadyV1 events | 2025-10-02 15:42:24.012128 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:21.928652 | info | SyncStreamService | Successfully processed 5 assets in batch | 2025-10-02 15:42:21.918135 | info | SyncStreamService | Processing batch of 5 AssetUploadReadyV1 events | 2025-10-02 15:42:13.911691 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:11.894938 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-10-02 15:42:11.890672 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-10-02 15:42:01.547184 | info | DriftBackupNotifier | Tasks to resume: 76 | 2025-10-02 15:42:01.547179 | info | DriftBackupNotifier | Found 76 tasks | 2025-10-02 15:42:01.546804 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:42:01.521870 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:42:00.691606 | info | SyncApiRepository | Remote Sync completed in 184ms | 2025-10-02 15:42:00.507031 | info | SyncStreamService | Remote sync request for user | 2025-10-02 15:41:59.549198 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 15:41:59.549192 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 15:41:59.519513 | info | HashService | Hashing took - 3ms | 2025-10-02 15:41:59.516400 | info | HashService | Starting hashing of assets | 2025-10-02 15:41:59.504961 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:41:57.502083 | info | SyncApiRepository | Remote Sync completed in 166ms | 2025-10-02 15:41:57.374407 | info | DeviceSyncService | Device sync took - 39ms | 2025-10-02 15:41:57.335477 | info | SyncStreamService | Remote sync request for user | 2025-10-02 15:40:41.744633 | info | HashService | Hashing took - 167ms | 2025-10-02 15:40:41.635888 | info | DriftBackupNotifier | Tasks to resume: 24 | 2025-10-02 15:40:41.635887 | info | DriftBackupNotifier | Found 24 tasks | 2025-10-02 15:40:41.635829 | info | DriftBackupNotifier | Tasks to resume: 24 | 2025-10-02 15:40:41.635821 | info | DriftBackupNotifier | Found 24 tasks | 2025-10-02 15:40:41.592950 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:40:41.576843 | info | HashService | Starting hashing of assets | 2025-10-02 15:40:41.561542 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:40:41.561508 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:40:39.556370 | info | DeviceSyncService | Device sync took - 1807ms | 2025-10-02 15:40:38.227793 | info | SyncApiRepository | Remote Sync completed in 478ms | 2025-10-02 15:40:37.748981 | info | SyncStreamService | Remote sync request for user | 2025-10-02 15:40:37.211955 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 15:38:20.782488 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:38:18.611088 | info | SyncStreamService | Successfully processed 2 assets in batch | 2025-10-02 15:38:18.603365 | info | SyncStreamService | Processing batch of 2 AssetUploadReadyV1 events | 2025-10-02 15:38:14.701118 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:38:12.561735 | info | SyncStreamService | Successfully processed 6 assets in batch | 2025-10-02 15:38:12.548707 | info | SyncStreamService | Processing batch of 6 AssetUploadReadyV1 events | 2025-10-02 15:38:04.097604 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:38:01.966888 | info | SyncStreamService | Successfully processed 1 assets in batch | 2025-10-02 15:38:01.964121 | info | SyncStreamService | Processing batch of 1 AssetUploadReadyV1 events | 2025-10-02 15:37:30.399176 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:37:30.397804 | info | DriftBackupNotifier | Tasks to resume: 8 | 2025-10-02 15:37:30.397800 | info | DriftBackupNotifier | Found 8 tasks | 2025-10-02 15:37:30.393428 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:37:28.388890 | info | HashService | Hashing took - 79949ms | 2025-10-02 15:37:27.721248 | 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: 0a6c2ed5-9b52-48a7-8fe3-cc924bff1cf3, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null | package:sqlite3/src/implementation/exception.dart 87 throwException package:sqlite3/src/implementation/statement.dart 109 StatementImplementation._execute package:sqlite3/src/implementation/statement.dart 289 StatementImplementation.executeWith package:sqlite3/src/statement.dart 81 CommonPreparedStatement.execute package:drift/src/sqlite3/database.dart 131 Sqlite3Delegate.runBatchSync package:drift/native.dart 373 _NativeDelegate.runBatched. dart:async/future.dart 315 new Future.sync package:drift/native.dart 373 _NativeDelegate.runBatched package:drift/src/runtime/executor/helpers/engines.dart 128 _BaseExecutor.runBatched. package:drift/src/runtime/executor/helpers/engines.dart 62 _BaseExecutor._synchronized package:drift/src/runtime/executor/helpers/engines.dart 122 _BaseExecutor.runBatched package:drift/src/remote/server_impl.dart 170 ServerImplementation._runBatched package:drift/src/remote/communication.dart 165 DriftCommunication.setRequestHandler. ===== asynchronous gap =========================== package:drift/src/remote/communication.dart 113 DriftCommunication.request package:drift/src/remote/client_impl.dart 84 _BaseExecutor.runBatched package:drift/src/runtime/api/batch.dart 215 Batch._runWith package:drift/src/runtime/api/batch.dart 199 Batch._commit package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 213 SyncStreamRepository.updateAssetsExifV1 package:immich_mobile/domain/services/sync_stream.service.dart 66 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 47 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 110 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 56 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 35 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-02 15:37:27.721132 | severe | SyncApiRepository | Error processing stream | 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: 0a6c2ed5-9b52-48a7-8fe3-cc924bff1cf3, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null | package:sqlite3/src/implementation/exception.dart 87 throwException package:sqlite3/src/implementation/statement.dart 109 StatementImplementation._execute package:sqlite3/src/implementation/statement.dart 289 StatementImplementation.executeWith package:sqlite3/src/statement.dart 81 CommonPreparedStatement.execute package:drift/src/sqlite3/database.dart 131 Sqlite3Delegate.runBatchSync package:drift/native.dart 373 _NativeDelegate.runBatched. dart:async/future.dart 315 new Future.sync package:drift/native.dart 373 _NativeDelegate.runBatched package:drift/src/runtime/executor/helpers/engines.dart 128 _BaseExecutor.runBatched. package:drift/src/runtime/executor/helpers/engines.dart 62 _BaseExecutor._synchronized package:drift/src/runtime/executor/helpers/engines.dart 122 _BaseExecutor.runBatched package:drift/src/remote/server_impl.dart 170 ServerImplementation._runBatched package:drift/src/remote/communication.dart 165 DriftCommunication.setRequestHandler. ===== asynchronous gap =========================== package:drift/src/remote/communication.dart 113 DriftCommunication.request package:drift/src/remote/client_impl.dart 84 _BaseExecutor.runBatched package:drift/src/runtime/api/batch.dart 215 Batch._runWith package:drift/src/runtime/api/batch.dart 199 Batch._commit package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 213 SyncStreamRepository.updateAssetsExifV1 package:immich_mobile/domain/services/sync_stream.service.dart 66 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 47 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 110 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 56 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 35 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-02 15:37:27.720302 | 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: 0a6c2ed5-9b52-48a7-8fe3-cc924bff1cf3, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null, Pātan, Bagmati Province, Nepal, 2025-10-02T09:04:40.712Z, , 4284, 5712, 1/50, 1.8, 2863242, 6.764999866, 27.6484027777778, 85.3486944444444, 250, Apple, iPhone 16 Pro, iPhone 16 Pro back triple camera 6.765mm f/1.78, 1, UTC+5:45, null, null | package:sqlite3/src/implementation/exception.dart 87 throwException package:sqlite3/src/implementation/statement.dart 109 StatementImplementation._execute package:sqlite3/src/implementation/statement.dart 289 StatementImplementation.executeWith package:sqlite3/src/statement.dart 81 CommonPreparedStatement.execute package:drift/src/sqlite3/database.dart 131 Sqlite3Delegate.runBatchSync package:drift/native.dart 373 _NativeDelegate.runBatched. dart:async/future.dart 315 new Future.sync package:drift/native.dart 373 _NativeDelegate.runBatched package:drift/src/runtime/executor/helpers/engines.dart 128 _BaseExecutor.runBatched. package:drift/src/runtime/executor/helpers/engines.dart 62 _BaseExecutor._synchronized package:drift/src/runtime/executor/helpers/engines.dart 122 _BaseExecutor.runBatched package:drift/src/remote/server_impl.dart 170 ServerImplementation._runBatched package:drift/src/remote/communication.dart 165 DriftCommunication.setRequestHandler. ===== asynchronous gap =========================== package:drift/src/remote/communication.dart 113 DriftCommunication.request package:drift/src/remote/client_impl.dart 84 _BaseExecutor.runBatched package:drift/src/runtime/api/batch.dart 215 Batch._runWith package:drift/src/runtime/api/batch.dart 199 Batch._commit package:immich_mobile/infrastructure/repositories/sync_stream.repository.dart 213 SyncStreamRepository.updateAssetsExifV1 package:immich_mobile/domain/services/sync_stream.service.dart 66 SyncStreamService._processBatch package:immich_mobile/domain/services/sync_stream.service.dart 47 SyncStreamService._handleEvents package:immich_mobile/infrastructure/repositories/sync_api.repository.dart 110 SyncApiRepository.streamChanges package:immich_mobile/domain/services/sync_stream.service.dart 30 SyncStreamService.sync package:immich_mobile/utils/isolate.dart 56 runInIsolateGentle.. package:immich_mobile/utils/isolate.dart 35 runInIsolateGentle. package:worker_manager/src/worker/worker_io.dart 106 WorkerImpl._anotherIsolate. 2025-10-02 15:37:26.500746 | info | SyncStreamService | Remote sync request for user | 2025-10-02 15:37:15.550854 | info | SyncApiRepository | Remote Sync completed in 2073ms | 2025-10-02 15:37:14.051620 | info | DeviceSyncService | Device sync took - 573ms | 2025-10-02 15:37:13.477839 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 15:37:13.477405 | info | SyncStreamService | Remote sync request for user | 2025-10-02 15:37:13.439963 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 15:37:13.439960 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 15:37:13.439668 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 15:37:13.439664 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 15:37:13.432684 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:37:13.432641 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:37:12.203906 | info | AppLifeCycleNotifier | Using server URL: null | 2025-10-02 15:36:08.468870 | info | DriftBackupNotifier | Start a new backup queue | 2025-10-02 15:36:08.468863 | info | DriftBackupNotifier | Found 0 tasks | 2025-10-02 15:36:08.439177 | info | HashService | Starting hashing of assets | 2025-10-02 15:36:08.422879 | info | DriftBackupNotifier | Resuming backup tasks... | 2025-10-02 15:36:06.420069 | info | DeviceSyncService | Device sync took - 1954ms | 2025-10-02 15:36:05.137848 | info | SyncApiRepository | Remote Sync completed in 671ms | 2025-10-02 15:36:04.465910 | info | SyncStreamService | Remote sync request for user | 2025-10-02 13:48:40.675959 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 13:48:38.665633 | info | SyncStreamService | Successfully processed 2 assets in batch | 2025-10-02 13:48:38.660222 | info | SyncStreamService | Processing batch of 2 AssetUploadReadyV1 events | 2025-10-02 13:48:34.626620 | warning | SyncLinkedAlbumService | No linked remote album ID found for local album: Recents | 2025-10-02 13:48:32.617285 | info | SyncStreamService | Successfully processed 10 assets in batch | 2025-10-02 13:48:32.532985 | info | SyncStreamService | Processing batch of 10 AssetUploadReadyV1 events |