android.database.sqlite.SQLiteBlobTooBigException

[g19980115]

 java.lang.RuntimeException:An error occurred while executing doInBackground()

 androidx.loader.content.ModernAsyncTask$3.done(ModernAsyncTask.java:164)
 ......
 Caused by:
 android.database.sqlite.SQLiteBlobTooBigException:Row too big to fit into CursorWindow requiredPos=0, totalRows=1
 android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
 android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:904)
 android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:851)
 android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
 android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:149)
 android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:137)
 android.database.AbstractCursor.moveToPosition(AbstractCursor.java:220)
 android.database.AbstractCursor.moveToFirst(AbstractCursor.java:259)
 com.genonbeta.android.database.SQLiteDatabase.getTable(SQLiteDatabase.java:137)
 com.genonbeta.android.database.SQLiteDatabase.castQuery(SQLiteDatabase.java:62)
 com.genonbeta.android.database.SQLiteDatabase.castQuery(SQLiteDatabase.java:56)
 com.genonbeta.android.database.SQLiteDatabase.castQuery(SQLiteDatabase.java:51)
 com.genonbeta.TrebleShot.adapter.TransferGroupListAdapter.onLoad(TransferGroupListAdapter.java:69)
 com.genonbeta.TrebleShot.widget.GroupEditableListAdapter.onLoad(GroupEditableListAdapter.java:53)
 com.genonbeta.android.framework.app.ListFragment$ListLoader.loadInBackground(ListFragment.java:361)
 com.genonbeta.android.framework.app.ListFragment$ListLoader.loadInBackground(ListFragment.java:341)
 androidx.loader.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:307)
 androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:60)
 androidx.loader.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:48)
 androidx.loader.content.ModernAsyncTask$2.call(ModernAsyncTask.java:141)
 java.util.concurrent.FutureTask.run(FutureTask.java:266)
 java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
 java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
 java.lang.Thread.run(Thread.java:784)

[velitasali]

Could you provide more details? I think this happens due to some changes in Android 9 APIs.

[g19980115]

Yes，the exception only in android 9 device.