m11:34:22,683 |-INFO in ch.qos.logback.classic.LoggerContext[default] - This is logback-classic version 1.5.6 11:34:22,684 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - No custom configurators were discovered as a service. 11:34:22,684 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.joran.SerializedModelConfigurator 11:34:22,684 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.joran.SerializedModelConfigurator s11:34:22,685 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.scmo] n11:34:22,685 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.scmo] 11:34:22,689 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - ch.qos.logback.classic.joran.SerializedModelConfigurator.configure() call lasted 1 milliseconds. ExecutionStatus=INVOKE_NEXT_IF_ANY 11:34:22,689 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.util.DefaultJoranConfigurator 11:34:22,689 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.util.DefaultJoranConfigurator r11:34:22,689 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml] 11:34:22,690 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/home/jenkins/.jenkins/workspace/dev-customizable-reports-draw-graph-from-data-output-End-To-End-Tests/app-ktor-server/build/resources/main/logback.xml] s11:34:22,736 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - Processing appender named [FILE] 11:34:22,736 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender] j11:34:22,750 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1280603381 - No compression will be used 11:34:22,751 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1280603381 - Will use the pattern ./log//ustad-server.%d{yyyy-MM-dd}.%i.log for the active file 11:34:22,752 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - The date pattern is 'yyyy-MM-dd' from file name pattern './log//ustad-server.%d{yyyy-MM-dd}.%i.log'. k11:34:22,752 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Roll-over at midnight. 11:34:22,753 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Setting initial period to 2025-07-28T09:34:22.396Z 11:34:22,753 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead 11:34:22,753 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - For more information see http://logback.qos.ch/manual/appenders.html#SizeAndTimeBasedRollingPolicy 11:34:22,755 |-INFO in ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property }11:34:22,761 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: ./log//ustad-server.log 11:34:22,761 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [./log//ustad-server.log] }11:34:22,761 |-INFO in ch.qos.logback.classic.model.processor.RootLoggerModelHandler - Setting level of ROOT logger to TRACE 11:34:22,762 |-INFO in ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching appender named [FILE] to Logger[ROOT] 11:34:22,762 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [org.eclipse.jetty] to INFO ~11:34:22,762 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [io.netty] to INFO m11:34:22,762 |-INFO in ch.qos.logback.core.model.processor.DefaultProcessor@54e22bdd - End of configuration. 11:34:22,762 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@3bd418e4 - Registering current configuration as safe fallback point 11:34:22,762 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - ch.qos.logback.classic.util.DefaultJoranConfigurator.configure() call lasted 73 milliseconds. ExecutionStatus=DO_NOT_INVOKE_NEXT_IF_ANY  IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog rFINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] : created tables IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO PersonGroup (groupUid, groupMasterCsn, groupLocalCsn, groupLastChangedBy, groupLct, groupName, groupActive, personGroupFlag) VALUES(?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[PersonGroup] IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO Person (personUid, username, firstNames, lastName, emailAddr, phoneNum, gender, active, isPersonalAccount, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : SQLite Change Tracker: Changed tables=[Person] IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO PersonGroupMember (groupMemberUid, groupMemberActive, groupMemberPersonUid, groupMemberGroupUid, groupMemberMasterCsn, groupMemberLocalCsn, groupMemberLastChangedBy, groupMemberLct) VALUES(?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[PersonGroupMember] IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=false IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO ScopedGrant (sgUid, sgPcsn, sgLcsn, sgLcb, sgLct, sgTableId, sgEntityUid, sgPermissions, sgGroupUid, sgIndex, sgFlags) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : SQLite Change Tracker: Changed tables=[ScopedGrant] IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 committed changes IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=true IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=false IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO PersonAuth2 (pauthUid, pauthMechanism, pauthAuth, pauthLcsn, pauthPcsn, pauthLcb, pauthLct) VALUES(?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : SQLite Change Tracker: Changed tables=[PersonAuth2] IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 committed changes IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=true IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "  SELECT PersonAuth2.*  FROM PersonAuth2 F JOIN Person ON PersonAuth2.pauthUid = Person.personUid # WHERE Person.username = ?  " IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 - start readOnly=true IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Person WHERE personUid = ?" IJul 29, 2025 11:34:23 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO PersonGroup (groupUid, groupMasterCsn, groupLocalCsn, groupLastChangedBy, groupLct, groupName, groupActive, personGroupFlag) VALUES(?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[PersonGroup] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO Person (personUid, username, firstNames, lastName, emailAddr, phoneNum, gender, active, isPersonalAccount, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : SQLite Change Tracker: Changed tables=[Person] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO PersonGroupMember (groupMemberUid, groupMemberActive, groupMemberPersonUid, groupMemberGroupUid, groupMemberMasterCsn, groupMemberLocalCsn, groupMemberLastChangedBy, groupMemberLct) VALUES(?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[PersonGroupMember] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO ScopedGrant (sgUid, sgPcsn, sgLcsn, sgLcb, sgLct, sgTableId, sgEntityUid, sgPermissions, sgGroupUid, sgIndex, sgFlags) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : SQLite Change Tracker: Changed tables=[ScopedGrant] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO PersonAuth2 (pauthUid, pauthMechanism, pauthAuth, pauthLcsn, pauthPcsn, pauthLcb, pauthLct) VALUES(?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : SQLite Change Tracker: Changed tables=[PersonAuth2] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "  SELECT PersonAuth2.*  FROM PersonAuth2 F JOIN Person ON PersonAuth2.pauthUid = Person.personUid # WHERE Person.username = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO Person (personUid, username, firstNames, lastName, emailAddr, phoneNum, gender, active, isPersonalAccount, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO SystemPermission (spUid, spToPersonUid, spToGroupUid, spPermissionsFlag, spLastModified, spIsDeleted) VALUES(?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[Person, SystemPermission] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ^FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SystemPermission IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO PersonAuth2 (pauthUid, pauthMechanism, pauthAuth, pauthLcsn, pauthPcsn, pauthLcb, pauthLct) VALUES(?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[PersonAuth2] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " N SELECT PersonAuth2.* FROM PersonAuth2 where PersonAuth2.pauthUid = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete  IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog  \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables  IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog  ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete  IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog  TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: RequestedEntry IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog {FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SyncNode, Site, PersonAuth2, SystemPermission IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode, Site IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO UserSession (usUid, usPcsn, usLcsn, usLcb, usLct, usPersonUid, usClientNodeId, usStartTime, usEndTime, usStatus, usReason, usAuth, usSessionType) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[UserSession] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: UserSession IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO SystemPermission (spUid, spToPersonUid, spToGroupUid, spPermissionsFlag, spLastModified, spIsDeleted) VALUES(?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : SQLite Change Tracker: Changed tables=[SystemPermission] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog VFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SystemPermission IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR IGNORE INTO StatementEntity (statementIdHi, statementIdLo, statementActorPersonUid, statementVerbUid, statementObjectType, statementObjectUid1, statementObjectUid2, statementActorUid, authorityActorUid, teamUid, resultCompletion, resultSuccess, resultScoreScaled, resultScoreRaw, resultScoreMin, resultScoreMax, resultDuration, resultResponse, timestamp, stored, contextRegistrationHi, contextRegistrationLo, contextRegistrationHash, contextPlatform, contextStatementRefIdHi, contextStatementRefIdLo, contextInstructorActorUid, statementLct, extensionProgress, completionOrProgress, statementContentEntryUid, statementLearnerGroupUid, statementClazzUid, statementCbUid, statementDoorNode, isSubStatement) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[StatementEntity] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog UFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: StatementEntity IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Report IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ]FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare " # SELECT ReportQueryResult.* ! FROM ReportQueryResult 3 WHERE ReportQueryResult.rqrReportUid = ? 1 AND ReportQueryResult.rqrTimeZone = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ]FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "  SELECT COALESCE( 9 (SELECT ReportQueryResult.rqrLastModified ) FROM ReportQueryResult : WHERE ReportQueryResult.rqrReportUid = ? 9 AND ReportQueryResult.rqrTimeZone = ? " LIMIT 1), 0) >=  (SELECT MAX(?, . (SELECT COALESCE( E (SELECT Report.reportLastModTime 3 FROM Report I WHERE Report.reportUid = ?), 0))))  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ~FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT auth  FROM DoorNode  WHERE nodeId = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog DFINE: [DEBUG] DoorLog - NodeIdAndAuthCache: New Node connected: 43 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO DoorNode(nodeId, auth, rel) VALUES(?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : SQLite Change Tracker: Changed tables=[DoorNode] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: DoorNode IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ^FINE: [DEBUG] NodeIdAuthCache$verify - NodeIdAndAuthCache: Fire new node event to 0 listeners IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "  SELECT COUNT(*)  FROM UserSession + WHERE UserSession.usPersonUid = ? ( AND UserSession.usStatus = 1 . AND UserSession.usClientNodeId = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Report WHERE reportUid = ?" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "  SELECT COALESCE( 9 (SELECT ReportQueryResult.rqrLastModified ) FROM ReportQueryResult : WHERE ReportQueryResult.rqrReportUid = ? 9 AND ReportQueryResult.rqrTimeZone = ? " LIMIT 1), 0) >=  (SELECT MAX(?, . (SELECT COALESCE( E (SELECT Report.reportLastModTime 3 FROM Report I WHERE Report.reportUid = ?), 0))))  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " & DELETE FROM ReportQueryResult  WHERE rqrReportUid = ?  AND rqrTimeZone = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO ReportQueryResult(rqrReportUid, rqrLastModified, :rqrReportSeriesUid, rqrLastValidated, rqrXAxis, rqrYAxis, rqrSubgroup, rqrTimeZone)  6WITH AllLearningRecordsPermission(hasPermission) AS (  SELECT EXISTS(  SELECT 1 $ FROM SystemPermission 6 WHERE SystemPermission.spToPersonUid = ? ? AND (SystemPermission.spPermissionsFlag & 128))  AS hasPermission ),  $ClazzesWithPermission(clazzUid) AS( ' SELECT Clazz.clazzUid AS clazzUid  FROM Clazz I WHERE NOT (SELECT hasPermission FROM AllLearningRecordsPermission) * AND Clazz.clazzOwnerPersonUid = ?  UNION 5 SELECT CoursePermission.cpClazzUid AS clazzUid  FROM CoursePermission J WHERE NOT (SELECT hasPermission FROM AllLearningRecordsPermission) 5 AND ( CoursePermission.cpToPersonUid = ? W OR ((CoursePermission.cpToEnrolmentRole, CoursePermission.cpClazzUid) IN = (SELECT ClazzEnrolment.clazzEnrolmentRole, @ ClazzEnrolment.clazzEnrolmentClazzUid / FROM ClazzEnrolment H WHERE ClazzEnrolment.clazzEnrolmentPersonUid = ?))) E AND (CoursePermission.cpPermissionsFlag & 128) > 0 ),ResultSourceCte AS ( 3 SELECT SUM(ResultSource.resultDuration) AS yAxis, Ostrftime('%Y-%m-%d', (ResultSource.timestamp + 0)/1000, 'unixepoch') AS xAxis, Qstrftime('%Y-%m-%d', (ResultSource.timestamp + 0)/1000, 'unixepoch') AS subgroup "FROM StatementEntity ResultSource -WHERE ResultSource.timestamp BETWEEN ? AND ? =AND ( (SELECT AllLearningRecordsPermission.hasPermission 0 FROM AllLearningRecordsPermission) 4 OR ResultSource.statementActorPersonUid = ? - OR ResultSource.statementClazzUid IN 1 (SELECT ClazzesWithPermission.clazzUid ) FROM ClazzesWithPermission) ( ) GROUP BY xAxis, subgroup ) SELECT ? AS rqrReportUid,  ? AS rqrLastModified,  ? AS rqrReportSeriesUid,  ? AS rqrLastValidated, * ResultSourceCte.xAxis AS rqrXAxis, * ResultSourceCte.yAxis AS rqrYAxis, 0 ResultSourceCte.subgroup AS rqrSubgroup,  ? AS rqrSubgroup  FROM ResultSourceCte " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " # SELECT ReportQueryResult.* ! FROM ReportQueryResult 3 WHERE ReportQueryResult.rqrReportUid = ? 1 AND ReportQueryResult.rqrTimeZone = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : SQLite Change Tracker: Changed tables=[ReportQueryResult] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 - start readOnly=true IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " / SELECT Clazz.clazzUid, Clazz.clazzName  FROM Clazz & WHERE Clazz.clazzUid IN (?)  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog nFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] creating SQLite triggers IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog ]FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare " & DELETE FROM ReportQueryResult  WHERE rqrReportUid = ?  AND rqrTimeZone = ?  " IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "INSERT INTO ReportQueryResult (rqrUid, rqrReportUid, rqrLastModified, rqrLastValidated, rqrReportSeriesUid, rqrXAxis, rqrYAxis, rqrSubgroup, rqrTimeZone) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)" IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[ReportQueryResult] IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog kFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] found 0 new events = IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 committed changes IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJul 29, 2025 11:34:24 AM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult