[Crash] IllegalStateException: Couldn't read row, col from CursorWindow on LocationOfInterestDao

[andreia-ferreira]

Fatal Exception: java.lang.IllegalStateException: Couldn't read row 163, col 0 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
       at android.database.CursorWindow.nativeGetString(CursorWindow.java)
       at android.database.CursorWindow.getString(CursorWindow.java:465)
       at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:54)
       at androidx.sqlite.driver.SupportSQLiteStatement$RowSQLiteStatement.getText(SupportSQLiteStatement.android.kt:370)
       at org.groundplatform.android.data.local.room.dao.LocationOfInterestDao_Impl.getByDeletionState$lambda$0(LocationOfInterestDao_Impl.kt:219)
       at org.groundplatform.android.data.local.room.dao.LocationOfInterestDao_Impl$$ExternalSyntheticLambda6.invoke(D8$$SyntheticClass)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invokeSuspend(DBUtil.kt:173)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invoke(:8)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$lambda$1$$inlined$internalPerform$1.invoke(:4)
       at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invokeSuspend(PassthroughConnectionPool.kt:59)
       at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invoke(:8)
       at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invoke(:4)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndspatched(Undispatched.kt:66)
       at kotlinx.coroutines.intrinsics.UndispatchedKt.startUndispatchedOrReturn(Undispatched.kt:43)
       at kotlinx.coroutines.BuildersKt__Builders_commonKt.withContext(Builders.common.kt:165)
       at kotlinx.coroutines.BuildersKt.withContext(:1)
       at androidx.room.coroutines.PassthroughConnectionPool.useConnection(PassthroughConnectionPool.kt:59)
       at androidx.room.RoomConnectionManager.useConnection(RoomConnectionManager.android.kt:138)
       at androidx.room.RoomDatabase.useConnection(RoomDatabase.android.kt:619)
       at androidx.room.util.DBUtil__DBUtil_androidKt$performSuspending$$inlined$compatCoroutineExecute$DBUtil__DBUtil_androidKt$1.invokeSuspend(DBUtil.android.kt:261)
       at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:34)
       at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:100)
       at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:124)
       at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
       at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:586)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:820)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:717)
       at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:704)

This crash seems to happen at least since 0.3.6, although its frequency varies, from no occurrences to periods where it becomes frequent, it may be related to specific survey LOIs

Full Crashlytics stacktrace