[midPoint] Update to Midpoint 4.4 - missing table m_acc_cert_campaign

[Rainer Herbst]

Hi *!

I am currently trying to update from 4.0 to 4.4. The migration went 
sucessfull on my test system, but on the productive system I use MariaDB and 
stumble over a problem with the database schema.

I have updated the database table using the file
doc/config/sql/generic-old/mysql-upgrade-4.0-4.4-utf8mb4.sql

But when I start Midpoint or run ninja.sh verify, an error is thrown:
<snip>

Initializing using midpoint home; with repository connection

*******************************************************************************
***  ***
***  Couldn't start midPoint because of a database schema issue.  ***
***  ***
*******************************************************************************
Database schema is not compatible with the executing code.

Current version is: 4.4
Required version is: 4.4

Please resolve this situation immediately.

Although the declared schema version matches the required version, the 
validation of the schema did not pass. This may indicate corrupted or 
inaccessible (parts of) the database schema.
Validation result: Schema-validation: missing table [m_acc_cert_campaign]

Unexpected exception occurred (class 
org.springframework.beans.factory.UnsatisfiedDependencyException), reason: 
Error creating bean with name 'auditService': Unsatisfied dependency 
expressed through field 'repositoryService'; nested exception is 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error 
creating bean with name 'repositoryService': Unsatisfied dependency 
expressed through field 'sequenceHelper'; nested exception is 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error 
creating bean with name 'sequenceHelper': Unsatisfied dependency expressed 
through field 'objectUpdater'; nested exception is 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error 
creating bean with name 'objectUpdater': Unsatisfied dependency expressed 
through field 'closureManager'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean 
with name 'schemaChecker': Invocation of init method failed; nested 
exception is com.evolveum.midpoint.util.exception.SystemException: Database 
schema problem: Database schema is not compatible with the executing 
code.;;Current version is: 4.4;Required version is: 4.4;;Please resolve this 
situation immediately.;;Although the declared schema version matches the 
required version, the validation of the schema did not pass. This may 
indicate corrupted or inaccessible (parts of) the database 
schema.;Validation result: Schema-validation: missing table 
[m_acc_cert_campaign]
<snap>

In the database, the table exists but is empty:


MariaDB [idms]> desc m_acc_cert_campaign;
+--------------------------+--------------+------+-----+---------+-------+
| Field  | Type  | Null | Key | Default | Extra |
+--------------------------+--------------+------+-----+---------+-------+
| definitionRef_relation  | varchar(157) | YES  |  | NULL  |  |
| definitionRef_targetOid  | varchar(36)  | YES  |  | NULL  |  |
| definitionRef_targetType | int(11)  | YES  |  | NULL  |  |
| endTimestamp  | datetime(6)  | YES  |  | NULL  |  |
| handlerUri  | varchar(255) | YES  |  | NULL  |  |
| iteration  | int(11)  | NO  |  | NULL  |  |
| name_norm  | varchar(191) | YES  | UNI | NULL  |  |
| name_orig  | varchar(191) | YES  | MUL | NULL  |  |
| ownerRef_relation  | varchar(157) | YES  |  | NULL  |  |
| ownerRef_targetOid  | varchar(36)  | YES  |  | NULL  |  |
| ownerRef_targetType  | int(11)  | YES  |  | NULL  |  |
| stageNumber  | int(11)  | YES  |  | NULL  |  |
| startTimestamp  | datetime(6)  | YES  |  | NULL  |  |
| state  | int(11)  | YES  |  | NULL  |  |
| oid  | varchar(36)  | NO  | PRI | NULL  |  |
+--------------------------+--------------+------+-----+---------+-------+




Any ideas what could cause the problem and how to solve it?



Viele Grüße

Rainer Herbst
Leiter IT-Service
Phone: +49 331 7499-257
e-mail: rainer.herbst at aip.de
https://www.aip.de

-----------------------------------------------------------------------------------------------
Leibniz-Institut für Astrophysik Potsdam (AIP)
An der Sternwarte 16, 14482 Potsdam

Vorstand: Prof. Dr. Matthias Steinmetz, Wolfram Rosenbach
Stiftung bürgerlichen Rechts
Stiftungsverzeichnis Brandenburg: 26 742-00/7026
-----------------------------------------------------------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3646 bytes
Desc: not available
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220408/22fe5f2e/attachment-0001.bin>