Release mode getting issue

[Okdone]

Hey team,
We have checkout your tags and testing with release mode and debug mode with 0.2.1_alpha+6, 0.2.1_alpha+4, 0.2.1_alpha+3 and run with release mode but in all these branch getting issue on release mode.

Issue (log):
I/flutter (23069): (2020-05-30 11:47:47.952083) ℹ️ RETRY QUEUE messaging:!members-CMejYZeK0zXGsUZ88VX0boqoicKpoQhWYJvGRRFNCpE add 0 messages E/flutter (23069): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (23069): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (23069): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (23069): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (23069): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (23069): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (23069): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (23069): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (23069): <asynchronous suspension> E/flutter (23069): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (23069): <asynchronous suspension>

[imtoori]

it's probably linked to this
simolus3/drift#581
I'll keep you updated

[imtoori]

can you try the last version? I downgraded the dependency

[Okdone]

We have tested with 0.2.1-alpha+7, but still issue is not solved.

[Okdone]

This issue also not solved in 0.2.1-alpha+8.

[imtoori]

hey, I'm looking into this right now, but I don't have this problem
are you using android?

[Okdone]

Yes, Are you testing with release mode?

[imtoori]

yes, with a real device
flutter run --release

[Okdone]

Please give me step for you generate release build because we have getting issue on database in release build, if it's possible then send your android release build so we can test

[imtoori]

can I ask you if that the full stacktrace?
if not, could you send the a longer one?

[Okdone]

The full stacktrace.

I/flutter (16987): (2020-06-10 15:52:34.411259) ℹ️ 🔌 connecting to wss://chat-us-east-1.stream-io-api.com/connect?api_key=s2dxdhpxd94g&authorization=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoic3VwZXItYmFuZC05In0.0L6lGoeLwkz0aZRUcpZKsvaXtNEDHBcezVTZ0oPq40A&stream-auth-type=jwt&json=%7B%22user_id%22%3A%22super-band-9%22%2C%22server_determines_connection_id%22%3Atrue%2C%22user_details%22%3A%7B%22id%22%3A%22super-band-9%22%7D%7D E/FlutterFcmService(16987): Fatal: failed to find callback I/flutter (16987): (2020-06-10 15:52:35.267518) ℹ️ 🔌 received new event: {"type":"health.check","connection_id":"b5031c26-aee3-4437-a6c1-97087f4c91b4","cid":"*","me":{"id":"super-band-9","role":"user","roles":[],"created_at":"2020-03-03T16:48:28.853674Z","updated_at":"2020-06-10T10:21:34.658919Z","last_active":"2020-06-10T10:22:36.283080129Z","banned":false,"online":true,"invisible":false,"devices":[{"push_provider":"firebase","id":"djQActKySNyCUWkYfMVVj1:APA91bGNaEo0OvYEpnXbkZlDnHMCRRvsQdswKdsJIf9LbknnogSvVtOKG02L-haJ-Nwma2EINPmyvBG_Xj33AVMLdZuiZKuB_-rbbQArVQX_z3ZK0D1t50yefFdaNIZ8JVHXTiBt8hmE","user_id":"super-band-9","created_at":"2020-06-10T10:20:04.221191Z"},{"push_provider":"firebase","id":"eFvW9UvlTBmU_fIszWfoCD:APA91bH60NYucnsN5N8i_CIxf442y9JwfRMfxpXzz0hBTKYjaZbkgdhnk-lwPlgV1ANXabfJR-4-8ufr4gPp50I4QD2cVEEYG6XPUE_wzxXzNc5UaLLwVIlOz2oLN2x52IRhLGm7YEw9","user_id":"super-band-9","created_at":"2020-06-10T07:56:55.055737Z"},{"push_provider":"firebase","id":"e3VP43QFSZuMaeeII0NV3S:APA91bGHmkqkrjqCIs8Qou8Lv9OWX_UXVmTmvg6 I/flutter (16987): (2020-06-10 15:52:35.268160) ℹ️ 🔌 connection estabilished I/flutter (16987): (2020-06-10 15:52:35.268341) ℹ️ 📡 handle new event: {type: connection.changed, cid: null, connection_id: null, created_at: null, me: null, user: null, message: null, channel: null, member: null, reaction: null, total_unread_count: null, unread_channels: null, online: true, is_local: true} I/flutter (16987): (2020-06-10 15:52:35.268568) ℹ️ 🔌 start health check monitor I/flutter (16987): (2020-06-10 15:52:35.268627) ℹ️ 🔌 sending health.check I/flutter (16987): (2020-06-10 15:52:35.269678) ℹ️ 📡 handle new event: {type: health.check, cid: *, connection_id: b5031c26-aee3-4437-a6c1-97087f4c91b4, created_at: 2020-06-10T10:22:36.285538Z, me: {id: super-band-9, roles: [], invisible: false, channel_mutes: [], unread_count: 0, language: , image: https://randomuser.me/api/portraits/thumb/men/15.jpg, name: Super-band-9}, user: null, message: null, channel: null, member: null, reaction: null, total_unread_count: null, unread_channels: null, online: null, is_local: false} I/flutter (16987): (2020-06-10 15:52:35.337782) ℹ️ 📡 Query channel start I/flutter (16987): (2020-06-10 15:52:35.338079) ℹ️ 💽 Get channel states I/flutter (16987): (2020-06-10 15:52:35.349046) ℹ️ 💽 Got 0 channels I/flutter (16987): (2020-06-10 15:52:35.349457) ℹ️ 📡 Got 0 channels from storage I/flutter (16987): (2020-06-10 15:52:35.355009) ℹ️ 📡 I/flutter (16987): method: GET I/flutter (16987): url: https://chat-us-east-1.stream-io-api.com/channels?payload=%7B%22filter_conditions%22%3A%7B%22members%22%3A%7B%22%24in%22%3A%5B%22super-band-9%22%5D%7D%7D%2C%22sort%22%3A%5B%7B%22field%22%3A%22last_message_at%22%2C%22direction%22%3A-1%7D%5D%2C%22user_details%22%3A%7B%22id%22%3A%22super-band-9%22%2C%22roles%22%3A%5B%5D%2C%22invisible%22%3Afalse%2C%22channel_mutes%22%3A%5B%5D%2C%22unread_count%22%3A0%2C%22language%22%3A%22%22%2C%22image%22%3A%22https%3A%2F%2Frandomuser.me%2Fapi%2Fportraits%2Fthumb%2Fmen%2F15.jpg%22%2C%22name%22%3A%22Super-band-9%22%7D%2C%22state%22%3Atrue%2C%22watch%22%3Atrue%2C%22presence%22%3Afalse%2C%22limit%22%3A20%7D&user_id=super-band-9&api_key=s2dxdhpxd94g&connection_id=b5031c26-aee3-4437-a6c1-97087f4c91b4 I/flutter (16987): headers: {content-type: application/json; charset=utf-8, Authorization: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoic3VwZXItYmFuZC05In0.0L6lGoeLwkz0aZRUcpZKsvaXtNEDHBcezVTZ0oPq40A, st I/flutter (16987): (2020-06-10 15:52:35.369523) ℹ️ 📡 I/flutter (16987): method: POST I/flutter (16987): url: https://chat-us-east-1.stream-io-api.com/devices?user_id=super-band-9&api_key=s2dxdhpxd94g&connection_id=b5031c26-aee3-4437-a6c1-97087f4c91b4 I/flutter (16987): headers: {content-type: application/json; charset=utf-8, Authorization: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoic3VwZXItYmFuZC05In0.0L6lGoeLwkz0aZRUcpZKsvaXtNEDHBcezVTZ0oPq40A, stream-auth-type: jwt, x-stream-client: stream-chat-dart-client-0.2.0-alpha+19} I/flutter (16987): data: {connection_id: b5031c26-aee3-4437-a6c1-97087f4c91b4, id: fZGYirSpSgG8Vv6PZf4wgp:APA91bHVzlF4AV6FEa-6zj0fGH7OUyvVNGimxCzb0R-XFK1J_AkEIctqIuprO6Nuq1OyLcvaNFVpF1Ji3F4INQ2d1k5MijVdM-gOjna_4G2fO0GY8tqc7YwfDXGtA9RhNfspSwsWbAu0, push_provider: firebase} I/flutter (16987): I/flutter (16987): I/flutter (16987): (2020-06-10 15:52:35.476956) ℹ️ 🔌 received new event: {"type":"health.check","connection_id":"b5031c26-aee3-4437-a6c1-97087f4c91b4","cid":"*","created_at":"2020-06-10T10:22:36.49825012Z"} I/flutter (16987): (2020-06-10 15:52:35.477194) ℹ️ 📡 handle new event: {type: health.check, cid: *, connection_id: b5031c26-aee3-4437-a6c1-97087f4c91b4, created_at: 2020-06-10T10:22:36.498250Z, me: null, user: null, message: null, channel: null, member: null, reaction: null, total_unread_count: null, unread_channels: null, online: null, is_local: false} I/flutter (16987): (2020-06-10 15:52:36.816795) ℹ️ 📡 Got 12 channels from api I/flutter (16987): (2020-06-10 15:52:36.818045) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.848499) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.868473) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.890642) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.913413) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.935336) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.955088) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.963404) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:36.983653) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:37.003365) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:37.022624) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:37.058790) ℹ️ 📡 New Channel instance initialized created I/flutter (16987): (2020-06-10 15:52:37.086812) ℹ️ RETRY QUEUE messaging:channel-ex-test-data-0-2 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:37.967350) ℹ️ RETRY QUEUE messaging:channel-ex-test-data-0-4 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.382193) ℹ️ RETRY QUEUE messaging:!members-o31r2hFibdH-bLux94yd5P_DSBuoMKpzSIusjvxPa1k add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.492223) ℹ️ RETRY QUEUE messaging:!members-pwbx_99gkG-PLf2dUh_K3F4dsKB7ST1taXebx3NPCtw add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.667092) ℹ️ RETRY QUEUE messaging:plain-truth-3 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.838089) ℹ️ RETRY QUEUE messaging:channel-ex-test-data-0-0 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.916587) ℹ️ RETRY QUEUE messaging:081884e8-6512-42b3-8f8b-72914f16b26f add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.953921) ℹ️ RETRY QUEUE messaging:channel-ex-test-data-0-3 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:38.995839) ℹ️ RETRY QUEUE messaging:test123 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:39.046062) ℹ️ RETRY QUEUE team:group123 add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:39.096349) ℹ️ RETRY QUEUE messaging:!members-5XUlSrvO9I0-DF3KSJx4WS4pJUoHSco-epUxF9XzqGY add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:52:39.150173) ℹ️ RETRY QUEUE messaging:!members-CMejYZeK0zXGsUZ88VX0boqoicKpoQhWYJvGRRFNCpE add 0 messages E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): E/flutter (16987): [ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: "SqliteException(275): CHECK constraint failed: users, constraint failed (code 275)" E/flutter (16987): #0 PreparedStatement.execute (package:moor_ffi/src/impl/prepared_statement.dart:96) E/flutter (16987): #1 _VmDelegate.runBatched (package:moor_ffi/src/vm_database.dart:54) E/flutter (16987): #2 _ExecutorWithQueryDelegate.runBatched.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:90) E/flutter (16987): #3 BasicLock.synchronized (package:synchronized/src/basic_lock.dart:32) E/flutter (16987): #4 _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:22) E/flutter (16987): #5 _ExecutorWithQueryDelegate.runBatched (package:moor/src/runtime/executor/helpers/engines.dart:86) E/flutter (16987): #6 _MoorServer._runBatched (package:moor/src/runtime/isolate/server.dart:97) E/flutter (16987): <asynchronous suspension> E/flutter (16987): #7 IsolateCommunication.setRequestHandler.<anonymous closure>.<anonymous closure> (package:moor/src/runtime/isolate/communication.dart:167) E/flutter (16987): <asynchronous suspension> E/flutter (16987): I/flutter (16987): (2020-06-10 15:53:05.270539) ℹ️ 🔌 sending health.check I/flutter (16987): (2020-06-10 15:53:05.480324) ℹ️ 🔌 received new event: {"type":"health.check","connection_id":"b5031c26-aee3-4437-a6c1-97087f4c91b4","cid":"*","created_at":"2020-06-10T10:23:06.499936179Z"}

[imtoori]

I just released another version.
I can't really understand the problem, but I'm trying to make the offline storage more robust.
I think it's a problem of concurrent updates.

[imtoori]

@Okdone do you still have the same problem?