...
https://mariadb.com/kb/en/rename-table/
RENAME TABLE old_tablepdpstatistics TOto backup_table;pdpstatistics;
dev-policy-galera-config-grt2f 0/1 Error 0 102s
dev-policy-galera-config-pq2kb 0/1 Error 0 2m17s
dev-policy-galera-config-sp7zg 0/1 Error 0 4m45s
dev-policy-galera-config-t9c6x 0/1 Error 0 61s
dev-policy-mariadb-0 2/2 Running 0 4m46s
dev-policy-pap-65ddfc8f54-4fql4 0/1 Init:0/4 0 4m46s
dev-policy-xacml-pdp-d7dfc9964-gnfpc 0/1 Init:0/4 0 4m46s
root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl logs dev-policy-galera-config-t9c6x
+ /opt/app/policy/bin/prepare_downgrade.sh policyadmin
239 blocks
Preparing downgrade release version: 0800
Preparing downgrade release version: 0900
Done
+ /opt/app/policy/bin/db-migrator -s policyadmin -o downgrade -f 0900 -t 0800
downgrade: 0900 -> 0800
Partial downgrade detected
Downgrade will attempt to resume at 0170-pdpstatistics.sql
> downgrade 0170-pdpstatistics.sql
--------------
ERROR 1146 (42S02) at line 20: Table 'policyadmin.pdpstatistics' doesn't exist
ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL
--------------
policyadmin: downgrade aborted at 0900 by script 0170-pdpstatistics.sql
policyadmin: failure: downgrade to release 0800 (0900)
+ rc=1
+ /opt/app/policy/bin/db-migrator -s policyadmin -o report
name version
policyadmin 0900
ID script operation from_version to_version tag success atTime
1 0100-jpapdpstatistics_enginestats.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:13
2 0110-jpapdpstatistics_enginestats.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:13
3 0120-pdp.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:13
4 0130-idx_tsidx1.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:14
5 0140-pk_pdpstatistics.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:16
6 0150-pdpstatistics.sql upgrade 0800 0900 1908211450100900u 1 2021-08-19 14:50:17
7 0160-pk_pdpstatistics.sql upgrade 0800 0900 1908211450100900u 0 2021-08-19 14:50:17
8 0160-pk_pdpstatistics.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:25
9 0170-pdpstatistics.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:26
10 0180-jpapolicyaudit.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:26
11 0190-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:27
12 0200-sequence.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:27
13 0210-sequence.sql upgrade 0800 0900 2008211234230900u 1 2021-08-20 12:34:27
14 0210-sequence.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:47
15 0200-sequence.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:47
16 0190-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:47
17 0180-jpapolicyaudit.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:47
18 0170-pdpstatistics.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:47
19 0160-pk_pdpstatistics.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:49
20 0150-pdpstatistics.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:50
21 0140-pk_pdpstatistics.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:50
22 0130-idx_tsidx1.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:51
23 0120-pdp.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:51
24 0110-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2308211655460900d 1 2021-08-23 16:55:51
25 0100-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2308211655460900d 0 2021-08-23 16:55:51
26 0110-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:37
27 0120-pdp.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:37
28 0130-idx_tsidx1.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:37
29 0140-pk_pdpstatistics.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:38
30 0150-pdpstatistics.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:38
31 0160-pk_pdpstatistics.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:41
32 0170-pdpstatistics.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:42
33 0180-jpapolicyaudit.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:42
34 0190-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:42
35 0200-sequence.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:42
36 0210-sequence.sql upgrade 0800 0900 2408210814360900u 1 2021-08-24 08:14:42
37 0210-sequence.sql downgrade 0900 0800 2408211341150900d 1 2021-08-24 13:41:15
38 0200-sequence.sql downgrade 0900 0800 2408211341150900d 1 2021-08-24 13:41:15
39 0190-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 2408211341150900d 1 2021-08-24 13:41:16
40 0180-jpapolicyaudit.sql downgrade 0900 0800 2408211341150900d 1 2021-08-24 13:41:16
41 0170-pdpstatistics.sql downgrade 0900 0800 2408211341150900d 0 2021-08-24 13:41:16
42 0170-pdpstatistics.sql downgrade 0900 0800 2408211341310900d 0 2021-08-24 13:41:31
43 0170-pdpstatistics.sql downgrade 0900 0800 2408211342050900d 0 2021-08-24 13:42:05
44 0170-pdpstatistics.sql downgrade 0900 0800 2408211342440900d 0 2021-08-24 13:42:44
+ exit 1
policyadmin: downgrade available: 0900 -> 0