...
Modify db_migrator_policy_init.sh - Remove any lines referencing downgrade and add the 2 lines under "Upgrade scripts"
Make + Re-run/redeploy
Number of files run = 11
Tables in policyadmin = 75
...
Version in schema_versions: 0900
6. Downgrade to Honolulu (0800) after failed downgrade
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 upgrade and add the 2 lines under "Downgrade scripts"
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 downgrade and add the 2 lines under "Upgrade scripts"
Re-run/redeploy
Number of files run = 12
Tables in policyadmin = 73
Records in policyadmin_schema_changelog = 36
Version in schema_versions: 0800
Test Results
kubectl logs:
| View file | ||||
|---|---|---|---|---|
|