Results

By type
Logs
raw version
          + /opt/app/policy/bin/prepare_upgrade.sh policyadmin
281 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-pdp.sql
--------------
ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY
--------------


> upgrade 0110-idx_tsidx1.sql
--------------
CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version)
--------------


> upgrade 0120-pk_pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics DROP PRIMARY KEY
--------------


> upgrade 0130-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 0140-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 0150-pdpstatistics.sql
--------------
ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL
--------------


> upgrade 0160-jpapdpstatistics_enginestats.sql
--------------
ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME
--------------


> upgrade 0170-jpapdpstatistics_enginestats.sql
--------------
UPDATE jpapdpstatistics_enginestats a
  JOIN pdpstatistics b
    ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp
   SET a.id = b.id
--------------


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


> upgrade 0190-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 0200-JpaPolicyAuditIndex_timestamp.sql
--------------
CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
--------------


> upgrade 0210-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 0220-sequence.sql
--------------
INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics))
--------------

+ rc=0
+ /opt/app/policy/bin/db-migrator -s policyadmin -o report
policyadmin: OK: upgrade (0900)
name	version
policyadmin	0900
ID	script	operation	from_version	to_version	tag	success	atTime
1	0100-jpapdpgroup_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:30
2	0110-jpapdpstatistics_enginestats.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:30
3	0120-jpapdpsubgroup_policies.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:31
4	0130-jpapdpsubgroup_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:31
5	0140-jpapdpsubgroup_supportedpolicytypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:31
6	0150-jpatoscacapabilityassignment_attributes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:32
7	0160-jpatoscacapabilityassignment_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:32
8	0170-jpatoscacapabilityassignment_occurrences.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:32
9	0180-jpatoscacapabilityassignment_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:32
10	0190-jpatoscacapabilitytype_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:33
11	0200-jpatoscacapabilitytype_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:33
12	0210-jpatoscadatatype_constraints.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:33
13	0220-jpatoscadatatype_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:33
14	0230-jpatoscadatatype_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:34
15	0240-jpatoscanodetemplate_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:34
16	0250-jpatoscanodetemplate_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:34
17	0260-jpatoscanodetype_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:34
18	0270-jpatoscanodetype_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
19	0280-jpatoscapolicy_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
20	0290-jpatoscapolicy_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
21	0300-jpatoscapolicy_targets.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
22	0310-jpatoscapolicytype_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
23	0320-jpatoscapolicytype_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:35
24	0330-jpatoscapolicytype_targets.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:36
25	0340-jpatoscapolicytype_triggers.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:36
26	0350-jpatoscaproperty_constraints.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:36
27	0360-jpatoscaproperty_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:36
28	0370-jpatoscarelationshiptype_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:37
29	0380-jpatoscarelationshiptype_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:38
30	0390-jpatoscarequirement_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:38
31	0400-jpatoscarequirement_occurrences.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:38
32	0410-jpatoscarequirement_properties.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:38
33	0420-jpatoscaservicetemplate_metadata.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:38
34	0430-jpatoscatopologytemplate_inputs.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:39
35	0440-pdpgroup_pdpsubgroup.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:40
36	0450-pdpgroup.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:41
37	0460-pdppolicystatus.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:08:41
38	0480-pdpstatistics.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:23
39	0490-pdpsubgroup_pdp.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:24
40	0500-pdpsubgroup.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:24
41	0510-toscacapabilityassignment.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:24
42	0520-toscacapabilityassignments.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:25
43	0530-toscacapabilityassignments_toscacapabilityassignment.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:25
44	0540-toscacapabilitytype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:25
45	0550-toscacapabilitytypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:25
46	0560-toscacapabilitytypes_toscacapabilitytype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:26
47	0570-toscadatatype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:26
48	0580-toscadatatypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:26
49	0590-toscadatatypes_toscadatatype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:26
50	0600-toscanodetemplate.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:27
51	0610-toscanodetemplates.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:27
52	0620-toscanodetemplates_toscanodetemplate.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:27
53	0630-toscanodetype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:27
54	0640-toscanodetypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:28
55	0650-toscanodetypes_toscanodetype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:28
56	0660-toscaparameter.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:28
57	0670-toscapolicies.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:28
58	0680-toscapolicies_toscapolicy.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:28
59	0690-toscapolicy.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:29
60	0700-toscapolicytype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:29
61	0710-toscapolicytypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:29
62	0720-toscapolicytypes_toscapolicytype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:29
63	0730-toscaproperty.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
64	0740-toscarelationshiptype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
65	0750-toscarelationshiptypes.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
66	0760-toscarelationshiptypes_toscarelationshiptype.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
67	0770-toscarequirement.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
68	0780-toscarequirements.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:30
69	0790-toscarequirements_toscarequirement.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:31
70	0800-toscaservicetemplate.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:32
71	0810-toscatopologytemplate.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:33
72	0820-toscatrigger.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:33
73	0830-FK_ToscaNodeTemplate_capabilitiesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:34
74	0840-FK_ToscaNodeTemplate_requirementsName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:34
75	0850-FK_ToscaNodeType_requirementsName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:34
76	0860-FK_ToscaServiceTemplate_capabilityTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:35
77	0870-FK_ToscaServiceTemplate_dataTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:35
78	0880-FK_ToscaServiceTemplate_nodeTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:35
79	0890-FK_ToscaServiceTemplate_policyTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:36
80	0900-FK_ToscaServiceTemplate_relationshipTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:36
81	0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:37
82	0920-FK_ToscaTopologyTemplate_policyName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:38
83	0940-PdpPolicyStatus_PdpGroup.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:39
84	0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:40
85	0960-FK_ToscaNodeTemplate_capabilitiesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:40
86	0970-FK_ToscaNodeTemplate_requirementsName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:41
87	0980-FK_ToscaNodeType_requirementsName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:41
88	0990-FK_ToscaServiceTemplate_capabilityTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:42
89	1000-FK_ToscaServiceTemplate_dataTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:43
90	1010-FK_ToscaServiceTemplate_nodeTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:43
91	1020-FK_ToscaServiceTemplate_policyTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:43
92	1030-FK_ToscaServiceTemplate_relationshipTypesName.sql	upgrade	0	0800	1603221308290800u	1	2022-03-16 13:09:44
93	0100-pdp.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:07
94	0110-idx_tsidx1.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:07
95	0120-pk_pdpstatistics.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:08
96	0130-pdpstatistics.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:08
97	0140-pk_pdpstatistics.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:09
98	0150-pdpstatistics.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:10
99	0160-jpapdpstatistics_enginestats.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:11
100	0170-jpapdpstatistics_enginestats.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:11
101	0180-jpapdpstatistics_enginestats.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:11
102	0190-jpapolicyaudit.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:12
103	0200-JpaPolicyAuditIndex_timestamp.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:12
104	0210-sequence.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:13
105	0220-sequence.sql	upgrade	0800	0900	1603221310040900u	1	2022-03-16 13:10:13
policyadmin: OK @ 0900
+ exit 0