2021-04-29T15:07:16.182Z||main|||||ERROR|900|############################ Logging is started. ############################| 2021-04-29T15:07:17.776Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-04-29T15:07:17.833Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-04-29T15:07:17.846Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-04-29T15:07:18.701Z||main|||||WARN|900|Could not find matching type descriptor for requested Java class [java.util.Map]; using fallback| 2021-04-29T15:07:18.737Z||main|||||WARN|900|HHH000038: Composite-id class does not override equals(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-04-29T15:07:18.738Z||main|||||WARN|900|HHH000039: Composite-id class does not override hashCode(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-04-29T15:18:39.153Z||schedulerFactoryBean_Worker-1|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:18:39.155Z||schedulerFactoryBean_Worker-1|||||ERROR|900|(conn:571) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:18:39.173Z||schedulerFactoryBean_Worker-1|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:571) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:18:59.604Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:18:59.604Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:557) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:18:59.611Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:557) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:47.603Z||schedulerFactoryBean_Worker-10|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:47.605Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:47.605Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:808) WSREP has not yet prepared node for application use\nQuery is: select * from vid_job as JOB left join \n(select template_id,count(*) as in_progress_count from vid_job \nwhere (\n (\n (job_status in ('IN_PROGRESS','RESOURCE_IN_PROGRESS') and DELETED_AT is NULL) \n or (JOB_STATUS='PENDING_RESOURCE' and TAKEN_BY IS NOT NULL)\n )\n and TEMPLATE_ID IS NOT NULL and DELETED_AT is NULL\n)\ngroup by template_id)\nas COUNTER on COUNTER.template_id=JOB.template_id \nwhere (\n JOB_STATUS = 'PENDING_RESOURCE' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677'\n and in_progress_count is NULL \n and JOB.template_id is not NULL \n)order by INDEX_IN_BULK,JOB.template_id \nlimit 1;| 2021-04-29T15:27:47.603Z||schedulerFactoryBean_Worker-9|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:47.606Z||schedulerFactoryBean_Worker-9|||||ERROR|900|(conn:530) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:27:47.604Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:47.604Z||schedulerFactoryBean_Worker-2|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:47.606Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:733) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:47.605Z||schedulerFactoryBean_Worker-10|||||ERROR|900|(conn:420) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'RESOURCE_IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:46.597919' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:47.606Z||schedulerFactoryBean_Worker-2|||||ERROR|900|(conn:492) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:46.59775' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:47.611Z||schedulerFactoryBean_Worker-10|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:420) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:47.613Z||schedulerFactoryBean_Worker-9|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:530) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:47.614Z||schedulerFactoryBean_Worker-6|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:808) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:47.614Z||schedulerFactoryBean_Worker-2|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:492) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:47.616Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:733) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:48.600Z||schedulerFactoryBean_Worker-1|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:48.601Z||schedulerFactoryBean_Worker-1|||||ERROR|900|(conn:1030) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:27:48.607Z||schedulerFactoryBean_Worker-1|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1030) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:48.609Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:48.610Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:1029) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:47.600657' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:48.611Z||schedulerFactoryBean_Worker-7|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:48.612Z||schedulerFactoryBean_Worker-7|||||ERROR|900|(conn:1028) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:48.613Z||schedulerFactoryBean_Worker-8|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:48.613Z||schedulerFactoryBean_Worker-4|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:48.613Z||schedulerFactoryBean_Worker-8|||||ERROR|900|(conn:966) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'RESOURCE_IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:47.601759' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:48.613Z||schedulerFactoryBean_Worker-4|||||ERROR|900|(conn:967) WSREP has not yet prepared node for application use\nQuery is: select * from vid_job as JOB left join \n(select template_id,count(*) as in_progress_count from vid_job \nwhere (\n (\n (job_status in ('IN_PROGRESS','RESOURCE_IN_PROGRESS') and DELETED_AT is NULL) \n or (JOB_STATUS='PENDING_RESOURCE' and TAKEN_BY IS NOT NULL)\n )\n and TEMPLATE_ID IS NOT NULL and DELETED_AT is NULL\n)\ngroup by template_id)\nas COUNTER on COUNTER.template_id=JOB.template_id \nwhere (\n JOB_STATUS = 'PENDING_RESOURCE' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677'\n and in_progress_count is NULL \n and JOB.template_id is not NULL \n)order by INDEX_IN_BULK,JOB.template_id \nlimit 1;| 2021-04-29T15:27:48.614Z||schedulerFactoryBean_Worker-3|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1029) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:48.619Z||schedulerFactoryBean_Worker-7|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1028) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:48.618Z||schedulerFactoryBean_Worker-4|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:967) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:48.623Z||schedulerFactoryBean_Worker-8|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:966) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:49.600Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:49.601Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:971) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:48.597464' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:49.601Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:49.602Z||schedulerFactoryBean_Worker-2|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:49.602Z||schedulerFactoryBean_Worker-2|||||ERROR|900|(conn:969) WSREP has not yet prepared node for application use\nQuery is: select * from vid_job as JOB left join \n(select template_id,count(*) as in_progress_count from vid_job \nwhere (\n (\n (job_status in ('IN_PROGRESS','RESOURCE_IN_PROGRESS') and DELETED_AT is NULL) \n or (JOB_STATUS='PENDING_RESOURCE' and TAKEN_BY IS NOT NULL)\n )\n and TEMPLATE_ID IS NOT NULL and DELETED_AT is NULL\n)\ngroup by template_id)\nas COUNTER on COUNTER.template_id=JOB.template_id \nwhere (\n JOB_STATUS = 'PENDING_RESOURCE' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677'\n and in_progress_count is NULL \n and JOB.template_id is not NULL \n)order by INDEX_IN_BULK,JOB.template_id \nlimit 1;| 2021-04-29T15:27:49.602Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:970) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'RESOURCE_IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:48.597498' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:49.602Z||schedulerFactoryBean_Worker-9|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:49.603Z||schedulerFactoryBean_Worker-9|||||ERROR|900|(conn:972) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:49.603Z||schedulerFactoryBean_Worker-6|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:971) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:49.604Z||schedulerFactoryBean_Worker-2|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:969) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:49.601Z||schedulerFactoryBean_Worker-10|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:49.604Z||schedulerFactoryBean_Worker-10|||||ERROR|900|(conn:1031) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:27:49.610Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:970) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:49.613Z||schedulerFactoryBean_Worker-9|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:972) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:49.614Z||schedulerFactoryBean_Worker-10|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1031) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:50.603Z||schedulerFactoryBean_Worker-8|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:50.603Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:50.602Z||schedulerFactoryBean_Worker-1|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:50.604Z||schedulerFactoryBean_Worker-4|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:50.604Z||schedulerFactoryBean_Worker-4|||||ERROR|900|(conn:974) WSREP has not yet prepared node for application use\nQuery is: select * from vid_job as JOB left join \n(select template_id,count(*) as in_progress_count from vid_job \nwhere (\n (\n (job_status in ('IN_PROGRESS','RESOURCE_IN_PROGRESS') and DELETED_AT is NULL) \n or (JOB_STATUS='PENDING_RESOURCE' and TAKEN_BY IS NOT NULL)\n )\n and TEMPLATE_ID IS NOT NULL and DELETED_AT is NULL\n)\ngroup by template_id)\nas COUNTER on COUNTER.template_id=JOB.template_id \nwhere (\n JOB_STATUS = 'PENDING_RESOURCE' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677'\n and in_progress_count is NULL \n and JOB.template_id is not NULL \n)order by INDEX_IN_BULK,JOB.template_id \nlimit 1;| 2021-04-29T15:27:50.604Z||schedulerFactoryBean_Worker-1|||||ERROR|900|(conn:975) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:27:50.604Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:1034) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:50.605Z||schedulerFactoryBean_Worker-8|||||ERROR|900|(conn:1033) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'RESOURCE_IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:49.600607' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:50.607Z||schedulerFactoryBean_Worker-7|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:50.608Z||schedulerFactoryBean_Worker-7|||||ERROR|900|(conn:1035) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:49.60047' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:50.608Z||schedulerFactoryBean_Worker-3|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1034) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:50.612Z||schedulerFactoryBean_Worker-1|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:975) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:50.614Z||schedulerFactoryBean_Worker-8|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1033) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:50.614Z||schedulerFactoryBean_Worker-4|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:974) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:50.616Z||schedulerFactoryBean_Worker-7|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1035) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:51.601Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:51.603Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:1037) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-04-29T15:27:51.604Z||schedulerFactoryBean_Worker-2|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:51.604Z||schedulerFactoryBean_Worker-9|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:51.604Z||schedulerFactoryBean_Worker-9|||||ERROR|900|(conn:976) WSREP has not yet prepared node for application use\nQuery is: select * from vid_job as JOB left join \n(select template_id,count(*) as in_progress_count from vid_job \nwhere (\n (\n (job_status in ('IN_PROGRESS','RESOURCE_IN_PROGRESS') and DELETED_AT is NULL) \n or (JOB_STATUS='PENDING_RESOURCE' and TAKEN_BY IS NOT NULL)\n )\n and TEMPLATE_ID IS NOT NULL and DELETED_AT is NULL\n)\ngroup by template_id)\nas COUNTER on COUNTER.template_id=JOB.template_id \nwhere (\n JOB_STATUS = 'PENDING_RESOURCE' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677'\n and in_progress_count is NULL \n and JOB.template_id is not NULL \n)order by INDEX_IN_BULK,JOB.template_id \nlimit 1;| 2021-04-29T15:27:51.604Z||schedulerFactoryBean_Worker-2|||||ERROR|900|(conn:979) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:51.606Z||schedulerFactoryBean_Worker-2|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:979) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:51.609Z||schedulerFactoryBean_Worker-10|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:51.609Z||schedulerFactoryBean_Worker-10|||||ERROR|900|(conn:978) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'RESOURCE_IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:50.60184' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:51.610Z||schedulerFactoryBean_Worker-9|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:976) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:51.611Z||schedulerFactoryBean_Worker-6|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:1037) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:51.612Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-04-29T15:27:51.612Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:977) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'IN_PROGRESS' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and MODIFIED_DATE <= '2021-04-29 15:27:50.601006' order by MODIFIED_DATE ASC limit 1| 2021-04-29T15:27:51.616Z||schedulerFactoryBean_Worker-10|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:978) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n 2021-04-29T15:27:51.617Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:977) 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 org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 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 ... 20 common frames omitted\n