...
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
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
> upgrade 0110-jpapdpstatistics_enginestats.sql
--------------
ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME
--------------
> upgrade 0120-pdp.sql
--------------
ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime DEFAULT NULL NULL AFTER HEALTHY
--------------
> upgrade 0130-idx_tsidx1.sql
--------------
CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version)
--------------
> upgrade 0140-pk_pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics DROP PRIMARY KEY
--------------
> upgrade 0150-pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL
--------------
> upgrade 0160-pk_pdpstatistics.sql
--------------
UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num
--------------
--------------
ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version)
--------------
> upgrade 0170-pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NULL
--------------
> upgrade 0180-jpapolicyaudit.sql
--------------
CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))
--------------
> upgrade 0190-JpaPolicyAuditIndex_timestamp.sql
--------------
CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
--------------
> upgrade 0200-sequence.sql
--------------
CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))
--------------
> upgrade 0210-sequence.sql
--------------
INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics))
--------------
policyadmin: OK: upgrade (0900)
+ rc=0
+ /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
policyadmin: OK @ 0900
+ exit 0