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) 2022-03-05T03:30:41.792Z||main|||||INFO|500||Starting Application on onap-so-etsi-nfvo-ns-lcm-6bf48cf4b6-8nfgv with PID 18 (/app/app.jar started by so in /app) 2022-03-05T03:30:41.815Z||main|||||DEBUG|500||Running with Spring Boot v2.3.7.RELEASE, Spring v5.2.12.RELEASE 2022-03-05T03:30:41.816Z||main|||||INFO|500||The following profiles are active: basic 2022-03-05T03:30:58.102Z||main|||||INFO|500||Starting service [Tomcat] 2022-03-05T03:30:58.103Z||main|||||INFO|500||Starting Servlet engine: [Apache Tomcat/9.0.41] 2022-03-05T03:30:58.255Z||main|||||INFO|500||Initializing Spring embedded WebApplicationContext 2022-03-05T03:30:58.329Z||main|||||INFO|500||Configuring camunda rest api. 2022-03-05T03:30:58.378Z||main|||||INFO|500||Finished configuring camunda rest api. 2022-03-05T03:30:59.826Z||main|||||DEBUG|500||Creating NFVO HikariDataSource bean ... 2022-03-05T03:30:59.849Z||main|||||DEBUG|500||Creating NFVO HikariConfig bean ... 2022-03-05T03:31:00.025Z||main|||||INFO|500||nfvo-pool - Starting... 2022-03-05T03:31:00.326Z||main|||||INFO|500||nfvo-pool - Start completed. 2022-03-05T03:31:00.431Z||main|||||INFO|500||Flyway Community Edition 6.5.7 by Redgate 2022-03-05T03:31:00.500Z||main|||||INFO|500||Database: jdbc:mariadb://mariadb-galera:3306/nfvo (MariaDB 10.5) 2022-03-05T03:31:00.540Z||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. 2022-03-05T03:31:00.624Z||main|||||INFO|500||Successfully validated 1 migration (execution time 00:00.051s) 2022-03-05T03:31:00.668Z||main|||||INFO|500||Creating Schema History table `nfvo`.`flyway_schema_history` ... 2022-03-05T03:31:00.755Z||main|||||WARN|500||DB: Name 'flyway_schema_history_pk' ignored for PRIMARY key. (SQL State: - Error Code: 1280) 2022-03-05T03:31:00.836Z||main|||||INFO|500||Current version of schema `nfvo`: << Empty Schema >> 2022-03-05T03:31:00.862Z||main|||||INFO|500||Migrating schema `nfvo` to version 1.1 - create nfvo tables 2022-03-05T03:31:01.593Z||main|||||INFO|500||Successfully applied 1 migration to schema `nfvo` (execution time 00:00.789s) 2022-03-05T03:31:01.876Z||main|||||INFO|500||HHH000204: Processing PersistenceUnitInfo [name: nfvo] 2022-03-05T03:31:02.086Z||main|||||INFO|500||HHH000412: Hibernate ORM core version 5.4.25.Final 2022-03-05T03:31:02.667Z||main|||||INFO|500||HCANN000001: Hibernate Commons Annotations {5.1.2.Final} 2022-03-05T03:31:03.677Z||main|||||INFO|500||HHH000400: Using dialect: org.hibernate.dialect.MariaDB103Dialect 2022-03-05T03:31:06.121Z||main|||||INFO|500||HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 2022-03-05T03:31:08.724Z||main|||||DEBUG|500||Creating Camunda HikariDataSource bean ... 2022-03-05T03:31:08.725Z||main|||||DEBUG|500||Creating Camunda HikariConfig bean ... 2022-03-05T03:31:09.384Z||main|||||INFO|500||bpmn-pool - Starting... 2022-03-05T03:31:09.420Z||main|||||INFO|500||bpmn-pool - Start completed. 2022-03-05T03:31:09.481Z||main|||||INFO|500||STARTER-SB040 Setting up jobExecutor with corePoolSize=3, maxPoolSize:30 2022-03-05T03:31:09.692Z||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' 2022-03-05T03:31:15.782Z||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 2022-03-05T03:31:15.782Z||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 2022-03-05T03:31:15.783Z||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 2022-03-05T03:31:15.783Z||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 2022-03-05T03:31:15.784Z||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]] 2022-03-05T03:31:15.790Z||main|||||INFO|500||Setting DeploymentTenantId to ns-workflow-engine-tenant and DeploymentName to NS-WORKFLOW-ENGINE 2022-03-05T03:31:15.791Z||main|||||INFO|500||Setting Camunda TransactionManager ... 2022-03-05T03:31:15.793Z||main|||||INFO|500||EVENTING-001: Initialized Camunda Spring Boot Eventing Engine Plugin. 2022-03-05T03:31:15.805Z||main|||||INFO|500||EVENTING-003: Task events will be published as Spring Events. 2022-03-05T03:31:15.806Z||main|||||INFO|500||EVENTING-005: Execution events will be published as Spring Events. 2022-03-05T03:31:15.813Z||main|||||INFO|500||EVENTING-007: History events will be published as Spring events. 2022-03-05T03:31:16.389Z||main|||||INFO|500||Engine created. [value-mapper: CompositeValueMapper(List(org.camunda.feel.impl.JavaValueMapper@3e52ed5d)), function-provider: org.camunda.bpm.dmn.feel.impl.scala.function.CustomFunctionTransformer@8077c97, clock: SystemClock, configuration: Configuration(false)] 2022-03-05T03:31:24.646Z||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' 2022-03-05T03:31:24.657Z||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' 2022-03-05T03:31:26.233Z||main|||||INFO|500||ENGINE-03067 No history level property found in database 2022-03-05T03:31:26.234Z||main|||||INFO|500||ENGINE-03065 Creating historyLevel property in database for level: HistoryLevelFull(name=full, id=3) 2022-03-05T03:31:26.533Z||main|||||INFO|500||ENGINE-00001 Process Engine default created. 2022-03-05T03:31:29.246Z||main|||||INFO|500||STARTER-SB010 creating initial Admin User: AdminUserProperty[id=admin, firstName=Admin, lastName=Admin, email=admin@localhost, password=******] 2022-03-05T03:31:32.732Z||main|||||DEBUG|500||Setting up HttpComponentsClientHttpRequestFactory with SSL Context 2022-03-05T03:31:32.737Z||main|||||DEBUG|500||Setting client trust-store: file:/opt/app/osaaf/local/truststoreONAPall.jks 2022-03-05T03:31:32.737Z||main|||||DEBUG|500||Creating SSLConnectionSocketFactory with AllowAllHostsVerifier ... 2022-03-05T03:31:33.651Z||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 2022-03-05T03:31:33.802Z||main|||||INFO|500||Setting ThreadPoolTaskExecutor for async calls ... 2022-03-05T03:31:34.285Z||main|||||DEBUG|500||Injecting class org.onap.so.security.SoBasicHttpSecurityConfigurer configuration ... 2022-03-05T03:31:36.776Z||main|||||INFO|500||Started Application in 59.455 seconds (JVM running for 61.325) 2022-03-05T03:31:36.790Z||main|||||INFO|500||ENGINE-14014 Starting up the JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]. 2022-03-05T03:31:36.797Z||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 2022-03-05T03:31:36.797Z||main|||||INFO|500||SO ETSI NFVO NS LCM Application started successfully! 2022-03-05T04:17:56.845Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@2bcabe58 ((conn=1913) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:01.953Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@2b96afdf ((conn=1874) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:06.964Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@38ada7a ((conn=1878) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:12.193Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@56941723 ((conn=1924) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:17.238Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@1a522f34 ((conn=1848) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:22.256Z||JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]|||||WARN|500||bpmn-pool - Failed to validate connection org.mariadb.jdbc.MariaDbConnection@31bbf080 ((conn=1929) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value. 2022-03-05T04:18:22.356Z||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 30443ms. 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 30443ms. 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 30443ms. 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=1929) 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