[midPoint] Update to Midpoint 4.4 - missing table m_acc_cert_campaign

[Oleksandr Nekriach]

Hi Rainer,
I had the same issue.
You need to change MariaDB settings in file /etc/mysql/my.cnf
to the next values
 
[mariadb]
lower_case_table_names=1

And if you have tables in midpoint database in uppercase then alter them to the lowercase

Best regards, 
Oleksandr

Glory to Ukraine! Glory to heroes!



> On 8 Apr 2022, at 16:20, Rainer Herbst via midPoint <midpoint at lists.evolveum.com> wrote:
> 
> 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