...
Modify db_migrator_policy_init.sh - Remove any lines referencing upgrade and add the 2 lines under "Downgrade scripts"
Make/Redeploy to run downgrade
Number of files run = 13
Tables in policyadmin = 73
...
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make/Redeploy to run upgrade
Number of files run = 13
Tables in policyadmin = 75
...
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make/Redeploy to run upgrade
Number of files run = 13
Tables in policyadmin = 75
...
Modify db_migrator_policy_init.sh - Remove any lines referencing upgrade and add the 2 lines under "Downgrade scripts"
Make/Redeploy to run downgrade
This should result in an error (last row in policyadmin_schema_changelog will have a success value of 0)
...
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make + Re-run/redeploy/Redeploy to run upgrade
Number of files run = 11
Tables in policyadmin = 75
...
Modify db_migrator_policy_init.sh - Remove any lines referencing upgrade and add the 2 lines under "Downgrade scripts"
Make/Redeploy to run downgrade
This should result in an error (last row in policyadmin_schema_changelog will have a success value of 0)
Rename backup_pdpstatistic table in policyadminschema: RENAME TABLE backup_pdpstatistic to pdpstatistics;
Redeploy to run downgrade
Number of files run = 12
Tables in policyadmin = 73
Records in policyadmin_schema_changelog = 36
Version in schema_versions: 0800
7. Downgrade to Honolulu (0800) after failed upgrade
Ensure you are on release 0800.
Rename pdpstatistics table in policyadmin schema: RENAME TABLE pdpstatistics to backup_pdpstatistics;
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make/Redeploy to run upgrade
This should result in an error (last row in policyadmin_schema_changelog will have a success value of 0)
Rename backup_pdpstatistic table in policyadminschema: RENAME TABLE backup_pdpstatistic to pdpstatistics;
Modify db_migrator_policy_init.sh - Remove any lines referencing upgrade and add the 2 lines under "Downgrade scripts"
Make/Redeploy to run downgradeRe-run/redeploy
Number of files run = 123
Tables in policyadmin = 73
Records in policyadmin_schema_changelog = 3639
Version in schema_versions: 0800
8. Upgrade to Istanbul (0900) after failed upgrade
Ensure you are on release 0900.
Rename pdpstatistics table in policyadmin schema: RENAME TABLE pdpstatistics to backup_pdpstatistics;
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make/Redeploy to run upgrade
This should result in an error (last row in policyadmin_schema_changelog will have a success value of 0)
Rename backup_pdpstatistic table in policyadminschema: RENAME TABLE backup_pdpstatistic to pdpstatistics;
Redeploy to run upgrade
Number of files run = 14
Tables in policyadmin = 75
Records in policyadmin_schema_changelog = 53
Version in schema_versions: 0900
Test Results
kubectl logs: db_migrator_kubectl_logs.xlsx
...