2026-08-10T16:37:14.251Z INFO 369 --- [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.accounts.HsAccountRepositoryIntegrationTest]: HsAccountRepositoryIntegrationTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T16:37:14.308Z INFO 369 --- [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.accounts.HsAccountRepositoryIntegrationTest
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v3.5.5)
2026-08-10T16:37:14.467Z INFO 369 --- [ Test worker] h.h.a.HsAccountRepositoryIntegrationTest : Starting HsAccountRepositoryIntegrationTest using Java 21.0.11 with PID 369 (started by root in /home/tallyman/hs.hsadmin.ng/.git/gittally/worktrees/mihoe_ci-build-performance-improvements-8da83bafd50c)
2026-08-10T16:37:14.468Z INFO 369 --- [ Test worker] h.h.a.HsAccountRepositoryIntegrationTest : No active profile set, falling back to 1 default profile: "default"
2026-08-10T16:37:14.870Z INFO 369 --- [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2026-08-10T16:37:15.041Z INFO 369 --- [ Test worker] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 169 ms. Found 35 JPA repository interfaces.
2026-08-10T16:37:16.736Z INFO 369 --- [ Test worker] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Starting...
2026-08-10T16:37:16.849Z INFO 369 --- [ Test worker] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Added connection org.testcontainers.jdbc.ConnectionWrapper@40116ff5
2026-08-10T16:37:16.849Z INFO 369 --- [ Test worker] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Start completed.
2026-08-10T16:37:19.333Z WARN 369 --- [ Test worker] liquibase.executor : Context defined as: testing currentSubjectUuid, , hsh-fran_superuser, []
2026-08-10T16:37:19.333Z WARN 369 --- [ Test worker] liquibase.executor : Context defined as: testing currentSubjectUuid, , hsh-alex_superuser, []
2026-08-10T16:37:19.594Z INFO 369 --- [ Test worker] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default]
2026-08-10T16:37:19.602Z INFO 369 --- [ Test worker] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled
2026-08-10T16:37:19.617Z INFO 369 --- [ Test worker] org.hibernate.orm.connections.pooling : HHH10001005: Database info:
Database JDBC URL [Connecting through datasource 'proxyDataSourceDecorator [net.ttddyy.dsproxy.support.ProxyDataSource] -> dataSource [com.zaxxer.hikari.HikariDataSource]']
Database driver: undefined/unknown
Database version: 15.5
Autocommit mode: undefined/unknown
Isolation level: undefined/unknown
Minimum pool size: undefined/unknown
Maximum pool size: undefined/unknown
2026-08-10T16:37:19.650Z INFO 369 --- [ Test worker] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer
2026-08-10T16:37:19.810Z WARN 369 --- [ Test worker] o.h.boot.model.internal.ToOneBinder : HHH000491: 'net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity.partner' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:37:19.811Z WARN 369 --- [ Test worker] o.h.boot.model.internal.ToOneBinder : HHH000491: 'net.hostsharing.hsadminng.hs.office.debitor.HsOfficeDebitorEntity.refundBankAccount' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:37:19.826Z WARN 369 --- [ Test worker] o.h.boot.model.internal.ToOneBinder : HHH000491: 'net.hostsharing.hsadminng.hs.office.partner.HsOfficePartnerRbacEntity.details' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:37:19.835Z WARN 369 --- [ Test worker] o.h.boot.model.internal.ToOneBinder : HHH000491: 'net.hostsharing.hsadminng.hs.office.partner.HsOfficePartnerRealEntity.details' uses both @NotFound and FetchType.LAZY. @ManyToOne and @OneToOne associations mapped with @NotFound are forced to EAGER fetching.
2026-08-10T16:37:20.440Z INFO 369 --- [ Test worker] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration)
2026-08-10T16:37:20.446Z INFO 369 --- [ Test worker] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2026-08-10T16:37:22.190Z INFO 369 --- [ Test worker] h.h.a.HsAccountRepositoryIntegrationTest : Started HsAccountRepositoryIntegrationTest in 7.873 seconds (process running for 56.921)
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: select max(roe1_0.serialid) from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
shouldFindByUuidUsingTestData(): TOTAL OBJECT COUNT (initial): null -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: select hae1_0.uuid,hae1_0.global_gid,hae1_0.global_uid,hae1_0.person_uuid,hae1_0.version from hs_accounts.account hae1_0 where hae1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.uuid=?
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
shouldFindByUuidUsingTestData(): TOTAL OBJECT COUNT (after): null -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
representativeShouldFindOwnAndRepresentedAccountByCurrentSubject(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where ? is null or hopre1_0.tradename like (cast(? as varchar)||'%') escape '' or hopre1_0.givenname like (cast(? as varchar)||'%') escape '' or hopre1_0.familyname like (cast(? as varchar)||'%') escape ''
Hibernate: insert into hs_office.contact (caption,emailaddresses,phonenumbers,postaladdress,version,uuid) values (?,?,?,?,?,?)
Hibernate: insert into hs_office.relation (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: insert into rbac.subject_rv (uuid, name, organization, type) values( ?, ?, ?, cast(? as rbac.SubjectType))
toCleanup(class net.hostsharing.hsadminng.rbac.subject.RbacSubjectEntity, 82d0b88e-6110-44da-b9e2-2404dfd19820
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.uuid=?
toCleanup(class net.hostsharing.hsadminng.hs.accounts.HsAccountEntity, 82d0b88e-6110-44da-b9e2-2404dfd19820
Hibernate: insert into hs_accounts.account (global_gid,global_uid,person_uuid,version,uuid) values (?,?,?,?,?)
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: WITH RECURSIVE
same_person AS (
SELECT own_account.person_uuid
FROM hs_accounts.account own_account
WHERE own_account.uuid = rbac.currentSubjectUuid()
),
represented_persons AS (
SELECT relation.anchorUuid person_uuid
FROM hs_office.relation relation
WHERE relation.type = 'REPRESENTATIVE'
AND relation.holderUuid IN (SELECT person_uuid FROM same_person)
)
SELECT DISTINCT account.*
FROM hs_accounts.account account
WHERE account.person_uuid IN (SELECT person_uuid FROM same_person)
OR account.person_uuid IN (SELECT person_uuid FROM represented_persons)
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_accounts.account WHERE uuid=?
DELETING temporary HsAccountEntity#82d0b88e-6110-44da-b9e2-2404dfd19820 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
representativeShouldFindOwnAndRepresentedAccountByCurrentSubject(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
shouldSaveAccount(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
toCleanup(class net.hostsharing.hsadminng.hs.accounts.HsAccountEntity, b44f1024-21e8-50c6-bacc-e8e9bcbf3a16
Hibernate: insert into hs_accounts.account (global_gid,global_uid,person_uuid,version,uuid) values (?,?,?,?,?)
Hibernate: select hae1_0.uuid,hae1_0.global_gid,hae1_0.global_uid,hae1_0.person_uuid,hae1_0.version from hs_accounts.account hae1_0 where hae1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.uuid=?
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.uuid=?
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_accounts.account WHERE uuid=?
DELETING temporary HsAccountEntity#b44f1024-21e8-50c6-bacc-e8e9bcbf3a16 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
shouldSaveAccount(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
nextFreeGlobalIdSkipsUsedNumbersInRange(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: SELECT hs_accounts.next_free_global_id()
toCleanup(class net.hostsharing.hsadminng.hs.accounts.HsAccountEntity, b44f1024-21e8-50c6-bacc-e8e9bcbf3a16
Hibernate: insert into hs_accounts.account (global_gid,global_uid,person_uuid,version,uuid) values (?,?,?,?,?)
Hibernate: SELECT hs_accounts.next_free_global_id()
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: DELETE FROM hs_accounts.account WHERE uuid=?
DELETING temporary HsAccountEntity#b44f1024-21e8-50c6-bacc-e8e9bcbf3a16 deleted 0 rows
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
nextFreeGlobalIdSkipsUsedNumbersInRange(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
historizationIsAvailable(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: set local hsadminng.tx_history_timestamp to '2026-08-09 16:37:30.794486919';
Hibernate: set local hsadminng.tx_history_txid to '';
Hibernate: select * from hs_accounts.account_hv
Hibernate: set local hsadminng.tx_history_timestamp to '2026-08-10 16:37:30.802113623';
Hibernate: set local hsadminng.tx_history_txid to '';
Hibernate: select * from hs_accounts.account_hv
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
historizationIsAvailable(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
shouldRejectAccountForGroupSubject(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: insert into rbac.subject_rv (uuid, name, organization, type) values( ?, ?, ?, cast(? as rbac.SubjectType))
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.uuid=?
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.uuid=?
Hibernate: insert into hs_accounts.account (global_gid,global_uid,person_uuid,version,uuid) values (?,?,?,?,?)
2026-08-10T16:37:32.215Z WARN 369 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T16:37:32.215Z ERROR 369 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: [400] subject 4e7beddf-caa5-46b2-944e-98fb9a85afdd must be of type USER, but is GROUP
Where: PL/pgSQL function rbac.assert_subject_type(uuid,rbac.subjecttype) line 14 at RAISE
SQL statement "SELECT rbac.assert_subject_type(new.uuid, 'USER'::rbac.SubjectType)"
PL/pgSQL function hs_accounts.assert_account_subject_is_user_tf() line 3 at PERFORM
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
shouldRejectAccountForGroupSubject(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
ContextBasedTestWithCleanup.retrieveInitialTestData
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rre1_0.uuid,rre1_0.objectidname,rre1_0.objecttable,rre1_0.objectuuid,rre1_0.objectTable||'#'||rre1_0.objectIdName||':'||rre1_0.roleType,rre1_0.objectTable||'#'||cast(rre1_0.objectUuid as varchar)||':'||rre1_0.roleType,rre1_0.roletype from rbac.role_rv rre1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rge1_0.grantedroleuuid,rge1_0.subjectuuid,rge1_0.assumed,rge1_0.grantedbyroleidname,rge1_0.grantedbyroleuuid,rge1_0.grantedroleidname,rge1_0.grantedroletype,rge1_0.username,rge1_0.objectidname,rge1_0.objecttable,rge1_0.objectuuid from rbac.grant_rv rge1_0
Hibernate: select count(*) from rbac.object roe1_0
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0
globalAdminShouldFindOnlyOwnAccountByCurrentSubject(): TOTAL OBJECT COUNT (initial): 210 -> 210
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.name=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.givenname=?
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: WITH RECURSIVE
same_person AS (
SELECT own_account.person_uuid
FROM hs_accounts.account own_account
WHERE own_account.uuid = rbac.currentSubjectUuid()
),
represented_persons AS (
SELECT relation.anchorUuid person_uuid
FROM hs_office.relation relation
WHERE relation.type = 'REPRESENTATIVE'
AND relation.holderUuid IN (SELECT person_uuid FROM same_person)
)
SELECT DISTINCT account.*
FROM hs_accounts.account account
WHERE account.person_uuid IN (SELECT person_uuid FROM same_person)
OR account.person_uuid IN (SELECT person_uuid FROM represented_persons)
Hibernate: select hopre1_0.uuid,hopre1_0.familyname,hopre1_0.givenname,hopre1_0.persontype,hopre1_0.salutation,hopre1_0.title,hopre1_0.tradename,hopre1_0.version from hs_office.person hopre1_0 where hopre1_0.uuid=?
Hibernate: select rse1_0.uuid,rse1_0.name,rse1_0.organization,rse1_0.type from rbac.subject rse1_0 where rse1_0.uuid=?
ContextBasedTestWithCleanup.cleanupAndCheckCleanup
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: call base.defineContext(
cast(? as varchar(127)),
cast(? as text),
cast(? as varchar(63)),
cast(? as text),
cast(? as text));
Hibernate: select roe1_0.uuid,roe1_0.objecttable,roe1_0.serialid from rbac.object roe1_0
Hibernate: select count(*) from rbac.object roe1_0
globalAdminShouldFindOnlyOwnAccountByCurrentSubject(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0