2021-06-04T01:20:27.310Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-4|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.310Z||schedulerFactoryBean_Worker-8|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-9|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:3603) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-7|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-4|||||ERROR|900|(conn:3680) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.27561' order by MODIFIED_DATE ASC limit 1|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-7|||||ERROR|900|(conn:3681) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-2|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.313Z||schedulerFactoryBean_Worker-2|||||ERROR|900|(conn:3679) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.313Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:3682) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272776' order by MODIFIED_DATE ASC limit 1|
2021-06-04T01:20:27.307Z||schedulerFactoryBean_Worker-10|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.314Z||schedulerFactoryBean_Worker-10|||||ERROR|900|(conn:3602) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.310Z||schedulerFactoryBean_Worker-1|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:3604) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.315Z||schedulerFactoryBean_Worker-1|||||ERROR|900|(conn:3606) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.275096' order by MODIFIED_DATE ASC limit 1|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-8|||||ERROR|900|(conn:3678) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272744' order by MODIFIED_DATE ASC limit 1|
2021-06-04T01:20:27.312Z||schedulerFactoryBean_Worker-9|||||ERROR|900|(conn:3605) Lock wait timeout exceeded; try restarting transaction\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-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-10|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3602) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.343Z||schedulerFactoryBean_Worker-6|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3682) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272776' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272776' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-3|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3604) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3603) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-8|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3678) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272744' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:18.272744' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-7|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3681) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.344Z||schedulerFactoryBean_Worker-4|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3680) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.27561' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.27561' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.346Z||schedulerFactoryBean_Worker-1|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3606) Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.275096' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 01:20:17.275096' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.349Z||schedulerFactoryBean_Worker-9|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3605) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T01:20:27.348Z||schedulerFactoryBean_Worker-2|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:3679) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.443Z||schedulerFactoryBean_Worker-2|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.444Z||schedulerFactoryBean_Worker-2|||||ERROR|900|(conn:4266) Lock wait timeout exceeded; try restarting transaction\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-06-04T02:52:53.441Z||schedulerFactoryBean_Worker-5|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.445Z||schedulerFactoryBean_Worker-5|||||ERROR|900|(conn:4264) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272745' order by MODIFIED_DATE ASC limit 1|
2021-06-04T02:52:53.441Z||schedulerFactoryBean_Worker-8|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.448Z||schedulerFactoryBean_Worker-8|||||ERROR|900|(conn:4262) Lock wait timeout exceeded; try restarting transaction\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-06-04T02:52:53.448Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.449Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:4195) Lock wait timeout exceeded; try restarting transaction\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-06-04T02:52:53.449Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.450Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:4265) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:43.275126' order by MODIFIED_DATE ASC limit 1|
2021-06-04T02:52:53.449Z||schedulerFactoryBean_Worker-7|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.450Z||schedulerFactoryBean_Worker-7|||||ERROR|900|(conn:4263) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272668' order by MODIFIED_DATE ASC limit 1|
2021-06-04T02:52:53.451Z||schedulerFactoryBean_Worker-2|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4266) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.452Z||schedulerFactoryBean_Worker-3|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4265) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:43.275126' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:43.275126' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.455Z||schedulerFactoryBean_Worker-4|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-06-04T02:52:53.451Z||schedulerFactoryBean_Worker-5|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4264) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272745' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272745' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.456Z||schedulerFactoryBean_Worker-4|||||ERROR|900|(conn:4196) Lock wait timeout exceeded; try restarting transaction\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-06-04T02:52:53.456Z||schedulerFactoryBean_Worker-7|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4263) Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272668' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:150)\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: Lock wait timeout exceeded; try restarting transaction\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-06-04 02:52:44.272668' order by MODIFIED_DATE ASC limit 1\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.456Z||schedulerFactoryBean_Worker-6|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4195) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.457Z||schedulerFactoryBean_Worker-4|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4196) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n
2021-06-04T02:52:53.461Z||schedulerFactoryBean_Worker-8|||||ERROR|900|failed to pull job from queue, breaking: {}|org.hibernate.exception.GenericJDBCException: could not extract ResultSet\n	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)\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.GeneratedMethodAccessor329.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.SQLException: (conn:4262) Lock wait timeout exceeded; try restarting transaction\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:150)\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: Lock wait timeout exceeded; try restarting transaction\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.readErrorPacket(AbstractQueryProtocol.java:1115)\n	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)\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\n