Coroutine Context Conflict with Room Database Transactions in Kotlin Coroutines
I'm converting an old project and I'm converting an old project and I'm upgrading from an older version and I'm attempting to set up I tried several approaches but none seem to work..... I'm working with an scenario when trying to perform database operations with Room in a coroutine that's launched within a ViewModel. Specifically, when I try to execute a transaction with `withContext(Dispatchers.IO)` for my Room database, I get the behavior: `java.lang.IllegalStateException: Room want to execute queries on the main thread because it may lock the UI for a long period of time.`. Here’s a simplified version of my code: ```kotlin class MyViewModel(application: Application) : AndroidViewModel(application) { private val myDao: MyDao = MyDatabase.getInstance(application).myDao() fun insertData(data: MyData) = viewModelScope.launch { withContext(Dispatchers.IO) { myDao.insert(data) } } } ``` I assumed that using `withContext(Dispatchers.IO)` would resolve this scenario, but it seems to continue. I've also ensured that `insert` method in `MyDao` is annotated with `@Insert` and the database has been properly set up to allow transactions. I've checked the main thread using `isMainThread()` method, and it returns false when I'm inside the coroutine. Additionally, I’ve verified that the `insertData` function is called from a non-UI thread. However, I still receive the same behavior message. Is there something I'm missing in the coroutine context setup, or is there another layer of threading I should be considering? Any insights would be greatly appreciated! This is part of a larger web app I'm building. What am I doing wrong? My development environment is Ubuntu 20.04. I'd be grateful for any help. Hoping someone can shed some light on this. I appreciate any insights! This is my first time working with Kotlin latest.