= OfflineItem.oiLct LIMIT 1 )) AS readyForOffline, NULL AS latestErrorStr FROM OfflineItem LEFT JOIN TransferJob ON TransferJob.tjUid = (SELECT TransferJob.tjUid FROM TransferJob WHERE TransferJob.tjTableId = 738 AND TransferJob.tjEntityUid IN (SELECT ContentEntryVersion.cevUid FROM ContentEntryVersion WHERE ContentEntryVersion.cevContentEntryUid = ?) AND TransferJob.tjStatus < 21 ORDER BY TransferJob.tjTimeCreated DESC LIMIT 1) WHERE OfflineItem.oiNodeId = ? AND OfflineItem.oiContentEntryUid = ? ORDER BY OfflineItem.oiLct DESC LIMIT 1 java.lang.IllegalStateException: com.ustadmobile.door.room.RoomDatabaseJdbcImplHelper@41f15eb5 is closed! at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.assertNotClosed(RoomDatabaseJdbcImplHelperCommon.kt:96) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:103) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.access$useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:21) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:237) at _COROUTINE._BOUNDARY._(CoroutineDebugging.kt:42) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:235) at com.ustadmobile.door.ext.DoorDatabaseExtJvmJsKt.prepareAndUseStatementAsync(DoorDatabaseExtJvmJs.kt:24) at com.ustadmobile.core.db.dao.OfflineItemDao_JdbcImpl$findByContentEntryUid$1.invokeSuspend(OfflineItemDao_JdbcImpl.kt:64) at com.ustadmobile.door.flow.DoorFlowKt$doorFlow$1$1.invokeSuspend(DoorFlow.kt:40) Caused by: java.lang.IllegalStateException: com.ustadmobile.door.room.RoomDatabaseJdbcImplHelper@41f15eb5 is closed! at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.assertNotClosed(RoomDatabaseJdbcImplHelperCommon.kt:96) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:103) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.access$useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:21) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:237) at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33) at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104) at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693) Apr 27, 2025 1:54:50 PM com.ustadmobile.core.util.NapierAntilogJvm performLog SEVERE: SEVERE DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - Exception running SELECT OfflineItem.*, TransferJob.*, (SELECT SUM(TransferJobItem.tjTotalSize) FROM TransferJobItem WHERE TransferJobItem.tjiTjUid = TransferJob.tjUid) AS totalSize, (SELECT SUM(TransferJobItem.tjTransferred) FROM TransferJobItem WHERE TransferJobItem.tjiTjUid = TransferJob.tjUid) AS transferred , CAST(OfflineItem.oiActive AS INTEGER) = 1 AND (SELECT EXISTS( SELECT CompletedJob.tjUid FROM TransferJob CompletedJob WHERE CompletedJob.tjTableId = 738 AND CompletedJob.tjEntityUid IN (SELECT ContentEntryVersion.cevUid FROM ContentEntryVersion WHERE ContentEntryVersion.cevContentEntryUid = ?) AND CompletedJob.tjStatus = 21 AND CompletedJob.tjType = 2 AND CompletedJob.tjTimeCreated >= OfflineItem.oiLct LIMIT 1 )) AS readyForOffline, NULL AS latestErrorStr FROM OfflineItem LEFT JOIN TransferJob ON TransferJob.tjUid = (SELECT TransferJob.tjUid FROM TransferJob WHERE TransferJob.tjTableId = 738 AND TransferJob.tjEntityUid IN (SELECT ContentEntryVersion.cevUid FROM ContentEntryVersion WHERE ContentEntryVersion.cevContentEntryUid = ?) AND TransferJob.tjStatus < 21 ORDER BY TransferJob.tjTimeCreated DESC LIMIT 1) WHERE OfflineItem.oiNodeId = ? AND OfflineItem.oiContentEntryUid = ? ORDER BY OfflineItem.oiLct DESC LIMIT 1 java.lang.IllegalStateException: com.ustadmobile.door.room.RoomDatabaseJdbcImplHelper@41f15eb5 is closed! at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.assertNotClosed(RoomDatabaseJdbcImplHelperCommon.kt:96) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:103) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.access$useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:21) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:237) at _COROUTINE._BOUNDARY._(CoroutineDebugging.kt:42) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:235) at com.ustadmobile.door.ext.DoorDatabaseExtJvmJsKt.prepareAndUseStatementAsync(DoorDatabaseExtJvmJs.kt:24) at com.ustadmobile.core.db.dao.OfflineItemDao_JdbcImpl$findByContentEntryUid$1.invokeSuspend(OfflineItemDao_JdbcImpl.kt:64) at com.ustadmobile.door.flow.DoorFlowKt$doorFlow$1$1.invokeSuspend(DoorFlow.kt:40) Caused by: java.lang.IllegalStateException: com.ustadmobile.door.room.RoomDatabaseJdbcImplHelper@41f15eb5 is closed! at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.assertNotClosed(RoomDatabaseJdbcImplHelperCommon.kt:96) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:103) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon.access$useNewConnectionAsyncInternal(RoomDatabaseJdbcImplHelperCommon.kt:21) at com.ustadmobile.door.room.RoomDatabaseJdbcImplHelperCommon$useConnectionAsync$2$2.invokeSuspend(RoomDatabaseJdbcImplHelperCommon.kt:237) at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33) at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:104) at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:585) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:802) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:706) at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:693) Apr 27, 2025 1:54:50 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - Closed HikariDataSource connection pool ]]>