agrosner / DBFlow

A blazing fast, powerful, and very simple ORM android database library that writes database code for you.
MIT License
4.87k stars 598 forks source link

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

Closed shainsingh89 closed 4 years ago

shainsingh89 commented 4 years ago

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});