...
Version in schema_versions: 0900
9. Downgrade to Honolulu (0800) with data in pdpstatistics and jpapdpstatistics_enginestats
Ensure you are on release 0900.
Run the sql statements in apex-pdpstatistics.sql from the "Resources" section to populate pdpstatistics and jpapdpstatistics_enginestats with data.
Modify db_migrator_policy_init.sh - Remove any lines referencing upgrade and add the 2 lines under "Downgrade scripts"
Make/Redeploy to run upgrade
Check the tables to ensure the number records is the same.
Check pdpstatistics to ensure the primary key has changed.
Check jpapdpstatistics_enginestats to ensure id column has been dropped and timestamp column added.
Check the pdp table to ensure the LASTUPDATE column has been dropped.
Redeploy to run upgrade
Number of files run = 13
Tables in policyadmin = 73
Records in policyadmin_schema_changelog = 66
Version in schema_versions: 0800
10. Upgrade to Istanbul (0900) with data in pdpstatistics and jpapdpstatistics_enginestats
Ensure you are on release 0800.
pdpstatistics and jpapdpstatistics_enginestats should contain data from the last test.
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make/Redeploy to run upgrade
Check the tables to ensure the number records is the same.
Check pdpstatistics to ensure the primary key has changed.
Check jpapdpstatistics_enginestats to ensure timestamp column has been dropped and id column added.
Check the pdp table to ensure the LASTUPDATE column has been added and the value has defaulted to the CURRENT_TIMESTAMP.
Redeploy to run upgrade
Number of files run = 13
Tables in policyadmin = 75
Records in policyadmin_schema_changelog = 79
Version in schema_versions: 0900
Test Results
kubectl logs: db_migrator_kubectl_logs.xlsx
...