<div dir="ltr"><div>Hi Rainer,</div><div><br></div><div>please see:</div><div><a href="https://docs.evolveum.com/midpoint/release/4.4/">https://docs.evolveum.com/midpoint/release/4.4/</a><br></div><div>"MySQL and MariaDB are no longer supported."</div><div>and also:</div><div>"<span style="color:rgb(0,0,0);font-family:Roboto,"Open Sans",-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">Since midPoint 4.0, </span><span style="box-sizing:border-box;font-weight:bolder;color:rgb(0,0,0);font-family:Roboto,"Open Sans",-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px">PostgreSQL is the recommended database</span><span style="color:rgb(0,0,0);font-family:Roboto,"Open Sans",-apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,"Helvetica Neue",Arial,"Noto Sans",sans-serif,"Apple Color Emoji","Segoe UI Emoji","Segoe UI Symbol","Noto Color Emoji";font-size:16px"> for midPoint deployments. </span>"</div><div><br></div><div>best regards,</div><div><br></div><div>Gustav Palos</div><div>Artin Solutions</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">pi 8. 4. 2022 o 15:21 Rainer Herbst via midPoint <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>> napísal(a):<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi *!<br>
<br>
I am currently trying to update from 4.0 to 4.4. The migration went <br>
sucessfull on my test system, but on the productive system I use MariaDB and <br>
stumble over a problem with the database schema.<br>
<br>
I have updated the database table using the file<br>
doc/config/sql/generic-old/mysql-upgrade-4.0-4.4-utf8mb4.sql<br>
<br>
But when I start Midpoint or run ninja.sh verify, an error is thrown:<br>
<snip><br>
<br>
Initializing using midpoint home; with repository connection<br>
<br>
*******************************************************************************<br>
*** ***<br>
*** Couldn't start midPoint because of a database schema issue. ***<br>
*** ***<br>
*******************************************************************************<br>
Database schema is not compatible with the executing code.<br>
<br>
Current version is: 4.4<br>
Required version is: 4.4<br>
<br>
Please resolve this situation immediately.<br>
<br>
Although the declared schema version matches the required version, the <br>
validation of the schema did not pass. This may indicate corrupted or <br>
inaccessible (parts of) the database schema.<br>
Validation result: Schema-validation: missing table [m_acc_cert_campaign]<br>
<br>
Unexpected exception occurred (class <br>
org.springframework.beans.factory.UnsatisfiedDependencyException), reason: <br>
Error creating bean with name 'auditService': Unsatisfied dependency <br>
expressed through field 'repositoryService'; nested exception is <br>
org.springframework.beans.factory.UnsatisfiedDependencyException: Error <br>
creating bean with name 'repositoryService': Unsatisfied dependency <br>
expressed through field 'sequenceHelper'; nested exception is <br>
org.springframework.beans.factory.UnsatisfiedDependencyException: Error <br>
creating bean with name 'sequenceHelper': Unsatisfied dependency expressed <br>
through field 'objectUpdater'; nested exception is <br>
org.springframework.beans.factory.UnsatisfiedDependencyException: Error <br>
creating bean with name 'objectUpdater': Unsatisfied dependency expressed <br>
through field 'closureManager'; nested exception is<br>
org.springframework.beans.factory.BeanCreationException: Error creating bean <br>
with name 'schemaChecker': Invocation of init method failed; nested <br>
exception is com.evolveum.midpoint.util.exception.SystemException: Database <br>
schema problem: Database schema is not compatible with the executing <br>
code.;;Current version is: 4.4;Required version is: 4.4;;Please resolve this <br>
situation immediately.;;Although the declared schema version matches the <br>
required version, the validation of the schema did not pass. This may <br>
indicate corrupted or inaccessible (parts of) the database <br>
schema.;Validation result: Schema-validation: missing table <br>
[m_acc_cert_campaign]<br>
<snap><br>
<br>
In the database, the table exists but is empty:<br>
<br>
<br>
MariaDB [idms]> desc m_acc_cert_campaign;<br>
+--------------------------+--------------+------+-----+---------+-------+<br>
| Field | Type | Null | Key | Default | Extra |<br>
+--------------------------+--------------+------+-----+---------+-------+<br>
| definitionRef_relation | varchar(157) | YES | | NULL | |<br>
| definitionRef_targetOid | varchar(36) | YES | | NULL | |<br>
| definitionRef_targetType | int(11) | YES | | NULL | |<br>
| endTimestamp | datetime(6) | YES | | NULL | |<br>
| handlerUri | varchar(255) | YES | | NULL | |<br>
| iteration | int(11) | NO | | NULL | |<br>
| name_norm | varchar(191) | YES | UNI | NULL | |<br>
| name_orig | varchar(191) | YES | MUL | NULL | |<br>
| ownerRef_relation | varchar(157) | YES | | NULL | |<br>
| ownerRef_targetOid | varchar(36) | YES | | NULL | |<br>
| ownerRef_targetType | int(11) | YES | | NULL | |<br>
| stageNumber | int(11) | YES | | NULL | |<br>
| startTimestamp | datetime(6) | YES | | NULL | |<br>
| state | int(11) | YES | | NULL | |<br>
| oid | varchar(36) | NO | PRI | NULL | |<br>
+--------------------------+--------------+------+-----+---------+-------+<br>
<br>
<br>
<br>
<br>
Any ideas what could cause the problem and how to solve it?<br>
<br>
<br>
<br>
Viele Grüße<br>
<br>
Rainer Herbst<br>
Leiter IT-Service<br>
Phone: +49 331 7499-257<br>
e-mail: <a href="mailto:rainer.herbst@aip.de" target="_blank">rainer.herbst@aip.de</a><br>
<a href="https://www.aip.de" rel="noreferrer" target="_blank">https://www.aip.de</a><br>
<br>
-----------------------------------------------------------------------------------------------<br>
Leibniz-Institut für Astrophysik Potsdam (AIP)<br>
An der Sternwarte 16, 14482 Potsdam<br>
<br>
Vorstand: Prof. Dr. Matthias Steinmetz, Wolfram Rosenbach<br>
Stiftung bürgerlichen Rechts<br>
Stiftungsverzeichnis Brandenburg: 26 742-00/7026<br>
-----------------------------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">s pozdravom<div><br></div><div>Gustáv Pálos</div></div></div>