2026-08-10T13:36:13.636Z INFO 368 --- [ Test worker] t.c.s.AnnotationConfigContextLoaderUtils : Could not detect default configuration classes for test class [net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRepositoryIntegrationTest$CreateRelation]: CreateRelation does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2026-08-10T13:36:13.640Z INFO 368 --- [ Test worker] .b.t.c.SpringBootTestContextBootstrapper : Found @SpringBootConfiguration net.hostsharing.hsadminng.HsadminNgApplication for test class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRepositoryIntegrationTest$CreateRelation
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
personOwner_canCreateNewRelationAnchoredToItsOwnPerson(): 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 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: 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: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRbacEntity, f923befa-c7ca-4498-8779-26dca6a2ffb3
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
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_office.relation WHERE uuid=?
DELETING temporary HsOfficeRelationRbacEntity#f923befa-c7ca-4498-8779-26dca6a2ffb3 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
personOwner_canCreateNewRelationAnchoredToItsOwnPerson(): 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
testHostsharingAdmin_withoutAssumedRole_canCreateNewRelation(): 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 count(*) from hs_office.relation_rv horre1_0
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: 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: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRbacEntity, ad895da3-589c-4837-a655-591eba96ecac
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: select horre1_0.uuid,horre1_0.anchoruuid,horre1_0.contactuuid,horre1_0.holderuuid,horre1_0.mark,horre1_0.type,horre1_0.version from hs_office.relation_rv horre1_0 where horre1_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 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 hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where hocre1_0.uuid=?
Hibernate: select count(*) from hs_office.relation_rv horre1_0
Hibernate: select horre1_0.uuid,horre1_0.anchoruuid,horre1_0.contactuuid,horre1_0.holderuuid,horre1_0.mark,horre1_0.type,horre1_0.version from hs_office.relation_rv horre1_0 where horre1_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_office.relation WHERE uuid=?
DELETING temporary HsOfficeRelationRbacEntity#ad895da3-589c-4837-a655-591eba96ecac 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
testHostsharingAdmin_withoutAssumedRole_canCreateNewRelation(): 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
createsAndGrantsRoles(): 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 rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
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: 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: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
toCleanup(class net.hostsharing.hsadminng.hs.office.relation.HsOfficeRelationRbacEntity, f653b6a7-8245-4864-aa1e-edd6698cfdef
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
Hibernate: select rrre1_0.uuid,rrre1_0.objectidname,rrre1_0.objecttable,rrre1_0.objectuuid,rrre1_0.objectTable||'#'||rrre1_0.objectIdName||':'||rrre1_0.roleType,rrre1_0.roletype from rbac.role_ev rrre1_0
Hibernate: select rrge1_0.uuid,rrge1_0.ascendantidname,rrge1_0.ascendantuuid,rrge1_0.assumed,rrge1_0.descendantidname,rrge1_0.descendantuuid,rrge1_0.grantedbyroleidname,rrge1_0.grantedbyroleuuid from rbac.grant_ev rrge1_0
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_office.relation WHERE uuid=?
DELETING temporary HsOfficeRelationRbacEntity#f653b6a7-8245-4864-aa1e-edd6698cfdef 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
createsAndGrantsRoles(): 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
personOwner_cannotCreateNewRelationAnchoredToForeignPerson(): 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 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: 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: select hocre1_0.uuid,hocre1_0.caption,hocre1_0.emailaddresses,hocre1_0.phonenumbers,hocre1_0.postaladdress,hocre1_0.version from hs_office.contact hocre1_0 where ? is null or hocre1_0.caption like (cast(? as varchar)||'%') escape ''
Hibernate: insert into hs_office.relation_rv (anchoruuid,contactuuid,holderuuid,mark,type,version,uuid) values (?,?,?,?,?,?,?)
2026-08-10T13:36:19.035Z WARN 368 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: P0001
2026-08-10T13:36:19.035Z ERROR 368 --- [ Test worker] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: [403] insert into hs_office.relation values((22794ca9-2fae-48c9-8c6f-aacba9287e46,0,57270c5d-a869-46f3-8d7e-078452af0c30,24fa9159-1dad-45d3-9b99-c4069a33e812,ffbb0888-a432-4469-9882-3000dce9a0a5,REPRESENTATIVE,)) not allowed for current subjects {tst-person_smithpeter} ({8042a23c-c1b3-57e4-afb6-38d68db35e22})
Where: PL/pgSQL function hs_office.relation_insert_permission_check_tf() line 10 at RAISE
SQL statement "insert
into hs_office.relation (uuid, version, anchoruuid, holderuuid, contactuuid, type, mark)
values (new.uuid, new.version, new.anchoruuid, new.holderuuid, new.contactuuid, new.type, new.mark)
returning *"
PL/pgSQL function hs_office.relation_instead_of_insert_tf() line 5 at SQL statement
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
personOwner_cannotCreateNewRelationAnchoredToForeignPerson(): TOTAL OBJECT COUNT (after): 210 -> 210
Hibernate: select count(*) from rbac.role_rv rre1_0
Hibernate: select count(*) from rbac.grant_rv rge1_0