How do I fix a Liquibase validation error during a EUM Schema update?

[Jayshree.Pal]

Resolving an intermittent Liquibase error when upgrading to EUM Server v4.5 from a version lower than 4.4

Problem

As of the 4.5 EUM Server in production, the EUM MySQL database has been moved from the Controller host machine to the EUM Server host machine. 

As a result, when upgrading to EUM Server version 4.5 from a version lower than 4.4, t you may see this intermittent error after the database has been imported and during the schema update:

cd <eum_server_home>/eum-processor/bin/

bash ./eum-schema update

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Unexpected error running Liquibase: Validation Failed:

1 change sets check sum

liquibaseChangelog.xml::21::AppDynamics is now: 7:834d03b3da7773ee8b2d5c0b9dd3aa96

Solution

To resolve this error, log in to the EUM database and run this SQL query:

update DATABASECHANGELOG set MD5SUM='7:834d03b3da7773ee8b2d5c0b9dd3aa96' where id=21;

Then, run the eum-schema command again, using the root user:

./eum-schema --username=root --password=XXXX update

For alternate solution, execute these commands:

bash ./eum-schema clearCheckSums
bash ./eum_schema update

[Abhinav.Pandey]

Sometimes the below SQL query fails with ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'synthetic-tag'

update DATABASECHANGELOG set MD5SUM='7:834d03b3da7773ee8b2d5c0b9dd3aa96' where id=21;

In that case, try addressing the checksum issue using below command

bash ./eum-schema clearCheckSums