2021-06-08T09:01:35.277Z||main|||||ERROR|900|############################ Logging is started. ############################| 2021-06-08T09:01:36.523Z||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-08T09:01:36.580Z||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-08T09:01:36.592Z||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-08T09:02:13.404Z||main|||||WARN|900|Could not find matching type descriptor for requested Java class [java.util.Map]; using fallback| 2021-06-08T09:02:13.441Z||main|||||WARN|900|HHH000038: Composite-id class does not override equals(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-06-08T09:02:13.442Z||main|||||WARN|900|HHH000039: Composite-id class does not override hashCode(): org.onap.portalsdk.analytics.model.base.ReportUserRole| 2021-06-08T09:10:28.388Z||schedulerFactoryBean_Worker-3|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-06-08T09:10:28.390Z||schedulerFactoryBean_Worker-3|||||ERROR|900|(conn:802) WSREP has not yet prepared node for application use\nQuery is: select vid_job.* from VID_JOB left join \n (select user_Id, 1 as has_any_in_progress_job from VID_JOB where JOB_STATUS = 'IN_PROGRESS' or TAKEN_BY IS NOT NULL \ngroup by user_id) users_have_any_in_progress_job_tbl\non vid_job.user_id = users_have_any_in_progress_job_tbl.user_id where JOB_STATUS = 'PENDING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' and (\nselect sum(CASE WHEN JOB_STATUS='IN_PROGRESS' or (JOB_STATUS='PENDING' and TAKEN_BY IS NOT NULL) THEN 1 ELSE 0 END) as in_progress\nfrom VID_JOB ) <200 \n and TEMPLATE_Id not in \n(select TEMPLATE_Id from vid_job where TEMPLATE_Id IS NOT NULL and( (JOB_STATUS IN('FAILED','FAILED_AND_PAUSED') and DELETED_AT is null) or JOB_STATUS='IN_PROGRESS' or TAKEN_BY IS NOT NULL)) \n order by has_any_in_progress_job, CREATED_DATE, INDEX_IN_BULK limit 1| 2021-06-08T09:10:28.388Z||schedulerFactoryBean_Worker-9|||||WARN|900|SQL Error: 1047, SQLState: 08S01| 2021-06-08T09:10:28.390Z||schedulerFactoryBean_Worker-9|||||ERROR|900|(conn:800) WSREP has not yet prepared node for application use\nQuery is: select * from VID_JOB where JOB_STATUS = 'CREATING' and TAKEN_BY is null and DELETED_AT is null and BUILD = '8.0.2..677' order by MODIFIED_DATE ASC limit 1| 2021-06-08T09:10:28.400Z||schedulerFactoryBean_Worker-3|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:802) Connection is close\n at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:137)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)\n at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)\n at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:266)\n at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Connection is close\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.cmdPrologue(AbstractQueryProtocol.java:1268)\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:138)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)\n ... 20 common frames omitted\n 2021-06-08T09:10:28.400Z||schedulerFactoryBean_Worker-9|||||ERROR|900|failed to pull job from queue, breaking: {}|org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: rollback failed\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:607)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:836)\n at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:810)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:649)\n at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:370)\n at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)\n at com.sun.proxy.$Proxy103.executeSQLQuery(Unknown Source)\n at org.onap.vid.job.impl.JobsBrokerServiceInDatabaseImpl.pull(JobsBrokerServiceInDatabaseImpl.java:110)\n at org.onap.vid.job.impl.JobWorker.pullJob(JobWorker.java:70)\n at org.onap.vid.job.impl.JobWorker.executeInternal(JobWorker.java:58)\n at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75)\n at org.quartz.core.JobRunShell.run(JobRunShell.java:202)\n at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)\nCaused by: org.hibernate.TransactionException: rollback failed\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:217)\n at org.springframework.orm.hibernate4.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)\n ... 14 common frames omitted\nCaused by: org.hibernate.TransactionException: unable to rollback against JDBC connection\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)\n at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:211)\n ... 15 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: (conn:800) Connection is close\n at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:137)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)\n at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)\n at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)\n at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:266)\n at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:616)\n at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:1033)\n at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)\n ... 16 common frames omitted\nCaused by: org.mariadb.jdbc.internal.util.dao.QueryException: Connection is close\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.cmdPrologue(AbstractQueryProtocol.java:1268)\n at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:138)\n at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)\n ... 20 common frames omitted\n