Results

          + JAVA_HOME=/usr/lib/jvm/java-11-openjdk/
+ KEYSTORE=/opt/app/osaaf/local/org.onap.policy.p12
+ TRUSTSTORE=/opt/app/policy/api/etc/ssl/policy-truststore
+ KEYSTORE_PASSWD='PS@L!fX56$%Ii0FT(w2Jd8(r'
+ TRUSTSTORE_PASSWD=Pol1cy_0nap
+ '[' 1 -eq 1 ']'
+ CONFIG_FILE=/opt/app/policy/api/etc/mounted/config.json
+ '[' -z /opt/app/policy/api/etc/mounted/config.json ']'
Policy api config file: /opt/app/policy/api/etc/mounted/config.json
overriding logback.xml
+ echo 'Policy api config file: /opt/app/policy/api/etc/mounted/config.json'
+ [[ -f /opt/app/policy/api/etc/mounted/policy-truststore ]]
+ [[ -f /opt/app/policy/api/etc/mounted/policy-keystore ]]
+ [[ -f /opt/app/policy/api/etc/mounted/logback.xml ]]
+ echo 'overriding logback.xml'
+ cp -f /opt/app/policy/api/etc/mounted/logback.xml /opt/app/policy/api/etc/
+ /usr/lib/jvm/java-11-openjdk//bin/java -cp '/opt/app/policy/api/etc:/opt/app/policy/api/lib/*' -Dlogback.configurationFile=/opt/app/policy/api/etc/logback.xml -Djavax.net.ssl.keyStore=/opt/app/osaaf/local/org.onap.policy.p12 '-Djavax.net.ssl.keyStorePassword=PS@L!fX56$%Ii0FT(w2Jd8(r' -Djavax.net.ssl.trustStore=/opt/app/policy/api/etc/ssl/policy-truststore -Djavax.net.ssl.trustStorePassword=Pol1cy_0nap org.onap.policy.api.main.startstop.Main -c /opt/app/policy/api/etc/mounted/config.json
[2021-04-23T02:10:39.590+00:00|INFO|Main|main] Starting policy api service with arguments - [-c, /opt/app/policy/api/etc/mounted/config.json]
[EL Info]: 2021-04-23 02:10:41.251--ServerSession(276869158)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:10:41.551--ServerSession(276869158)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Info]: connection: 2021-04-23 02:10:45.953--ServerSession(276869158)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:10:46.479+00:00|INFO|ServiceManager|main] service manager starting
[2021-04-23T02:10:46.479+00:00|INFO|ServiceManager|main] service manager starting REST ApiGroup
[2021-04-23T02:10:46.479+00:00|INFO|JettyServletServer|main] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-1ee5632d@49472a41==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@2871ac91{STOPPED}[9.4.30.v20200611], context=o.e.j.s.ServletContextHandler@3c54ddec{/,null,UNAVAILABLE}, connector=ApiGroup@3b4086c1{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=null]]: STARTING
[2021-04-23T02:10:46.548+00:00|INFO|ServiceManager|main] service manager started
[2021-04-23T02:10:46.548+00:00|INFO|JettyServletServer|ApiGroup-6969] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-1ee5632d@49472a41==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@2871ac91{STOPPED}[9.4.30.v20200611], context=o.e.j.s.ServletContextHandler@3c54ddec{/,null,UNAVAILABLE}, connector=ApiGroup@3b4086c1{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=Thread[ApiGroup-6969,5,main]]]: STARTING
[2021-04-23T02:10:46.552+00:00|INFO|Main|main] Started policy-api service successfully.
[2021-04-23T02:10:48.263+00:00|INFO|GsonMessageBodyHandler|ApiGroup-6969] Using GSON for REST calls
[2021-04-23T02:10:48.263+00:00|INFO|YamlMessageBodyHandler|ApiGroup-6969] Accepting YAML for REST calls
[EL Info]: 2021-04-23 02:14:43.153--ServerSession(911865251)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:43.186--ServerSession(911865251)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:43.495--ServerSession(911865251)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=244) Can't create table `policyadmin`.`#sql-1_f4` (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)")
[EL Warning]: 2021-04-23 02:14:43.523--ServerSession(911865251)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=244) Can't create table `policyadmin`.`#sql-1_f4` (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 Info]: connection: 2021-04-23 02:14:45.886--ServerSession(911865251)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:46.077+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:42 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:46.674--ServerSession(147240876)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:46.77--ServerSession(147240876)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:47.01--ServerSession(147240876)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=246) Can't create table `policyadmin`.`#sql-1_f6` (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)")
[EL Warning]: 2021-04-23 02:14:47.032--ServerSession(147240876)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=246) Can't create table `policyadmin`.`#sql-1_f6` (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 Info]: connection: 2021-04-23 02:14:47.948--ServerSession(147240876)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:47.952+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:46 +0000] "GET /policy/api/v1/policytypes/onap.policies.Match/versions/1.0.0 HTTP/1.1" 200 334 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:48.271--ServerSession(1249214584)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:48.364--ServerSession(1249214584)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:48.585--ServerSession(1249214584)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=248) Can't create table `policyadmin`.`#sql-1_f8` (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)")
[EL Warning]: 2021-04-23 02:14:48.611--ServerSession(1249214584)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=248) Can't create table `policyadmin`.`#sql-1_f8` (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 Info]: connection: 2021-04-23 02:14:49.496--ServerSession(1249214584)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:49.549+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:48 +0000] "GET /policy/api/v1/policytypes/onap.policies.Monitoring/versions/1.0.0 HTTP/1.1" 200 376 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:49.775--ServerSession(1289142282)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:49.859--ServerSession(1289142282)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:50.034--ServerSession(1289142282)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=251) Can't create table `policyadmin`.`#sql-1_fb` (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)")
[EL Warning]: 2021-04-23 02:14:50.059--ServerSession(1289142282)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=251) Can't create table `policyadmin`.`#sql-1_fb` (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 Info]: connection: 2021-04-23 02:14:50.95--ServerSession(1289142282)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:50.954+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:49 +0000] "GET /policy/api/v1/policytypes/onap.policies.Naming/versions/1.0.0 HTTP/1.1" 200 3798 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:51.266--ServerSession(254979147)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:51.284--ServerSession(254979147)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:51.525--ServerSession(254979147)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=254) Can't create table `policyadmin`.`#sql-1_fe` (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)")
[EL Warning]: 2021-04-23 02:14:51.55--ServerSession(254979147)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=254) Can't create table `policyadmin`.`#sql-1_fe` (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 Info]: connection: 2021-04-23 02:14:52.37--ServerSession(254979147)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:52.373+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:51 +0000] "GET /policy/api/v1/policytypes/onap.policies.Native/versions/1.0.0 HTTP/1.1" 200 343 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:52.578--ServerSession(1769143320)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:52.666--ServerSession(1769143320)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:52.944--ServerSession(1769143320)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=256) Can't create table `policyadmin`.`#sql-1_100` (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)")
[EL Warning]: 2021-04-23 02:14:52.97--ServerSession(1769143320)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=256) Can't create table `policyadmin`.`#sql-1_100` (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 Info]: connection: 2021-04-23 02:14:53.687--ServerSession(1769143320)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:53.691+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:52 +0000] "GET /policy/api/v1/policytypes/onap.policies.Optimization/versions/1.0.0 HTTP/1.1" 200 1099 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:53.968--ServerSession(282851476)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:54.058--ServerSession(282851476)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:54.297--ServerSession(282851476)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=258) Can't create table `policyadmin`.`#sql-1_102` (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)")
[EL Warning]: 2021-04-23 02:14:54.319--ServerSession(282851476)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=258) Can't create table `policyadmin`.`#sql-1_102` (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 Info]: connection: 2021-04-23 02:14:54.873--ServerSession(282851476)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:54.876+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:53 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.Guard/versions/1.0.0 HTTP/1.1" 200 371 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:55.075--ServerSession(1831094684)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:55.157--ServerSession(1831094684)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:55.336--ServerSession(1831094684)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=260) Can't create table `policyadmin`.`#sql-1_104` (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)")
[EL Warning]: 2021-04-23 02:14:55.36--ServerSession(1831094684)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=260) Can't create table `policyadmin`.`#sql-1_104` (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 Info]: connection: 2021-04-23 02:14:55.88--ServerSession(1831094684)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:55.882+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:54 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.Common/versions/1.0.0 HTTP/1.1" 200 1198 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:56.058--ServerSession(1520127496)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:56.075--ServerSession(1520127496)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:56.296--ServerSession(1520127496)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=262) Can't create table `policyadmin`.`#sql-1_106` (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)")
[EL Warning]: 2021-04-23 02:14:56.33--ServerSession(1520127496)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=262) Can't create table `policyadmin`.`#sql-1_106` (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 Info]: connection: 2021-04-23 02:14:56.816--ServerSession(1520127496)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:56.818+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:55 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.Coordination/versions/1.0.0 HTTP/1.1" 200 632 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:57.059--ServerSession(43094252)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:57.075--ServerSession(43094252)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:57.321--ServerSession(43094252)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=264) Can't create table `policyadmin`.`#sql-1_108` (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)")
[EL Warning]: 2021-04-23 02:14:57.348--ServerSession(43094252)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=264) Can't create table `policyadmin`.`#sql-1_108` (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 Info]: connection: 2021-04-23 02:14:57.857--ServerSession(43094252)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:57.861+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:56 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.Blacklist/versions/1.0.0 HTTP/1.1" 200 1775 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:58.062--ServerSession(721865414)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:58.078--ServerSession(721865414)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:58.318--ServerSession(721865414)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=266) Can't create table `policyadmin`.`#sql-1_10a` (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)")
[EL Warning]: 2021-04-23 02:14:58.341--ServerSession(721865414)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=266) Can't create table `policyadmin`.`#sql-1_10a` (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 Info]: connection: 2021-04-23 02:14:58.89--ServerSession(721865414)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:58.894+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:57 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.Filter/versions/1.0.0 HTTP/1.1" 200 3442 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:14:59.159--ServerSession(1272348045)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:14:59.176--ServerSession(1272348045)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:14:59.429--ServerSession(1272348045)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=268) Can't create table `policyadmin`.`#sql-1_10c` (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)")
[EL Warning]: 2021-04-23 02:14:59.453--ServerSession(1272348045)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=268) Can't create table `policyadmin`.`#sql-1_10c` (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 Info]: connection: 2021-04-23 02:14:59.983--ServerSession(1272348045)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:14:59.986+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:14:59 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.FrequencyLimiter/versions/1.0.0 HTTP/1.1" 200 2096 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:00.285--ServerSession(596374545)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:00.356--ServerSession(596374545)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:00.571--ServerSession(596374545)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=271) Can't create table `policyadmin`.`#sql-1_10f` (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)")
[EL Warning]: 2021-04-23 02:15:00.596--ServerSession(596374545)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=271) Can't create table `policyadmin`.`#sql-1_10f` (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 Info]: connection: 2021-04-23 02:15:01.081--ServerSession(596374545)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:01.086+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:00 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.common.MinMax/versions/1.0.0 HTTP/1.1" 200 2079 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:01.281--ServerSession(2068439383)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:01.357--ServerSession(2068439383)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:01.569--ServerSession(2068439383)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=274) Can't create table `policyadmin`.`#sql-1_112` (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)")
[EL Warning]: 2021-04-23 02:15:01.594--ServerSession(2068439383)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=274) Can't create table `policyadmin`.`#sql-1_112` (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 Info]: connection: 2021-04-23 02:15:02.038--ServerSession(2068439383)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:02.040+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:01 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.guard.coordination.FirstBlocksSecond/versions/1.0.0 HTTP/1.1" 200 1199 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:02.144--ServerSession(1891464518)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:02.169--ServerSession(1891464518)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:02.389--ServerSession(1891464518)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=276) Can't create table `policyadmin`.`#sql-1_114` (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)")
[EL Warning]: 2021-04-23 02:15:02.414--ServerSession(1891464518)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=276) Can't create table `policyadmin`.`#sql-1_114` (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 Info]: connection: 2021-04-23 02:15:03.035--ServerSession(1891464518)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:03.039+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:02 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.Common/versions/1.0.0 HTTP/1.1" 200 6614 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:03.255--ServerSession(1101487835)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:03.273--ServerSession(1101487835)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:03.497--ServerSession(1101487835)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=278) Can't create table `policyadmin`.`#sql-1_116` (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)")
[EL Warning]: 2021-04-23 02:15:03.523--ServerSession(1101487835)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=278) Can't create table `policyadmin`.`#sql-1_116` (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 Info]: connection: 2021-04-23 02:15:04.015--ServerSession(1101487835)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:04.019+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:03 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Apex/versions/1.0.0 HTTP/1.1" 200 7712 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:04.177--ServerSession(315275036)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:04.19--ServerSession(315275036)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:04.417--ServerSession(315275036)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=280) Can't create table `policyadmin`.`#sql-1_118` (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)")
[EL Warning]: 2021-04-23 02:15:04.441--ServerSession(315275036)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=280) Can't create table `policyadmin`.`#sql-1_118` (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 Info]: connection: 2021-04-23 02:15:04.949--ServerSession(315275036)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:04.953+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:04 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0 HTTP/1.1" 200 7066 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:05.153--ServerSession(426423892)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:05.167--ServerSession(426423892)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:05.383--ServerSession(426423892)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=282) Can't create table `policyadmin`.`#sql-1_11a` (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)")
[EL Warning]: 2021-04-23 02:15:05.406--ServerSession(426423892)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=282) Can't create table `policyadmin`.`#sql-1_11a` (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 Info]: connection: 2021-04-23 02:15:05.848--ServerSession(426423892)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:05.850+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:05 +0000] "GET /policy/api/v1/policytypes/onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server/versions/1.0.0 HTTP/1.1" 200 1032 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:06.054--ServerSession(830597213)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:06.101--ServerSession(830597213)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:06.301--ServerSession(830597213)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=284) Can't create table `policyadmin`.`#sql-1_11c` (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)")
[EL Warning]: 2021-04-23 02:15:06.329--ServerSession(830597213)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=284) Can't create table `policyadmin`.`#sql-1_11c` (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 Info]: connection: 2021-04-23 02:15:06.876--ServerSession(830597213)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:06.880+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:06 +0000] "GET /policy/api/v1/policytypes/onap.policies.monitoring.tcagen2/versions/1.0.0 HTTP/1.1" 200 8411 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:06.964--ServerSession(2056646406)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:06.979--ServerSession(2056646406)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:07.172--ServerSession(2056646406)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=286) Can't create table `policyadmin`.`#sql-1_11e` (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)")
[EL Warning]: 2021-04-23 02:15:07.196--ServerSession(2056646406)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=286) Can't create table `policyadmin`.`#sql-1_11e` (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 Info]: connection: 2021-04-23 02:15:07.658--ServerSession(2056646406)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:07.663+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:06 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Apex/versions/1.0.0 HTTP/1.1" 200 11574 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:07.828--ServerSession(1901926443)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:07.849--ServerSession(1901926443)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:08.073--ServerSession(1901926443)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=288) Can't create table `policyadmin`.`#sql-1_120` (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)")
[EL Warning]: 2021-04-23 02:15:08.098--ServerSession(1901926443)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=288) Can't create table `policyadmin`.`#sql-1_120` (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 Info]: connection: 2021-04-23 02:15:08.529--ServerSession(1901926443)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:08.532+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:07 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Drools/versions/1.0.0 HTTP/1.1" 200 561 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:08.725--ServerSession(168560035)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:08.756--ServerSession(168560035)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:08.984--ServerSession(168560035)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=290) Can't create table `policyadmin`.`#sql-1_122` (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)")
[EL Warning]: 2021-04-23 02:15:09.009--ServerSession(168560035)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=290) Can't create table `policyadmin`.`#sql-1_122` (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 Info]: connection: 2021-04-23 02:15:09.948--ServerSession(168560035)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:09.952+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:08 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.Xacml/versions/1.0.0 HTTP/1.1" 200 736 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:10.155--ServerSession(1926376779)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:10.172--ServerSession(1926376779)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:10.414--ServerSession(1926376779)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=293) Can't create table `policyadmin`.`#sql-1_125` (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)")
[EL Warning]: 2021-04-23 02:15:10.438--ServerSession(1926376779)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=293) Can't create table `policyadmin`.`#sql-1_125` (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 Info]: connection: 2021-04-23 02:15:11.064--ServerSession(1926376779)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:11.067+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:10 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.drools.Artifact/versions/1.0.0 HTTP/1.1" 200 2325 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:11.265--ServerSession(2118399082)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:11.282--ServerSession(2118399082)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:11.544--ServerSession(2118399082)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=296) Can't create table `policyadmin`.`#sql-1_128` (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)")
[EL Warning]: 2021-04-23 02:15:11.568--ServerSession(2118399082)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=296) Can't create table `policyadmin`.`#sql-1_128` (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 Info]: connection: 2021-04-23 02:15:12.068--ServerSession(2118399082)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:12.070+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:11 +0000] "GET /policy/api/v1/policytypes/onap.policies.native.drools.Controller/versions/1.0.0 HTTP/1.1" 200 3853 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:12.18--ServerSession(1260977603)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:12.259--ServerSession(1260977603)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:12.425--ServerSession(1260977603)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=300) Can't create table `policyadmin`.`#sql-1_12c` (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)")
[EL Warning]: 2021-04-23 02:15:12.449--ServerSession(1260977603)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=300) Can't create table `policyadmin`.`#sql-1_12c` (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 Info]: connection: 2021-04-23 02:15:12.914--ServerSession(1260977603)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:12.917+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:12 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.Resource/versions/1.0.0 HTTP/1.1" 200 1928 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:13.184--ServerSession(841848738)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:13.295--ServerSession(841848738)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:13.467--ServerSession(841848738)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=302) Can't create table `policyadmin`.`#sql-1_12e` (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)")
[EL Warning]: 2021-04-23 02:15:13.493--ServerSession(841848738)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=302) Can't create table `policyadmin`.`#sql-1_12e` (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 Info]: connection: 2021-04-23 02:15:13.937--ServerSession(841848738)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:13.940+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:13 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.Service/versions/1.0.0 HTTP/1.1" 200 1636 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:14.07--ServerSession(1388634841)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:14.088--ServerSession(1388634841)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:14.298--ServerSession(1388634841)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=304) Can't create table `policyadmin`.`#sql-1_130` (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)")
[EL Warning]: 2021-04-23 02:15:14.323--ServerSession(1388634841)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=304) Can't create table `policyadmin`.`#sql-1_130` (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 Info]: connection: 2021-04-23 02:15:14.781--ServerSession(1388634841)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:14.783+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:14 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.AffinityPolicy/versions/1.0.0 HTTP/1.1" 200 3034 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:14.961--ServerSession(751337433)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:14.977--ServerSession(751337433)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:15.16--ServerSession(751337433)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=306) Can't create table `policyadmin`.`#sql-1_132` (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)")
[EL Warning]: 2021-04-23 02:15:15.184--ServerSession(751337433)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=306) Can't create table `policyadmin`.`#sql-1_132` (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 Info]: connection: 2021-04-23 02:15:15.616--ServerSession(751337433)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:15.619+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:14 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.DistancePolicy/versions/1.0.0 HTTP/1.1" 200 3836 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:15.889--ServerSession(931301849)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:15.958--ServerSession(931301849)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:16.187--ServerSession(931301849)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=310) Can't create table `policyadmin`.`#sql-1_136` (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)")
[EL Warning]: 2021-04-23 02:15:16.213--ServerSession(931301849)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=310) Can't create table `policyadmin`.`#sql-1_136` (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 Info]: connection: 2021-04-23 02:15:16.655--ServerSession(931301849)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:16.657+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:15 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.HpaPolicy/versions/1.0.0 HTTP/1.1" 200 6300 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:16.854--ServerSession(362395475)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:16.87--ServerSession(362395475)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:17.081--ServerSession(362395475)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=312) Can't create table `policyadmin`.`#sql-1_138` (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)")
[EL Warning]: 2021-04-23 02:15:17.104--ServerSession(362395475)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=312) Can't create table `policyadmin`.`#sql-1_138` (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 Info]: connection: 2021-04-23 02:15:17.542--ServerSession(362395475)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:17.549+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:16 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.OptimizationPolicy/versions/1.0.0 HTTP/1.1" 200 4137 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:17.755--ServerSession(1171543559)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:17.768--ServerSession(1171543559)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:17.971--ServerSession(1171543559)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=314) Can't create table `policyadmin`.`#sql-1_13a` (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)")
[EL Warning]: 2021-04-23 02:15:17.994--ServerSession(1171543559)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=314) Can't create table `policyadmin`.`#sql-1_13a` (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 Info]: connection: 2021-04-23 02:15:18.558--ServerSession(1171543559)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:18.562+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:17 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.PciPolicy/versions/1.0.0 HTTP/1.1" 200 3291 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:18.732--ServerSession(1603686690)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:18.751--ServerSession(1603686690)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:18.954--ServerSession(1603686690)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=316) Can't create table `policyadmin`.`#sql-1_13c` (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)")
[EL Warning]: 2021-04-23 02:15:18.978--ServerSession(1603686690)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=316) Can't create table `policyadmin`.`#sql-1_13c` (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 Info]: connection: 2021-04-23 02:15:19.467--ServerSession(1603686690)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:19.470+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:18 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.Vim_fit/versions/1.0.0 HTTP/1.1" 200 2982 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:19.628--ServerSession(1521713799)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:19.65--ServerSession(1521713799)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:19.852--ServerSession(1521713799)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=319) Can't create table `policyadmin`.`#sql-1_13f` (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)")
[EL Warning]: 2021-04-23 02:15:19.88--ServerSession(1521713799)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=319) Can't create table `policyadmin`.`#sql-1_13f` (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 Info]: connection: 2021-04-23 02:15:20.321--ServerSession(1521713799)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:20.325+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:19 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.resource.VnfPolicy/versions/1.0.0 HTTP/1.1" 200 3441 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:20.477--ServerSession(894445839)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:20.488--ServerSession(894445839)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:20.734--ServerSession(894445839)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=321) Can't create table `policyadmin`.`#sql-1_141` (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)")
[EL Warning]: 2021-04-23 02:15:20.757--ServerSession(894445839)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=321) Can't create table `policyadmin`.`#sql-1_141` (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 Info]: connection: 2021-04-23 02:15:21.217--ServerSession(894445839)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:21.220+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:20 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.service.QueryPolicy/versions/1.0.0 HTTP/1.1" 200 2642 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:15:21.483--ServerSession(1734476728)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:15:21.5--ServerSession(1734476728)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:15:21.677--ServerSession(1734476728)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=324) Can't create table `policyadmin`.`#sql-1_144` (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)")
[EL Warning]: 2021-04-23 02:15:21.703--ServerSession(1734476728)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=324) Can't create table `policyadmin`.`#sql-1_144` (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 Info]: connection: 2021-04-23 02:15:22.135--ServerSession(1734476728)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:15:22.140+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:15:21 +0000] "GET /policy/api/v1/policytypes/onap.policies.optimization.service.SubscriberPolicy/versions/1.0.0 HTTP/1.1" 200 2904 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:19:41.979--ServerSession(906049347)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:19:41.998--ServerSession(906049347)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:19:42.204--ServerSession(906049347)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=395) Can't create table `policyadmin`.`#sql-1_18b` (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)")
[EL Warning]: 2021-04-23 02:19:42.229--ServerSession(906049347)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=395) Can't create table `policyadmin`.`#sql-1_18b` (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 Info]: connection: 2021-04-23 02:19:42.92--ServerSession(906049347)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:19:42.927+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:19:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:24:42.019--ServerSession(301988507)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:24:42.095--ServerSession(301988507)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:24:42.477--ServerSession(301988507)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=477) Can't create table `policyadmin`.`#sql-1_1dd` (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)")
[EL Warning]: 2021-04-23 02:24:42.503--ServerSession(301988507)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=477) Can't create table `policyadmin`.`#sql-1_1dd` (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 Info]: connection: 2021-04-23 02:24:43.287--ServerSession(301988507)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:24:43.298+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:24:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:29:42.015--ServerSession(1787519756)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:29:42.033--ServerSession(1787519756)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:29:42.25--ServerSession(1787519756)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=553) Can't create table `policyadmin`.`#sql-1_229` (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)")
[EL Warning]: 2021-04-23 02:29:42.276--ServerSession(1787519756)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=553) Can't create table `policyadmin`.`#sql-1_229` (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 Info]: connection: 2021-04-23 02:29:43.081--ServerSession(1787519756)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:29:43.087+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.69.130 - healthcheck [23/Apr/2021:02:29:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:34:42.078--ServerSession(263967497)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:34:42.094--ServerSession(263967497)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:34:42.263--ServerSession(263967497)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=635) Can't create table `policyadmin`.`#sql-1_27b` (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)")
[EL Warning]: 2021-04-23 02:34:42.288--ServerSession(263967497)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=635) Can't create table `policyadmin`.`#sql-1_27b` (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 Info]: connection: 2021-04-23 02:34:43.058--ServerSession(263967497)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:34:43.067+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:34:42 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:39:41.98--ServerSession(21434692)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:39:41.999--ServerSession(21434692)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:39:42.25--ServerSession(21434692)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=711) Can't create table `policyadmin`.`#sql-1_2c7` (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)")
[EL Warning]: 2021-04-23 02:39:42.276--ServerSession(21434692)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=711) Can't create table `policyadmin`.`#sql-1_2c7` (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 Info]: connection: 2021-04-23 02:39:42.993--ServerSession(21434692)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:39:43.001+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.69.130 - healthcheck [23/Apr/2021:02:39:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:44:42.038--ServerSession(736408242)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:44:42.06--ServerSession(736408242)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:44:42.263--ServerSession(736408242)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=793) Can't create table `policyadmin`.`#sql-1_319` (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)")
[EL Warning]: 2021-04-23 02:44:42.288--ServerSession(736408242)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=793) Can't create table `policyadmin`.`#sql-1_319` (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 Info]: connection: 2021-04-23 02:44:43.055--ServerSession(736408242)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:44:43.061+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.69.130 - healthcheck [23/Apr/2021:02:44:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:49:42.088--ServerSession(231025989)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:49:42.154--ServerSession(231025989)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:49:42.357--ServerSession(231025989)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=869) Can't create table `policyadmin`.`#sql-1_365` (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)")
[EL Warning]: 2021-04-23 02:49:42.383--ServerSession(231025989)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=869) Can't create table `policyadmin`.`#sql-1_365` (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 Info]: connection: 2021-04-23 02:49:43.603--ServerSession(231025989)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:49:43.609+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.69.130 - healthcheck [23/Apr/2021:02:49:42 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 02:54:42.079--ServerSession(2123496787)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:54:42.099--ServerSession(2123496787)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:54:42.275--ServerSession(2123496787)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=951) Can't create table `policyadmin`.`#sql-1_3b7` (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)")
[EL Warning]: 2021-04-23 02:54:42.3--ServerSession(2123496787)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=951) Can't create table `policyadmin`.`#sql-1_3b7` (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 Info]: connection: 2021-04-23 02:54:43.032--ServerSession(2123496787)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:54:43.038+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.69.130 - healthcheck [23/Apr/2021:02:54:42 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-04-23T02:57:00.223+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.74.253 - healthcheck [23/Apr/2021:02:57:00 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T02:57:00.996+00:00|INFO|OrderedServiceImpl|qtp1110014943-23] ***** OrderedServiceImpl implementers:
 []
[2021-04-23T02:57:01.050+00:00|INFO|network|qtp1110014943-23] [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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 02:57:01.077--ServerSession(1070246970)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:57:01.151--ServerSession(1070246970)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:57:01.319--ServerSession(1070246970)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=991) Can't create table `policyadmin`.`#sql-1_3df` (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)")
[EL Warning]: 2021-04-23 02:57:01.342--ServerSession(1070246970)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=991) Can't create table `policyadmin`.`#sql-1_3df` (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 Info]: connection: 2021-04-23 02:57:01.662--ServerSession(1070246970)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:57:01.665+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.74.71 - healthcheck [23/Apr/2021:02:57:00 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 02:57:01.78--ServerSession(403226886)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:57:01.795--ServerSession(403226886)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:57:02.016--ServerSession(403226886)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=993) Can't create table `policyadmin`.`#sql-1_3e1` (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)")
[EL Warning]: 2021-04-23 02:57:02.038--ServerSession(403226886)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=993) Can't create table `policyadmin`.`#sql-1_3e1` (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 Info]: connection: 2021-04-23 02:57:02.319--ServerSession(403226886)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:57:02.322+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.74.71 - healthcheck [23/Apr/2021:02:57:01 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 02:57:04.582--ServerSession(1625215641)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:57:04.595--ServerSession(1625215641)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:57:04.839--ServerSession(1625215641)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=999) Can't create table `policyadmin`.`#sql-1_3e7` (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)")
[EL Warning]: 2021-04-23 02:57:04.866--ServerSession(1625215641)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=999) Can't create table `policyadmin`.`#sql-1_3e7` (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 Info]: connection: 2021-04-23 02:57:05.469--ServerSession(1625215641)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:57:05.471+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.74.71 - healthcheck [23/Apr/2021:02:57:04 +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 1189 "-" "python-requests/2.25.1"
[2021-04-23T02:59:09.154+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.74.253 - healthcheck [23/Apr/2021:02:59:09 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T02:59:09.672+00:00|INFO|network|qtp1110014943-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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 02:59:09.699--ServerSession(98060080)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:59:09.752--ServerSession(98060080)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:59:09.947--ServerSession(98060080)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1034) Can't create table `policyadmin`.`#sql-1_40a` (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)")
[EL Warning]: 2021-04-23 02:59:09.967--ServerSession(98060080)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1034) Can't create table `policyadmin`.`#sql-1_40a` (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 Info]: connection: 2021-04-23 02:59:10.294--ServerSession(98060080)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:59:10.297+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.75.113 - healthcheck [23/Apr/2021:02:59:09 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 02:59:10.393--ServerSession(443638584)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:59:10.409--ServerSession(443638584)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:59:10.608--ServerSession(443638584)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1036) Can't create table `policyadmin`.`#sql-1_40c` (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)")
[EL Warning]: 2021-04-23 02:59:10.635--ServerSession(443638584)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1036) Can't create table `policyadmin`.`#sql-1_40c` (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 Info]: connection: 2021-04-23 02:59:10.955--ServerSession(443638584)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:59:10.958+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.75.113 - healthcheck [23/Apr/2021:02:59:10 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 02:59:12.602--ServerSession(1676403202)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:59:12.614--ServerSession(1676403202)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:59:12.787--ServerSession(1676403202)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1043) Can't create table `policyadmin`.`#sql-1_413` (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)")
[EL Warning]: 2021-04-23 02:59:12.819--ServerSession(1676403202)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1043) Can't create table `policyadmin`.`#sql-1_413` (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 Info]: connection: 2021-04-23 02:59:13.144--ServerSession(1676403202)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:59:13.146+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.75.113 - healthcheck [23/Apr/2021:02:59:12 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 02:59:42.015--ServerSession(392994039)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 02:59:42.029--ServerSession(392994039)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 02:59:42.259--ServerSession(392994039)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1051) Can't create table `policyadmin`.`#sql-1_41b` (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)")
[EL Warning]: 2021-04-23 02:59:42.286--ServerSession(392994039)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1051) Can't create table `policyadmin`.`#sql-1_41b` (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 Info]: connection: 2021-04-23 02:59:43.162--ServerSession(392994039)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T02:59:43.170+00:00|INFO|RequestLog|qtp1110014943-25] 10.233.69.130 - healthcheck [23/Apr/2021:02:59:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-04-23T03:00:38.639+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.74.253 - healthcheck [23/Apr/2021:03:00:38 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T03:00:39.152+00:00|INFO|network|qtp1110014943-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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 03:00:39.179--ServerSession(2133633628)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:00:39.293--ServerSession(2133633628)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:00:39.508--ServerSession(2133633628)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1073) Can't create table `policyadmin`.`#sql-1_431` (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)")
[EL Warning]: 2021-04-23 03:00:39.548--ServerSession(2133633628)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1073) Can't create table `policyadmin`.`#sql-1_431` (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 Info]: connection: 2021-04-23 03:00:39.947--ServerSession(2133633628)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:00:39.950+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.70.70 - healthcheck [23/Apr/2021:03:00:39 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:00:40.078--ServerSession(1253958056)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:00:40.093--ServerSession(1253958056)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:00:40.268--ServerSession(1253958056)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1076) Can't create table `policyadmin`.`#sql-1_434` (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)")
[EL Warning]: 2021-04-23 03:00:40.295--ServerSession(1253958056)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1076) Can't create table `policyadmin`.`#sql-1_434` (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 Info]: connection: 2021-04-23 03:00:40.582--ServerSession(1253958056)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:00:40.585+00:00|INFO|RequestLog|qtp1110014943-23] 10.233.70.70 - healthcheck [23/Apr/2021:03:00:40 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:00:42.275--ServerSession(1116874454)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:00:42.287--ServerSession(1116874454)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:00:42.525--ServerSession(1116874454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1083) Can't create table `policyadmin`.`#sql-1_43b` (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)")
[EL Warning]: 2021-04-23 03:00:42.551--ServerSession(1116874454)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1083) Can't create table `policyadmin`.`#sql-1_43b` (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 Info]: connection: 2021-04-23 03:00:42.873--ServerSession(1116874454)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:00:42.875+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.70.70 - healthcheck [23/Apr/2021:03:00:42 +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 1189 "-" "python-requests/2.25.1"
[2021-04-23T03:02:09.050+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.74.253 - healthcheck [23/Apr/2021:03:02:08 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T03:02:09.454+00:00|INFO|network|qtp1110014943-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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 03:02:09.486--ServerSession(1467128752)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:02:09.503--ServerSession(1467128752)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:02:09.74--ServerSession(1467128752)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1106) Can't create table `policyadmin`.`#sql-1_452` (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)")
[EL Warning]: 2021-04-23 03:02:09.764--ServerSession(1467128752)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1106) Can't create table `policyadmin`.`#sql-1_452` (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 Info]: connection: 2021-04-23 03:02:10.077--ServerSession(1467128752)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:02:10.080+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.74.66 - healthcheck [23/Apr/2021:03:02:09 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:02:10.181--ServerSession(709754817)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:02:10.196--ServerSession(709754817)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:02:10.411--ServerSession(709754817)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1108) Can't create table `policyadmin`.`#sql-1_454` (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)")
[EL Warning]: 2021-04-23 03:02:10.438--ServerSession(709754817)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1108) Can't create table `policyadmin`.`#sql-1_454` (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 Info]: connection: 2021-04-23 03:02:10.711--ServerSession(709754817)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:02:10.714+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.74.66 - healthcheck [23/Apr/2021:03:02:10 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:02:12.878--ServerSession(1059813996)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:02:12.897--ServerSession(1059813996)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:02:13.131--ServerSession(1059813996)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1117) Can't create table `policyadmin`.`#sql-1_45d` (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)")
[EL Warning]: 2021-04-23 03:02:13.168--ServerSession(1059813996)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1117) Can't create table `policyadmin`.`#sql-1_45d` (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 Info]: connection: 2021-04-23 03:02:13.505--ServerSession(1059813996)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:02:13.507+00:00|INFO|RequestLog|qtp1110014943-27] 10.233.74.66 - healthcheck [23/Apr/2021:03:02:12 +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 1189 "-" "python-requests/2.25.1"
[2021-04-23T03:03:48.304+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.74.253 - healthcheck [23/Apr/2021:03:03:48 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T03:03:48.863+00:00|INFO|network|qtp1110014943-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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 03:03:48.882--ServerSession(1120238163)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:03:48.897--ServerSession(1120238163)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:03:49.16--ServerSession(1120238163)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1141) Can't create table `policyadmin`.`#sql-1_475` (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)")
[EL Warning]: 2021-04-23 03:03:49.185--ServerSession(1120238163)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1141) Can't create table `policyadmin`.`#sql-1_475` (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 Info]: connection: 2021-04-23 03:03:49.483--ServerSession(1120238163)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:03:49.485+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.75.247 - healthcheck [23/Apr/2021:03:03:48 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:03:49.588--ServerSession(264204909)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:03:49.662--ServerSession(264204909)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:03:49.861--ServerSession(264204909)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1144) Can't create table `policyadmin`.`#sql-1_478` (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)")
[EL Warning]: 2021-04-23 03:03:49.885--ServerSession(264204909)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1144) Can't create table `policyadmin`.`#sql-1_478` (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 Info]: connection: 2021-04-23 03:03:50.156--ServerSession(264204909)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:03:50.158+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.75.247 - healthcheck [23/Apr/2021:03:03:49 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:03:51.871--ServerSession(40273056)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:03:51.886--ServerSession(40273056)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:03:52.06--ServerSession(40273056)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1151) Can't create table `policyadmin`.`#sql-1_47f` (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)")
[EL Warning]: 2021-04-23 03:03:52.083--ServerSession(40273056)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1151) Can't create table `policyadmin`.`#sql-1_47f` (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 Info]: connection: 2021-04-23 03:03:52.4--ServerSession(40273056)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:03:52.402+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.75.247 - healthcheck [23/Apr/2021:03:03:51 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:04:42.068--ServerSession(1338658893)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:04:42.085--ServerSession(1338658893)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:04:42.303--ServerSession(1338658893)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1169) Can't create table `policyadmin`.`#sql-1_491` (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)")
[EL Warning]: 2021-04-23 03:04:42.328--ServerSession(1338658893)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1169) Can't create table `policyadmin`.`#sql-1_491` (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 Info]: connection: 2021-04-23 03:04:43.152--ServerSession(1338658893)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:04:43.162+00:00|INFO|RequestLog|qtp1110014943-24] 10.233.69.130 - healthcheck [23/Apr/2021:03:04:42 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-04-23T03:05:09.279+00:00|INFO|RequestLog|qtp1110014943-40] 10.233.74.253 - healthcheck [23/Apr/2021:03:05:09 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T03:05:09.739+00:00|INFO|network|qtp1110014943-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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 03:05:09.769--ServerSession(1125317765)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:05:09.784--ServerSession(1125317765)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:05:09.99--ServerSession(1125317765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1180) Can't create table `policyadmin`.`#sql-1_49c` (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)")
[EL Warning]: 2021-04-23 03:05:10.014--ServerSession(1125317765)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1180) Can't create table `policyadmin`.`#sql-1_49c` (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 Info]: connection: 2021-04-23 03:05:10.337--ServerSession(1125317765)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:05:10.339+00:00|INFO|RequestLog|qtp1110014943-26] 10.233.75.180 - healthcheck [23/Apr/2021:03:05:09 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:05:10.455--ServerSession(974339797)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:05:10.469--ServerSession(974339797)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:05:10.697--ServerSession(974339797)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1182) Can't create table `policyadmin`.`#sql-1_49e` (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)")
[EL Warning]: 2021-04-23 03:05:10.726--ServerSession(974339797)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1182) Can't create table `policyadmin`.`#sql-1_49e` (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 Info]: connection: 2021-04-23 03:05:11.064--ServerSession(974339797)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:05:11.066+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.75.180 - healthcheck [23/Apr/2021:03:05:10 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:05:12.877--ServerSession(2021446101)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:05:12.89--ServerSession(2021446101)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:05:13.125--ServerSession(2021446101)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1189) Can't create table `policyadmin`.`#sql-1_4a5` (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)")
[EL Warning]: 2021-04-23 03:05:13.146--ServerSession(2021446101)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1189) Can't create table `policyadmin`.`#sql-1_4a5` (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 Info]: connection: 2021-04-23 03:05:13.597--ServerSession(2021446101)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:05:13.599+00:00|INFO|RequestLog|qtp1110014943-40] 10.233.75.180 - healthcheck [23/Apr/2021:03:05:12 +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 1189 "-" "python-requests/2.25.1"
[2021-04-23T03:07:51.638+00:00|INFO|RequestLog|qtp1110014943-40] 10.233.74.253 - healthcheck [23/Apr/2021:03:07:51 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-04-23T03:07:52.162+00:00|INFO|network|qtp1110014943-21] [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"}],"controllerName":"frankfurt"},"version":"1.0.0","metadata":{"policy-id":"operational.modifyconfig"}}}]}}
[EL Info]: 2021-04-23 03:07:52.185--ServerSession(345991956)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:07:52.202--ServerSession(345991956)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:07:52.383--ServerSession(345991956)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1231) Can't create table `policyadmin`.`#sql-1_4cf` (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)")
[EL Warning]: 2021-04-23 03:07:52.405--ServerSession(345991956)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1231) Can't create table `policyadmin`.`#sql-1_4cf` (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 Info]: connection: 2021-04-23 03:07:52.731--ServerSession(345991956)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:07:52.733+00:00|INFO|RequestLog|qtp1110014943-21] 10.233.70.173 - healthcheck [23/Apr/2021:03:07:52 +0000] "POST /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:07:52.836--ServerSession(1138073478)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:07:52.848--ServerSession(1138073478)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:07:53.035--ServerSession(1138073478)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1233) Can't create table `policyadmin`.`#sql-1_4d1` (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)")
[EL Warning]: 2021-04-23 03:07:53.074--ServerSession(1138073478)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1233) Can't create table `policyadmin`.`#sql-1_4d1` (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 Info]: connection: 2021-04-23 03:07:53.35--ServerSession(1138073478)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:07:53.351+00:00|INFO|RequestLog|qtp1110014943-28] 10.233.70.173 - healthcheck [23/Apr/2021:03:07:52 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:07:55.069--ServerSession(1650334915)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:07:55.081--ServerSession(1650334915)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:07:55.245--ServerSession(1650334915)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1239) Can't create table `policyadmin`.`#sql-1_4d7` (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)")
[EL Warning]: 2021-04-23 03:07:55.271--ServerSession(1650334915)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1239) Can't create table `policyadmin`.`#sql-1_4d7` (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 Info]: connection: 2021-04-23 03:07:55.583--ServerSession(1650334915)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:07:55.585+00:00|INFO|RequestLog|qtp1110014943-40] 10.233.70.173 - healthcheck [23/Apr/2021:03:07:54 +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 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-04-23 03:09:41.979--ServerSession(449530650)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:09:41.993--ServerSession(449530650)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:09:42.161--ServerSession(449530650)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1269) Can't create table `policyadmin`.`#sql-1_4f5` (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)")
[EL Warning]: 2021-04-23 03:09:42.203--ServerSession(449530650)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1269) Can't create table `policyadmin`.`#sql-1_4f5` (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 Info]: connection: 2021-04-23 03:09:42.923--ServerSession(449530650)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:09:42.929+00:00|INFO|RequestLog|qtp1110014943-39] 10.233.69.130 - healthcheck [23/Apr/2021:03:09:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 03:14:41.986--ServerSession(1241715918)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:14:42.09--ServerSession(1241715918)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:14:42.264--ServerSession(1241715918)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1351) Can't create table `policyadmin`.`#sql-1_547` (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)")
[EL Warning]: 2021-04-23 03:14:42.288--ServerSession(1241715918)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1351) Can't create table `policyadmin`.`#sql-1_547` (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 Info]: connection: 2021-04-23 03:14:43.28--ServerSession(1241715918)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:14:43.286+00:00|INFO|RequestLog|qtp1110014943-40] 10.233.69.130 - healthcheck [23/Apr/2021:03:14:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 03:19:42.022--ServerSession(1743301287)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:19:42.053--ServerSession(1743301287)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:19:42.262--ServerSession(1743301287)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1427) Can't create table `policyadmin`.`#sql-1_593` (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)")
[EL Warning]: 2021-04-23 03:19:42.286--ServerSession(1743301287)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1427) Can't create table `policyadmin`.`#sql-1_593` (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 Info]: connection: 2021-04-23 03:19:43.083--ServerSession(1743301287)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:19:43.090+00:00|INFO|RequestLog|qtp1110014943-39] 10.233.69.130 - healthcheck [23/Apr/2021:03:19:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-04-23 03:24:41.975--ServerSession(297573656)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-04-23 03:24:41.99--ServerSession(297573656)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user login successful
[EL Warning]: 2021-04-23 03:24:42.162--ServerSession(297573656)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1509) Can't create table `policyadmin`.`#sql-1_5e5` (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)")
[EL Warning]: 2021-04-23 03:24:42.188--ServerSession(297573656)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1509) Can't create table `policyadmin`.`#sql-1_5e5` (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 Info]: connection: 2021-04-23 03:24:42.981--ServerSession(297573656)--/file:/opt/app/policy/api/lib/api-main-2.3.3.jar_PolicyMariaDb_url=jdbc:mariadb://policy-mariadb:3306/policyadmin_user=policy_user logout successful
[2021-04-23T03:24:42.986+00:00|INFO|RequestLog|qtp1110014943-39] 10.233.69.130 - healthcheck [23/Apr/2021:03:24:41 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"