Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Hibernate: select assessment2_.ID as col_0_0_, count(*) as col_1_0_ from SAM_ITEM_T itemdata0_ cross join SAM_SECTION_T sectiondat1_ cross join SAM_ASSESSMENTBASE_T assessment2_ cross join SAM_AUTHZDATA_T authorizat3_ where assessment2_.isTemplate='0' and assessment2_.ID=sectiondat1_.ASSESSMENTID and sectiondat1_.SECTIONID=itemdata0_.SECTIONID and assessment2_.ID=authorizat3_.QUALIFIERID and authorizat3_.FUNCTIONID=? and authorizat3_.AGENTID=? group by assessment2_.ID
Hibernate: select publisheda0_.ID as col_0_0_, publisheda0_.TITLE as col_1_0_, publisheda1_.RELEASETO as col_2_0_, publisheda1_.STARTDATE as col_3_0_, publisheda1_.DUEDATE as col_4_0_, publisheda1_.RETRACTDATE as col_5_0_, publisheda0_.STATUS as col_6_0_, publisheda0_.LASTMODIFIEDDATE as col_7_0_, publisheda0_.LASTMODIFIEDBY as col_8_0_, publisheda1_.LATEHANDLING as col_9_0_, publisheda1_.UNLIMITEDSUBMISSIONS as col_10_0_, publisheda1_.SUBMISSIONSALLOWED as col_11_0_ from SAM_PUBLISHEDASSESSMENT_T publisheda0_ cross join SAM_PUBLISHEDACCESSCONTROL_T publisheda1_ cross join SAM_AUTHZDATA_T authorizat2_ where publisheda1_.ASSESSMENTID=publisheda0_.ID and publisheda0_.ID=authorizat2_.QUALIFIERID and authorizat2_.FUNCTIONID=? and authorizat2_.AGENTID=? and (publisheda0_.STATUS=? or publisheda0_.STATUS=?) order by publisheda0_.TITLE asc
Hibernate: select assessment0_.PUBLISHEDASSESSMENTID as col_0_0_, assessment0_.AGENTID as col_1_0_, count(*) as col_2_0_ from SAM_ASSESSMENTGRADING_T assessment0_ cross join SAM_AUTHZDATA_T authorizat1_ where assessment0_.FORGRADE=? and authorizat1_.FUNCTIONID=? and authorizat1_.AGENTID=? and assessment0_.PUBLISHEDASSESSMENTID=authorizat1_.QUALIFIERID group by assessment0_.PUBLISHEDASSESSMENTID , assessment0_.AGENTID order by assessment0_.PUBLISHEDASSESSMENTID, assessment0_.AGENTID
Hibernate: select assessment0_.PUBLISHEDASSESSMENTID as col_0_0_, assessment0_.AGENTID as col_1_0_, count(*) as col_2_0_ from SAM_ASSESSMENTGRADING_T assessment0_ cross join SAM_AUTHZDATA_T authorizat1_ where assessment0_.FORGRADE=? and authorizat1_.FUNCTIONID=? and authorizat1_.AGENTID=? and assessment0_.PUBLISHEDASSESSMENTID=authorizat1_.QUALIFIERID and (assessment0_.STATUS=? or assessment0_.STATUS=?) group by assessment0_.PUBLISHEDASSESSMENTID , assessment0_.AGENTID order by assessment0_.PUBLISHEDASSESSMENTID, assessment0_.AGENTID
Hibernate: select studentgra0_.STUDENTGRADINGSUMMARYID as STUDENTG1_182_, studentgra0_.PUBLISHEDASSESSMENTID as PUBLISHE2_182_, studentgra0_.AGENTID as AGENTID3_182_, studentgra0_.NUMBERRETAKE as NUMBERRE4_182_, studentgra0_.CREATEDBY as CREATEDB5_182_, studentgra0_.CREATEDDATE as CREATEDD6_182_, studentgra0_.LASTMODIFIEDBY as LASTMODI7_182_, studentgra0_.LASTMODIFIEDDATE as LASTMODI8_182_ from SAM_STUDENTGRADINGSUMMARY_T studentgra0_ cross join SAM_AUTHZDATA_T authorizat1_ where authorizat1_.FUNCTIONID=? and authorizat1_.AGENTID=? and studentgra0_.PUBLISHEDASSESSMENTID=authorizat1_.QUALIFIERID order by studentgra0_.PUBLISHEDASSESSMENTID, studentgra0_.AGENTID
Hibernate: select assessment0_.PUBLISHEDASSESSMENTID as col_0_0_, assessment0_.AGENTID as col_1_0_, count(*) as col_2_0_ from SAM_ASSESSMENTGRADING_T assessment0_ cross join SAM_STUDENTGRADINGSUMMARY_T studentgra1_ cross join SAM_AUTHZDATA_T authorizat2_ cross join SAM_PUBLISHEDASSESSMENT_T publisheda3_ where assessment0_.FORGRADE=? and authorizat2_.FUNCTIONID=? and authorizat2_.AGENTID=? and assessment0_.PUBLISHEDASSESSMENTID=authorizat2_.QUALIFIERID and assessment0_.PUBLISHEDASSESSMENTID=studentgra1_.PUBLISHEDASSESSMENTID and assessment0_.AGENTID=studentgra1_.AGENTID and assessment0_.SUBMITTEDDATE>studentgra1_.CREATEDDATE and assessment0_.PUBLISHEDASSESSMENTID=publisheda3_.ID and publisheda3_.STATUS<>2 group by assessment0_.PUBLISHEDASSESSMENTID , assessment0_.AGENTID order by assessment0_.PUBLISHEDASSESSMENTID
Hibernate: select distinct assessment0_.PUBLISHEDASSESSMENTID as col_0_0_ from SAM_ASSESSMENTGRADING_T assessment0_ cross join SAM_AUTHZDATA_T authorizat1_ where authorizat1_.FUNCTIONID=? and authorizat1_.AGENTID=? and assessment0_.PUBLISHEDASSESSMENTID=authorizat1_.QUALIFIERID and assessment0_.FORGRADE=? and assessment0_.STATUS=?
07-Sep-2017 13:31:56.212 WARN [QuartzScheduler_Worker-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions SQL Error: 1205, SQLState: 40001
07-Sep-2017 13:31:56.212 ERROR [QuartzScheduler_Worker-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions Lock wait timeout exceeded; try restarting transaction
07-Sep-2017 13:31:56.214 WARN [QuartzScheduler_Worker-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning SQL Warning Code: 1205, SQLState: 40001
07-Sep-2017 13:31:56.214 WARN [QuartzScheduler_Worker-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logWarning Lock wait timeout exceeded; try restarting transaction
07-Sep-2017 13:31:56.216 ERROR [QuartzScheduler_Worker-3] org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.autoSubmitAssessments Error while auto submitting assessment grade data id: 21
org.springframework.dao.CannotAcquireLockException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute statement
at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:154)
at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:730)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:592)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy181.autoSubmitSingleAssessment(Unknown Source)
at org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.autoSubmitAssessments(AssessmentGradingFacadeQueries.java:3125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy180.autoSubmitAssessments(Unknown Source)
at org.sakaiproject.tool.assessment.services.GradingService.autoSubmitAssessments(GradingService.java:3339)
at org.sakaiproject.tool.assessment.services.AutoSubmitAssessmentsJob.execute(AutoSubmitAssessmentsJob.java:103)
at org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:95)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
at org.hibernate.dialect.MySQLDialect$1.convert(MySQLDialect.java:451)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3281)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3183)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3525)
at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:159)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1258)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:425)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:177)
at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
... 27 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1281)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:782)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
... 41 more
07-Sep-2017 13:31:56.228 INFO [QuartzScheduler_Worker-3] org.sakaiproject.tool.assessment.services.AutoSubmitAssessmentsJob.execute End Job: AutoSubmitAssessmentsJob $ Job: autosubmit Trigger: MT_blp1d6rn0ebo6 Fire scheduled: Thu Sep 07 13:31:04 EDT 2017 Fire actual: Thu Sep 07 13:31:04 EDT 2017 (1 failures)
Hibernate: insert into scheduler_trigger_events (eventType, jobName, message, serverId, eventTime, triggerName, uuid) values (?, ?, ?, ?, ?, ?, ?)
07-Sep-2017 13:32:08.086 WARN [http-nio-9080-exec-2] org.sakaiproject.portal.charon.handlers.SiteHandler.doSite Redirecting tool inline url: http://127.0.0.1:9080/portal/site/!admin/tool/!admin-1010
07-Sep-2017 13:34:24.596 DEBUG [Timer-1] org.sakaiproject.content.impl.BaseContentService.run running timer task
Hibernate: select academicse0_.ACADEMIC_SESSION_ID as ACADEMIC1_21_, academicse0_.VERSION as VERSION2_21_, academicse0_.LAST_MODIFIED_BY as LAST_MOD3_21_, academicse0_.LAST_MODIFIED_DATE as LAST_MOD4_21_, academicse0_.CREATED_BY as CREATED_5_21_, academicse0_.CREATED_DATE as CREATED_6_21_, academicse0_.ENTERPRISE_ID as ENTERPRI7_21_, academicse0_.TITLE as TITLE8_21_, academicse0_.DESCRIPTION as DESCRIPT9_21_, academicse0_.START_DATE as START_D10_21_, academicse0_.END_DATE as END_DAT11_21_, academicse0_.IS_CURRENT as IS_CURR12_21_ from CM_ACADEMIC_SESSION_T academicse0_ order by academicse0_.START_DATE desc
Hibernate: insert into scheduler_trigger_events (eventType, jobName, message, serverId, eventTime, triggerName, uuid) values (?, ?, ?, ?, ?, ?, ?)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.