2021-07-12T23:02:07.196Z||main|||||ERROR|900|############################ Logging is started. ############################|
2021-07-12T23:02:08.539Z||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-07-12T23:02:08.596Z||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-07-12T23:02:08.608Z||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-07-12T23:02:09.669Z||main|||||WARN|900|Could not find matching type descriptor for requested Java class [java.util.Map]; using fallback|
2021-07-12T23:02:09.705Z||main|||||WARN|900|HHH000038: Composite-id class does not override equals(): org.onap.portalsdk.analytics.model.base.ReportUserRole|
2021-07-12T23:02:09.706Z||main|||||WARN|900|HHH000039: Composite-id class does not override hashCode(): org.onap.portalsdk.analytics.model.base.ReportUserRole|
2021-07-12T23:17:05.361Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1205, SQLState: HY000|
2021-07-12T23:17:05.365Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:433) 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-07-12T23:17:05.387Z||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.GeneratedMethodAccessor333.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:433) 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