Problem:Upgrading AMP from 8.2.1.1 to 8.2.3 is getting failed.
Diagnostics:When we upgrade AMP from 8.2.1.1 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.
SolutionWe can resolve the missing indices and schema error by executing the following script from AMP CLI,
#fix_missing_indices
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,
#screen
#make
Once the recompiling is completed we can check the AMP version by executing the following commands,
#amp_version