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
... View more