SqliteException(5): while executing statement, database is locked, database is locked

[tpucci]

Which packages are you using?

stream_chat_persistance

On what platforms did you experience the issue?

Android

What version are you using?

stream_chat_persistence: 9.11.0

What happened?

Since stream_chat_persistence: 9.11.0, we have those issues on Android clients.
With stream_chat_persistence: 9.8.0, we did not have have those issues.

Steps to reproduce

Sorry, it is difficult and time consuming to do a min repro project :/
Our project shows only this one diff: stream_chat_persistence: 9.8.0 -> 9.11.0

Supporting info to reproduce

No response

Relevant log output

Flutter analyze output

Flutter doctor output

Code of Conduct

• I agree to follow this project's Code of Conduct

[xsahil03x]

Hey @tpucci , can you share some logs with more data, so that we can try to determine when exactly it happens?
Also can you verify if it happens on both ConnectionMode.regular and ConnectionMode.background or only in a particular ConnectionMode?

Generally, this happens while doing a hot reload/restart. It should work fine on full restart.

[tpucci]

It seems to happen when the app is in the background for a long time

[tpucci]

connectionMode is set on background

  final chatPersistentClient = StreamChatPersistenceClient(
    connectionMode: ConnectionMode.background,
  );