2022-03-14T10:10:19.768Z||main|||||ERROR|900|############################ Logging is started. ############################|
2022-03-14T10:11:21.361Z||schedulerFactoryBean_Worker-2|||||ERROR|900|Application exception overridden by rollback exception|org.hibernate.exception.JDBCConnectionException: could not extract ResultSet\n	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:65)\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)\n	at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)\n	at org.hibernate.loader.Loader.doQuery(Loader.java:910)\n	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)\n	at org.hibernate.loader.Loader.doList(Loader.java:2554)\n	at org.hibernate.loader.Loader.doList(Loader.java:2540)\n	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)\n	at org.hibernate.loader.Loader.list(Loader.java:2365)\n	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)\n	at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)\n	at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)\n	at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:313)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:297)\n	at jdk.internal.reflect.GeneratedMethodAccessor331.invoke(Unknown Source)\n	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n	at java.base/java.lang.reflect.Method.invoke(Method.java:566)\n	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)\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: java.sql.SQLNonTransientConnectionException: (conn:1026) Could not read packet: unexpected end of stream, read 0 bytes from 4\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\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.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:361)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQuery(MariaDbServerPreparedStatement.java:342)\n	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)\n	... 32 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not read packet: unexpected end of stream, read 0 bytes from 4\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\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1031)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1002)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:399)\n	... 36 common frames omitted\nCaused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4\n	at org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.getReusableBuffer(ReadPacketFetcher.java:178)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1022)\n	... 39 common frames omitted\n
2022-03-14T10:11:21.362Z||schedulerFactoryBean_Worker-3|||||ERROR|900|Application exception overridden by rollback exception|org.hibernate.exception.JDBCConnectionException: could not extract ResultSet\n	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:65)\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)\n	at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)\n	at org.hibernate.loader.Loader.doQuery(Loader.java:910)\n	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)\n	at org.hibernate.loader.Loader.doList(Loader.java:2554)\n	at org.hibernate.loader.Loader.doList(Loader.java:2540)\n	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)\n	at org.hibernate.loader.Loader.list(Loader.java:2365)\n	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)\n	at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)\n	at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)\n	at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:313)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:297)\n	at jdk.internal.reflect.GeneratedMethodAccessor331.invoke(Unknown Source)\n	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n	at java.base/java.lang.reflect.Method.invoke(Method.java:566)\n	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)\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: java.sql.SQLNonTransientConnectionException: (conn:1028) Could not read packet: unexpected end of stream, read 0 bytes from 4\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\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.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:361)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQuery(MariaDbServerPreparedStatement.java:342)\n	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)\n	... 32 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not read packet: unexpected end of stream, read 0 bytes from 4\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\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1031)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1002)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:399)\n	... 36 common frames omitted\nCaused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4\n	at org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.getReusableBuffer(ReadPacketFetcher.java:178)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1022)\n	... 39 common frames omitted\n
2022-03-14T10:11:21.362Z||schedulerFactoryBean_Worker-4|||||ERROR|900|Application exception overridden by rollback exception|org.hibernate.exception.JDBCConnectionException: could not extract ResultSet\n	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:65)\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)\n	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)\n	at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)\n	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)\n	at org.hibernate.loader.Loader.doQuery(Loader.java:910)\n	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)\n	at org.hibernate.loader.Loader.doList(Loader.java:2554)\n	at org.hibernate.loader.Loader.doList(Loader.java:2540)\n	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)\n	at org.hibernate.loader.Loader.list(Loader.java:2365)\n	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)\n	at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)\n	at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)\n	at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:313)\n	at org.onap.portalsdk.core.service.DataAccessServiceImpl.executeSQLQuery(DataAccessServiceImpl.java:297)\n	at jdk.internal.reflect.GeneratedMethodAccessor331.invoke(Unknown Source)\n	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n	at java.base/java.lang.reflect.Method.invoke(Method.java:566)\n	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)\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: java.sql.SQLNonTransientConnectionException: (conn:1027) Could not read packet: unexpected end of stream, read 0 bytes from 4\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;\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.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:411)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.execute(MariaDbServerPreparedStatement.java:361)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeQuery(MariaDbServerPreparedStatement.java:342)\n	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)\n	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)\n	... 32 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not read packet: unexpected end of stream, read 0 bytes from 4\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;\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1031)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1002)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:588)\n	at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:399)\n	... 36 common frames omitted\nCaused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4\n	at org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.getReusableBuffer(ReadPacketFetcher.java:178)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1022)\n	... 39 common frames omitted\n
2022-03-14T10:11:21.364Z||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: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
2022-03-14T10:11:21.364Z||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:1027) 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
2022-03-14T10:11:21.363Z||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:1026) 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