...
MariaDB [policyadmin]> select max(timeStamp) from pdpstatistics;
+---------------------+
| max(timeStamp) |
+---------------------+
| 2021-08-19 11:50:07 |
+---------------------+
1 row in set (0.453 sec)
Run upgrade again
Update shell script:
root@esy-master-policy-002-nfs:~/oom/kubernetes# cat policy/resources/config/db_migrator_policy_init.sh
#!/bin/sh
/opt/app/policy/bin/prepare_upgrade.sh ${SQL_DB}
#/opt/app/policy/bin/prepare_downgrade.sh ${SQL_DB}
#/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o downgrade -f 0900 -t 0800
/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o upgrade
rc=$?
/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report
exit $rc
Update values.yaml
#################################################################
# DB configuration defaults.
#################################################################
repository: nexus3.onap.org:10001
pullPolicy: Always
mariadb:
image: mariadb:10.5.8
dbmigrator:
image: onap/policy-db-migrator
schema: policyadmin
policy_home: "/opt/app/policy"
subChartsOnly:
enabled: true
Re-deploy:
root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl logs dev-policy-galera-config-5z8c9
+ /opt/app/policy/bin/prepare_upgrade.sh policyadmin
279 blocks
+ /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Done
upgrade: 0900 -> 0900
Partial downgrade detected
Upgrade will attempt to resume after 0100-jpapdpstatistics_enginestats.sql
...