IssueTracker

Component used: Room
Version used: 2.0.0
Devices/Android versions reproduced on: SDK 28

We occasionally get a crash from sqlite because something is attempting to set PRAGMA temp_store inside of a transaction. This is not allowed (https://github.com/sqlite/sqlite/blob/08652b5ea00316539c913fc936e2966c8d58d283/src/pragma.c#L135). We tracked it down to inside of the Room InvalidationTracker class internalInit method (https://android.googlesource.com/platform/frameworks/support/+/android-room-release/room/runtime/src/main/java/androidx/room/InvalidationTracker.java). We believe this doesn't always happen because it appears (based on a read of the sqlite code) that it depends on the number of connections present, which is often only one during initialization, but this isn't always the case.

We have worked around this by setting this exact PRAGMA in onConfigure, so that when Room goes to do it, there is no change and therefore doesn't validate sqlite's precondition.

It would be great if Room could update to not set this PRAGMA inside of a transaction.

Thanks for your help/consideration!