[Building Sakai] Audio recording not working on localhost

Tue Dec 16 15:27:53 PST 2014

Hi,

What is the exact value to set?

Or is it system dependant!

Yours,
Alaa

Sent from Samsung Mobile.

<div>-------- Original message --------</div><div>From: Neal Caidin <neal.caidin at apereo.org> </div><div>Date:16/12/2014  22:55  (GMT+00:00) </div><div>To: Sakai-Dev <sakai-dev at collab.sakaiproject.org> </div><div>Subject: Re: [Building Sakai] Audio recording not working on localhost </div><div>
</div>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

-- 
This message has been scanned for viruses and 
dangerous content by MailScanner, and is 
believed to be clean.
-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141216/7789fb1b/attachment.html 