no such table: room_table_modification_log

[mandrachek]

I am experiencing #7 - #7
This is with SQLCipher 4.11.0 and Room 2.8.2

The full stack trace is:
Fatal Exception: android.database.sqlite.SQLiteException: no such table: room_table_modification_log (code 1): , while compiling: INSERT OR IGNORE INTO room_table_modification_log VALUES(2, 0)
at net.zetetic.database.sqlcipher.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
at net.zetetic.database.sqlcipher.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:973)
at net.zetetic.database.sqlcipher.SQLiteConnection.prepare(SQLiteConnection.java:537)
at net.zetetic.database.sqlcipher.SQLiteSession.prepare(SQLiteSession.java:593)
at net.zetetic.database.sqlcipher.SQLiteProgram.(SQLiteProgram.java:65)
at net.zetetic.database.sqlcipher.SQLiteStatement.(SQLiteStatement.java:38)
at net.zetetic.database.sqlcipher.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1270)
at net.zetetic.database.sqlcipher.SQLiteDatabase.compileStatement(SQLiteDatabase.java:76)
at androidx.sqlite.driver.SupportSQLiteStatement$OtherSQLiteStatement.(SupportSQLiteStatement.java:519)
at androidx.sqlite.driver.SupportSQLiteStatement$Companion.create(SupportSQLiteStatement.java:74)
at androidx.sqlite.driver.SupportSQLiteConnection.prepare(SupportSQLiteConnection.android.kt:35)
at androidx.room.coroutines.PassthroughConnection$usePrepared$2.invokeSuspend(PassthroughConnectionPool.kt:91)
at androidx.room.coroutines.PassthroughConnection$usePrepared$2.invoke(PassthroughConnectionPool.kt:11)
at androidx.room.coroutines.PassthroughConnection$usePrepared$2.invoke(PassthroughConnectionPool.kt:11)
at androidx.room.RoomDatabaseKt__RoomDatabase_androidKt.compatTransactionCoroutineExecute(RoomDatabaseKt__RoomDatabase_android.kt:2184)
at androidx.room.RoomDatabaseKt.compatTransactionCoroutineExecute(RoomDatabase.kt:1)
at androidx.room.RoomDatabase$createConnectionManager$3.invoke(RoomDatabase.kt:338)
at androidx.room.RoomDatabase$createConnectionManager$3.invoke(RoomDatabase.java:338)
at androidx.room.coroutines.PassthroughConnection.usePrepared(PassthroughConnectionPool.kt:91)
at androidx.room.TransactorKt.execSQL(Transactor.kt:46)
at androidx.room.TriggerBasedInvalidationTracker.startTrackingTable(InvalidationTracker.kt:328)
at androidx.room.TriggerBasedInvalidationTracker.access$startTrackingTable(InvalidationTracker.kt:147)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1$1$1.invokeSuspend(InvalidationTracker.kt:318)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1$1$1.invoke(InvalidationTracker.kt:13)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1$1$1.invoke(InvalidationTracker.kt:13)
at androidx.room.coroutines.PassthroughConnection.transaction(PassthroughConnectionPool.kt:127)
at androidx.room.coroutines.PassthroughConnection.access$transaction(PassthroughConnection.java:77)
at androidx.room.coroutines.PassthroughConnection$withTransaction$2.invokeSuspend(PassthroughConnectionPool.kt:103)
at androidx.room.coroutines.PassthroughConnection$withTransaction$2.invoke(PassthroughConnectionPool.kt:55)
at androidx.room.coroutines.PassthroughConnection$withTransaction$2.invoke(PassthroughConnectionPool.kt:55)
at androidx.room.RoomDatabaseKt__RoomDatabase_androidKt.compatTransactionCoroutineExecute(RoomDatabaseKt__RoomDatabase_android.kt:2187)
at androidx.room.RoomDatabaseKt.compatTransactionCoroutineExecute(RoomDatabase.kt:1)
at androidx.room.RoomDatabase$createConnectionManager$3.invoke(RoomDatabase.kt:338)
at androidx.room.RoomDatabase$createConnectionManager$3.invoke(RoomDatabase.java:338)
at androidx.room.coroutines.PassthroughConnection.withTransaction(PassthroughConnectionPool.kt:103)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1.invokeSuspend(TriggerBasedInvalidationTracker.java:314)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1.invoke(TriggerBasedInvalidationTracker.java:460)
at androidx.room.TriggerBasedInvalidationTracker$syncTriggers$2$1.invoke(TriggerBasedInvalidationTracker.java:460)
at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invokeSuspend(PassthroughConnectionPool.java:59)
at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invoke(PassthroughConnectionPool.java:325)
at androidx.room.coroutines.PassthroughConnectionPool$useConnection$2.invoke(PassthroughConnectionPool.java:325)
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(BuildersKt__Builders_common.kt:165)
at kotlinx.coroutines.BuildersKt.withContext(Builders.kt:1)
at androidx.room.coroutines.PassthroughConnectionPool.useConnection(PassthroughConnectionPool.kt:59)
at androidx.room.RoomDatabase.getOpenHelper(RoomDatabase.android.kt:136)
at androidx.room.RoomConnectionManager.useConnection(RoomConnectionManager.java:136)
at androidx.room.RoomDatabase.useConnection(RoomDatabase.android.kt:619)
at androidx.room.TriggerBasedInvalidationTracker.syncTriggers$room_runtime(InvalidationTracker.kt:306)
at androidx.room.TriggerBasedInvalidationTracker$createFlow$1$1.invokeSuspend(TriggerBasedInvalidationTracker.java:239)
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.java:124)
at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:89)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.java: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)

[developernotes]

Hi @mandrachek,

Can you provide any further details regarding how you receive this error?

• Is it occurring during an application migration?
• Are you able to reproduce the issue in isolation such that we could review it further?
• Have you tried other versions of Room, do they also behave the same way?

[mandrachek]

1. We're going from 4.10 to 4.11. We have several dbs, and we do have 2 dbs we're doing migrations on. I'll try an upgrade and see if I can replicate that way.

2. No, unfortunately. It seems to happen randomly. Happened to one user 3 times, and another user once. As you can tell from the stack trace, there's no app code being referenced.

3. We could try 2.8.1, but as we can't repro reliably it's a bit hard to tell if it worked or not.

[developernotes]

Hi @mandrachek,

Are you using automatic or manual migrations with Room 2.8.2 and SQLCipher for Android 4.11.0? We are trying to setup a small test application to see if we're able to reproduce the behavior, but have not experienced the issue with automatic migrations thus far.

Also, in the situation where this error has occurred for you, is there any chance another error occurred prior to this exception?

[mandrachek]

I think I may have tracked a potential cause. We're using KMP, and so we cant use the the old clear table method room provides, so we built our own. We were skipping the room_master... and some other tables. Im not 100% that this code path was followed here, but we updated it to ignore room_% tables.

If that isn't the fix the room folks suggested there's a setting for the invalidating tracker to use a real db table instead of an in-memory temp table for this.

[mandrachek]

That didn't fix it, unfortunately. And it happens on fresh installs occasionally.

We've enabled the experimental setInTrackingMemoryMode(false) to try and work around this, per https://issuetracker.google.com/issues/454152426

[developernotes]

Hi @mandrachek,

Thanks for the update, please keep us posted on how setInTrackingMemoryMode works for you.