IssueTracker

Devices/Android versions reproduced on: Android 33, 34 and iOS 17 (always emulators).
At random occasions the app crashes with this exception. The code is practically copied and pasted from another project that is only Android and has never had this issue. It happens throughout all the app when a Room query is collected from a Flow. I think that happens more frequently when multiple queries are requested at the same time or the data collected is big.

For example, this is how I gather all the flows (some of them use Room queries) into a single flow to be .collectAsState() in a Screen. It usually crashes when I simply get into the Screen, I know it's going to crash within 5 or 10 seconds because it should be showing info that is not present. If I navigate back and forth maybe the next time it loads everything and works perfectly.

    val state = combine(
        buscando, textfieldText, hayTeleindicadores, listaGraficos, idGrafico,
        diaSemana, ordenBusqueda, dialogCompi, turnosBuscados, trenesBuscados,
        teleindicadoresBuscados, coloresTrenes, imagenEgaInitialScroll, imagenEgaTurno
    ) {array ->
        BuscadorState(
            array[0] as Buscando,
            array[1] as String,
            array[2] as Boolean,
            array[3] as List<GrGraficos>,
            array[4] as Long,
            array[5] as String,
            array[6] as OrdenBusqueda,
            array[7] as LsUsers,
            array[8] as List<TurnoBuscadorDM>?,
            array[9] as List<TurnoBuscadorDM>?,
            array[10] as List<OtTeleindicadores>,
            array[11] as List<OtColoresTrenes>?,
            array[12] as Int,
            array[13] as TurnoBuscadorDM?,
        )
    }

The project uses Koin to inject the database and has its libraries updated.
Versions used:
androidx-room = "2.7.0-alpha04"
ksp = "2.0.0-1.0.22"
sqlite = "2.5.0-alpha04"
kotlin = "2.0.0"
koin = "3.6.0-Beta4"
koinComposeMultiplatform = "1.2.0-Beta4"


The exception on Android:

FATAL EXCEPTION: main
Process: es.kirito.kirito, PID: 7775
android.database.SQLException: Error code: 5, message: Timed out attempting to acquire a connection
        at androidx.sqlite.SQLiteKt.throwSQLiteException(SQLite.kt:42)
        at androidx.room.coroutines.ConnectionPoolImpl.useConnection(ConnectionPoolImpl.kt:138)
        at androidx.room.coroutines.ConnectionPoolImpl$useConnection$1.invokeSuspend(Unknown Source:16)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.internal.ScopeCoroutine.afterResume(Scopes.kt:28)
        at kotlinx.coroutines.AbstractCoroutine.resumeWith(AbstractCoroutine.kt:99)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:46)
        at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:102)
        at kotlinx.coroutines.internal.LimitedDispatcher$Worker.run(LimitedDispatcher.kt:111)
        at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:99)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:584)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:811)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:715)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:702)
        Suppressed: kotlinx.coroutines.internal.DiagnosticCoroutineContextException: [StandaloneCoroutine{Cancelling}@4fef71c, Dispatchers.Main.immediate]

And this is the same error on iOS, that shows a longer stacktrace:
Uncaught Kotlin exception: androidx.sqlite.SQLiteException: Error code: 5, message: Timed out attempting to acquire a connection
    at 0   Kirito                              0x10228eab9        kfun:kotlin.Throwable#<init>(kotlin.String?){} + 105
    at 1   Kirito                              0x102288fe5        kfun:kotlin.Exception#<init>(kotlin.String?){} + 101
    at 2   Kirito                              0x1022891a5        kfun:kotlin.RuntimeException#<init>(kotlin.String?){} + 101
    at 3   Kirito                              0x103e022e9        kfun:androidx.sqlite.SQLiteException#<init>(kotlin.String){} + 89
    at 4   Kirito                              0x103e01dc8        kfun:androidx.sqlite#throwSQLiteException(kotlin.Int;kotlin.String?){}kotlin.Nothing + 792
    at 5   Kirito                              0x103e202d5        kfun:androidx.room.coroutines.ConnectionPoolImpl.$useConnectionCOROUTINE$0.invokeSuspend#internal + 6165
    at 6   Kirito                              0x1023d8143        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#invokeSuspend(kotlin.Result<kotlin.Any?>){}kotlin.Any?-trampoline + 51
    at 7   Kirito                              0x1022947bd        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 829
    at 8   Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
    at 9   Kirito                              0x10251c596        kfun:kotlinx.coroutines.internal.ScopeCoroutine#afterResume(kotlin.Any?){} + 294
    at 10  Kirito                              0x102544eab        kfun:kotlinx.coroutines.AbstractCoroutine#afterResume(kotlin.Any?){}-trampoline + 43
    at 11  Kirito                              0x102477c07        kfun:kotlinx.coroutines.AbstractCoroutine#resumeWith(kotlin.Result<1:0>){} + 391
    at 12  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
    at 13  Kirito                              0x102294a4e        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 1486
    at 14  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
    at 15  Kirito                              0x1025147f2        kfun:kotlinx.coroutines.DispatchedTask#run(){} + 2514
    at 16  Kirito                              0x1025477b0        kfun:kotlinx.coroutines.Runnable#run(){}-trampoline + 64
    at 17  Kirito                              0x102517a97        kfun:kotlinx.coroutines.internal.LimitedDispatcher.Worker.run#internal + 343
    at 18  Kirito                              0x1025477b0        kfun:kotlinx.coroutines.Runnable#run(){}-trampoline + 64
    at 19  Kirito                              0x10253f445        kfun:kotlinx.coroutines.MultiWorkerDispatcher.$workerRunLoop$lambda$2COROUTINE$0.invokeSuspend#internal + 2597
    at 20  Kirito                              0x1023d8143        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#invokeSuspend(kotlin.Result<kotlin.Any?>){}kotlin.Any?-trampoline + 51
    at 21  Kirito                              0x1022947bd        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 829
    at 22  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
    at 23  Kirito                              0x1025148e7        kfun:kotlinx.coroutines.DispatchedTask#run(){} + 2759
    at 24  Kirito                              0x1025477b0        kfun:kotlinx.coroutines.Runnable#run(){}-trampoline + 64
    at 25  Kirito                              0x10248f2be        kfun:kotlinx.coroutines.EventLoopImplBase#processNextEvent(){}kotlin.Long + 1534
    at 26  Kirito                              0x1025475b3        kfun:kotlinx.coroutines.EventLoop#processNextEvent(){}kotlin.Long-trampoline + 35
    at 27  Kirito                              0x102537e36        kfun:kotlinx.coroutines.BlockingCoroutine.joinBlocking#internal + 566
    at 28  Kirito                              0x102536bd4        kfun:kotlinx.coroutines#runBlocking(kotlin.coroutines.CoroutineContext;kotlin.coroutines.SuspendFunction1<kotlinx.coroutines.CoroutineScope,0:0>){0§<kotlin.Any?>}0:0 + 1780
    at 29  Kirito                              0x102536e22        kfun:kotlinx.coroutines#runBlocking$default(kotlin.coroutines.CoroutineContext?;kotlin.coroutines.SuspendFunction1<kotlinx.coroutines.CoroutineScope,0:0>;kotlin.Int){0§<kotlin.Any?>}0:0 + 290
    at 30  Kirito                              0x10253cef5        kfun:kotlinx.coroutines.MultiWorkerDispatcher.workerRunLoop#internal + 197
    at 31  Kirito                              0x10253e5ab        kfun:kotlinx.coroutines.MultiWorkerDispatcher.<init>$lambda$1$lambda$0#internal + 59
    at 32  Kirito                              0x10253fbcf        kfun:kotlinx.coroutines.MultiWorkerDispatcher.$<init>$lambda$1$lambda$0$FUNCTION_REFERENCE$5.invoke#internal + 63
    at 33  Kirito                              0x10253fc8f        kfun:kotlinx.coroutines.MultiWorkerDispatcher.$<init>$lambda$1$lambda$0$FUNCTION_REFERENCE$5.$<bridge-UNN>invoke(){}#internal + 63
    at 34  Kirito                              0x1023d5628        kfun:kotlin.Function0#invoke(){}1:0-trampoline + 72
    at 35  Kirito                              0x1022a1bb1        WorkerLaunchpad + 129
    at 36  Kirito                              0x102435a81        _ZN6Worker19processQueueElementEb + 2817
    at 37  Kirito                              0x102434ec2        ZN12_GLOBAL_N_113workerRoutineEPv + 130
    at 38  libsystem_pthread.dylib             0x10788a18a        _pthread_start + 98
    at 39  libsystem_pthread.dylib             0x107885ae2        thread_start + 14
    Suppressed: kotlinx.coroutines.internal.DiagnosticCoroutineContextException: [StandaloneCoroutine{Cancelling}@88cc89e8, Dispatchers.Main.immediate]
        at 0   Kirito                              0x10228eab9        kfun:kotlin.Throwable#<init>(kotlin.String?){} + 105
        at 1   Kirito                              0x102288fe5        kfun:kotlin.Exception#<init>(kotlin.String?){} + 101
        at 2   Kirito                              0x1022891a5        kfun:kotlin.RuntimeException#<init>(kotlin.String?){} + 101
        at 3   Kirito                              0x1025411b4        kfun:kotlinx.coroutines.internal.DiagnosticCoroutineContextException#<init>(kotlin.coroutines.CoroutineContext){} + 180
        at 4   Kirito                              0x10251007e        kfun:kotlinx.coroutines.internal#handleUncaughtCoroutineException(kotlin.coroutines.CoroutineContext;kotlin.Throwable){} + 942
        at 5   Kirito                              0x102489e93        kfun:kotlinx.coroutines#handleCoroutineException(kotlin.coroutines.CoroutineContext;kotlin.Throwable){} + 723
        at 6   Kirito                              0x10247c134        kfun:kotlinx.coroutines.StandaloneCoroutine.handleJobException#internal + 180
        at 7   Kirito                              0x102548abb        kfun:kotlinx.coroutines.JobSupport#handleJobException(kotlin.Throwable){}kotlin.Boolean-trampoline + 43
        at 8   Kirito                              0x1024955e6        kfun:kotlinx.coroutines.JobSupport.finalizeFinishingState#internal + 1382
        at 9   Kirito                              0x10249f597        kfun:kotlinx.coroutines.JobSupport.tryMakeCompletingSlowPath#internal + 2487
        at 10  Kirito                              0x10249eb99        kfun:kotlinx.coroutines.JobSupport.tryMakeCompleting#internal + 697
        at 11  Kirito                              0x10249e6bd        kfun:kotlinx.coroutines.JobSupport#makeCompletingOnce(kotlin.Any?){}kotlin.Any? + 509
        at 12  Kirito                              0x102477ba7        kfun:kotlinx.coroutines.AbstractCoroutine#resumeWith(kotlin.Result<1:0>){} + 295
        at 13  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 14  Kirito                              0x102294a4e        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 1486
        at 15  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 16  Kirito                              0x10251c596        kfun:kotlinx.coroutines.internal.ScopeCoroutine#afterResume(kotlin.Any?){} + 294
        at 17  Kirito                              0x102544eab        kfun:kotlinx.coroutines.AbstractCoroutine#afterResume(kotlin.Any?){}-trampoline + 43
        at 18  Kirito                              0x102477c07        kfun:kotlinx.coroutines.AbstractCoroutine#resumeWith(kotlin.Result<1:0>){} + 391
        at 19  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 20  Kirito                              0x102294a4e        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 1486
        at 21  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 22  Kirito                              0x1025147f2        kfun:kotlinx.coroutines.DispatchedTask#run(){} + 2514
        at 23  Kirito                              0x10248d0f6        kfun:kotlinx.coroutines.EventLoop#processUnconfinedEvent(){}kotlin.Boolean + 438
        at 24  Kirito                              0x102513407        kfun:kotlinx.coroutines.internal#resumeCancellableWith_at_kotlin.coroutines.Continuation<0:0>(kotlin.Result<0:0>;kotlin.Function1<kotlin.Throwable,kotlin.Unit>?){0§<kotlin.Any?>} + 2871
        at 25  Kirito                              0x1025135b6        kfun:kotlinx.coroutines.internal#resumeCancellableWith$default_at_kotlin.coroutines.Continuation<0:0>(kotlin.Result<0:0>;kotlin.Function1<kotlin.Throwable,kotlin.Unit>?;kotlin.Int){0§<kotlin.Any?>} + 310
        at 26  Kirito                              0x10251c442        kfun:kotlinx.coroutines.internal.ScopeCoroutine#afterCompletion(kotlin.Any?){} + 370
        at 27  Kirito                              0x10254906b        kfun:kotlinx.coroutines.JobSupport#afterCompletion(kotlin.Any?){}-trampoline + 43
        at 28  Kirito                              0x1024a01e4        kfun:kotlinx.coroutines.JobSupport.continueCompleting#internal + 564
        at 29  Kirito                              0x1024a2ef7        kfun:kotlinx.coroutines.JobSupport.ChildCompletion.invoke#internal + 343
        at 30  Kirito                              0x102548beb        kfun:kotlinx.coroutines.JobNode#invoke(kotlin.Throwable?){}-trampoline + 43
        at 31  Kirito                              0x102497aa0        kfun:kotlinx.coroutines.JobSupport.notifyCompletion#internal + 1136
        at 32  Kirito                              0x102496b42        kfun:kotlinx.coroutines.JobSupport.completeStateFinalization#internal + 1506
        at 33  Kirito                              0x102495739        kfun:kotlinx.coroutines.JobSupport.finalizeFinishingState#internal + 1721
        at 34  Kirito                              0x10249f597        kfun:kotlinx.coroutines.JobSupport.tryMakeCompletingSlowPath#internal + 2487
        at 35  Kirito                              0x10249eb99        kfun:kotlinx.coroutines.JobSupport.tryMakeCompleting#internal + 697
        at 36  Kirito                              0x10249e6bd        kfun:kotlinx.coroutines.JobSupport#makeCompletingOnce(kotlin.Any?){}kotlin.Any? + 509
        at 37  Kirito                              0x102477ba7        kfun:kotlinx.coroutines.AbstractCoroutine#resumeWith(kotlin.Result<1:0>){} + 295
        at 38  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 39  Kirito                              0x102294a4e        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 1486
        at 40  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 41  Kirito                              0x10251c596        kfun:kotlinx.coroutines.internal.ScopeCoroutine#afterResume(kotlin.Any?){} + 294
        at 42  Kirito                              0x102544eab        kfun:kotlinx.coroutines.AbstractCoroutine#afterResume(kotlin.Any?){}-trampoline + 43
        at 43  Kirito                              0x102477c07        kfun:kotlinx.coroutines.AbstractCoroutine#resumeWith(kotlin.Result<1:0>){} + 391
        at 44  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 45  Kirito                              0x102294a4e        kfun:kotlin.coroutines.native.internal.BaseContinuationImpl#resumeWith(kotlin.Result<kotlin.Any?>){} + 1486
        at 46  Kirito                              0x1023d81e9        kfun:kotlin.coroutines.Continuation#resumeWith(kotlin.Result<1:0>){}-trampoline + 73
        at 47  Kirito                              0x1025147f2        kfun:kotlinx.coroutines.DispatchedTask#run(){} + 2514
        at 48  Kirito                              0x1025477b0        kfun:kotlinx.coroutines.Runnable#run(){}-trampoline + 64
        at 49  Kirito                              0x10254380b        kfun:kotlinx.coroutines.DarwinMainDispatcher.dispatch$lambda$0#internal + 59
        at 50  Kirito                              0x102543aff        kfun:kotlinx.coroutines.DarwinMainDispatcher.$dispatch$lambda$0$FUNCTION_REFERENCE$1.invoke#internal + 63
        at 51  Kirito                              0x102543bbf        kfun:kotlinx.coroutines.DarwinMainDispatcher.$dispatch$lambda$0$FUNCTION_REFERENCE$1.$<bridge-UNN>invoke(){}#internal + 63
        at 52  Kirito                              0x1023d5628        kfun:kotlin.Function0#invoke(){}1:0-trampoline + 72
        at 53  Kirito                              0x102544c48        _6f72672e6a6574627261696e732e6b6f746c696e783a6b6f746c696e782d636f726f7574696e65732d636f72652f6f70742f6275696c644167656e742f776f726b2f343465633665383530643563363366302f6b6f746c696e782d636f726f7574696e65732d636f72652f6e617469766544617277696e2f7372632f44697370617463686572732e6b74_knbridge13 + 184
        at 54  libdispatch.dylib                   0x7ff8001783eb     _dispatch_call_block_and_release + 11
        at 55  libdispatch.dylib                   0x7ff8001796d7     _dispatch_client_callout + 7
        at 56  libdispatch.dylib                   0x7ff80018848b     _dispatch_main_queue_drain + 1419
        at 57  libdispatch.dylib                   0x7ff800187ef1     _dispatch_main_queue_callback_4CF + 30
        at 58  CoreFoundation                      0x7ff800429af3     _CFRUNLOOP_IS_SERVICING_THE_MAIN_DISPATCH_QUEUE_ + 8
        at 59  CoreFoundation                      0x7ff80042442e     __CFRunLoopRun + 2462
        at 60  CoreFoundation                      0x7ff8004236ac     CFRunLoopRunSpecific + 556
        at 61  GraphicsServices                    0x7ff8103da08e     GSEventRunModal + 136
        at 62  UIKitCore                           0x7ff805cc0ad0     -[UIApplication _run] + 971
        at 63  UIKitCore                           0x7ff805cc5550     UIApplicationMain + 122
        at 64  SwiftUI                             0x7ffa159e5f0e     objectdestroy.44Tm + 2709
        at 65  SwiftUI                             0x7ffa159e5dcb     objectdestroy.44Tm + 2386
        at 66  SwiftUI                             0x7ffa15611f34     get_witness_table 7SwiftUI4ViewRzlAA15ModifiedContentVyxAA30_EnvironmentKeyWritingModifierVySbGGAaBHPxAaBHD1__AgA0cI0HPyHCHCTm + 218
        at 67  Kirito                              0x10179491d        $s6Kirito6iOSAppV5$mainyyFZ + 29
        at 68  Kirito                              0x1017949a8        main + 8 (/Users/yak112/StudioProjects/KiritoMultiplatform/iosApp/iosApp/iOSApp.swift:<unknown>)
        at 69  dyld                                0x10732d3df        0x0 + 4415738847
        at 70  ???                                 0x113e58365        0x0 + 4628775781