Versions Compared

Key

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

...

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


Other policy pods are not starting:

root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl get pods | grep policy
dev-policy-apex-pdp-0 0/1 Init:CrashLoopBackOff 6 11m
dev-policy-api-78976fbd5d-pbk4h 0/1 Init:CrashLoopBackOff 5 11m
dev-policy-clamp-be-5c6cb758d8-hgf8w 0/1 Init:CrashLoopBackOff 5 11m
dev-policy-clamp-fe-569494fb5d-5qfkr 0/1 Init:0/3 1 11m
dev-policy-clamp-galera-config-5g2kb 0/1 Completed 0 11m
dev-policy-distribution-7dfdfbd64c-lzj46 0/1 Init:CrashLoopBackOff 6 11m
dev-policy-drools-pdp-0 0/1 Init:CrashLoopBackOff 5 11m
dev-policy-galera-config-xg8nl 0/1 Completed 0 11m
dev-policy-mariadb-0 2/2 Running 0 11m
dev-policy-pap-7899b7f9fb-x6pf8 0/1 Init:CrashLoopBackOff 5 11m
dev-policy-xacml-pdp-68f589ccc4-xmv6h 0/1 Init:CrashLoopBackOff 5 11m
root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl logs dev-policy-apex-pdp-0
Error from server (BadRequest): container "policy-apex-pdp" in pod "dev-policy-apex-pdp-0" is waiting to start: PodInitializing
root@esy-master-policy-002-nfs:~/oom/kubernetes# kubectl logs dev-policy-api-78976fbd5d-pbk4h
Error from server (BadRequest): container "policy-api" in pod "dev-policy-api-78976fbd5d-pbk4h" is waiting to start: PodInitializing