agrosner/DBFlow

Database get deleted on search query using raw query on virtual table

shainsingh89 opened this issue · 0 comments

ISSUE

DBFlow Version: 4.2.4

Bug or Feature Request:
Database get delete if I am performing search query with the virtual table using FTS5

Description:
E/Database: Calling error handler for corrupt database (detected) /data/user/0/com.test.debug/databases/test.db

E/DefaultDatabaseErrorHandler: Corruption reported by sqlite on database, deleting: /data/user/0/com.test.debug/databases/test.db

E/DefaultDatabaseErrorHandler: Database object for corrupted database is already open, closing

E/DefaultDatabaseErrorHandler: deleting the database file: /data/user/0/com.test.debug/databases/test.db

This is happening after upgrading the database, in fresh installation, it working

FlowManager.getDatabase(AppDatabase.NAME).getWritableDatabase().rawQuery(MESSAGES_QUERY, new String[]{fullTextSearchQuery});