[midPoint] Update to Midpoint 4.4 - missing table m_acc_cert_campaign

[Pálos Gustáv]

Hi Rainer,

please see:
https://docs.evolveum.com/midpoint/release/4.4/
"MySQL and MariaDB are no longer supported."
and also:
"Since midPoint 4.0, PostgreSQL is the recommended database for midPoint
deployments. "

best regards,

Gustav Palos
Artin Solutions

pi 8. 4. 2022 o 15:21 Rainer Herbst via midPoint <
midpoint at lists.evolveum.com> napísal(a):

> 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
>
> -----------------------------------------------------------------------------------------------
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
>


-- 
s pozdravom

Gustáv Pálos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220411/dd740963/attachment.htm>