2021-04-08T14:21:18.082Z||main|||||ERROR|900|############################ Logging is started. ############################| 2021-04-08T14:23:14.482Z||main|||||WARN|900|Cannot set auto commit to false on connection| 2021-04-08T14:23:16.287Z||main|||||WARN|900|Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'deleteOldJobsSchedulerInitializer' defined in file [/usr/local/tomcat/webapps/vid/WEB-INF/classes/org/onap/vid/job/impl/DeleteOldJobsSchedulerInitializer.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseBean' defined in org.onap.portalapp.conf.ExternalAppConfig: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: (conn:547) Connection is close [Failed SQL: (1220) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]| 2021-04-08T14:23:16.485Z||main|||||ERROR|900|Context initialization failed|org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'deleteOldJobsSchedulerInitializer' defined in file [/usr/local/tomcat/webapps/vid/WEB-INF/classes/org/onap/vid/job/impl/DeleteOldJobsSchedulerInitializer.class]: Unsatisfied dependency expressed through constructor parameter 1; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseBean' defined in org.onap.portalapp.conf.ExternalAppConfig: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: (conn:547) Connection is close [Failed SQL: (1220) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]\n at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:798)\n at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:228)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1358)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1204)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)\n at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)\n at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)\n at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)\n at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879)\n at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878)\n at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)\n at org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:702)\n at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:578)\n at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:530)\n at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:170)\n at javax.servlet.GenericServlet.init(GenericServlet.java:158)\n at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1134)\n at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:986)\n at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4902)\n at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5211)\n at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)\n at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:717)\n at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:690)\n at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:706)\n at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1093)\n at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1810)\n at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)\n at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118)\n at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1013)\n at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:428)\n at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1520)\n at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:309)\n at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)\n at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423)\n at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366)\n at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:936)\n at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:843)\n at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)\n at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)\n at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)\n at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)\n at java.base/java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140)\n at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)\n at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)\n at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)\n at org.apache.catalina.core.StandardService.startInternal(StandardService.java:434)\n at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)\n at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930)\n at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)\n at org.apache.catalina.startup.Catalina.start(Catalina.java:772)\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n at java.base/java.lang.reflect.Method.invoke(Method.java:566)\n at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:342)\n at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:473)\nCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibaseBean' defined in org.onap.portalapp.conf.ExternalAppConfig: Invocation of init method failed; nested exception is liquibase.exception.LockException: liquibase.exception.DatabaseException: (conn:547) Connection is close [Failed SQL: (1220) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517)\n at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323)\n at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)\n at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321)\n at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)\n at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)\n at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)\n at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287)\n at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207)\n at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:885)\n at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:789)\n ... 60 common frames omitted\nCaused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: (conn:547) Connection is close [Failed SQL: (1220) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]\n at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:295)\n at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:213)\n at liquibase.Liquibase.update(Liquibase.java:184)\n at liquibase.Liquibase.update(Liquibase.java:179)\n at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:366)\n at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:314)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792)\n ... 73 common frames omitted\nCaused by: liquibase.exception.DatabaseException: (conn:547) Connection is close [Failed SQL: (1220) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, `LOCKED` BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]\n at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:402)\n at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:59)\n at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:131)\n at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:111)\n at liquibase.lockservice.StandardLockService.init(StandardLockService.java:102)\n at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:252)\n ... 80 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:547) Connection is close\n at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:137)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)\n at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)\n at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:266)\n at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)\n at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:398)\n ... 85 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Connection is close\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.cmdPrologue(AbstractQueryProtocol.java:1268)\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:138)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)\n ... 88 common frames omitted\n