"Operation was cancelled" error about drift

[simolus3]

Can you try to use an explicit drift isolate and pass isolateDebugLog: true to connect()? Having those logs would be very useful to narrow this down.

The QueryStream.fetchAndEmitData in the stack trace seems suspicious, is it possible that there is a stream query being listened to at that point?

[paldepind]

Thanks a lot for the response. I really appreciate it.

The QueryStream.fetchAndEmitData in the stack trace seems suspicious, is it possible that there is a stream query being listened to at that point?

My app uses stream queries that execute when the app is opened. But I'm surprised if they seem to be running concurrently with the code in beforeOpen as I would expect that to run before any queries.

Can you try to use an explicit drift isolate and pass isolateDebugLog: true to connect()? Having those logs would be very useful to narrow this down.

I tried to do that. It made the error go away and all the deletes went through immediately. Below are the changes that I made to my code, based on the docs that you linked to. Of course it's nice that the deletes no go through, but still, I would have expected the original code to work as well.

 class MyDatabase extends _$MyDatabase {
-  MyDatabase() : super(_openConnection());
+  MyDatabase([QueryExecutor? executor]) : super(executor ?? _openConnection());

-  var db = MyDatabase();
+  final db = MyDatabase(
+    DatabaseConnection.delayed(Future.sync(() async {
+      final isolate = await createIsolateWithSpawn();
+      return isolate.connect(singleClientMode: true, isolateDebugLog: true);
+    })),
+  );

+Future<DriftIsolate> createIsolateWithSpawn() async {
+  final token = RootIsolateToken.instance!;
+  return await DriftIsolate.spawn(() {
+    BackgroundIsolateBinaryMessenger.ensureInitialized(token);

+    return LazyDatabase(() async {
+      final dbFolder = await getApplicationDocumentsDirectory();
+      final file = File(p.join(dbFolder.path, 'my-app-database.sqlite'));
+      return NativeDatabase(file);
+    });
+  });
+}

Here is the log output I got after isolateDebugLog: true. But since the error did not occur with this I suspect that the log is not terribly useful.

Log Output

``` Restarted application in 2,991ms. flutter: [IN]: Request (id = 0): ServerInfo(SqlDialect.sqlite) flutter: [OUT]: SuccessResponse (id = 0): null flutter: [OUT]: Request (id = 0): EnsureOpen(1, null) flutter: [IN]: Request (id = 1): RunBeforeOpen(Instance of 'OpeningDetails', 0) flutter: [OUT]: Request (id = 1): EnsureOpen(1, 0) flutter: [IN]: SuccessResponse (id = 1): true flutter: [OUT]: Request (id = 2): StatementMethod.select: PRAGMA foreign_key_check with [] (@0) flutter: [IN]: SuccessResponse (id = 2): Instance of 'SelectResult' flutter: {table: sessions_tags, rowid: 5628, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 3): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5628] (@0) flutter: [IN]: SuccessResponse (id = 3): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5629, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 4): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5629] (@0) flutter: [IN]: SuccessResponse (id = 4): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5630, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 5): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5630] (@0) flutter: [IN]: SuccessResponse (id = 5): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5631, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 6): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5631] (@0) flutter: [IN]: SuccessResponse (id = 6): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5632, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 7): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5632] (@0) flutter: [IN]: SuccessResponse (id = 7): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5633, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 8): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5633] (@0) flutter: [IN]: SuccessResponse (id = 8): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5634, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 9): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5634] (@0) flutter: [IN]: SuccessResponse (id = 9): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5635, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 10): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5635] (@0) flutter: [IN]: SuccessResponse (id = 10): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5636, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 11): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5636] (@0) flutter: [IN]: SuccessResponse (id = 11): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5637, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 12): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5637] (@0) flutter: [IN]: SuccessResponse (id = 12): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5638, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 13): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5638] (@0) flutter: [IN]: SuccessResponse (id = 13): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5639, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 14): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5639] (@0) flutter: [IN]: SuccessResponse (id = 14): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5640, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 15): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5640] (@0) flutter: [IN]: SuccessResponse (id = 15): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5641, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 16): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5641] (@0) flutter: [IN]: SuccessResponse (id = 16): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5642, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 17): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5642] (@0) flutter: [IN]: SuccessResponse (id = 17): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5643, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 18): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5643] (@0) flutter: [IN]: SuccessResponse (id = 18): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5644, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 19): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5644] (@0) flutter: [IN]: SuccessResponse (id = 19): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5645, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 20): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5645] (@0) flutter: [IN]: SuccessResponse (id = 20): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5646, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 21): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5646] (@0) flutter: [IN]: SuccessResponse (id = 21): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5647, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 22): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5647] (@0) flutter: [IN]: SuccessResponse (id = 22): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5648, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 23): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5648] (@0) flutter: [IN]: SuccessResponse (id = 23): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5649, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 24): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5649] (@0) flutter: [IN]: SuccessResponse (id = 24): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5650, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 25): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5650] (@0) flutter: [IN]: SuccessResponse (id = 25): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5651, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 26): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5651] (@0) flutter: [IN]: SuccessResponse (id = 26): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5652, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 27): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5652] (@0) flutter: [IN]: SuccessResponse (id = 27): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5653, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 28): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5653] (@0) flutter: [IN]: SuccessResponse (id = 28): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5654, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 29): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5654] (@0) flutter: [IN]: SuccessResponse (id = 29): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5655, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 30): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5655] (@0) flutter: [IN]: SuccessResponse (id = 30): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5656, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 31): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5656] (@0) flutter: [IN]: SuccessResponse (id = 31): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5657, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 32): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5657] (@0) flutter: [IN]: SuccessResponse (id = 32): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5658, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 33): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5658] (@0) flutter: [IN]: SuccessResponse (id = 33): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5659, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 34): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5659] (@0) flutter: [IN]: SuccessResponse (id = 34): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5660, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 35): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5660] (@0) flutter: [IN]: SuccessResponse (id = 35): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5661, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 36): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5661] (@0) flutter: [IN]: SuccessResponse (id = 36): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5664, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 37): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5664] (@0) flutter: [IN]: SuccessResponse (id = 37): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5665, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 38): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5665] (@0) flutter: [IN]: SuccessResponse (id = 38): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5666, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 39): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5666] (@0) flutter: [IN]: SuccessResponse (id = 39): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5667, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 40): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5667] (@0) flutter: [IN]: SuccessResponse (id = 40): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5668, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 41): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5668] (@0) flutter: [IN]: SuccessResponse (id = 41): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5669, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 42): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5669] (@0) flutter: [IN]: SuccessResponse (id = 42): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5670, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 43): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5670] (@0) flutter: [IN]: SuccessResponse (id = 43): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5671, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 44): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5671] (@0) flutter: [IN]: SuccessResponse (id = 44): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5672, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 45): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5672] (@0) flutter: [IN]: SuccessResponse (id = 45): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5673, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 46): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5673] (@0) flutter: [IN]: SuccessResponse (id = 46): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5674, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 47): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5674] (@0) flutter: [IN]: SuccessResponse (id = 47): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5675, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 48): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5675] (@0) flutter: [IN]: SuccessResponse (id = 48): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5676, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 49): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5676] (@0) flutter: [IN]: SuccessResponse (id = 49): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5677, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 50): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5677] (@0) flutter: [IN]: SuccessResponse (id = 50): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5678, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 51): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5678] (@0) flutter: [IN]: SuccessResponse (id = 51): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5679, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 52): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5679] (@0) flutter: [IN]: SuccessResponse (id = 52): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5680, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 53): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5680] (@0) flutter: [IN]: SuccessResponse (id = 53): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5681, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 54): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5681] (@0) flutter: [IN]: SuccessResponse (id = 54): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5682, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 55): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5682] (@0) flutter: [IN]: SuccessResponse (id = 55): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5683, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 56): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5683] (@0) flutter: [IN]: SuccessResponse (id = 56): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5684, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 57): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5684] (@0) flutter: [IN]: SuccessResponse (id = 57): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5685, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 58): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5685] (@0) flutter: [IN]: SuccessResponse (id = 58): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5686, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 59): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5686] (@0) flutter: [IN]: SuccessResponse (id = 59): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5687, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 60): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5687] (@0) flutter: [IN]: SuccessResponse (id = 60): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5688, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 61): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5688] (@0) flutter: [IN]: SuccessResponse (id = 61): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5689, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 62): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5689] (@0) flutter: [IN]: SuccessResponse (id = 62): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5690, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 63): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5690] (@0) flutter: [IN]: SuccessResponse (id = 63): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5691, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 64): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5691] (@0) flutter: [IN]: SuccessResponse (id = 64): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5692, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 65): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5692] (@0) flutter: [IN]: SuccessResponse (id = 65): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5693, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 66): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5693] (@0) flutter: [IN]: SuccessResponse (id = 66): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5694, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 67): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5694] (@0) flutter: [IN]: SuccessResponse (id = 67): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5695, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 68): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5695] (@0) flutter: [IN]: SuccessResponse (id = 68): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5696, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 69): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5696] (@0) flutter: [IN]: SuccessResponse (id = 69): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5697, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 70): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5697] (@0) flutter: [IN]: SuccessResponse (id = 70): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5698, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 71): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5698] (@0) flutter: [IN]: SuccessResponse (id = 71): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5699, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 72): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5699] (@0) flutter: [IN]: SuccessResponse (id = 72): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5700, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 73): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5700] (@0) flutter: [IN]: SuccessResponse (id = 73): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5701, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 74): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5701] (@0) flutter: [IN]: SuccessResponse (id = 74): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5702, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 75): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5702] (@0) flutter: [IN]: SuccessResponse (id = 75): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5703, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 76): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5703] (@0) flutter: [IN]: SuccessResponse (id = 76): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5704, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 77): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5704] (@0) flutter: [IN]: SuccessResponse (id = 77): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5705, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 78): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5705] (@0) flutter: [IN]: SuccessResponse (id = 78): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5706, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 79): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5706] (@0) flutter: [IN]: SuccessResponse (id = 79): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5707, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 80): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5707] (@0) flutter: [IN]: SuccessResponse (id = 80): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5708, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 81): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5708] (@0) flutter: [IN]: SuccessResponse (id = 81): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5709, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 82): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5709] (@0) flutter: [IN]: SuccessResponse (id = 82): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5710, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 83): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5710] (@0) flutter: [IN]: SuccessResponse (id = 83): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5711, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 84): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5711] (@0) flutter: [IN]: SuccessResponse (id = 84): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5712, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 85): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5712] (@0) flutter: [IN]: SuccessResponse (id = 85): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5713, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 86): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5713] (@0) flutter: [IN]: SuccessResponse (id = 86): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5714, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 87): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5714] (@0) flutter: [IN]: SuccessResponse (id = 87): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5715, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 88): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5715] (@0) flutter: [IN]: SuccessResponse (id = 88): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5716, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 89): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5716] (@0) flutter: [IN]: SuccessResponse (id = 89): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5717, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 90): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5717] (@0) flutter: [IN]: SuccessResponse (id = 90): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5718, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 91): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5718] (@0) flutter: [IN]: SuccessResponse (id = 91): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5719, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 92): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5719] (@0) flutter: [IN]: SuccessResponse (id = 92): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5720, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 93): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5720] (@0) flutter: [IN]: SuccessResponse (id = 93): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5721, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 94): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5721] (@0) flutter: [IN]: SuccessResponse (id = 94): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5722, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 95): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5722] (@0) flutter: [IN]: SuccessResponse (id = 95): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5723, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 96): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5723] (@0) flutter: [IN]: SuccessResponse (id = 96): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5724, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 97): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5724] (@0) flutter: [IN]: SuccessResponse (id = 97): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5725, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 98): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5725] (@0) flutter: [IN]: SuccessResponse (id = 98): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5726, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 99): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5726] (@0) flutter: [IN]: SuccessResponse (id = 99): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5727, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 100): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5727] (@0) flutter: [IN]: SuccessResponse (id = 100): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5728, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 101): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5728] (@0) flutter: [IN]: SuccessResponse (id = 101): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5729, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 102): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5729] (@0) flutter: [IN]: SuccessResponse (id = 102): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5730, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 103): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5730] (@0) flutter: [IN]: SuccessResponse (id = 103): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5731, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 104): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5731] (@0) flutter: [IN]: SuccessResponse (id = 104): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5732, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 105): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5732] (@0) flutter: [IN]: SuccessResponse (id = 105): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5733, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 106): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5733] (@0) flutter: [IN]: SuccessResponse (id = 106): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5734, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 107): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5734] (@0) flutter: [IN]: SuccessResponse (id = 107): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5735, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 108): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5735] (@0) flutter: [IN]: SuccessResponse (id = 108): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5736, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 109): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5736] (@0) flutter: [IN]: SuccessResponse (id = 109): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5737, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 110): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5737] (@0) flutter: [IN]: SuccessResponse (id = 110): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5738, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 111): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5738] (@0) flutter: [IN]: SuccessResponse (id = 111): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5739, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 112): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5739] (@0) flutter: [IN]: SuccessResponse (id = 112): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5740, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 113): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5740] (@0) flutter: [IN]: SuccessResponse (id = 113): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5741, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 114): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5741] (@0) flutter: [IN]: SuccessResponse (id = 114): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5742, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 115): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5742] (@0) flutter: [IN]: SuccessResponse (id = 115): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5743, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 116): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5743] (@0) flutter: [IN]: SuccessResponse (id = 116): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5744, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 117): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5744] (@0) flutter: [IN]: SuccessResponse (id = 117): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5745, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 118): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5745] (@0) flutter: [IN]: SuccessResponse (id = 118): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5746, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 119): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5746] (@0) flutter: [IN]: SuccessResponse (id = 119): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5747, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 120): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5747] (@0) flutter: [IN]: SuccessResponse (id = 120): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5748, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 121): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5748] (@0) flutter: [IN]: SuccessResponse (id = 121): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5749, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 122): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5749] (@0) flutter: [IN]: SuccessResponse (id = 122): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5750, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 123): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5750] (@0) flutter: [IN]: SuccessResponse (id = 123): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5751, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 124): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5751] (@0) flutter: [IN]: SuccessResponse (id = 124): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5752, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 125): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5752] (@0) flutter: [IN]: SuccessResponse (id = 125): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5753, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 126): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5753] (@0) flutter: [IN]: SuccessResponse (id = 126): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5754, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 127): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5754] (@0) flutter: [IN]: SuccessResponse (id = 127): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5755, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 128): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5755] (@0) flutter: [IN]: SuccessResponse (id = 128): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5756, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 129): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5756] (@0) flutter: [IN]: SuccessResponse (id = 129): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5757, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 130): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5757] (@0) flutter: [IN]: SuccessResponse (id = 130): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5758, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 131): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5758] (@0) flutter: [IN]: SuccessResponse (id = 131): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5759, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 132): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5759] (@0) flutter: [IN]: SuccessResponse (id = 132): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5760, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 133): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5760] (@0) flutter: [IN]: SuccessResponse (id = 133): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5761, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 134): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5761] (@0) flutter: [IN]: SuccessResponse (id = 134): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5762, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 135): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5762] (@0) flutter: [IN]: SuccessResponse (id = 135): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5763, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 136): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5763] (@0) flutter: [IN]: SuccessResponse (id = 136): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5764, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 137): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5764] (@0) flutter: [IN]: SuccessResponse (id = 137): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5765, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 138): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5765] (@0) flutter: [IN]: SuccessResponse (id = 138): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5766, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 139): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5766] (@0) flutter: [IN]: SuccessResponse (id = 139): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5767, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 140): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5767] (@0) flutter: [IN]: SuccessResponse (id = 140): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5768, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 141): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5768] (@0) flutter: [IN]: SuccessResponse (id = 141): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5769, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 142): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5769] (@0) flutter: [IN]: SuccessResponse (id = 142): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5770, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 143): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5770] (@0) flutter: [IN]: SuccessResponse (id = 143): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5771, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 144): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5771] (@0) flutter: [IN]: SuccessResponse (id = 144): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5772, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 145): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5772] (@0) flutter: [IN]: SuccessResponse (id = 145): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5773, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 146): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5773] (@0) flutter: [IN]: SuccessResponse (id = 146): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5774, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 147): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5774] (@0) flutter: [IN]: SuccessResponse (id = 147): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5775, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 148): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5775] (@0) flutter: [IN]: SuccessResponse (id = 148): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5776, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 149): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5776] (@0) flutter: [IN]: SuccessResponse (id = 149): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5777, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 150): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5777] (@0) flutter: [IN]: SuccessResponse (id = 150): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5778, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 151): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5778] (@0) flutter: [IN]: SuccessResponse (id = 151): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5779, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 152): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5779] (@0) flutter: [IN]: SuccessResponse (id = 152): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5780, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 153): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5780] (@0) flutter: [IN]: SuccessResponse (id = 153): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5781, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 154): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5781] (@0) flutter: [IN]: SuccessResponse (id = 154): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5782, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 155): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5782] (@0) flutter: [IN]: SuccessResponse (id = 155): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5783, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 156): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5783] (@0) flutter: [IN]: SuccessResponse (id = 156): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5784, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 157): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5784] (@0) flutter: [IN]: SuccessResponse (id = 157): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5785, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 158): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5785] (@0) flutter: [IN]: SuccessResponse (id = 158): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5791, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 159): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5791] (@0) flutter: [IN]: SuccessResponse (id = 159): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5792, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 160): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5792] (@0) flutter: [IN]: SuccessResponse (id = 160): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5793, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 161): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5793] (@0) flutter: [IN]: SuccessResponse (id = 161): 1 flutter: Cleaned up violation (1) flutter: {table: sessions_tags, rowid: 5794, parent: sessions, fkid: 0} flutter: [OUT]: Request (id = 162): StatementMethod.deleteOrUpdate: DELETE FROM "sessions_tags" WHERE "_rowid_" = ?; with [5794] (@0) flutter: [IN]: SuccessResponse (id = 162): 1 flutter: Cleaned up violation (1) flutter: [OUT]: Request (id = 163): StatementMethod.custom: PRAGMA foreign_keys = ON with [] (@0) flutter: [IN]: SuccessResponse (id = 163): null flutter: [OUT]: SuccessResponse (id = 1): null flutter: [IN]: SuccessResponse (id = 0): true flutter: [OUT]: Request (id = 164): StatementMethod.select: SELECT * FROM "sessions" WHERE "duration" IS NULL; with [] flutter: [OUT]: Request (id = 165): StatementMethod.select: SELECT * FROM "tags"; with [] flutter: [OUT]: Request (id = 166): StatementMethod.select: SELECT "sessions"."created_at" AS "sessions.created_at", "sessions"."changed_at" AS "sessions.changed_at", "sessions"."synced_at" AS "sessions.synced_at", "sessions"."id" AS "sessions.id", "sessions"."goal_duration" AS "sessions.goal_duration", "ses flutter: sions"."started_at" AS "sessions.started_at", "sessions"."ended_at" AS "sessions.ended_at", "sessions"."utc_offset" AS "sessions.utc_offset", "sessions"."duration" AS "sessions.duration", "sessions"."pause_segments" AS "sessions.pause_segments", "sessions_tags"."tag_id" AS "sessions_tags.tag_id", "s flutter: essions_tags"."session_id" AS "sessions_tags.session_id" FROM "sessions" LEFT OUTER JOIN "sessions_tags" ON "sessions_tags"."session_id" = "sessions"."id" WHERE "sessions"."started_at" >= ? ORDER BY "sessions"."started_at" DESC; with [1701039600] flutter: [IN]: SuccessResponse (id = 164): Instance of 'SelectResult' flutter: [IN]: SuccessResponse (id = 165): Instance of 'SelectResult' flutter: [IN]: SuccessResponse (id = 166): Instance of 'SelectResult' ```

[simolus3]

Thanks for providing the details! But the log output looks just like what I would expect it to look like, nothing stands out unfortunately.

I would have expected the original code to work as well.

Yeah, me too. And _openConnection() has just been using path provider + NativeDatabase.createInBackground before or has there been some custom setup in there?

[paldepind]

Yes, my _openConnection is very normal I think:

LazyDatabase _openConnection() {
  // the LazyDatabase util lets us find the right location for the file async.
  return LazyDatabase(() async {
    // put the database file, called db.sqlite here, into the documents folder
    // for your app.
    final dbFolder = await getApplicationDocumentsDirectory();
    final file = File(p.join(dbFolder.path, 'deep-time-database.sqlite'));
    return NativeDatabase.createInBackground(file);
  });
}

Based on your comment above I removed a stream query that is initiated on the first page of my app. With this query removed all the deletes (the original code without explicit isolate creation) go through without errors. So it seems to be related to the stream query running in parallel with the code in beforeOpen. Is guess this should not happen as queries should wait till the beforeOpen is done?

[simolus3]

I think I'm beginning to form a theory for this, but I couldn't reproduce this yet.

Is guess this should not happen as queries should wait till the beforeOpen is done?

Definitely! Stream queries have a mechanism to cancel pending work it goes stale or if there aren't any subscriptions left. I wonder if this could have happened because listening to the stream is what caused the database to be opened, but then the subscription got cancelled before the database is fully open. That still shouldn't interfere with other statements though.

If you bring the stream query back, but do this immediately after constructing your database, does the error still happen?

var db = MyDatabase();
db.customSelect('select 1').get();

You don't even need to await that, it would just be interesting to know what happens when that runs before the stream is listened to.

[paldepind]

Hi again. Sorry for the delayed response, I somehow missed your reply.

If you bring the stream query back, but do this immediately after constructing your database, does the error still happen?

No, that fixes the error! With db.customSelect('select 1').get(); right after construction of MyDatabase everything works flawlessly and if I remove it again the error returns.