= 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@5a25058d 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@5a25058d 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) May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog INFO: INFO DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog INFO: INFO DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[UserSession] May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/localhost_localdomain_43237_.sqlite] - useNewConnectionAsyncInternal connection #14 : SQLite Change Tracker: Changed tables=[PendingRepositorySession] May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog WARNING: WARNING DoorLog - [DoorRepositoryReplicationClient - http://localhost.localdomain:43237/UmAppDatabase/ - endpoint=http://localhost.localdomain:43237/UmAppDatabase/] getRemoteNodeId : exception getting remote node id java.lang.IllegalStateException: [DoorRepositoryReplicationClient - http://localhost.localdomain:43237/UmAppDatabase/ - endpoint=http://localhost.localdomain:43237/UmAppDatabase/] getRemoteNodeId : server did not provide node id at com.ustadmobile.door.replication.DoorRepositoryReplicationClient$1.invokeSuspend(DoorRepositoryReplicationClient.kt:275) 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) May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog WARNING: WARNING DoorLog - [DoorRepositoryReplicationClient - http://localhost.localdomain:43237/UmAppDatabase/ - endpoint=http://localhost.localdomain:43237/UmAppDatabase/] getRemoteNodeId : exception getting remote node id java.lang.IllegalStateException: [DoorRepositoryReplicationClient - http://localhost.localdomain:43237/UmAppDatabase/ - endpoint=http://localhost.localdomain:43237/UmAppDatabase/] getRemoteNodeId : server did not provide node id at com.ustadmobile.door.replication.DoorRepositoryReplicationClient$1.invokeSuspend(DoorRepositoryReplicationClient.kt:275) 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) May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : SQLite Change Tracker: Changed tables=[Person, PersonGroup, PersonGroupMember, ScopedGrant, UserSession] May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[SystemPermission] May 21, 2025 12:47:14 PM com.ustadmobile.core.util.NapierAntilogJvm performLog FINE: FINER DoorLog - Closed HikariDataSource connection pool ]]>