[midPoint] Problem with upgrade from 4.8.6 to 4.9.1

[Yakov Revyakin]

Hi all,
I have a problem upgrading 4.8.6 -> 4.9.1
When I start Midpoint after DB and binary upgrades I get long list
including the following exception:

2025-02-14 18:24:09,119 [REPOSITORY] [midPointScheduler_Worker-2] ERROR
(com.evolveum.midpoint.repo.common.activity.run.processing.ItemProcessingGatekeeper):
Validity scan (COMBINED) of object UserType:SLi****ch (Se***i Li****ch,
ff7a9109-377b-4f04-849f-a5204c732835) failed: Caught PSQLException for
insert into m_shadow_partition_def (resourceOid, partition, attached,
"table")
values (?, ?, ?, ?)
com.evolveum.midpoint.util.exception.SystemException: Caught PSQLException
for insert into m_shadow_partition_def (resourceOid, partition, attached,
"table")
values (?, ?, ?, ?)
        at
com.evolveum.midpoint.repo.sqale.SqaleServiceBase.handledGeneralException(SqaleServiceBase.java:110)
        at
com.evolveum.midpoint.repo.sqale.SqaleRepositoryService.modifyObject(SqaleRepositoryService.java:499)
Caused by: com.querydsl.core.QueryException: Caught PSQLException for
insert into m_shadow_partition_def (resourceOid, partition, attached,
"table")
values (?, ?, ?, ?)
        at
com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
        at com.querydsl.sql.Configuration.translate(Configuration.java:507)
        ... 79 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied:
"RI_ConstraintTrigger_c_17360" is a system trigger
  Where: SQL statement "ALTER TABLE m_shadow_default DISABLE TRIGGER ALL;"
PL/pgSQL function m_shadow_create_partition() line 60 at EXECUTE
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
        ... 94 common frames omitted

Midpoint works with
psql (PostgreSQL) 14.15 (Ubuntu 14.15-1.pgdg22.04+1)

This happens only if I jump from latests 4.8 to 4.9. If I upgrade, for
example, 4.8.5 to 4.8.6 I have no problems.

Could you advise how to solve this behavior?
Thanks in advance,
Yakov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20250214/a506fef2/attachment.htm>