[Building Sakai] Audio recording not working on localhost
Neal Caidin
neal.caidin at apereo.org
Tue Dec 16 14:55:06 PST 2014
That seems to have done the trick, increasing max_allowed_packet on
/etc/my.cnf
Works now on localhost.
On Tue, Dec 16, 2014 at 5:24 PM, Neal Caidin <neal.caidin at apereo.org> wrote:
>
> 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/eb1de77a/attachment.html
More information about the sakai-dev
mailing list