Results

By type
Logs
raw version
          + /opt/app/policy/bin/prepare_upgrade.sh policyadmin
302 blocks
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Preparing upgrade release version: 1000
Done
+ /opt/app/policy/bin/db-migrator -s policyadmin -o upgrade
Partial upgrade detected
Upgrade will attempt to resume at 0200-JpaPolicyAuditIndex_timestamp.sql
upgrade: 0800 -> 1000

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

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