cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jayshree.Pal
AppDynamics Team

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

 

Comments
Abhinav.Pandey
AppDynamics Team

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

 

Version history
Last update:
‎06-05-2020 01:13 PM
Updated by:
On-Demand Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here