Upgrading AMP from 220.127.116.11 to 8.2.3 is getting failed.
When we upgrade AMP from 18.104.22.168 to 8.2.3 the upgrade is getting failed with the following schema error in the /var/log/AMP-8.2.3-upgrade.log,
Inconsistencies in the database schema detected....
More details in /var/log/schema_change
make: *** [detect_schema_change] Error 1
make: Leaving directory `/root/git/mercury'
We encounter this inconsistencies error in the database because of the change in schema with missing indicies.
We can resolve the missing indices and schema error by executing the following script from AMP CLI,
Once the script is completed we need to recompile the AMP code for successful upgrade. We need to execute the following commands to recompiled the code,
Once the recompiling is completed we can check the AMP version by executing the following commands,