[Building Sakai] Audio recording not working on localhost
Neal Caidin
neal.caidin at apereo.org
Tue Dec 16 14:24:14 PST 2014
See logs below. Sounds like I just need to change my max_allowed_packet
(however it is I do that)?
Thanks,
Neal
2014-12-16 17:19:34,643 INFO http-bio-8080-exec-3
org.sakaiproject.tool.assessment.ui.servlet.delivery.UploadAudioMediaServlet
- Acknowleged:
/Users/nealcaidin/dev/sakai-10.x/pack/pack-demo/sakai-demo-10-SNAPSHOT/sakai/samigo/answerUploadRepositoryPath/jsf/upload_tmp/assessment1/question1/student0002/audio_2_1.au->
901164 bytes.
2014-12-16 17:19:35,372 WARN http-bio-8080-exec-3
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: S1000
2014-12-16 17:19:35,372 ERROR http-bio-8080-exec-3
org.hibernate.util.JDBCExceptionReporter - Packet for query is too large
(1802744 > 1048576). You can change this value on the server by setting the
max_allowed_packet' variable.
2014-12-16 17:19:35,373 WARN http-bio-8080-exec-3
org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries -
problem saving media: Hibernate operation: could not insert:
[org.sakaiproject.tool.assessment.data.dao.grading.MediaData]; SQL [insert
into SAM_MEDIA_T (ITEMGRADINGID, MEDIA, FILESIZE, MIMETYPE, DESCRIPTION,
LOCATION, FILENAME, ISLINK, ISHTMLINLINE, STATUS, CREATEDBY, CREATEDDATE,
LASTMODIFIEDBY, LASTMODIFIEDDATE, DURATION) values (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)]; Packet for query is too large (1802744 > 1048576).
You can change this value on the server by setting the max_allowed_packet'
variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet
for query is too large (1802744 > 1048576). You can change this value on
the server by setting the max_allowed_packet' variable.
2014-12-16 17:19:35,373 WARN http-bio-8080-exec-3
org.sakaiproject.tool.assessment.services.PersistenceHelper - Error saving
to db...retry again....
2014-12-16 17:19:35,373 WARN http-bio-8080-exec-3
org.sakaiproject.tool.assessment.services.PersistenceHelper - Hibernate
operation: could not insert:
[org.sakaiproject.tool.assessment.data.dao.grading.MediaData]; SQL [insert
into SAM_MEDIA_T (ITEMGRADINGID, MEDIA, FILESIZE, MIMETYPE, DESCRIPTION,
LOCATION, FILENAME, ISLINK, ISHTMLINLINE, STATUS, CREATEDBY, CREATEDDATE,
LASTMODIFIEDBY, LASTMODIFIEDDATE, DURATION) values (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)]; Packet for query is too large (1802744 > 1048576).
You can change this value on the server by setting the max_allowed_packet'
variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet
for query is too large (1802744 > 1048576). You can change this value on
the server by setting the max_allowed_packet' variable.
2014-12-16 17:19:35,373 ERROR http-bio-8080-exec-3
org.hibernate.AssertionFailure - an assertion failure occured (this may
indicate a bug in Hibernate, but is more likely due to unsafe use of the
session)
org.hibernate.AssertionFailure: null id in
org.sakaiproject.tool.assessment.data.dao.grading.MediaData entry (don't
flush the Session after an exception occurs)
at
org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:82)
at
org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:190)
at
org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:147)
at
org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:219)
at
org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:99)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at
org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:657)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy105.saveMedia(Unknown Source)
at
org.sakaiproject.tool.assessment.services.GradingService.saveMedia(GradingService.java:465)
at
org.sakaiproject.tool.assessment.ui.servlet.delivery.UploadAudioMediaServlet.saveMedia(UploadAudioMediaServlet.java:430)
at
org.sakaiproject.tool.assessment.ui.servlet.delivery.UploadAudioMediaServlet.submitMediaAsAnswer(UploadAudioMediaServlet.java:391)
at
org.sakaiproject.tool.assessment.ui.servlet.delivery.UploadAudioMediaServlet.doPost(UploadAudioMediaServlet.java:128)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:455)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
2014-12-16 17:19:35,375 INFO http-bio-8080-exec-3
org.sakaiproject.tool.assessment.ui.servlet.delivery.UploadAudioMediaServlet
- null id in org.sakaiproject.tool.assessment.data.dao.grading.MediaData
entry (don't flush the Session after an exception occurs)
On Tue, Dec 16, 2014 at 4:13 PM, Neal Caidin <neal.caidin at apereo.org> wrote:
>
> Hi sakai-dev,
>
> I have a conundrum. When I test on 10.x and on 10.3 in Samigo Test and
> Quizzes, the Audio Recording question type works fine as instructor and
> student.
>
> I update my local 10.x (svn up), running as pack-demo against MySql. As
> a student, I take open the question, allow recording, click record. Seems
> to record fine. I can play it back. Click Save and it says Uploading and
> then complete , then Closing Window, and it closes. But the recording does
> not show up for the student. It is like the student didn't even do a
> recording. I have it set to unlimited, so I can do it again with the same
> results.
>
> Any idea why 10.x would work on nightly for Audio Recording but not
> locally?
>
> Thanks,
> Neal
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141216/e867c35a/attachment.html
More information about the sakai-dev
mailing list