Policy api config file: /opt/app/policy/api/etc/mounted/config.json overriding logback.xml [2021-04-27T20:58:36.649+00:00|INFO|Main|main] Starting policy api service with arguments - [-c, /opt/app/policy/api/etc/mounted/config.json] [EL Info]: 2021-04-27 20:58:38.582--ServerSession(1166230227)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 20:58:40.593--ServerSession(1166230227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1700) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 20:58:40.667--ServerSession(1166230227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1700) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 20:58:41.238--ServerSession(1166230227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1700) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 20:58:41.317--ServerSession(1166230227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1700) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T20:58:57.956+00:00|INFO|ServiceManager|main] service manager starting [2021-04-27T20:58:57.957+00:00|INFO|ServiceManager|main] service manager starting REST ApiGroup [2021-04-27T20:58:57.957+00:00|INFO|JettyServletServer|main] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6a09484c@22daccf5==org.glassfish.jersey.servlet.ServletContainer,jsp=null,order=0,inst=false,async=true}, swaggerId=swagger-6969, toString()=JettyServer [name=ApiGroup, host=0.0.0.0, port=6969, user=healthcheck, password=true, contextPath=/, jettyServer=Server@5657967b{STOPPED}[9.4.33.v20201020], context=o.e.j.s.ServletContextHandler@61394494{/,null,STOPPED}, connector=ApiGroup@118041c7{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=null]]: STARTING [2021-04-27T20:58:57.964+00:00|INFO|ServiceManager|main] service manager started [2021-04-27T20:58:57.964+00:00|INFO|JettyServletServer|ApiGroup-6969] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-6a09484c@22daccf5==org.glassfish.jersey.servlet.ServletContainer,jsp=null,order=0,inst=false,async=true}, swaggerId=swagger-6969, toString()=JettyServer [name=ApiGroup, host=0.0.0.0, port=6969, user=healthcheck, password=true, contextPath=/, jettyServer=Server@5657967b{STOPPED}[9.4.33.v20201020], context=o.e.j.s.ServletContextHandler@61394494{/,null,STOPPED}, connector=ApiGroup@118041c7{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=Thread[ApiGroup-6969,5,main]]]: STARTING [2021-04-27T20:58:57.965+00:00|INFO|Main|main] Started policy-api service successfully. [2021-04-27T20:58:59.963+00:00|INFO|GsonMessageBodyHandler|ApiGroup-6969] Using GSON for REST calls [2021-04-27T20:58:59.963+00:00|INFO|YamlMessageBodyHandler|ApiGroup-6969] Accepting YAML for REST calls [2021-04-27T21:00:08.745+00:00|INFO|RequestLog|qtp190496961-28] 10.233.70.23 - healthcheck [27/Apr/2021:21:00:08 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [2021-04-27T21:00:11.570+00:00|INFO|OrderedServiceImpl|qtp190496961-28] ***** OrderedServiceImpl implementers: [] [2021-04-27T21:00:11.572+00:00|INFO|network|qtp190496961-28] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:00:11.854--ServerSession(380956335)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:00:12.694--ServerSession(380956335)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1742) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:00:12.762--ServerSession(380956335)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1742) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:00:13.051--ServerSession(380956335)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1742) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:00:13.257--ServerSession(380956335)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1742) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:00:15.366+00:00|INFO|RequestLog|qtp190496961-28] 10.233.76.247 - healthcheck [27/Apr/2021:21:00:11 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:00:15.668--ServerSession(687661279)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:00:16.276--ServerSession(687661279)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1745) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:00:17.258--ServerSession(687661279)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1745) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:00:18.258--ServerSession(687661279)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1745) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:00:19.258--ServerSession(687661279)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1745) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:00:20.480+00:00|INFO|RequestLog|qtp190496961-25] 10.233.76.247 - healthcheck [27/Apr/2021:21:00:15 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1158 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:00:27.871--ServerSession(1153901821)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:00:28.639--ServerSession(1153901821)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1757) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:00:28.711--ServerSession(1153901821)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1757) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:00:28.815--ServerSession(1153901821)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1757) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:00:28.905--ServerSession(1153901821)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1757) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:00:29.977+00:00|INFO|RequestLog|qtp190496961-25] 10.233.76.247 - healthcheck [27/Apr/2021:21:00:27 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:01:18.163--ServerSession(1045154261)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:23.268--ServerSession(1045154261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1781) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:23.335--ServerSession(1045154261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1781) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:24.269--ServerSession(1045154261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1781) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:24.36--ServerSession(1045154261)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1781) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:29.066+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:01:30.372--ServerSession(1075622510)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:34.343--ServerSession(1075622510)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1787) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:35.27--ServerSession(1075622510)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1787) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:35.368--ServerSession(1075622510)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1787) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:36.27--ServerSession(1075622510)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1787) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:38.244+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:30 +0000] "GET /policy/api/v1/policytypes/onap.policies.Match/versions/1.0.0 HTTP/1.1" 200 320 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:01:40.455--ServerSession(991079911)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:45.271--ServerSession(991079911)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1794) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:45.412--ServerSession(991079911)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1794) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:46.271--ServerSession(991079911)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1794) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:46.341--ServerSession(991079911)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1794) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:47.969+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:40 +0000] "GET /policy/api/v1/policytypes/onap.policies.Monitoring/versions/1.0.0 HTTP/1.1" 200 362 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:01:48.449--ServerSession(1495559838)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:48.913--ServerSession(1495559838)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1799) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:49.272--ServerSession(1495559838)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1799) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:49.373--ServerSession(1495559838)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1799) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:49.459--ServerSession(1495559838)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1799) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:50.289+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:48 +0000] "GET /policy/api/v1/policytypes/onap.policies.Naming/versions/1.0.0 HTTP/1.1" 200 3230 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:01:51.451--ServerSession(933760469)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:54.361--ServerSession(933760469)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1801) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:54.434--ServerSession(933760469)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1801) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:55.273--ServerSession(933760469)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1801) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:55.361--ServerSession(933760469)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1801) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:56.671+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:51 +0000] "GET /policy/api/v1/policytypes/onap.policies.Native/versions/1.0.0 HTTP/1.1" 200 329 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:01:57.401--ServerSession(1314686267)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:01:58.514--ServerSession(1314686267)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1805) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:01:58.571--ServerSession(1314686267)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1805) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:01:58.665--ServerSession(1314686267)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1805) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:01:59.274--ServerSession(1314686267)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1805) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:01:59.913+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:01:57 +0000] "GET /policy/api/v1/policytypes/onap.policies.Optimization/versions/1.0.0 HTTP/1.1" 200 1008 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:00.55--ServerSession(563512236)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:01.371--ServerSession(563512236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1807) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:01.425--ServerSession(563512236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1807) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:01.552--ServerSession(563512236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1807) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:01.617--ServerSession(563512236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1807) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:02.480+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:00 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.Guard/versions/1.0.0 HTTP/1.1" 200 357 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:03.45--ServerSession(578608300)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:05.368--ServerSession(578608300)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1809) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:05.438--ServerSession(578608300)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1809) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:05.531--ServerSession(578608300)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1809) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:06.275--ServerSession(578608300)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1809) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:07.274+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:03 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.Common/versions/1.0.0 HTTP/1.1" 200 1064 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:09.38--ServerSession(2010521159)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:13.276--ServerSession(2010521159)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1814) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:13.339--ServerSession(2010521159)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1814) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:14.276--ServerSession(2010521159)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1814) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:14.343--ServerSession(2010521159)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1814) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:15.726+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:09 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.Coordination/versions/1.0.0 HTTP/1.1" 200 618 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:16.379--ServerSession(905151305)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:19.438--ServerSession(905151305)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1819) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:20.277--ServerSession(905151305)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1819) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:20.374--ServerSession(905151305)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1819) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:20.455--ServerSession(905151305)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1819) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:22.042+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:16 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.Blacklist/versions/1.0.0 HTTP/1.1" 200 1595 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:22.452--ServerSession(2062070591)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:22.964--ServerSession(2062070591)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1823) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:23.032--ServerSession(2062070591)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1823) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:23.277--ServerSession(2062070591)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1823) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:23.345--ServerSession(2062070591)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1823) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:24.407+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:22 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.Filter/versions/1.0.0 HTTP/1.1" 200 3163 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:25.454--ServerSession(399205131)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:28.278--ServerSession(399205131)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1826) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:28.385--ServerSession(399205131)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1826) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:28.479--ServerSession(399205131)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1826) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:29.279--ServerSession(399205131)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1826) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:29.908+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:25 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0 HTTP/1.1" 200 1906 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:30.364--ServerSession(240178632)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:30.869--ServerSession(240178632)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1830) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:31.278--ServerSession(240178632)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1830) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:31.384--ServerSession(240178632)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1830) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:31.461--ServerSession(240178632)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1830) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:32.177+00:00|INFO|RequestLog|qtp190496961-25] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:30 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0 HTTP/1.1" 200 1855 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:32.39--ServerSession(1786882765)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:32.868--ServerSession(1786882765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1832) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:32.953--ServerSession(1786882765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1832) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:33.046--ServerSession(1786882765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1832) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:33.112--ServerSession(1786882765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1832) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:33.842+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:32 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.coordination.FirstBlocksSecond/versions/1.0.0 HTTP/1.1" 200 1139 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:33.963--ServerSession(49851454)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:34.553--ServerSession(49851454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1833) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:34.624--ServerSession(49851454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1833) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:34.727--ServerSession(49851454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1833) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:34.796--ServerSession(49851454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1833) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:35.393+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:33 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.Common/versions/1.0.0 HTTP/1.1" 200 5965 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:36.396--ServerSession(1062266489)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:39.279--ServerSession(1062266489)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1835) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:39.345--ServerSession(1062266489)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1835) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:39.45--ServerSession(1062266489)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1835) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:40.279--ServerSession(1062266489)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1835) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:41.637+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:36 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Apex/versions/1.0.0 HTTP/1.1" 200 6943 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:42.386--ServerSession(788894521)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:43.466--ServerSession(788894521)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1839) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:43.534--ServerSession(788894521)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1839) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:43.626--ServerSession(788894521)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1839) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:44.28--ServerSession(788894521)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1839) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:44.948+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:42 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0 HTTP/1.1" 200 6387 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:45.444--ServerSession(1947970149)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:45.905--ServerSession(1947970149)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1840) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:45.96--ServerSession(1947970149)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1840) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:46.281--ServerSession(1947970149)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1840) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:46.355--ServerSession(1947970149)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1840) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:46.908+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:45 +0000] "GET /policy/api/v1/policytypes/onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server/versions/1.0.0 HTTP/1.1" 200 958 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:47.02--ServerSession(127985368)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:47.782--ServerSession(127985368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1842) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:47.848--ServerSession(127985368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1842) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:47.946--ServerSession(127985368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1842) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:48.027--ServerSession(127985368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1842) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:48.991+00:00|INFO|RequestLog|qtp190496961-25] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:46 +0000] "GET /policy/api/v1/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0 HTTP/1.1" 200 7987 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:49.149--ServerSession(554241901)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:49.704--ServerSession(554241901)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1846) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:49.772--ServerSession(554241901)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1846) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:49.879--ServerSession(554241901)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1846) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:49.94--ServerSession(554241901)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1846) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:50.665+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:49 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Apex/versions/1.0.0 HTTP/1.1" 200 10340 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:50.812--ServerSession(590730724)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:51.281--ServerSession(590730724)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1847) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:51.352--ServerSession(590730724)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1847) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:51.449--ServerSession(590730724)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1847) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:51.516--ServerSession(590730724)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1847) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:52.074+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:50 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Drools/versions/1.0.0 HTTP/1.1" 200 547 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:52.16--ServerSession(2133742550)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:52.741--ServerSession(2133742550)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1848) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:52.804--ServerSession(2133742550)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1848) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:52.9--ServerSession(2133742550)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1848) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:52.978--ServerSession(2133742550)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1848) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:53.625+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:52 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Xacml/versions/1.0.0 HTTP/1.1" 200 706 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:54.389--ServerSession(4376939)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:55.547--ServerSession(4376939)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1850) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:55.609--ServerSession(4376939)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1850) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:56.282--ServerSession(4376939)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1850) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:56.368--ServerSession(4376939)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1850) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:56.948+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:54 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.drools.Artifact/versions/1.0.0 HTTP/1.1" 200 2131 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:57.368--ServerSession(400995720)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:57.885--ServerSession(400995720)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1853) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:58.282--ServerSession(400995720)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1853) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:58.383--ServerSession(400995720)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1853) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:02:58.465--ServerSession(400995720)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1853) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:02:59.036+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:57 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.drools.Controller/versions/1.0.0 HTTP/1.1" 200 3445 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:02:59.394--ServerSession(826857484)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:02:59.821--ServerSession(826857484)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1855) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:02:59.878--ServerSession(826857484)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1855) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:02:59.971--ServerSession(826857484)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1855) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:00.283--ServerSession(826857484)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1855) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:00.957+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:02:59 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.Resource/versions/1.0.0 HTTP/1.1" 200 1773 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:01.111--ServerSession(658624188)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:01.73--ServerSession(658624188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1856) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:01.798--ServerSession(658624188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1856) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:01.905--ServerSession(658624188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1856) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:01.98--ServerSession(658624188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1856) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:02.748+00:00|INFO|RequestLog|qtp190496961-24] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:01 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.Service/versions/1.0.0 HTTP/1.1" 200 1513 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:02.852--ServerSession(1121942175)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:03.432--ServerSession(1121942175)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1858) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:03.495--ServerSession(1121942175)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1858) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:03.589--ServerSession(1121942175)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1858) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:03.657--ServerSession(1121942175)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1858) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:04.216+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:02 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.AffinityPolicy/versions/1.0.0 HTTP/1.1" 200 2777 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:04.387--ServerSession(547758608)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:04.832--ServerSession(547758608)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1859) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:04.906--ServerSession(547758608)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1859) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:05.014--ServerSession(547758608)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1859) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [2021-04-27T21:03:05.018+00:00|INFO|RequestLog|qtp190496961-23] 10.233.70.23 - healthcheck [27/Apr/2021:21:03:05 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [EL Warning]: 2021-04-27 21:03:05.101--ServerSession(547758608)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1859) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:05.734+00:00|INFO|RequestLog|qtp190496961-26] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:04 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.DistancePolicy/versions/1.0.0 HTTP/1.1" 200 3458 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:05.963--ServerSession(368260894)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [2021-04-27T21:03:06.057+00:00|INFO|network|qtp190496961-25] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [EL Warning]: 2021-04-27 21:03:06.661--ServerSession(368260894)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1862) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:06.725--ServerSession(368260894)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1862) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:06.812--ServerSession(368260894)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1861) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:06.893--ServerSession(368260894)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1862) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:07.070+00:00|INFO|RequestLog|qtp190496961-25] 10.233.76.45 - healthcheck [27/Apr/2021:21:03:06 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [2021-04-27T21:03:07.816+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:05 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.HpaPolicy/versions/1.0.0 HTTP/1.1" 200 5450 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:03:08.110+00:00|INFO|RequestLog|qtp190496961-26] 10.233.76.45 - healthcheck [27/Apr/2021:21:03:07 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1158 "-" "python-requests/2.25.1" [2021-04-27T21:03:08.858+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:07 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.OptimizationPolicy/versions/1.0.0 HTTP/1.1" 200 3699 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:09.046--ServerSession(197048508)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:09.496--ServerSession(197048508)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1867) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:09.558--ServerSession(197048508)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1867) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:09.655--ServerSession(197048508)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1867) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:09.729--ServerSession(197048508)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1867) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:10.288+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:08 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.PciPolicy/versions/1.0.0 HTTP/1.1" 200 2940 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:10.402--ServerSession(1799454278)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:11.078--ServerSession(1799454278)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1869) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:11.136--ServerSession(1799454278)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1869) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:11.284--ServerSession(1799454278)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1869) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:11.36--ServerSession(1799454278)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1869) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:12.016+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:10 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.Vim_fit/versions/1.0.0 HTTP/1.1" 200 2708 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:03:12.440+00:00|INFO|RequestLog|qtp190496961-28] 10.233.76.45 - healthcheck [27/Apr/2021:21:03:11 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [2021-04-27T21:03:13.015+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:12 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.VnfPolicy/versions/1.0.0 HTTP/1.1" 200 3092 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:13.12--ServerSession(409700664)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:13.971--ServerSession(409700664)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1872) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:14.03--ServerSession(409700664)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1872) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:14.128--ServerSession(409700664)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1872) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:14.196--ServerSession(409700664)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1872) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:14.898+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:13 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.service.QueryPolicy/versions/1.0.0 HTTP/1.1" 200 2383 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:03:15.043--ServerSession(786593090)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:03:15.456--ServerSession(786593090)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1873) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:03:15.518--ServerSession(786593090)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1873) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:03:15.634--ServerSession(786593090)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1873) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:03:15.707--ServerSession(786593090)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1873) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:03:16.569+00:00|INFO|RequestLog|qtp190496961-24] 10.233.67.228 - healthcheck [27/Apr/2021:21:03:14 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.service.SubscriberPolicy/versions/1.0.0 HTTP/1.1" 200 2655 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:05:15.039+00:00|INFO|RequestLog|qtp190496961-25] 10.233.70.23 - healthcheck [27/Apr/2021:21:05:15 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [2021-04-27T21:05:16.119+00:00|INFO|network|qtp190496961-26] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:05:16.155--ServerSession(104922991)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:05:16.724--ServerSession(104922991)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1931) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:05:16.809--ServerSession(104922991)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1931) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:05:16.917--ServerSession(104922991)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1931) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:05:16.999--ServerSession(104922991)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1931) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:05:17.514+00:00|INFO|RequestLog|qtp190496961-26] 10.233.76.163 - healthcheck [27/Apr/2021:21:05:16 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:05:17.629--ServerSession(583502726)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:05:18.015--ServerSession(583502726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1934) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:05:18.094--ServerSession(583502726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1934) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:05:18.302--ServerSession(583502726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1934) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:05:18.388--ServerSession(583502726)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=1934) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:05:18.678+00:00|INFO|RequestLog|qtp190496961-23] 10.233.76.163 - healthcheck [27/Apr/2021:21:05:17 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1158 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:06:17.957--ServerSession(860335935)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Severe]: 2021-04-27 21:06:20.013--ServerSession(860335935)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 [EL Severe]: ejb: 2021-04-27 21:06:20.014--ServerSession(860335935)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 [2021-04-27T21:06:20.015+00:00|WARN|DefaultPfDao|qtp190496961-25] Creation of Policy Framework persistence unit "PolicyMariaDb" failed [2021-04-27T21:06:20.016+00:00|WARN|PolicyModelsProviderFactory|qtp190496961-25] could not create an instance of PolicyModelsProvider "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl" [2021-04-27T21:06:20.019+00:00|WARN|ApiRestController|qtp190496961-25] GET /policytypes org.onap.policy.models.base.PfModelException: could not create an instance of PolicyModelsProvider "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl" at org.onap.policy.models.provider.PolicyModelsProviderFactory.createPolicyModelsProvider(PolicyModelsProviderFactory.java:77) at org.onap.policy.api.main.rest.provider.CommonModelProvider.(CommonModelProvider.java:62) at org.onap.policy.api.main.rest.provider.PolicyTypeProvider.(PolicyTypeProvider.java:42) at org.onap.policy.api.main.rest.ApiRestController.getAllPolicyTypes(ApiRestController.java:240) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:563) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540) at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395) at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.onap.policy.models.base.PfModelException: could not create Data Access Object (DAO) using url "jdbc:mariadb://policy-mariadb:3306/policyadmin" and persistence unit "PolicyMariaDb" at org.onap.policy.models.provider.impl.AbstractModelsProvider.init(AbstractModelsProvider.java:101) at org.onap.policy.models.provider.PolicyModelsProviderFactory.createPolicyModelsProvider(PolicyModelsProviderFactory.java:70) ... 65 common frames omitted Caused by: org.onap.policy.models.base.PfModelException: Creation of Policy Framework persistence unit "PolicyMariaDb" failed at org.onap.policy.models.dao.impl.DefaultPfDao.init(DefaultPfDao.java:129) at org.onap.policy.models.provider.impl.AbstractModelsProvider.init(AbstractModelsProvider.java:95) ... 66 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:857) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:222) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:200) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getDatabaseSession(EntityManagerFactoryImpl.java:542) at org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactoryImpl(PersistenceProvider.java:153) at org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(PersistenceProvider.java:191) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:80) at org.onap.policy.models.dao.impl.DefaultPfDao.init(DefaultPfDao.java:123) ... 67 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:328) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:140) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:172) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:349) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:316) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:438) at org.eclipse.persistence.sessions.server.ConnectionPool.buildConnection(ConnectionPool.java:219) at org.eclipse.persistence.sessions.server.ConnectionPool.startUp(ConnectionPool.java:507) at org.eclipse.persistence.sessions.server.ServerSession.connect(ServerSession.java:522) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:824) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:258) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:772) ... 74 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1392) at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) at org.mariadb.jdbc.Driver.connect(Driver.java:89) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:100) ... 84 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:183) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:255) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:519) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1387) ... 90 common frames omitted Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.base/java.net.SocksSocketImpl.connect(Unknown Source) at java.base/java.net.Socket.connect(Unknown Source) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:250) ... 92 common frames omitted [2021-04-27T21:06:20.022+00:00|INFO|RequestLog|qtp190496961-25] 10.233.67.228 - healthcheck [27/Apr/2021:21:06:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 500 1508 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:07:28.011+00:00|INFO|RequestLog|qtp190496961-24] 10.233.70.23 - healthcheck [27/Apr/2021:21:07:28 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [2021-04-27T21:07:30.184+00:00|INFO|network|qtp190496961-24] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:07:30.215--ServerSession(148597163)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Severe]: 2021-04-27 21:07:32.279--ServerSession(148597163)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 [EL Severe]: ejb: 2021-04-27 21:07:32.279--ServerSession(148597163)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 [2021-04-27T21:07:32.280+00:00|WARN|DefaultPfDao|qtp190496961-24] Creation of Policy Framework persistence unit "PolicyMariaDb" failed [2021-04-27T21:07:32.280+00:00|WARN|PolicyModelsProviderFactory|qtp190496961-24] could not create an instance of PolicyModelsProvider "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl" [2021-04-27T21:07:32.282+00:00|WARN|ApiRestController|qtp190496961-24] POST /policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies org.onap.policy.models.base.PfModelException: could not create an instance of PolicyModelsProvider "org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl" at org.onap.policy.models.provider.PolicyModelsProviderFactory.createPolicyModelsProvider(PolicyModelsProviderFactory.java:77) at org.onap.policy.api.main.rest.provider.CommonModelProvider.(CommonModelProvider.java:62) at org.onap.policy.api.main.rest.provider.PolicyProvider.(PolicyProvider.java:43) at org.onap.policy.api.main.rest.ApiRestController.createPolicy(ApiRestController.java:787) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:563) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540) at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395) at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.onap.policy.models.base.PfModelException: could not create Data Access Object (DAO) using url "jdbc:mariadb://policy-mariadb:3306/policyadmin" and persistence unit "PolicyMariaDb" at org.onap.policy.models.provider.impl.AbstractModelsProvider.init(AbstractModelsProvider.java:101) at org.onap.policy.models.provider.PolicyModelsProviderFactory.createPolicyModelsProvider(PolicyModelsProviderFactory.java:70) ... 65 common frames omitted Caused by: org.onap.policy.models.base.PfModelException: Creation of Policy Framework persistence unit "PolicyMariaDb" failed at org.onap.policy.models.dao.impl.DefaultPfDao.init(DefaultPfDao.java:129) at org.onap.policy.models.provider.impl.AbstractModelsProvider.init(AbstractModelsProvider.java:95) ... 66 common frames omitted Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:857) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:222) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:200) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getDatabaseSession(EntityManagerFactoryImpl.java:542) at org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactoryImpl(PersistenceProvider.java:153) at org.eclipse.persistence.jpa.PersistenceProvider.createEntityManagerFactory(PersistenceProvider.java:191) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:80) at org.onap.policy.models.dao.impl.DefaultPfDao.init(DefaultPfDao.java:123) ... 67 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) Error Code: -1 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:328) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:140) at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:172) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:349) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:316) at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:438) at org.eclipse.persistence.sessions.server.ConnectionPool.buildConnection(ConnectionPool.java:219) at org.eclipse.persistence.sessions.server.ConnectionPool.startUp(ConnectionPool.java:507) at org.eclipse.persistence.sessions.server.ServerSession.connect(ServerSession.java:522) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:824) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:258) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:772) ... 74 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=policy-mariadb)(port=3306)(type=master) : Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1392) at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635) at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150) at org.mariadb.jdbc.Driver.connect(Driver.java:89) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:100) ... 84 common frames omitted Caused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:policy-mariadb, port:3306. Connection refused (Connection refused) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:183) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:255) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:519) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1387) ... 90 common frames omitted Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) at java.base/java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.base/java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.base/java.net.SocksSocketImpl.connect(Unknown Source) at java.base/java.net.Socket.connect(Unknown Source) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createSocket(AbstractConnectProtocol.java:250) ... 92 common frames omitted [2021-04-27T21:07:32.284+00:00|INFO|RequestLog|qtp190496961-24] 10.233.76.32 - healthcheck [27/Apr/2021:21:07:30 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 500 1508 "-" "python-requests/2.25.1" [2021-04-27T21:10:11.131+00:00|INFO|RequestLog|qtp190496961-21] 10.233.70.23 - healthcheck [27/Apr/2021:21:10:11 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [2021-04-27T21:10:12.109+00:00|INFO|network|qtp190496961-26] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:10:12.155--ServerSession(1572442790)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:10:12.709--ServerSession(1572442790)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2056) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:10:12.778--ServerSession(1572442790)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2056) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:10:12.891--ServerSession(1572442790)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2056) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:10:12.964--ServerSession(1572442790)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2056) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:10:13.371+00:00|INFO|RequestLog|qtp190496961-26] 10.233.72.16 - healthcheck [27/Apr/2021:21:10:12 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:10:13.556--ServerSession(1753248247)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:10:14.152--ServerSession(1753248247)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2058) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:10:14.21--ServerSession(1753248247)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2058) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:10:14.345--ServerSession(1753248247)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2058) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:10:14.416--ServerSession(1753248247)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2058) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:10:14.980+00:00|INFO|RequestLog|qtp190496961-24] 10.233.72.16 - healthcheck [27/Apr/2021:21:10:13 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1158 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:10:18.948--ServerSession(2137805571)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:10:19.42--ServerSession(2137805571)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2066) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:10:19.489--ServerSession(2137805571)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2066) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:10:19.59--ServerSession(2137805571)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2066) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:10:19.823--ServerSession(2137805571)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2066) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:10:20.178+00:00|INFO|RequestLog|qtp190496961-24] 10.233.72.16 - healthcheck [27/Apr/2021:21:10:18 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:11:17.96--ServerSession(122738346)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:11:19.354--ServerSession(122738346)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2095) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:11:20.354--ServerSession(122738346)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2095) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:11:21.354--ServerSession(122738346)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2095) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:11:21.425--ServerSession(122738346)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2095) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:11:25.601+00:00|INFO|RequestLog|qtp190496961-24] 10.233.67.228 - healthcheck [27/Apr/2021:21:11:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:16:17.982--ServerSession(2025928081)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:16:18.918--ServerSession(2025928081)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2234) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:16:18.988--ServerSession(2025928081)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2234) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:16:19.087--ServerSession(2025928081)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2234) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:16:19.151--ServerSession(2025928081)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2234) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:16:19.214+00:00|INFO|RequestLog|qtp190496961-28] 10.233.70.23 - healthcheck [27/Apr/2021:21:16:19 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.33 (HttpUrlConnection 11.0.9.1)" [2021-04-27T21:16:20.268+00:00|INFO|network|qtp190496961-26] [IN|REST|/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"operational.modifyconfig":{"type":"onap.policies.controlloop.operational.common.Drools","type_version":"1.0.0","properties":{"id":"ControlLoop-vFirewall-d0a1dfc6-94f5-4fd4-a5b5-4630b438850a","timeout":1200,"abatement":false,"trigger":"unique-policy-id-1-modifyConfig","operations":[{"id":"unique-policy-id-1-modifyConfig","description":"Modify the packet generator","operation":{"actor":"CDS","operation":"modify-config","target":{"targetType":"VNF","entityIds":{"resourceID":"37b008b9-b367-4359-93fd-74d3ce0ee1a0"}},"payload":{"artifact_name":"vFW-CDS","artifact_version":"1.0.0","data":"{\"active-streams\": \"7\"}"}},"timeout":300,"retries":0,"success":"final_success","failure":"final_failure","failure_timeout":"final_failure_timeout","failure_retries":"final_failure_retries","failure_exception":"final_failure_exception","failure_guard":"final_failure_guard"}]},"name":"NULL","version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]},"name":"NULL","version":"0.0.0"} [2021-04-27T21:16:20.544+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:16:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:16:23.429+00:00|INFO|RequestLog|qtp190496961-26] 10.233.72.232 - healthcheck [27/Apr/2021:21:16:20 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:16:23.551--ServerSession(1398038659)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:16:27.393--ServerSession(1398038659)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2241) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:16:27.473--ServerSession(1398038659)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2241) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:16:27.568--ServerSession(1398038659)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2241) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:16:27.646--ServerSession(1398038659)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2241) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:16:28.853+00:00|INFO|RequestLog|qtp190496961-23] 10.233.72.232 - healthcheck [27/Apr/2021:21:16:23 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1158 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:16:32.95--ServerSession(1626012272)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:16:33.733--ServerSession(1626012272)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2248) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:16:33.792--ServerSession(1626012272)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2248) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:16:33.893--ServerSession(1626012272)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2248) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:16:33.981--ServerSession(1626012272)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2248) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:16:34.722+00:00|INFO|RequestLog|qtp190496961-28] 10.233.72.232 - healthcheck [27/Apr/2021:21:16:32 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1146 "-" "python-requests/2.25.1" [EL Info]: 2021-04-27 21:21:17.945--ServerSession(671316483)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:21:18.435--ServerSession(671316483)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2379) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:21:18.501--ServerSession(671316483)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2379) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:21:18.605--ServerSession(671316483)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2379) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:21:18.681--ServerSession(671316483)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2379) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:21:19.871+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:21:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:26:17.988--ServerSession(1639931565)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:26:18.873--ServerSession(1639931565)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2530) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:26:18.933--ServerSession(1639931565)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2530) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:26:19.479--ServerSession(1639931565)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2530) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:26:19.554--ServerSession(1639931565)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2530) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:26:20.810+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:26:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:27:49.807--ServerSession(1924599570)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:50.666--ServerSession(1924599570)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2573) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:50.744--ServerSession(1924599570)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2573) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:50.842--ServerSession(1924599570)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2573) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:50.912--ServerSession(1924599570)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2573) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:27:51.600+00:00|WARN|ApiRestController|qtp190496961-23] DELETE /policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0/policies/MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ/versions/1.0.0 org.onap.policy.models.base.PfModelRuntimeException: policy MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ:1.0.0 not found at org.onap.policy.models.tosca.simple.provider.SimpleToscaProvider.deletePolicy(SimpleToscaProvider.java:628) at org.onap.policy.models.tosca.authorative.provider.AuthorativeToscaProvider.deletePolicy(AuthorativeToscaProvider.java:543) at org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl.deletePolicy(DatabasePolicyModelsProviderImpl.java:203) at org.onap.policy.api.main.rest.provider.PolicyProvider.deletePolicy(PolicyProvider.java:128) at org.onap.policy.api.main.rest.ApiRestController.deleteSpecificVersionOfPolicy(ApiRestController.java:845) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:563) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540) at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395) at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Unknown Source) [2021-04-27T21:27:51.603+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:49 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0/policies/MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ/versions/1.0.0 HTTP/1.1" 404 184 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:27:51.698+00:00|INFO|network|qtp190496961-23] [IN|REST|/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ":{"type":"onap.policies.monitoring.tcagen2","type_version":"1.0.0","properties":{"tca.policy":{"domain":"measurementsForVfScaling","metricsPerEventName":[{"policyScope":"DCAE","thresholds":[{"version":"1.0.2","severity":"MAJOR","thresholdValue":200,"closedLoopEventStatus":"ONSET","closedLoopControlName":"LOOP_instance_basicclamp0","direction":"LESS_OR_EQUAL","fieldPath":"$.event.measurementsForVfScalingFields.vNicPerformanceArray[*].receivedTotalPacketsDelta"}],"eventName":"vLoadBalancer","policyVersion":"v0.0.1","controlLoopSchemaType":"VM","policyName":"DCAE.Config_tca-hi-lo"}]}},"name":"MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ","version":"1.0.0","metadata":{"policy-id":"MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ","policy-version":"1.0.0"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:27:51.724--ServerSession(1872191863)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:52.617--ServerSession(1872191863)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2574) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:52.678--ServerSession(1872191863)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2574) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:52.775--ServerSession(1872191863)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2574) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:52.847--ServerSession(1872191863)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2574) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:27:53.655+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:51 +0000] "POST /policy/api/v1/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0/policies HTTP/1.1" 200 957 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:27:53.843--ServerSession(1058064606)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:54.703--ServerSession(1058064606)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2576) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:54.771--ServerSession(1058064606)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2576) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:54.883--ServerSession(1058064606)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2576) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:54.954--ServerSession(1058064606)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2576) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:27:55.639+00:00|WARN|ApiRestController|qtp190496961-38] DELETE /policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW/versions/1.0.0 org.onap.policy.models.base.PfModelRuntimeException: policy OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW:1.0.0 not found at org.onap.policy.models.tosca.simple.provider.SimpleToscaProvider.deletePolicy(SimpleToscaProvider.java:628) at org.onap.policy.models.tosca.authorative.provider.AuthorativeToscaProvider.deletePolicy(AuthorativeToscaProvider.java:543) at org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl.deletePolicy(DatabasePolicyModelsProviderImpl.java:203) at org.onap.policy.api.main.rest.provider.PolicyProvider.deletePolicy(PolicyProvider.java:128) at org.onap.policy.api.main.rest.ApiRestController.deleteSpecificVersionOfPolicy(ApiRestController.java:845) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:563) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540) at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395) at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Unknown Source) [2021-04-27T21:27:55.643+00:00|INFO|RequestLog|qtp190496961-38] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:53 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW/versions/1.0.0 HTTP/1.1" 404 200 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:27:55.719+00:00|INFO|network|qtp190496961-27] [IN|REST|/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW":{"type":"onap.policies.controlloop.guard.common.FrequencyLimiter","type_version":"1.0.0","properties":{"actor":"SO","operation":"VF Module Create","limit":1,"timeWindow":10,"timeUnits":"minute"},"name":"OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW","version":"1.0.0","metadata":{"policy-id":"OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW","policy-version":"1.0.0"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:27:55.743--ServerSession(1909802749)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:56.493--ServerSession(1909802749)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2577) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:56.563--ServerSession(1909802749)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2577) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:56.665--ServerSession(1909802749)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2577) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:56.737--ServerSession(1909802749)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2577) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:27:57.149+00:00|INFO|RequestLog|qtp190496961-27] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:55 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0/policies HTTP/1.1" 200 588 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:27:57.594--ServerSession(242128751)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:58.057--ServerSession(242128751)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2581) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:58.123--ServerSession(242128751)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2581) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:58.493--ServerSession(242128751)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2581) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:58.58--ServerSession(242128751)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2581) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:27:58.849+00:00|WARN|ApiRestController|qtp190496961-21] DELETE /policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn/versions/1.0.0 org.onap.policy.models.base.PfModelRuntimeException: policy OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn:1.0.0 not found at org.onap.policy.models.tosca.simple.provider.SimpleToscaProvider.deletePolicy(SimpleToscaProvider.java:628) at org.onap.policy.models.tosca.authorative.provider.AuthorativeToscaProvider.deletePolicy(AuthorativeToscaProvider.java:543) at org.onap.policy.models.provider.impl.DatabasePolicyModelsProviderImpl.deletePolicy(DatabasePolicyModelsProviderImpl.java:203) at org.onap.policy.api.main.rest.provider.PolicyProvider.deletePolicy(PolicyProvider.java:128) at org.onap.policy.api.main.rest.ApiRestController.deleteSpecificVersionOfPolicy(ApiRestController.java:845) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:176) at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) at org.glassfish.jersey.internal.Errors.process(Errors.java:292) at org.glassfish.jersey.internal.Errors.process(Errors.java:274) at org.glassfish.jersey.internal.Errors.process(Errors.java:244) at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:680) at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:563) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:567) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540) at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395) at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Unknown Source) [2021-04-27T21:27:58.852+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:57 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn/versions/1.0.0 HTTP/1.1" 404 180 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [2021-04-27T21:27:58.912+00:00|INFO|network|qtp190496961-28] [IN|REST|/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0/policies] {"tosca_definitions_version":"tosca_simple_yaml_1_1_0","topology_template":{"policies":[{"OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn":{"type":"onap.policies.controlloop.guard.common.MinMax","type_version":"1.0.0","properties":{"actor":"test","operation":"test","target":"test","timeRange":{"start_time":"00:00:00","end_time":"01:00:00"},"min":1,"max":10},"name":"OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn","version":"1.0.0","metadata":{"policy-id":"OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn","policy-version":"1.0.0"}}}]},"name":"NULL","version":"0.0.0"} [EL Info]: 2021-04-27 21:27:58.936--ServerSession(1998360609)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:27:59.622--ServerSession(1998360609)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2582) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:27:59.699--ServerSession(1998360609)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2582) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:27:59.807--ServerSession(1998360609)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2582) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:27:59.879--ServerSession(1998360609)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2582) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:28:00.522+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:27:58 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0/policies HTTP/1.1" 200 584 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:28:11.801--ServerSession(630403487)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:28:13.577--ServerSession(630403487)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2590) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:28:13.644--ServerSession(630403487)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2590) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:28:13.746--ServerSession(630403487)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2590) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:28:13.821--ServerSession(630403487)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2590) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:28:14.165+00:00|INFO|RequestLog|qtp190496961-23] 10.233.67.228 - healthcheck [27/Apr/2021:21:28:11 +0000] "GET /policy/api/v1/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0/policies/MICROSERVICE_basicclamp_v1_0_tcagen2_1_0_0_QaZ/versions/1.0.0 HTTP/1.1" 200 969 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:28:14.574--ServerSession(888853988)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:28:15.782--ServerSession(888853988)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2594) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:28:15.845--ServerSession(888853988)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2594) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:28:16.496--ServerSession(888853988)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2594) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:28:16.578--ServerSession(888853988)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2594) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:28:17.674+00:00|INFO|RequestLog|qtp190496961-28] 10.233.67.228 - healthcheck [27/Apr/2021:21:28:14 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_FrequencyLimiter_1_0_0_gpW/versions/1.0.0 HTTP/1.1" 200 600 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:28:17.922--ServerSession(770204732)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:28:18.882--ServerSession(770204732)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2600) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:28:18.949--ServerSession(770204732)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2600) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:28:19.496--ServerSession(770204732)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2600) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:28:19.581--ServerSession(770204732)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2600) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:28:19.876+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:28:17 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0/policies/OPERATIONAL_basicclamp_v1_0_MinMax_1_0_0_YAn/versions/1.0.0 HTTP/1.1" 200 596 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)" [EL Info]: 2021-04-27 21:31:17.976--ServerSession(500798110)--EclipseLink, version: Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4 [EL Warning]: 2021-04-27 21:31:18.522--ServerSession(500798110)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2683) Can't create table `policyadmin`.`toscanodetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeTemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES ToscaCapabilityAssignments (name, version)") [EL Warning]: 2021-04-27 21:31:18.59--ServerSession(500798110)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2683) Can't create table `policyadmin`.`toscanodetype` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaNodeType ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES ToscaRequirements (name, version)") [EL Warning]: 2021-04-27 21:31:18.688--ServerSession(500798110)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2683) Can't create table `policyadmin`.`toscaservicetemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaServiceTemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES ToscaDataTypes (name, version)") [EL Warning]: 2021-04-27 21:31:18.762--ServerSession(500798110)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.8.v20201217-ecdf3c32c4): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLTransientConnectionException: (conn=2683) Can't create table `policyadmin`.`toscatopologytemplate` (errno: 121 "Duplicate key on write or update") Error Code: 1005 Call: ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version) Query: DataModifyQuery(sql="ALTER TABLE ToscaTopologyTemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES ToscaPolicies (name, version)") [2021-04-27T21:31:19.970+00:00|INFO|RequestLog|qtp190496961-21] 10.233.67.228 - healthcheck [27/Apr/2021:21:31:17 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 56277 "-" "Apache-HttpClient/4.5.13 (Java/11.0.8)"