Upgrading Room DB with migrations causes DB lock
I was browsing this page on adding Architecture Components to your app and I came across this beautiful line:
def room_version = "1.1.0" // or, for latest rc, use "1.1.1-rc1"
I was using Room version 1.1.0, naturally, because it should be stable and we want stable, solid software that we can rely on from Google, of course.
Bumped up the version to 1.1.1-rc1 and I can safely say that this nonsensical error that stems from Google's own code is now gone, I've retested the same scenario on all the devices I mentioned in the original question.
Be careful when exceptions occur and no mention of your code is included. This is a bug in Room 1.1.0, please confirm if you have seen it, the only other mention of it online that I've seen is this one here from 2017