Error during processing events - SqfliteFfiException(sqlite_error: 1032

[PhantomRay]

Checklist

• I could not find a solution in the documentation, the existing issues or discussions.
• I already asked for help in the chat

In which Project did the bug appear?

No response

If you selected "Other" as Project, please enter in which project the bug occurred.

No response

On which platform did the bug appear?

Android, iOS

SDK Version

0.35

Describe the problem caused by this bug

I see frequent error from both iOS and Android. It's constantly spitting logs.

Steps To Reproduce

Unknown.

Screenshots or Logs

flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142065,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142065,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142071,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142071,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142066,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142066,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142065,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142065,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142061,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142061,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142059,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142059,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>
flutter: [Matrix] \^[[31mError during processing events - SqfliteFfiException(sqlite_error: 1032, , SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142060,"currently_active":true}}) DatabaseException(SqliteException(1032): while executing statement, attempt to write a readonly database, attempt to write a readonly database (code 1032)
  Causing statement: INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?), parameters: @1t8mnyt65dz4:my.matrix.com, {"user_id":"@1t8mnyt65dz4:my.matrix.com","presence":"online","last_active_timestamp":1733227142060,"currently_active":true}) sql 'INSERT OR REPLACE INTO box_presences (k, v) VALUES (?, ?)' args [@1t8mnyt65dz4:my.matrix.com, {"user_id"<…>

<MORE and NEVER ENDING>...

Security related

No response

[PhantomRay]

This might be related to re-used database for different users. Let me confirm.

[krille-chan]

Cannot reproduce this problem in FluffyChat 🤔 but according to the logs it looks like your database somehow got into readonly mode. Have you maybe opened it wrong?

[PhantomRay]

Might be related to how I use the sqlite db file. I use one file per user just to avoid conflict for now.