Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...