By type
+ /dbcmd-config/db_migrator_policy_init.sh
314 blocks
Preparing upgrade release version: 0800
Preparing upgrade release version: 0900
Preparing upgrade release version: 1000
Preparing upgrade release version: 1100
Preparing upgrade release version: 1200
Done
Partial upgrade detected
Upgrade will attempt to resume at 0100-pdp.sql
upgrade: 0800 -> 1200
> upgrade 0100-pdp.sql
--------------
ERROR 1060 (42S21) at line 20: Duplicate column name 'LASTUPDATE'
ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY
--------------
policyadmin: upgrade aborted at 0900 by script 0100-pdp.sql
policyadmin: failure: upgrade to release 1200 (0900)
Partial upgrade detected
Upgrade will attempt to resume after 0100-pdp.sql
name version
policyadmin 0900
ID script operation from_version to_version tag success atTime
1 0100-jpapdpgroup_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:36
2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:36
3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:37
9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:38
15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:39
21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:40
22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:40
23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:40
24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:40
25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:41
26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:42
27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:42
28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:43
29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:43
30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:43
31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:44
32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:44
33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:44
34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:45
35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:45
36 0450-pdpgroup.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:45
37 0460-pdppolicystatus.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:00:46
38 0480-pdpstatistics.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:21
39 0490-pdpsubgroup_pdp.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:22
40 0500-pdpsubgroup.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:22
41 0510-toscacapabilityassignment.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:22
42 0520-toscacapabilityassignments.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:23
43 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:23
44 0540-toscacapabilitytype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:23
45 0550-toscacapabilitytypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:24
46 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:24
47 0570-toscadatatype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:24
48 0580-toscadatatypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:24
49 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:25
50 0600-toscanodetemplate.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:25
51 0610-toscanodetemplates.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:25
52 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:25
53 0630-toscanodetype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:26
54 0640-toscanodetypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:26
55 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:26
56 0660-toscaparameter.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:26
57 0670-toscapolicies.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:27
58 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:27
59 0690-toscapolicy.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:27
60 0700-toscapolicytype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:27
61 0710-toscapolicytypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:27
62 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:28
63 0730-toscaproperty.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:28
64 0740-toscarelationshiptype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:28
65 0750-toscarelationshiptypes.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:28
66 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:28
67 0770-toscarequirement.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:29
68 0780-toscarequirements.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:29
69 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:29
70 0800-toscaservicetemplate.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:30
71 0810-toscatopologytemplate.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:31
72 0820-toscatrigger.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:31
73 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:32
74 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:32
75 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:32
76 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:33
77 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:33
78 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:33
79 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:34
80 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:34
81 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:34
82 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:34
83 0940-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:35
84 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:35
85 0960-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:35
86 0970-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:36
87 0980-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:36
88 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:37
89 1000-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:37
90 1010-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:38
91 1020-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:38
92 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:38
93 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:39
94 1050-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:39
95 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 2703230000370800u 1 2023-03-27 00:01:39
96 0100-pdp.sql upgrade 0800 0900 2703230000370900u 1 2023-03-27 00:01:40
97 0110-idx_tsidx1.sql upgrade 0800 0900 2703230000370900u 1 2023-03-27 00:01:40
98 0120-pk_pdpstatistics.sql upgrade 0800 0900 2703230000370900u 1 2023-03-27 00:01:41
99 0130-pdpstatistics.sql upgrade 0800 0900 2703230000370900u 1 2023-03-27 00:01:42
100 0140-pk_pdpstatistics.sql upgrade 0800 0900 2703230000370900u 1 2023-03-27 00:01:42
101 0100-pdp.sql upgrade 0800 0900 2703230002030900u 0 2023-03-27 00:02:04
102 0100-pdp.sql upgrade 0800 0900 2703230002250900u 0 2023-03-27 00:02:25
103 0100-pdp.sql upgrade 0800 0900 2703230002440900u 0 2023-03-27 00:02:45
104 0100-pdp.sql upgrade 0800 0900 2703230003240900u 0 2023-03-27 00:03:25
policyadmin: upgrade available: 0900 -> 1200