JVM Arguments: -Dspring.profiles.active=basic -Djava.security.egd=file:/dev/./urandom -Dlogs_dir=./logs/so-etsi-nfvo-ns-lcm/ -Dlogging.config=/app/logback-spring.xml -Djavax.net.ssl.trustStore=/opt/app/osaaf/local/truststoreONAPall.jks -Djavax.net.ssl.trustStorePassword=changeit -Dspring.config.additional-location=/app/config/override.yaml ____ _ ____ ____ __ __ / ___| __ _ _ __ ___ _ _ _ __ __| | __ _ | __ )| _ \| \/ | | | / _` | '_ ` _ \| | | | '_ \ / _` |/ _` | | _ \| |_) | |\/| | | |__| (_| | | | | | | |_| | | | | (_| | (_| | | |_) | __/| | | | \____/\__,_|_| |_| |_|\__,_|_| |_|\__,_|\__,_| |____/|_| |_| |_| Spring-Boot: (v2.3.7.RELEASE) Camunda BPM: (v7.14.0) Camunda BPM Spring Boot Starter: (v7.14.0) 2021-04-21T12:04:03.919Z||main|||||INFO|500||Starting Application on onap-so-etsi-nfvo-ns-lcm-764c9598df-p2hdk with PID 17 (/app/app.jar started by so in /app) 2021-04-21T12:04:03.938Z||main|||||DEBUG|500||Running with Spring Boot v2.3.7.RELEASE, Spring v5.2.12.RELEASE 2021-04-21T12:04:03.952Z||main|||||INFO|500||The following profiles are active: basic 2021-04-21T12:04:11.751Z||main|||||INFO|500||Starting service [Tomcat] 2021-04-21T12:04:11.752Z||main|||||INFO|500||Starting Servlet engine: [Apache Tomcat/9.0.41] 2021-04-21T12:04:11.863Z||main|||||INFO|500||Initializing Spring embedded WebApplicationContext 2021-04-21T12:04:11.927Z||main|||||INFO|500||Configuring camunda rest api. 2021-04-21T12:04:11.965Z||main|||||INFO|500||Finished configuring camunda rest api. 2021-04-21T12:04:12.848Z||main|||||DEBUG|500||Creating NFVO HikariDataSource bean ... 2021-04-21T12:04:12.849Z||main|||||DEBUG|500||Creating NFVO HikariConfig bean ... 2021-04-21T12:04:12.999Z||main|||||INFO|500||nfvo-pool - Starting... 2021-04-21T12:04:13.350Z||main|||||INFO|500||nfvo-pool - Start completed. 2021-04-21T12:04:13.432Z||main|||||INFO|500||Flyway Community Edition 6.5.7 by Redgate 2021-04-21T12:04:13.518Z||main|||||INFO|500||Database: jdbc:mariadb://mariadb-galera:3306/nfvo (MariaDB 10.5) 2021-04-21T12:04:13.560Z||main|||||WARN|500||Flyway upgrade recommended: MariaDB 10.5 is newer than this version of Flyway and support has not been tested. The latest supported version of MariaDB is 10.4. 2021-04-21T12:04:13.615Z||main|||||INFO|500||Successfully validated 1 migration (execution time 00:00.025s) 2021-04-21T12:04:13.639Z||main|||||INFO|500||Creating Schema History table `nfvo`.`flyway_schema_history` ... 2021-04-21T12:04:13.730Z||main|||||WARN|500||DB: Name 'flyway_schema_history_pk' ignored for PRIMARY key. (SQL State: - Error Code: 1280) 2021-04-21T12:04:13.795Z||main|||||INFO|500||Current version of schema `nfvo`: << Empty Schema >> 2021-04-21T12:04:13.817Z||main|||||INFO|500||Migrating schema `nfvo` to version 1.1 - create nfvo tables 2021-04-21T12:04:14.252Z||main|||||INFO|500||Successfully applied 1 migration to schema `nfvo` (execution time 00:00.465s) 2021-04-21T12:04:14.464Z||main|||||INFO|500||HHH000204: Processing PersistenceUnitInfo [name: nfvo] 2021-04-21T12:04:14.641Z||main|||||INFO|500||HHH000412: Hibernate ORM core version 5.4.25.Final 2021-04-21T12:04:15.051Z||main|||||INFO|500||HCANN000001: Hibernate Commons Annotations {5.1.2.Final} 2021-04-21T12:04:15.889Z||main|||||INFO|500||HHH000400: Using dialect: org.hibernate.dialect.MariaDB103Dialect 2021-04-21T12:04:17.627Z||main|||||INFO|500||HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2021-04-21T12:04:19.670Z||main|||||DEBUG|500||Creating Camunda HikariDataSource bean ... 2021-04-21T12:04:19.671Z||main|||||DEBUG|500||Creating Camunda HikariConfig bean ... 2021-04-21T12:04:19.921Z||main|||||INFO|500||bpmn-pool - Starting... 2021-04-21T12:04:19.930Z||main|||||INFO|500||bpmn-pool - Start completed. 2021-04-21T12:04:19.988Z||main|||||INFO|500||STARTER-SB040 Setting up jobExecutor with corePoolSize=3, maxPoolSize:30 2021-04-21T12:04:20.171Z||main|||||INFO|500||ENGINE-12003 Plugin 'CompositeProcessEnginePlugin[genericPropertiesConfiguration, camundaProcessEngineConfiguration, camundaDatasourceConfiguration, camundaJpaConfiguration, camundaJobConfiguration, camundaHistoryConfiguration, camundaMetricsConfiguration, camundaAuthorizationConfiguration, camundaDeploymentConfiguration, CreateAdminUserConfiguration[adminUser=AdminUserProperty[id=admin, firstName=Admin, lastName=Admin, email=admin@localhost, password=******]], failedJobConfiguration, CamundaCustomConfiguration, transactionManagerProcessEnginePlugin, eventPublisherPlugin]' activated on process engine 'default' 2021-04-21T12:04:24.882Z||main|||||WARN|500||unable to determine if resource URL [jar:file:/app/app.jar!/BOOT-INF/lib/camunda-engine-dmn-7.14.0.jar!/META-INF/maven/org.camunda.bpm.dmn/] is a deployable resource 2021-04-21T12:04:24.882Z||main|||||WARN|500||unable to determine if resource URL [jar:file:/app/app.jar!/BOOT-INF/lib/camunda-engine-feel-api-7.14.0.jar!/META-INF/maven/org.camunda.bpm.dmn/] is a deployable resource 2021-04-21T12:04:24.883Z||main|||||WARN|500||unable to determine if resource URL [jar:file:/app/app.jar!/BOOT-INF/lib/camunda-engine-feel-juel-7.14.0.jar!/META-INF/maven/org.camunda.bpm.dmn/] is a deployable resource 2021-04-21T12:04:24.883Z||main|||||WARN|500||unable to determine if resource URL [jar:file:/app/app.jar!/BOOT-INF/lib/camunda-engine-feel-scala-7.14.0.jar!/META-INF/maven/org.camunda.bpm.dmn/] is a deployable resource 2021-04-21T12:04:24.884Z||main|||||INFO|500||STARTER-SB021 Auto-Deploying resources: [URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/TerminateNs.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/MonitorSol003AdapterCreateNodeStatus.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/TerminateVnf.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/DeleteNs.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/InstantiateNs.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/MonitorSol003AdapterCreateJob.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/MonitorSol003AdapterTerminateNodeStatus.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/CreateNs.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/CreateInstantiateVnf.bpmn], URL [jar:file:/app/app.jar!/BOOT-INF/lib/so-etsi-nfvo-ns-lcm-bpmn-flows-1.8.2.jar!/MonitorSol003AdapterTerminateJob.bpmn]] 2021-04-21T12:04:24.888Z||main|||||INFO|500||Setting DeploymentTenantId to ns-workflow-engine-tenant and DeploymentName to NS-WORKFLOW-ENGINE 2021-04-21T12:04:24.889Z||main|||||INFO|500||Setting Camunda TransactionManager ... 2021-04-21T12:04:24.891Z||main|||||INFO|500||EVENTING-001: Initialized Camunda Spring Boot Eventing Engine Plugin. 2021-04-21T12:04:24.891Z||main|||||INFO|500||EVENTING-003: Task events will be published as Spring Events. 2021-04-21T12:04:24.891Z||main|||||INFO|500||EVENTING-005: Execution events will be published as Spring Events. 2021-04-21T12:04:24.896Z||main|||||INFO|500||EVENTING-007: History events will be published as Spring events. 2021-04-21T12:04:25.368Z||main|||||INFO|500||Engine created. [value-mapper: CompositeValueMapper(List(org.camunda.feel.impl.JavaValueMapper@28e94c2)), function-provider: org.camunda.bpm.dmn.feel.impl.scala.function.CustomFunctionTransformer@563317c1, clock: SystemClock, configuration: Configuration(false)] 2021-04-21T12:04:31.100Z||main|||||INFO|500||CNCT-01004 Discovered provider for connector id 'http-connector' and class 'org.camunda.connect.httpclient.impl.HttpConnectorImpl': 'org.camunda.connect.httpclient.impl.HttpConnectorProviderImpl' 2021-04-21T12:04:31.104Z||main|||||INFO|500||CNCT-01004 Discovered provider for connector id 'soap-http-connector' and class 'org.camunda.connect.httpclient.soap.impl.SoapHttpConnectorImpl': 'org.camunda.connect.httpclient.soap.impl.SoapHttpConnectorProviderImpl' 2021-04-21T12:04:31.246Z||main|||||INFO|500||ENGINE-03067 No history level property found in database 2021-04-21T12:04:31.247Z||main|||||INFO|500||ENGINE-03065 Creating historyLevel property in database for level: HistoryLevelFull(name=full, id=3) 2021-04-21T12:04:31.373Z||main|||||INFO|500||ENGINE-00001 Process Engine default created. 2021-04-21T12:04:32.606Z||main|||||INFO|500||STARTER-SB010 creating initial Admin User: AdminUserProperty[id=admin, firstName=Admin, lastName=Admin, email=admin@localhost, password=******] 2021-04-21T12:04:35.517Z||main|||||DEBUG|500||Setting up HttpComponentsClientHttpRequestFactory with SSL Context 2021-04-21T12:04:35.517Z||main|||||DEBUG|500||Setting client trust-store: file:/opt/app/osaaf/local/truststoreONAPall.jks 2021-04-21T12:04:35.518Z||main|||||DEBUG|500||Creating SSLConnectionSocketFactory with AllowAllHostsVerifier ... 2021-04-21T12:04:36.070Z||main|||||WARN|500||spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2021-04-21T12:04:36.207Z||main|||||INFO|500||Setting ThreadPoolTaskExecutor for async calls ... 2021-04-21T12:04:36.531Z||main|||||DEBUG|500||Injecting class org.onap.so.security.SoBasicHttpSecurityConfigurer configuration ... 2021-04-21T12:04:38.138Z||main|||||INFO|500||Started Application in 36.633 seconds (JVM running for 37.922) 2021-04-21T12:04:38.152Z||main|||||INFO|500||ENGINE-14014 Starting up the JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]. 2021-04-21T12:04:38.155Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||INFO|500||ENGINE-14018 JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor] starting to acquire jobs 2021-04-21T12:04:38.155Z||main|||||INFO|500||SO ETSI NFVO NS LCM Application started successfully! 2021-04-21T14:00:42.497Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@2f89efa ((conn=2653) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:00:43.820Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||ERROR|500||ENGINE-14019 Exception during job acquisition Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: bpmn-pool - Connection is not available, request timed out after 49386ms. org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: bpmn-pool - Connection is not available, request timed out after 49386ms. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305) at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137) at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:44) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70) at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33) at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.acquireJobs(SequentialJobAcquisitionRunnable.java:158) at org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:76) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLTransientConnectionException: bpmn-pool - Connection is not available, request timed out after 49386ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:261) ... 10 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: (conn=2653) Connection.setNetworkTimeout cannot be called on a closed connection at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:171) at org.mariadb.jdbc.MariaDbConnection.setNetworkTimeout(MariaDbConnection.java:1655) at com.zaxxer.hikari.pool.PoolBase.setNetworkTimeout(PoolBase.java:560) at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:173) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186) ... 13 common frames omitted 2021-04-21T14:00:58.198Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@76614cff ((conn=2654) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:01:03.232Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@188d503b ((conn=2769) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:01:08.239Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@41618413 ((conn=2773) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:01:08.242Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@3d9b3e74 ((conn=2912) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:01:08.243Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@45bda426 ((conn=2919) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2021-04-21T14:01:08.244Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@37c33822 ((conn=2920) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.