Versions Compared

Old Version 25

changes.mady.by.user Kevin Timoney

Saved on

compared with

New Version 26

changes.mady.by.user Kevin Timoney

Saved on

Key

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

...

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


Downgrade completes on re-try but is unsuccessful due to updates from pap and api components


MariaDB [migration]> select * from policyadmin_change_history order by id asc;
+----+----------------------------------------+-----------+--------------+------------+-------------------+---------+---------------------+
| 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 |
| 45 | 0170-pdpstatistics.sql | downgrade | 0900 | 0800 | 2408211344040900d | 0 | 2021-08-24 13:44:04 |
| 46 | 0170-pdpstatistics.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:45 |
| 47 | 0160-pk_pdpstatistics.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:47 |
| 48 | 0150-pdpstatistics.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:48 |
| 49 | 0140-pk_pdpstatistics.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:48 |
| 50 | 0130-idx_tsidx1.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:48 |
| 51 | 0120-pdp.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:48 |
| 52 | 0110-jpapdpstatistics_enginestats.sql | downgrade | 0900 | 0800 | 2408211346450900d | 1 | 2021-08-24 13:46:48 |
| 53 | 0100-jpapdpstatistics_enginestats.sql | downgrade | 0900 | 0800 | 2408211346450900d | 0 | 2021-08-24 13:4
6:48 |
+----+----------------------------------------+-----------+--------------+------------+-------------------+---------+---------------------+
53 rows in set (0.889 sec)


Update migration tables so reflect correct downgrade status:


MariaDB [migration]> update policyadmin_change_history set success=1 where id=53;
Query OK, 1 row affected (0.270 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [migration]> commit;
Query OK, 0 rows affected (0.000 sec)

MariaDB [migration]> select * from db_metadata_versions;
+-------------+---------+
| name | version |
+-------------+---------+
| policyadmin | 0900 |
+-------------+---------+
1 row in set (0.471 sec)

MariaDB [migration]> update db_metadata_versions set version = '0800';
Query OK, 1 row affected (0.402 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [migration]> commit;
Query OK, 0 rows affected (0.001 sec)


Run upgrade followed by downgrade


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/db-migrator -s ${SQL_DB} -o upgrade

/opt/app/policy/bin/prepare_downgrade.sh ${SQL_DB}
/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o downgrade -f 0900 -t 0800
rc=$?
/opt/app/policy/bin/db-migrator -s ${SQL_DB} -o report
exit $rc


dev-policy-galera-config-6jwpk 0/1 Completed 0 4m3s


root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl logs dev-policy-galera-config-6jwpk
+ /opt/app/policy/bin/prepare_upgrade.sh policyadmin
279 blocks
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Done
+ /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
upgrade: 0800 -> 0900

> upgrade 0100-jpapdpstatistics_enginestats.sql
--------------
ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp
--------------


> 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)
+ /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

> downgrade 0210-sequence.sql
--------------
DELETE from sequence
--------------


> downgrade 0200-sequence.sql
--------------
DROP TABLE IF EXISTS `sequence`
--------------


> downgrade 0190-JpaPolicyAuditIndex_timestamp.sql
--------------
ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp
--------------


> downgrade 0180-jpapolicyaudit.sql
--------------
DROP TABLE IF EXISTS `jpapolicyaudit`
--------------


> downgrade 0170-pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime NOT NULL
--------------


> downgrade 0160-pk_pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY
--------------

--------------
UPDATE pdpstatistics set ID = 0
--------------


> downgrade 0150-pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID
--------------


> downgrade 0140-pk_pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version)
--------------


> downgrade 0130-idx_tsidx1.sql
--------------
DROP INDEX IDX_TSIDX1 ON pdpstatistics
--------------


> downgrade 0120-pdp.sql
--------------
ALTER TABLE pdp DROP COLUMN LASTUPDATE
--------------


> downgrade 0110-jpapdpstatistics_enginestats.sql
--------------
ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID
--------------


> downgrade 0100-jpapdpstatistics_enginestats.sql
--------------
ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime DEFAULT NULL NULL AFTER UPTIME
--------------

policyadmin: OK: downgrade (0800)
+ rc=0
+ /opt/app/policy/bin/db-migrator -s policyadmin -o report
name version
policyadmin 0800
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
45 0170-pdpstatistics.sql downgrade 0900 0800 2408211344040900d 0 2021-08-24 13:44:04
46 0170-pdpstatistics.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:45
47 0160-pk_pdpstatistics.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:47
48 0150-pdpstatistics.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:48
49 0140-pk_pdpstatistics.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:48
50 0130-idx_tsidx1.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:48
51 0120-pdp.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:48
52 0110-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 13:46:48
53 0100-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2408211346450900d 1 2021-08-24 14:21:09
54 0100-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:05
55 0110-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:05
56 0120-pdp.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:05
57 0130-idx_tsidx1.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:05
58 0140-pk_pdpstatistics.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:06
59 0150-pdpstatistics.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:06
60 0160-pk_pdpstatistics.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
61 0170-pdpstatistics.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
62 0180-jpapolicyaudit.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
63 0190-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
64 0200-sequence.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
65 0210-sequence.sql upgrade 0800 0900 2408211435040900u 1 2021-08-24 14:35:09
66 0210-sequence.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:10
67 0200-sequence.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:10
68 0190-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:10
69 0180-jpapolicyaudit.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:10
70 0170-pdpstatistics.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:10
71 0160-pk_pdpstatistics.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:12
72 0150-pdpstatistics.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:12
73 0140-pk_pdpstatistics.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:12
74 0130-idx_tsidx1.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:13
75 0120-pdp.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:14
76 0110-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:15
77 0100-jpapdpstatistics_enginestats.sql downgrade 0900 0800 2408211435100900d 1 2021-08-24 14:35:15
policyadmin: downgrade available: 0800 -> 0
+ exit 0