Results

By type
Logs
raw version
          + 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='g0CM5y51u9j}ao{}KN@P{i@K'
+ TRUSTSTORE_PASSWD=Pol1cy_0nap
Policy api config file: /opt/app/policy/api/etc/mounted/config.json
overriding logback.xml
+ '[' 1 -eq 1 ']'
+ CONFIG_FILE=/opt/app/policy/api/etc/mounted/config.json
+ '[' -z /opt/app/policy/api/etc/mounted/config.json ']'
+ 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=g0CM5y51u9j}ao{}KN@P{i@K' -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-05-25T02:30:02.420+00:00|INFO|Main|main] Starting policy api service with arguments - [-c, /opt/app/policy/api/etc/mounted/config.json]
[EL Info]: 2021-05-25 02:30:03.991--ServerSession(1288108586)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:30:04.303--ServerSession(1288108586)--/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-05-25 02:30:04.581--ServerSession(1288108586)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=303) Can't create table `policyadmin`.`#sql-1_12f` (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-05-25 02:30:04.613--ServerSession(1288108586)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=303) Can't create table `policyadmin`.`#sql-1_12f` (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-05-25 02:30:07.223--ServerSession(1288108586)--/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-05-25T02:30:07.706+00:00|INFO|ServiceManager|main] service manager starting
[2021-05-25T02:30:07.707+00:00|INFO|ServiceManager|main] service manager starting REST ApiGroup
[2021-05-25T02:30:07.707+00:00|INFO|JettyServletServer|main] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-4f114b@6220ba8e==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@492521c4{STOPPED}[9.4.30.v20200611], context=o.e.j.s.ServletContextHandler@443a06ad{/,null,UNAVAILABLE}, connector=ApiGroup@74ba6ff5{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=null]]: STARTING
[2021-05-25T02:30:07.715+00:00|INFO|ServiceManager|main] service manager started
[2021-05-25T02:30:07.715+00:00|INFO|JettyServletServer|ApiGroup-6969] JettyJerseyServer [Jerseyservlets={/*=org.glassfish.jersey.servlet.ServletContainer-4f114b@6220ba8e==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@492521c4{STOPPED}[9.4.30.v20200611], context=o.e.j.s.ServletContextHandler@443a06ad{/,null,UNAVAILABLE}, connector=ApiGroup@74ba6ff5{SSL, (ssl, http/1.1)}{0.0.0.0:6969}, jettyThread=Thread[ApiGroup-6969,5,main]]]: STARTING
[2021-05-25T02:30:07.716+00:00|INFO|Main|main] Started policy-api service successfully.
[2021-05-25T02:30:09.187+00:00|INFO|GsonMessageBodyHandler|ApiGroup-6969] Using GSON for REST calls
[2021-05-25T02:30:09.187+00:00|INFO|YamlMessageBodyHandler|ApiGroup-6969] Accepting YAML for REST calls
[EL Info]: 2021-05-25 02:31:14.914--ServerSession(999056021)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:14.996--ServerSession(999056021)--/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-05-25 02:31:15.225--ServerSession(999056021)--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-05-25 02:31:15.248--ServerSession(999056021)--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-05-25 02:31:16.722--ServerSession(999056021)--/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-05-25T02:31:16.908+00:00|INFO|RequestLog|qtp1146867354-28] 10.233.75.40 - healthcheck [25/May/2021:02:31:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 02:31:17.518--ServerSession(1818477324)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:17.596--ServerSession(1818477324)--/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-05-25 02:31:17.795--ServerSession(1818477324)--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-05-25 02:31:17.833--ServerSession(1818477324)--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-05-25 02:31:18.51--ServerSession(1818477324)--/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-05-25T02:31:18.512+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:17 +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-05-25 02:31:18.906--ServerSession(830737925)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:18.996--ServerSession(830737925)--/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-05-25 02:31:19.168--ServerSession(830737925)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=325) Can't create table `policyadmin`.`#sql-1_145` (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-05-25 02:31:19.188--ServerSession(830737925)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=325) Can't create table `policyadmin`.`#sql-1_145` (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-05-25 02:31:19.891--ServerSession(830737925)--/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-05-25T02:31:19.894+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:18 +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-05-25 02:31:20.208--ServerSession(1952278862)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:20.287--ServerSession(1952278862)--/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-05-25 02:31:20.429--ServerSession(1952278862)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=327) Can't create table `policyadmin`.`#sql-1_147` (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-05-25 02:31:20.45--ServerSession(1952278862)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=327) Can't create table `policyadmin`.`#sql-1_147` (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-05-25 02:31:21.021--ServerSession(1952278862)--/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-05-25T02:31:21.024+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:20 +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-05-25 02:31:21.323--ServerSession(1527920641)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:21.401--ServerSession(1527920641)--/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-05-25 02:31:21.617--ServerSession(1527920641)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=329) Can't create table `policyadmin`.`#sql-1_149` (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-05-25 02:31:21.635--ServerSession(1527920641)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=329) Can't create table `policyadmin`.`#sql-1_149` (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-05-25 02:31:22.221--ServerSession(1527920641)--/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-05-25T02:31:22.224+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.75.40 - healthcheck [25/May/2021:02:31:21 +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-05-25 02:31:22.598--ServerSession(356572205)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:22.621--ServerSession(356572205)--/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-05-25 02:31:22.822--ServerSession(356572205)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=331) Can't create table `policyadmin`.`#sql-1_14b` (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-05-25 02:31:22.842--ServerSession(356572205)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=331) Can't create table `policyadmin`.`#sql-1_14b` (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-05-25 02:31:23.332--ServerSession(356572205)--/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-05-25T02:31:23.386+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:22 +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-05-25 02:31:23.598--ServerSession(1016043102)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:23.617--ServerSession(1016043102)--/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-05-25 02:31:23.81--ServerSession(1016043102)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=333) Can't create table `policyadmin`.`#sql-1_14d` (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-05-25 02:31:23.829--ServerSession(1016043102)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=333) Can't create table `policyadmin`.`#sql-1_14d` (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-05-25 02:31:24.308--ServerSession(1016043102)--/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-05-25T02:31:24.312+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:23 +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-05-25 02:31:24.59--ServerSession(963511013)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:24.609--ServerSession(963511013)--/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-05-25 02:31:24.842--ServerSession(963511013)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=335) Can't create table `policyadmin`.`#sql-1_14f` (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-05-25 02:31:24.862--ServerSession(963511013)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=335) Can't create table `policyadmin`.`#sql-1_14f` (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-05-25 02:31:25.321--ServerSession(963511013)--/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-05-25T02:31:25.324+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:02:31:24 +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-05-25 02:31:25.49--ServerSession(402829077)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:25.506--ServerSession(402829077)--/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-05-25 02:31:25.713--ServerSession(402829077)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=337) Can't create table `policyadmin`.`#sql-1_151` (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-05-25 02:31:25.735--ServerSession(402829077)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=337) Can't create table `policyadmin`.`#sql-1_151` (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-05-25 02:31:26.11--ServerSession(402829077)--/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-05-25T02:31:26.113+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:02:31:25 +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-05-25 02:31:26.305--ServerSession(2022641516)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:26.393--ServerSession(2022641516)--/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-05-25 02:31:26.57--ServerSession(2022641516)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=339) Can't create table `policyadmin`.`#sql-1_153` (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-05-25 02:31:26.592--ServerSession(2022641516)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=339) Can't create table `policyadmin`.`#sql-1_153` (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-05-25 02:31:27.133--ServerSession(2022641516)--/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-05-25T02:31:27.135+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:02:31:26 +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-05-25 02:31:27.292--ServerSession(597848531)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:27.308--ServerSession(597848531)--/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-05-25 02:31:27.506--ServerSession(597848531)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=341) Can't create table `policyadmin`.`#sql-1_155` (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-05-25 02:31:27.526--ServerSession(597848531)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=341) Can't create table `policyadmin`.`#sql-1_155` (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-05-25 02:31:27.912--ServerSession(597848531)--/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-05-25T02:31:27.914+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.75.40 - healthcheck [25/May/2021:02:31:27 +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-05-25 02:31:28.098--ServerSession(332000161)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:28.112--ServerSession(332000161)--/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-05-25 02:31:28.307--ServerSession(332000161)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=344) Can't create table `policyadmin`.`#sql-1_158` (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-05-25 02:31:28.334--ServerSession(332000161)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=344) Can't create table `policyadmin`.`#sql-1_158` (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-05-25 02:31:28.733--ServerSession(332000161)--/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-05-25T02:31:28.736+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:28 +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-05-25 02:31:28.991--ServerSession(812948257)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:29.086--ServerSession(812948257)--/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-05-25 02:31:29.228--ServerSession(812948257)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=347) Can't create table `policyadmin`.`#sql-1_15b` (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-05-25 02:31:29.251--ServerSession(812948257)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=347) Can't create table `policyadmin`.`#sql-1_15b` (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-05-25 02:31:29.654--ServerSession(812948257)--/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-05-25T02:31:29.656+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:02:31:28 +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-05-25 02:31:29.801--ServerSession(876515458)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:29.815--ServerSession(876515458)--/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-05-25 02:31:30.012--ServerSession(876515458)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=349) Can't create table `policyadmin`.`#sql-1_15d` (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-05-25 02:31:30.032--ServerSession(876515458)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=349) Can't create table `policyadmin`.`#sql-1_15d` (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-05-25 02:31:30.362--ServerSession(876515458)--/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-05-25T02:31:30.365+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:02:31:29 +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-05-25 02:31:30.478--ServerSession(1488547212)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:30.498--ServerSession(1488547212)--/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-05-25 02:31:30.662--ServerSession(1488547212)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=351) Can't create table `policyadmin`.`#sql-1_15f` (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-05-25 02:31:30.686--ServerSession(1488547212)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=351) Can't create table `policyadmin`.`#sql-1_15f` (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-05-25 02:31:31.035--ServerSession(1488547212)--/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-05-25T02:31:31.039+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.75.40 - healthcheck [25/May/2021:02:31:30 +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-05-25 02:31:31.192--ServerSession(1423385422)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:31.205--ServerSession(1423385422)--/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-05-25 02:31:31.348--ServerSession(1423385422)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=353) Can't create table `policyadmin`.`#sql-1_161` (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-05-25 02:31:31.371--ServerSession(1423385422)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=353) Can't create table `policyadmin`.`#sql-1_161` (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-05-25 02:31:31.798--ServerSession(1423385422)--/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-05-25T02:31:31.801+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:31 +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-05-25 02:31:32.186--ServerSession(1176451850)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:32.2--ServerSession(1176451850)--/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-05-25 02:31:32.401--ServerSession(1176451850)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=355) Can't create table `policyadmin`.`#sql-1_163` (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-05-25 02:31:32.42--ServerSession(1176451850)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=355) Can't create table `policyadmin`.`#sql-1_163` (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-05-25 02:31:32.863--ServerSession(1176451850)--/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-05-25T02:31:32.866+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:32 +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-05-25 02:31:33.039--ServerSession(895854822)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:33.055--ServerSession(895854822)--/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-05-25 02:31:33.269--ServerSession(895854822)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=357) Can't create table `policyadmin`.`#sql-1_165` (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-05-25 02:31:33.296--ServerSession(895854822)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=357) Can't create table `policyadmin`.`#sql-1_165` (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-05-25 02:31:33.629--ServerSession(895854822)--/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-05-25T02:31:33.631+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:33 +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-05-25 02:31:33.786--ServerSession(276308907)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:33.836--ServerSession(276308907)--/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-05-25 02:31:33.997--ServerSession(276308907)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=359) Can't create table `policyadmin`.`#sql-1_167` (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-05-25 02:31:34.016--ServerSession(276308907)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=359) Can't create table `policyadmin`.`#sql-1_167` (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-05-25 02:31:34.493--ServerSession(276308907)--/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-05-25T02:31:34.496+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:33 +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-05-25 02:31:34.599--ServerSession(1844995734)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:34.619--ServerSession(1844995734)--/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-05-25 02:31:34.809--ServerSession(1844995734)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=361) Can't create table `policyadmin`.`#sql-1_169` (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-05-25 02:31:34.826--ServerSession(1844995734)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=361) Can't create table `policyadmin`.`#sql-1_169` (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-05-25 02:31:35.167--ServerSession(1844995734)--/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-05-25T02:31:35.171+00:00|INFO|RequestLog|qtp1146867354-28] 10.233.75.40 - healthcheck [25/May/2021:02:31:34 +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-05-25 02:31:35.271--ServerSession(1472713046)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:35.285--ServerSession(1472713046)--/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-05-25 02:31:35.437--ServerSession(1472713046)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=363) Can't create table `policyadmin`.`#sql-1_16b` (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-05-25 02:31:35.455--ServerSession(1472713046)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=363) Can't create table `policyadmin`.`#sql-1_16b` (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-05-25 02:31:35.871--ServerSession(1472713046)--/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-05-25T02:31:35.873+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.75.40 - healthcheck [25/May/2021:02:31:35 +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-05-25 02:31:35.979--ServerSession(1470198236)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:35.993--ServerSession(1470198236)--/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-05-25 02:31:36.155--ServerSession(1470198236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=365) Can't create table `policyadmin`.`#sql-1_16d` (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-05-25 02:31:36.181--ServerSession(1470198236)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=365) Can't create table `policyadmin`.`#sql-1_16d` (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-05-25 02:31:36.545--ServerSession(1470198236)--/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-05-25T02:31:36.547+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:35 +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-05-25 02:31:36.684--ServerSession(82834108)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:36.698--ServerSession(82834108)--/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-05-25 02:31:36.867--ServerSession(82834108)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=367) Can't create table `policyadmin`.`#sql-1_16f` (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-05-25 02:31:36.892--ServerSession(82834108)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=367) Can't create table `policyadmin`.`#sql-1_16f` (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-05-25 02:31:37.327--ServerSession(82834108)--/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-05-25T02:31:37.330+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:02:31:36 +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-05-25 02:31:37.472--ServerSession(1273053229)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:37.496--ServerSession(1273053229)--/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-05-25 02:31:37.636--ServerSession(1273053229)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=369) Can't create table `policyadmin`.`#sql-1_171` (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-05-25 02:31:37.655--ServerSession(1273053229)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=369) Can't create table `policyadmin`.`#sql-1_171` (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-05-25 02:31:38.024--ServerSession(1273053229)--/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-05-25T02:31:38.026+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:37 +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-05-25 02:31:38.319--ServerSession(1907018827)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:38.331--ServerSession(1907018827)--/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-05-25 02:31:38.51--ServerSession(1907018827)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=372) Can't create table `policyadmin`.`#sql-1_174` (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-05-25 02:31:38.533--ServerSession(1907018827)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=372) Can't create table `policyadmin`.`#sql-1_174` (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-05-25 02:31:38.877--ServerSession(1907018827)--/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-05-25T02:31:38.881+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.75.40 - healthcheck [25/May/2021:02:31:38 +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-05-25 02:31:38.987--ServerSession(1619719864)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:38.999--ServerSession(1619719864)--/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-05-25 02:31:39.132--ServerSession(1619719864)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=375) Can't create table `policyadmin`.`#sql-1_177` (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-05-25 02:31:39.154--ServerSession(1619719864)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=375) Can't create table `policyadmin`.`#sql-1_177` (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-05-25 02:31:39.473--ServerSession(1619719864)--/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-05-25T02:31:39.475+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:38 +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-05-25 02:31:39.591--ServerSession(1049657338)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:39.603--ServerSession(1049657338)--/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-05-25 02:31:39.763--ServerSession(1049657338)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=377) Can't create table `policyadmin`.`#sql-1_179` (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-05-25 02:31:39.788--ServerSession(1049657338)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=377) Can't create table `policyadmin`.`#sql-1_179` (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-05-25 02:31:40.136--ServerSession(1049657338)--/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-05-25T02:31:40.139+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:39 +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-05-25 02:31:40.281--ServerSession(1339620972)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:40.294--ServerSession(1339620972)--/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-05-25 02:31:40.436--ServerSession(1339620972)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=379) Can't create table `policyadmin`.`#sql-1_17b` (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-05-25 02:31:40.456--ServerSession(1339620972)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=379) Can't create table `policyadmin`.`#sql-1_17b` (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-05-25 02:31:40.785--ServerSession(1339620972)--/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-05-25T02:31:40.788+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:40 +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-05-25 02:31:40.934--ServerSession(866681953)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:40.987--ServerSession(866681953)--/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-05-25 02:31:41.186--ServerSession(866681953)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=381) Can't create table `policyadmin`.`#sql-1_17d` (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-05-25 02:31:41.211--ServerSession(866681953)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=381) Can't create table `policyadmin`.`#sql-1_17d` (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-05-25 02:31:41.563--ServerSession(866681953)--/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-05-25T02:31:41.566+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:40 +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-05-25 02:31:41.811--ServerSession(699259867)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:41.822--ServerSession(699259867)--/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-05-25 02:31:41.993--ServerSession(699259867)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=383) Can't create table `policyadmin`.`#sql-1_17f` (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-05-25 02:31:42.019--ServerSession(699259867)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=383) Can't create table `policyadmin`.`#sql-1_17f` (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-05-25 02:31:42.349--ServerSession(699259867)--/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-05-25T02:31:42.351+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:41 +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-05-25 02:31:42.47--ServerSession(1231363215)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:42.481--ServerSession(1231363215)--/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-05-25 02:31:42.625--ServerSession(1231363215)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=385) Can't create table `policyadmin`.`#sql-1_181` (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-05-25 02:31:42.642--ServerSession(1231363215)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=385) Can't create table `policyadmin`.`#sql-1_181` (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-05-25 02:31:42.965--ServerSession(1231363215)--/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-05-25T02:31:42.968+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:42 +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-05-25 02:31:43.074--ServerSession(738883825)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:43.086--ServerSession(738883825)--/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-05-25 02:31:43.229--ServerSession(738883825)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=387) Can't create table `policyadmin`.`#sql-1_183` (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-05-25 02:31:43.254--ServerSession(738883825)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=387) Can't create table `policyadmin`.`#sql-1_183` (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-05-25 02:31:43.579--ServerSession(738883825)--/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-05-25T02:31:43.582+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:02:31:43 +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-05-25 02:31:43.676--ServerSession(128962618)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:43.691--ServerSession(128962618)--/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-05-25 02:31:43.816--ServerSession(128962618)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=389) Can't create table `policyadmin`.`#sql-1_185` (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-05-25 02:31:43.833--ServerSession(128962618)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=389) Can't create table `policyadmin`.`#sql-1_185` (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-05-25 02:31:44.147--ServerSession(128962618)--/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-05-25T02:31:44.149+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:31:43 +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-05-25 02:31:44.287--ServerSession(760168252)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:44.298--ServerSession(760168252)--/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-05-25 02:31:44.464--ServerSession(760168252)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=391) Can't create table `policyadmin`.`#sql-1_187` (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-05-25 02:31:44.497--ServerSession(760168252)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=391) Can't create table `policyadmin`.`#sql-1_187` (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-05-25 02:31:44.922--ServerSession(760168252)--/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-05-25T02:31:44.924+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:02:31:44 +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-05-25 02:31:45.069--ServerSession(1991020583)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:31:45.134--ServerSession(1991020583)--/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-05-25 02:31:45.276--ServerSession(1991020583)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=393) Can't create table `policyadmin`.`#sql-1_189` (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-05-25 02:31:45.298--ServerSession(1991020583)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=393) Can't create table `policyadmin`.`#sql-1_189` (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-05-25 02:31:45.609--ServerSession(1991020583)--/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-05-25T02:31:45.612+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:31:45 +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-05-25 02:36:14.147--ServerSession(1173525336)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:36:14.192--ServerSession(1173525336)--/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-05-25 02:36:14.375--ServerSession(1173525336)--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-05-25 02:36:14.395--ServerSession(1173525336)--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-05-25 02:36:15.027--ServerSession(1173525336)--/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-05-25T02:36:15.034+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:36:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 02:41:14.123--ServerSession(51552662)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:41:14.198--ServerSession(51552662)--/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-05-25 02:41:14.361--ServerSession(51552662)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=558) Can't create table `policyadmin`.`#sql-1_22e` (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-05-25 02:41:14.381--ServerSession(51552662)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=558) Can't create table `policyadmin`.`#sql-1_22e` (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-05-25 02:41:15.01--ServerSession(51552662)--/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-05-25T02:41:15.018+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:02:41:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 02:46:14.002--ServerSession(1488514114)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:46:14.017--ServerSession(1488514114)--/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-05-25 02:46:14.155--ServerSession(1488514114)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=638) Can't create table `policyadmin`.`#sql-1_27e` (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-05-25 02:46:14.175--ServerSession(1488514114)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=638) Can't create table `policyadmin`.`#sql-1_27e` (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-05-25 02:46:14.785--ServerSession(1488514114)--/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-05-25T02:46:14.793+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:02:46:13 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 02:51:14.115--ServerSession(565006444)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:51:14.129--ServerSession(565006444)--/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-05-25 02:51:14.291--ServerSession(565006444)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=716) Can't create table `policyadmin`.`#sql-1_2cc` (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-05-25 02:51:14.311--ServerSession(565006444)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=716) Can't create table `policyadmin`.`#sql-1_2cc` (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-05-25 02:51:14.854--ServerSession(565006444)--/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-05-25T02:51:14.860+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.75.40 - healthcheck [25/May/2021:02:51:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 02:56:14.113--ServerSession(1125722535)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 02:56:14.128--ServerSession(1125722535)--/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-05-25 02:56:14.342--ServerSession(1125722535)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=796) Can't create table `policyadmin`.`#sql-1_31c` (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-05-25 02:56:14.361--ServerSession(1125722535)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=796) Can't create table `policyadmin`.`#sql-1_31c` (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-05-25 02:56:15.046--ServerSession(1125722535)--/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-05-25T02:56:15.053+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:02:56:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 03:01:14.011--ServerSession(852919881)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:01:14.026--ServerSession(852919881)--/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-05-25 03:01:14.22--ServerSession(852919881)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=874) Can't create table `policyadmin`.`#sql-1_36a` (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-05-25 03:01:14.241--ServerSession(852919881)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=874) Can't create table `policyadmin`.`#sql-1_36a` (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-05-25 03:01:14.801--ServerSession(852919881)--/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-05-25T03:01:14.807+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:03:01:13 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 03:06:14.034--ServerSession(87887000)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:06:14.09--ServerSession(87887000)--/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-05-25 03:06:14.275--ServerSession(87887000)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=954) Can't create table `policyadmin`.`#sql-1_3ba` (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-05-25 03:06:14.297--ServerSession(87887000)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=954) Can't create table `policyadmin`.`#sql-1_3ba` (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-05-25 03:06:15.231--ServerSession(87887000)--/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-05-25T03:06:15.285+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.75.40 - healthcheck [25/May/2021:03:06:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 03:11:14.123--ServerSession(68428655)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:11:14.143--ServerSession(68428655)--/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-05-25 03:11:14.358--ServerSession(68428655)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1032) Can't create table `policyadmin`.`#sql-1_408` (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-05-25 03:11:14.377--ServerSession(68428655)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1032) Can't create table `policyadmin`.`#sql-1_408` (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-05-25 03:11:14.936--ServerSession(68428655)--/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-05-25T03:11:14.943+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:03:11:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-05-25T03:15:15.304+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.71.60 - healthcheck [25/May/2021:03:15:15 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:15:15.922+00:00|INFO|OrderedServiceImpl|qtp1146867354-27] ***** OrderedServiceImpl implementers:
 []
[2021-05-25T03:15:15.924+00:00|INFO|network|qtp1146867354-27] [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-05-25 03:15:16.001--ServerSession(191743364)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:15:16.016--ServerSession(191743364)--/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-05-25 03:15:16.213--ServerSession(191743364)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1098) Can't create table `policyadmin`.`#sql-1_44a` (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-05-25 03:15:16.236--ServerSession(191743364)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1098) Can't create table `policyadmin`.`#sql-1_44a` (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-05-25 03:15:16.513--ServerSession(191743364)--/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-05-25T03:15:16.516+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.67.44 - healthcheck [25/May/2021:03:15:15 +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-05-25 03:15:16.634--ServerSession(1009147627)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:15:16.686--ServerSession(1009147627)--/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-05-25 03:15:16.823--ServerSession(1009147627)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1100) Can't create table `policyadmin`.`#sql-1_44c` (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-05-25 03:15:16.842--ServerSession(1009147627)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1100) Can't create table `policyadmin`.`#sql-1_44c` (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-05-25 03:15:17.071--ServerSession(1009147627)--/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-05-25T03:15:17.073+00:00|INFO|RequestLog|qtp1146867354-28] 10.233.67.44 - healthcheck [25/May/2021:03:15:16 +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-05-25 03:15:19.017--ServerSession(367981826)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:15:19.027--ServerSession(367981826)--/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-05-25 03:15:19.158--ServerSession(367981826)--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-05-25 03:15:19.177--ServerSession(367981826)--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-05-25 03:15:19.685--ServerSession(367981826)--/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-05-25T03:15:19.687+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.67.44 - healthcheck [25/May/2021:03:15:18 +0000] "DELETE /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-05-25 03:16:14.11--ServerSession(2132416878)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:16:14.125--ServerSession(2132416878)--/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-05-25 03:16:14.263--ServerSession(2132416878)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1124) Can't create table `policyadmin`.`#sql-1_464` (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-05-25 03:16:14.28--ServerSession(2132416878)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1124) Can't create table `policyadmin`.`#sql-1_464` (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-05-25 03:16:15.0--ServerSession(2132416878)--/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-05-25T03:16:15.008+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.75.40 - healthcheck [25/May/2021:03:16:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-05-25T03:17:10.740+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.71.60 - healthcheck [25/May/2021:03:17:10 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:17:11.190+00:00|INFO|network|qtp1146867354-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-05-25 03:17:11.218--ServerSession(1975042095)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:17:11.232--ServerSession(1975042095)--/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-05-25 03:17:11.382--ServerSession(1975042095)--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-05-25 03:17:11.406--ServerSession(1975042095)--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-05-25 03:17:11.648--ServerSession(1975042095)--/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-05-25T03:17:11.651+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.67.243 - healthcheck [25/May/2021:03:17:11 +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-05-25 03:17:11.757--ServerSession(1056848253)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:17:11.771--ServerSession(1056848253)--/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-05-25 03:17:11.906--ServerSession(1056848253)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1146) Can't create table `policyadmin`.`#sql-1_47a` (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-05-25 03:17:11.926--ServerSession(1056848253)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1146) Can't create table `policyadmin`.`#sql-1_47a` (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-05-25 03:17:12.141--ServerSession(1056848253)--/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-05-25T03:17:12.142+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.67.243 - healthcheck [25/May/2021:03:17:11 +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-05-25 03:17:13.416--ServerSession(1458002289)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:17:13.427--ServerSession(1458002289)--/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-05-25 03:17:13.564--ServerSession(1458002289)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1152) Can't create table `policyadmin`.`#sql-1_480` (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-05-25 03:17:13.587--ServerSession(1458002289)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1152) Can't create table `policyadmin`.`#sql-1_480` (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-05-25 03:17:13.823--ServerSession(1458002289)--/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-05-25T03:17:13.825+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.67.243 - healthcheck [25/May/2021:03:17:13 +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-05-25T03:19:06.887+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.71.60 - healthcheck [25/May/2021:03:19:06 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:19:07.292+00:00|INFO|network|qtp1146867354-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-05-25 03:19:07.315--ServerSession(56421618)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:19:07.327--ServerSession(56421618)--/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-05-25 03:19:07.51--ServerSession(56421618)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1184) Can't create table `policyadmin`.`#sql-1_4a0` (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-05-25 03:19:07.53--ServerSession(56421618)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1184) Can't create table `policyadmin`.`#sql-1_4a0` (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-05-25 03:19:07.787--ServerSession(56421618)--/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-05-25T03:19:07.789+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.70.63 - healthcheck [25/May/2021:03:19:07 +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-05-25 03:19:07.881--ServerSession(891654524)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:19:07.891--ServerSession(891654524)--/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-05-25 03:19:08.033--ServerSession(891654524)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1187) Can't create table `policyadmin`.`#sql-1_4a3` (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-05-25 03:19:08.052--ServerSession(891654524)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1187) Can't create table `policyadmin`.`#sql-1_4a3` (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-05-25 03:19:08.271--ServerSession(891654524)--/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-05-25T03:19:08.273+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.70.63 - healthcheck [25/May/2021:03:19:07 +0000] "GET /policy/api/v1/policytypes/onap.policies.controlloop.operational.common.Drools/versions/1.0.0/policies/operational.modifyconfig/versions/1.0.0 HTTP/1.1" 200 1189 "-" "python-requests/2.25.1"
[EL Info]: 2021-05-25 03:19:09.521--ServerSession(75419350)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:19:09.534--ServerSession(75419350)--/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-05-25 03:19:09.722--ServerSession(75419350)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1194) Can't create table `policyadmin`.`#sql-1_4aa` (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-05-25 03:19:09.74--ServerSession(75419350)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1194) Can't create table `policyadmin`.`#sql-1_4aa` (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-05-25 03:19:09.977--ServerSession(75419350)--/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-05-25T03:19:09.980+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.70.63 - healthcheck [25/May/2021:03:19:09 +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-05-25 03:21:14.004--ServerSession(129684727)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:21:14.017--ServerSession(129684727)--/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-05-25 03:21:14.151--ServerSession(129684727)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1226) Can't create table `policyadmin`.`#sql-1_4ca` (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-05-25 03:21:14.169--ServerSession(129684727)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1226) Can't create table `policyadmin`.`#sql-1_4ca` (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-05-25 03:21:15.09--ServerSession(129684727)--/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-05-25T03:21:15.097+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.75.40 - healthcheck [25/May/2021:03:21:13 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-05-25T03:21:34.614+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.71.60 - healthcheck [25/May/2021:03:21:34 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:21:35.089+00:00|INFO|network|qtp1146867354-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-05-25 03:21:35.109--ServerSession(1168216368)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:21:35.119--ServerSession(1168216368)--/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-05-25 03:21:35.295--ServerSession(1168216368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1238) Can't create table `policyadmin`.`#sql-1_4d6` (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-05-25 03:21:35.313--ServerSession(1168216368)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1238) Can't create table `policyadmin`.`#sql-1_4d6` (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-05-25 03:21:35.547--ServerSession(1168216368)--/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-05-25T03:21:35.549+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.72.215 - healthcheck [25/May/2021:03:21:35 +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-05-25 03:21:35.637--ServerSession(1396211852)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:21:35.648--ServerSession(1396211852)--/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-05-25 03:21:35.791--ServerSession(1396211852)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1240) Can't create table `policyadmin`.`#sql-1_4d8` (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-05-25 03:21:35.811--ServerSession(1396211852)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1240) Can't create table `policyadmin`.`#sql-1_4d8` (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-05-25 03:21:36.015--ServerSession(1396211852)--/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-05-25T03:21:36.017+00:00|INFO|RequestLog|qtp1146867354-23] 10.233.72.215 - healthcheck [25/May/2021:03:21:35 +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-05-25 03:21:37.205--ServerSession(1224381447)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:21:37.217--ServerSession(1224381447)--/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-05-25 03:21:37.388--ServerSession(1224381447)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1246) Can't create table `policyadmin`.`#sql-1_4de` (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-05-25 03:21:37.418--ServerSession(1224381447)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1246) Can't create table `policyadmin`.`#sql-1_4de` (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-05-25 03:21:37.651--ServerSession(1224381447)--/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-05-25T03:21:37.653+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.72.215 - healthcheck [25/May/2021:03:21:37 +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-05-25T03:24:00.786+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.71.60 - healthcheck [25/May/2021:03:24:00 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:24:01.188+00:00|INFO|network|qtp1146867354-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-05-25 03:24:01.213--ServerSession(582705890)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:24:01.228--ServerSession(582705890)--/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-05-25 03:24:01.375--ServerSession(582705890)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1288) Can't create table `policyadmin`.`#sql-1_508` (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-05-25 03:24:01.4--ServerSession(582705890)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1288) Can't create table `policyadmin`.`#sql-1_508` (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-05-25 03:24:01.626--ServerSession(582705890)--/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-05-25T03:24:01.628+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.70.36 - healthcheck [25/May/2021:03:24:01 +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-05-25 03:24:01.719--ServerSession(2123959626)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:24:01.732--ServerSession(2123959626)--/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-05-25 03:24:01.927--ServerSession(2123959626)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1290) Can't create table `policyadmin`.`#sql-1_50a` (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-05-25 03:24:01.945--ServerSession(2123959626)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1290) Can't create table `policyadmin`.`#sql-1_50a` (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-05-25 03:24:02.149--ServerSession(2123959626)--/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-05-25T03:24:02.151+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.70.36 - healthcheck [25/May/2021:03:24: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-05-25 03:24:03.607--ServerSession(1479270262)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:24:03.627--ServerSession(1479270262)--/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-05-25 03:24:03.81--ServerSession(1479270262)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1296) Can't create table `policyadmin`.`#sql-1_510` (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-05-25 03:24:03.834--ServerSession(1479270262)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1296) Can't create table `policyadmin`.`#sql-1_510` (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-05-25 03:24:04.062--ServerSession(1479270262)--/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-05-25T03:24:04.064+00:00|INFO|RequestLog|qtp1146867354-21] 10.233.70.36 - healthcheck [25/May/2021:03:24:03 +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-05-25 03:26:14.101--ServerSession(1944299712)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:26:14.117--ServerSession(1944299712)--/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-05-25 03:26:14.257--ServerSession(1944299712)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1330) Can't create table `policyadmin`.`#sql-1_532` (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-05-25 03:26:14.276--ServerSession(1944299712)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1330) Can't create table `policyadmin`.`#sql-1_532` (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-05-25 03:26:14.911--ServerSession(1944299712)--/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-05-25T03:26:14.917+00:00|INFO|RequestLog|qtp1146867354-27] 10.233.75.40 - healthcheck [25/May/2021:03:26:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[2021-05-25T03:26:39.805+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.71.60 - healthcheck [25/May/2021:03:26:39 +0000] "GET /policy/api/v1/healthcheck HTTP/1.1" 200 105 "-" "Jersey/2.30.1 (HttpUrlConnection 11.0.8)"
[2021-05-25T03:26:40.200+00:00|INFO|network|qtp1146867354-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-05-25 03:26:40.226--ServerSession(2070658212)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:26:40.238--ServerSession(2070658212)--/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-05-25 03:26:40.466--ServerSession(2070658212)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1342) Can't create table `policyadmin`.`#sql-1_53e` (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-05-25 03:26:40.484--ServerSession(2070658212)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1342) Can't create table `policyadmin`.`#sql-1_53e` (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-05-25 03:26:40.805--ServerSession(2070658212)--/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-05-25T03:26:40.807+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.72.189 - healthcheck [25/May/2021:03:26:40 +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-05-25 03:26:40.898--ServerSession(234343244)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:26:40.912--ServerSession(234343244)--/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-05-25 03:26:41.111--ServerSession(234343244)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1344) Can't create table `policyadmin`.`#sql-1_540` (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-05-25 03:26:41.134--ServerSession(234343244)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1344) Can't create table `policyadmin`.`#sql-1_540` (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-05-25 03:26:41.372--ServerSession(234343244)--/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-05-25T03:26:41.374+00:00|INFO|RequestLog|qtp1146867354-24] 10.233.72.189 - healthcheck [25/May/2021:03:26: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-05-25 03:26:42.521--ServerSession(1476731160)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:26:42.532--ServerSession(1476731160)--/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-05-25 03:26:42.756--ServerSession(1476731160)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1350) Can't create table `policyadmin`.`#sql-1_546` (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-05-25 03:26:42.78--ServerSession(1476731160)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1350) Can't create table `policyadmin`.`#sql-1_546` (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-05-25 03:26:43.012--ServerSession(1476731160)--/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-05-25T03:26:43.014+00:00|INFO|RequestLog|qtp1146867354-26] 10.233.72.189 - healthcheck [25/May/2021:03:26: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"
[EL Info]: 2021-05-25 03:31:14.111--ServerSession(557419933)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:31:14.126--ServerSession(557419933)--/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-05-25 03:31:14.303--ServerSession(557419933)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1420) Can't create table `policyadmin`.`#sql-1_58c` (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-05-25 03:31:14.327--ServerSession(557419933)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1420) Can't create table `policyadmin`.`#sql-1_58c` (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-05-25 03:31:14.922--ServerSession(557419933)--/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-05-25T03:31:14.929+00:00|INFO|RequestLog|qtp1146867354-28] 10.233.75.40 - healthcheck [25/May/2021:03:31:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"
[EL Info]: 2021-05-25 03:36:14.094--ServerSession(24713227)--EclipseLink, version: Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158
[EL Info]: connection: 2021-05-25 03:36:14.106--ServerSession(24713227)--/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-05-25 03:36:14.27--ServerSession(24713227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1500) Can't create table `policyadmin`.`#sql-1_5dc` (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-05-25 03:36:14.291--ServerSession(24713227)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.5.v20191016-ea124dd158): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: (conn=1500) Can't create table `policyadmin`.`#sql-1_5dc` (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-05-25 03:36:14.932--ServerSession(24713227)--/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-05-25T03:36:14.939+00:00|INFO|RequestLog|qtp1146867354-25] 10.233.75.40 - healthcheck [25/May/2021:03:36:14 +0000] "GET /policy/api/v1/policytypes HTTP/1.1" 200 62660 "-" "Apache-HttpClient/4.5.12 (Java/11.0.8)"