m12:38:10,413 |-INFO in ch.qos.logback.classic.LoggerContext[default] - This is logback-classic version 1.5.6 12:38:10,414 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - No custom configurators were discovered as a service. 12:38:10,414 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.joran.SerializedModelConfigurator 12:38:10,415 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.joran.SerializedModelConfigurator s12:38:10,415 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.scmo] n12:38:10,416 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.scmo] 12:38:10,419 |-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 12:38:10,419 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.util.DefaultJoranConfigurator 12:38:10,419 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.util.DefaultJoranConfigurator r12:38:10,420 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml] 12:38:10,421 |-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] s12:38:10,468 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - Processing appender named [FILE] 12:38:10,468 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender] j12:38:10,483 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1280603381 - No compression will be used 12:38:10,483 |-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 12:38:10,485 |-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'. k12:38:10,485 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Roll-over at midnight. 12:38:10,485 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Setting initial period to 2025-06-11T05:38:06.278Z 12:38:10,485 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead 12:38:10,485 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - For more information see http://logback.qos.ch/manual/appenders.html#SizeAndTimeBasedRollingPolicy 12:38:10,487 |-INFO in ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property }12:38:10,494 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: ./log//ustad-server.log 12:38:10,494 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [./log//ustad-server.log] }12:38:10,494 |-INFO in ch.qos.logback.classic.model.processor.RootLoggerModelHandler - Setting level of ROOT logger to TRACE 12:38:10,494 |-INFO in ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching appender named [FILE] to Logger[ROOT] 12:38:10,495 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [org.eclipse.jetty] to INFO ~12:38:10,495 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [io.netty] to INFO m12:38:10,495 |-INFO in ch.qos.logback.core.model.processor.DefaultProcessor@54e22bdd - End of configuration. 12:38:10,495 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@3bd418e4 - Registering current configuration as safe fallback point 12:38:10,495 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - ch.qos.logback.classic.util.DefaultJoranConfigurator.configure() call lasted 76 milliseconds. ExecutionStatus=DO_NOT_INVOKE_NEXT_IF_ANY  IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog rFINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] : created tables IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=true IJun 11, 2025 12:38:11 PM 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 = ?  " IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Person WHERE personUid = ?" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=true IJun 11, 2025 12:38:11 PM 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 = ?  " IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog ^FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SystemPermission IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=true IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1" IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:11 PM 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(?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:11 PM 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] IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=true IJun 11, 2025 12:38:11 PM 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 = ?  " IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables IJun 11, 2025 12:38:11 PM io.github.aakira.napier.DebugAntilog performLog ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete  IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog  \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables  IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog  ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete  IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog  TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: RequestedEntry IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog {FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SyncNode, Site, PersonAuth2, SystemPermission IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode, Site IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:12 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:12 PM 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] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: UserSession IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:12 PM 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(?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:12 PM 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] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog VFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SystemPermission IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:12 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:12 PM 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] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog UFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: StatementEntity IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Report IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 - start readOnly=true IJun 11, 2025 12:38:12 PM 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 = ?  " IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 : end transaction #1 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 - start readOnly=true IJun 11, 2025 12:38:12 PM 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))))  " IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : end transaction #2 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=true IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog ~FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT auth  FROM DoorNode  WHERE nodeId = ?  " IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog DFINE: [DEBUG] DoorLog - NodeIdAndAuthCache: New Node connected: 43 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO DoorNode(nodeId, auth, rel) VALUES(?, ?, ?)" IJun 11, 2025 12:38:12 PM 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] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: DoorNode IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog ^FINE: [DEBUG] NodeIdAuthCache$verify - NodeIdAndAuthCache: Fire new node event to 0 listeners IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=true IJun 11, 2025 12:38:12 PM 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 = ?  " IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Report WHERE reportUid = ?" IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers IJun 11, 2025 12:38:12 PM 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))))  " IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog sFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " & DELETE FROM ReportQueryResult  WHERE rqrReportUid = ?  AND rqrTimeZone = ?  " IJun 11, 2025 12:38:12 PM 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, '' 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 " IJun 11, 2025 12:38:12 PM 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 = ?  " IJun 11, 2025 12:38:12 PM 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] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 - start readOnly=false IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog nFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] creating SQLite triggers IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog ]FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare " & DELETE FROM ReportQueryResult  WHERE rqrReportUid = ?  AND rqrTimeZone = ?  " IJun 11, 2025 12:38:12 PM 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(?, ?, ?, ?, ?, ?, ?, ?, ?)" IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[ReportQueryResult] IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog kFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] found 0 new events = IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 committed changes IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : end transaction #3 IJun 11, 2025 12:38:12 PM io.github.aakira.napier.DebugAntilog performLog WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult