m14:11:57,485 |-INFO in ch.qos.logback.classic.LoggerContext[default] - This is logback-classic version 1.5.6
‡14:11:57,486 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - No custom configurators were discovered as a service.
£14:11:57,486 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.joran.SerializedModelConfigurator
±14:11:57,487 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.joran.SerializedModelConfigurator
s14:11:57,488 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.scmo]
n14:11:57,488 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.scmo]
Õ14:11:57,493 |-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
Ÿ14:11:57,493 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Trying to configure with ch.qos.logback.classic.util.DefaultJoranConfigurator
­14:11:57,493 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - Constructed configurator of type class ch.qos.logback.classic.util.DefaultJoranConfigurator
r14:11:57,494 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
õ14:11:57,495 |-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/app-ktor-server/build/resources/main/logback.xml]
s14:11:57,559 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - Processing appender named [FILE]
ª14:11:57,559 |-INFO in ch.qos.logback.core.model.processor.AppenderModelHandler - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
j14:11:57,575 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1280603381 - No compression will be used
¡14:11:57,576 |-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
¹14:11:57,578 |-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'.
k14:11:57,578 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Roll-over at midnight.
‡14:11:57,579 |-INFO in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - Setting initial period to 2025-07-11T10:58:46.145Z
£14:11:57,579 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - SizeAndTimeBasedFNATP is deprecated. Use SizeAndTimeBasedRollingPolicy instead
·14:11:57,579 |-WARN in ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP@2f4205be - For more information see http://logback.qos.ch/manual/appenders.html#SizeAndTimeBasedRollingPolicy
µ14:11:57,582 |-INFO in ch.qos.logback.core.model.processor.ImplicitModelHandler - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
}14:11:57,594 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: ./log//ustad-server.log
14:11:57,594 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [./log//ustad-server.log]
}14:11:57,594 |-INFO in ch.qos.logback.classic.model.processor.RootLoggerModelHandler - Setting level of ROOT logger to TRACE
…14:11:57,595 |-INFO in ch.qos.logback.core.model.processor.AppenderRefModelHandler - Attaching appender named [FILE] to Logger[ROOT]
‡14:11:57,595 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [org.eclipse.jetty] to INFO
~14:11:57,595 |-INFO in ch.qos.logback.classic.model.processor.LoggerModelHandler - Setting level of logger [io.netty] to INFO
m14:11:57,595 |-INFO in ch.qos.logback.core.model.processor.DefaultProcessor@54e22bdd - End of configuration.
Š14:11:57,595 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@3bd418e4 - Registering current configuration as safe fallback point
Ú14:11:57,595 |-INFO in ch.qos.logback.classic.util.ContextInitializer@319bc845 - ch.qos.logback.classic.util.DefaultJoranConfigurator.configure() call lasted 102 milliseconds. ExecutionStatus=DO_NOT_INVOKE_NEXT_IF_ANY

 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 rFINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] : created tables
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:58 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(?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:58 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]
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:58 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:58 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]
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:58 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(?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:58 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]
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=false
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:58 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:58 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]
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  committed changes
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=true
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 •FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=false
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:58 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(?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:58 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]
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  committed changes
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
 HJul 14, 2025 2:11:58 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 •FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=true
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 œFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Person WHERE personUid = ?"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 –FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 •FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 •FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=true
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 –FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ^FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SystemPermission
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 •FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=true
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete
 	HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 	\FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables
 	HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 	^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete
 	HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 	TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: RequestedEntry
 
HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 
tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
 
HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 
{FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SyncNode, Site, PersonAuth2, SystemPermission
 
HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 
NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
 
HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 
JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 tINFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 TFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode, Site
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 JFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 QFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: UserSession
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 VFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SystemPermission
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 UFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: StatementEntity
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 LFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Report
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 \FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ^INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1  - start readOnly=true
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ‹FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 : end transaction #1
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2  - start readOnly=true
 HJul 14, 2025 2:11:59 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))))
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ‹FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : end transaction #2
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ~FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT auth
             FROM DoorNode
             WHERE nodeId = ?
             "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 DFINE: [DEBUG] DoorLog - NodeIdAndAuthCache: New Node connected: 43 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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(?, ?, ?)"
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 NFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: DoorNode
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ^FINE: [DEBUG] NodeIdAuthCache$verify - NodeIdAndAuthCache: Fire new node event to 0 listeners
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=true
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 œFINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Report WHERE reportUid = ?"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¤FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¯FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 „FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
 HJul 14, 2025 2:11:59 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))))
     "
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 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,
 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  "
 HJul 14, 2025 2:11:59 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 = ?
     "
 HJul 14, 2025 2:11:59 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]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŸFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 £FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9  - start readOnly=true
 HJul 14, 2025 2:11:59 PM 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 (?) 
     "
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ¡FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ŽFINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ™FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 nFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] creating SQLite triggers
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ]FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "
 &        DELETE FROM ReportQueryResult
           WHERE rqrReportUid = ?
            AND rqrTimeZone = ?
     "
 HJul 14, 2025 2:11:59 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(?, ?, ?, ?, ?, ?, ?, ?, ?)"
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ®FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[ReportQueryResult]
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 kFINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] found 0 new events = 
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ‰FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3  committed changes
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 ‹FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : end transaction #3
 HJul 14, 2025 2:11:59 PM io.github.aakira.napier.DebugAntilog performLog
 WFINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult