search

AndBible / and-bible

AndBible: Bible Study
https://andbible.org
GNU General Public License v3.0
551 stars 193 forks source link

Crash in migration ( no such column: _id (code 1 SQLITE_ERROR): , while compiling: INSERT INTO ReadingPlanMap SELECT _id, randomblob(16) FROM readingplan) #3079

Open tuomas2 opened 7 months ago

tuomas2 commented 7 months ago

https://support.andbible.org/scp/tickets.php?id=2277

Device info:
Version: 5.0.771#5578074 github standard release (built 23/11/23 08:43:16)
Android version: 13
Android SDK version: 33
Manufacturer: OnePlus
Model: LE2115
Storage Mb free: 44176
WebView version: 119.0.6045.163
SQLITE version: 3.42.0
Used heap memory in Mb: 17
Max heap memory in Mb: 384

Exception:
android.database.sqlite.SQLiteException: no such column: _id (code 1 SQLITE_ERROR): , while compiling: INSERT INTO ReadingPlanMap SELECT _id, randomblob(16) FROM readingplan
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement([SQLiteConnection.java:1074](denied:SQLiteConnection.java:1074))
at android.database.sqlite.SQLiteConnection.prepare([SQLiteConnection.java:679](denied:SQLiteConnection.java:679))
at android.database.sqlite.SQLiteSession.prepare([SQLiteSession.java:590](denied:SQLiteSession.java:590))
at android.database.sqlite.SQLiteProgram. ([SQLiteProgram.java:62](denied:SQLiteProgram.java:62))
at android.database.sqlite.SQLiteStatement. ([SQLiteStatement.java:34](denied:SQLiteStatement.java:34))
at android.database.sqlite.SQLiteDatabase.executeSql([SQLiteDatabase.java:2086](denied:SQLiteDatabase.java:2086))
at android.database.sqlite.SQLiteDatabase.execSQL([SQLiteDatabase.java:2008](denied:SQLiteDatabase.java:2008))
at androidx.sqlite.db.framework.FrameworkSQLiteDatabase.execSQL(FrameworkSQLiteDatabase.kt:246)
at [net.bible.android](https://net.bible.android/).database.migrations.DatabaseSplitMigrations.readingPlanDb(DatabaseSplitMigrations.kt:171)
at [net.bible.android](https://net.bible.android/).database.migrations.DatabaseSplitMigrations.migrateAll(DatabaseSplitMigrations.kt:47)
at [net.bible](https://net.bible/).service.db.DatabaseContainer.migrateOldDatabaseIfNeeded(DatabaseContainer.kt:99)
at [net.bible](https://net.bible/).service.db.DatabaseContainer. (DatabaseContainer.kt:73)
at [net.bible](https://net.bible/).service.db.DatabaseContainer$Companion.getInstance(DatabaseContainer.kt:277)
at [net.bible.android](https://net.bible.android/).view.activity.StartupActivity$initializeDatabase$2.invokeSuspend(StartupActivity.kt:229)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at [kotlinx.coroutines.DispatchedTask.run](https://kotlinx.coroutines.dispatchedtask.run/)(DispatchedTask.kt:108)
at kotlinx.coroutines.internal.LimitedDispatcher$[Worker.run](https://worker.run/)(LimitedDispatcher.kt:115)
at [kotlinx.coroutines.scheduling.TaskImpl.run](https://kotlinx.coroutines.scheduling.taskimpl.run/)(Tasks.kt:103)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:584)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:793)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:697)
at kotlinx.coroutines.scheduling.CoroutineScheduler$[Worker.run](https://worker.run/)(CoroutineScheduler.kt:684)
Suppressed: kotlinx.coroutines.internal.DiagnosticCoroutineContextException: [StandaloneCoroutine{Cancelling}@525f366, Dispatchers.Main.immediate]
tuomas2 commented 4 months ago

also: https://support.andbible.org/scp/tickets.php?id=2485