2021-06-02T11:05:29.520Z||main|||||ERROR|900|############################ Logging is started. ############################| 2021-06-02T11:05:31.167Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-06-02T11:05:31.252Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-06-02T11:05:31.268Z||main|||||WARN|900|HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!| 2021-06-02T11:05:32.326Z||main|||||WARN|900|Could not find matching type descriptor for requested Java class [java.util.Map]; using fallback| 2021-06-02T11:05:32.373Z||main|||||WARN|900|HHH000038: Composite-id class does not override equals(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-06-02T11:05:32.374Z||main|||||WARN|900|HHH000039: Composite-id class does not override hashCode(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-06-02T11:11:58.459Z||schedulerFactoryBean_Worker-4|||||WARN|900|SQL Error: 1205, SQLState: HY000| 2021-06-02T11:11:58.459Z||schedulerFactoryBean_Worker-10|||||WARN|900|SQL Error: 1205, SQLState: HY000| 2021-06-02T11:11:58.459Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1205, SQLState: HY000| 2021-06-02T11:11:58.463Z||schedulerFactoryBean_Worker-4|||||ERROR|900|(conn:467) 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-02T11:11:58.463Z||schedulerFactoryBean_Worker-10|||||ERROR|900|(conn:469) 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-02T11:11:58.463Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:468) 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-02T11:11:58.479Z||schedulerFactoryBean_Worker-6|||||WARN|900|SQL Error: 1205, SQLState: HY000| 2021-06-02T11:11:58.479Z||schedulerFactoryBean_Worker-6|||||ERROR|900|(conn:577) 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-02 11:11:49.143196' order by MODIFIED_DATE ASC limit 1| 2021-06-02T11:11:58.882Z||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.GeneratedMethodAccessor326.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:467) 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-02T11:11:58.954Z||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.GeneratedMethodAccessor326.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:577) 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-02 11:11:49.143196' 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-02 11:11:49.143196' 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-02T11:11:59.039Z||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.GeneratedMethodAccessor326.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:469) 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-02T11:11:59.075Z||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.GeneratedMethodAccessor326.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:468) 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