Class com.ustadmobile.lib.rest.PersonAuthRegisterRouteTest

all > com.ustadmobile.lib.rest > PersonAuthRegisterRouteTest
tests
failures
ignored
1.230s
duration
100%
successful
Tests
Standard error
Tests

Test	Duration	Result
givenInvalidCredentials_whenLoginCalled_thenShouldRespondForbidden	0.132s	passed
givenRegisterPersonWithAuth_whenRegisterCalled_thenShouldGenerateAuth	0.114s	passed
givenValidCredentials_whenLoginCalled_thenShouldReturnAccount	0.984s	passed
Standard error

Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] : created tables
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
Apr 26, 2025 1:54:15 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:15 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(?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "
        SELECT PersonAuth2.*
          FROM PersonAuth2
               JOIN Person ON PersonAuth2.pauthUid = Person.personUid
         WHERE Person.username = ?
    "
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Person WHERE personUid = ?"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #9 : end transaction #9
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroup
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonGroupMember
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ScopedGrant
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "
        SELECT PersonAuth2.*
          FROM PersonAuth2
               JOIN Person ON PersonAuth2.pauthUid = Person.personUid
         WHERE Person.username = ?
    "
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, PersonGroup, PersonGroupMember, SyncNode, Site, ScopedGrant, PersonAuth2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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, dateOfBirth, personAddress, personOrgId, personGroupUid, personLct, personCountry, personType, personMasterChangeSeqNum, personLocalChangeSeqNum, personLastChangedBy, admin, personNotes, fatherName, fatherNumber, motherName, motherNum) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Person, SystemPermission
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT authSalt FROM Site LIMIT 1"
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Apr 26, 2025 1:54:16 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(?, ?, ?, ?, ?, ?, ?)"
Apr 26, 2025 1:54:16 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]
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: PersonAuth2
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=true
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "
        SELECT PersonAuth2.*
          FROM PersonAuth2
         WHERE PersonAuth2.pauthUid = ? 
    "
Apr 26, 2025 1:54:16 PM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4