[Building Sakai] Samigo Test & quizzes file upload error
Francois Campbell
francois at opencollab.co.za
Fri Jul 19 02:40:00 PDT 2013
Good day.
The error was being caused by an incorrectly configured MySQL property.
Namely max_allowed_packet, It was set to 1M, it needed to be something
larger e.g. 20M
On 18 July 2013 09:19, Francois Campbell <francois at opencollab.co.za> wrote:
> Hi Karen,
>
> It occurs with most(+-60%) students.
>
> Sakai 2.8.2
> Samigo 2.8.5
> CentOS 6
> MySQL 5.1
>
>
>
> On 17 July 2013 19:43, Karen Tsao <ktsao at stanford.edu> wrote:
>
>> Hi Francois,
>>
>> Does this happen to all your users or just this one? What Samigo version
>> do you run?
>>
>> Thanks,
>> Karen
>>
>>
>> On Wed, Jul 17, 2013 at 7:48 AM, Francois Campbell <
>> francois at opencollab.co.za> wrote:
>>
>>> Good day.
>>>
>>> We are having an error (listed below) when users are attempting to
>>> upload a file in tests and quizzes. Any input would be welcome.
>>>
>>> *Samigo settings* :
>>>
>>> samigo.answerUploadRepositoryPath=${sakai.home}/samigo/answerUploadRepositoryPath/
>>> samigo.sizeThreshold=512
>>> samigo.sizeMax=20480
>>> samigo.saveMediaToDb=true
>>> samigo.email.prefixedPath=/tmp/
>>> samigo.samliteEnabled=true
>>> samigo.editPubAssessment.restricted=true
>>> samigo.editPubAnonyGrading.restricted=false
>>> samigo.autoSubmit.enabled=false
>>>
>>>
>>>
>>> *Error*
>>> bug-id: 4602099f-3e34-43b5-9df1-68f578d76a66
>>> user: 11237 (username)
>>> email: e <john.okumu at za.gt.com>mail at email.com
>>> usage-session: 7a04e313-0d01-4d76-b49a-8d75be697269
>>> stack-trace-digest: 7C0516C9AB441FABB80771D7E2CE31A5A78EFFCA
>>> sakai-version: 2.8.2
>>> service-version: Production
>>> app-server:client server
>>> user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36
>>> (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36
>>> browser-id: Win-Mozilla
>>> IP: 41.78.190.64
>>> time: Jul 17, 2013 16:04:04
>>>
>>>
>>> user comment:
>>>
>>> I was attempting to upload my Computer project Workings
>>>
>>>
>>> stack trace:
>>>
>>>
>>> org.sakaiproject.portal.api.PortalHandlerException:
>>> org.sakaiproject.tool.api.ToolException: 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.sakaiproject.portal.charon.handlers.ToolHandler.
>>> doPost(ToolHandler.java:73)
>>> caused by: org.sakaiproject.tool.api.ToolException: 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.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(
>>> SkinnableCharonPortal.java:1429)
>>> caused by: javax.servlet.ServletException: 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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:269)
>>> caused by: javax.faces.el.EvaluationException: 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 javax.faces.component.UIInput.broadcast(UIInput.java:492)
>>> caused by: 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:55)
>>> at org.hibernate.event.def.DefaultFlushEntityEventListene
>>> r.getValues(DefaultFlushEntityEventListener.java:164)
>>> at org.hibernate.event.def.DefaultFlushEntityEventListene
>>> r.onFlushEntity(DefaultFlushEntityEventListener.java:120)
>>> at org.hibernate.event.def.AbstractFlushingEventListener.
>>> flushEntities(AbstractFlushingEventListener.java:196)
>>> at org.hibernate.event.def.AbstractFlushingEventListener.
>>> flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
>>> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(
>>> DefaultFlushEventListener.java:26)
>>> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
>>> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:339)
>>> at org.hibernate.transaction.JDBCTransaction.commit(
>>> JDBCTransaction.java:106)
>>> at org.springframework.orm.hibernate3.HibernateTransactionManager.
>>> doCommit(HibernateTransactionManager.java:655)
>>> at org.springframework.transaction.support.
>>> AbstractPlatformTransactionManager.processCommit(
>>> AbstractPlatformTransactionManager.java:732)
>>> at org.springframework.transaction.support.
>>> AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionMan
>>> ager.java:701)
>>> at org.springframework.transaction.interceptor.
>>> TransactionAspectSupport.commitTransactionAfterReturnin
>>> g(TransactionAspectSupport.java:321)
>>> at org.springframework.transaction.interceptor.
>>> TransactionInterceptor.invoke(TransactionInterceptor.java:116)
>>> at org.springframework.aop.framework.ReflectiveMethodInvocation.
>>> proceed(ReflectiveMethodInvocation.java:171)
>>> at org.springframework.aop.framework.JdkDynamicAopProxy.
>>> invoke(JdkDynamicAopProxy.java:204)
>>> at $Proxy92.saveMedia(null:-1)
>>> at org.sakaiproject.tool.assessment.services.
>>> GradingService.saveMedia(GradingService.java:418)
>>> at org.sakaiproject.tool.assessment.ui.bean.delivery.
>>> DeliveryBean.saveMedia(DeliveryBean.java:2081)
>>> at org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.
>>> addMediaToItemGrading(DeliveryBean.java:2020)
>>> at org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.
>>> addMediaToItemGrading(DeliveryBean.java:1941)
>>> at sun.reflect.GeneratedMethodAccessor4171.invoke(null:-1)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>>> DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:597)
>>> at com.sun.faces.el.MethodBindingImpl.invoke(
>>> MethodBindingImpl.java:126)
>>> at javax.faces.component.UIInput.broadcast(UIInput.java:492)
>>> at javax.faces.component.UIData.broadcast(UIData.java:657)
>>> at javax.faces.component.UIData.broadcast(UIData.java:657)
>>> at javax.faces.component.UIViewRoot.broadcastEvents(
>>> UIViewRoot.java:249)
>>> at javax.faces.component.UIViewRoot.processValidators(
>>> UIViewRoot.java:343)
>>> at com.sun.faces.lifecycle.ProcessValidationsPhase.execute(
>>> ProcessValidationsPhase.java:78)
>>> at com.sun.faces.lifecycle.LifecycleImpl.phase(
>>> LifecycleImpl.java:200)
>>> at com.sun.faces.lifecycle.LifecycleImpl.execute(
>>> LifecycleImpl.java:90)
>>> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:269)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at com.corejsf.UploadFilter.doFilter(UploadFilter.java:139)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:215)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at org.sakaiproject.util.RequestFilter.doFilter(
>>> RequestFilter.java:598)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:215)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at org.apache.catalina.core.ApplicationDispatcher.invoke(
>>> ApplicationDispatcher.java:659)
>>> at org.apache.catalina.core.ApplicationDispatcher.processRequest(
>>> ApplicationDispatcher.java:457)
>>> at org.apache.catalina.core.ApplicationDispatcher.doForward(
>>> ApplicationDispatcher.java:395)
>>> at org.apache.catalina.core.ApplicationDispatcher.forward(
>>> ApplicationDispatcher.java:311)
>>> at org.sakaiproject.jsf.util.SamigoJsfTool.dispatch(
>>> SamigoJsfTool.java:301)
>>> at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:269)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at org.apache.catalina.core.ApplicationDispatcher.invoke(
>>> ApplicationDispatcher.java:659)
>>> at org.apache.catalina.core.ApplicationDispatcher.processRequest(
>>> ApplicationDispatcher.java:457)
>>> at org.apache.catalina.core.ApplicationDispatcher.doForward(
>>> ApplicationDispatcher.java:359)
>>> at org.apache.catalina.core.ApplicationDispatcher.forward(
>>> ApplicationDispatcher.java:311)
>>> at org.sakaiproject.tool.impl.ActiveToolComponent$
>>> MyActiveTool.forward(ActiveToolComponent.java:511)
>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(
>>> SkinnableCharonPortal.java:1429)
>>> at org.sakaiproject.portal.charon.handlers.ToolHandler.
>>> doTool(ToolHandler.java:204)
>>> at org.sakaiproject.portal.charon.handlers.ToolHandler.
>>> doGet(ToolHandler.java:96)
>>> at org.sakaiproject.portal.charon.handlers.ToolHandler.
>>> doPost(ToolHandler.java:73)
>>> at org.sakaiproject.portal.charon.SkinnableCharonPortal.
>>> doPost(SkinnableCharonPortal.java:1224)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:269)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at org.sakaiproject.util.RequestFilter.doFilter(
>>> RequestFilter.java:659)
>>> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
>>> ApplicationFilterChain.java:215)
>>> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
>>> ApplicationFilterChain.java:188)
>>> at org.apache.catalina.core.StandardWrapperValve.invoke(
>>> StandardWrapperValve.java:213)
>>> at org.apache.catalina.core.StandardContextValve.invoke(
>>> StandardContextValve.java:172)
>>> at org.apache.catalina.core.StandardHostValve.invoke(
>>> StandardHostValve.java:127)
>>> at org.apache.catalina.valves.ErrorReportValve.invoke(
>>> ErrorReportValve.java:117)
>>> at org.apache.catalina.core.StandardEngineValve.invoke(
>>> StandardEngineValve.java:108)
>>> at org.apache.catalina.connector.CoyoteAdapter.service(
>>> CoyoteAdapter.java:174)
>>> at org.apache.coyote.http11.Http11Processor.process(
>>> Http11Processor.java:881)
>>> at org.apache.coyote.http11.Http11BaseProtocol$
>>> Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
>>> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
>>> PoolTcpEndpoint.java:541)
>>> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
>>> LeaderFollowerWorkerThread.java:81)
>>> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
>>> ThreadPool.java:689)
>>> at java.lang.Thread.run(Thread.java:662)
>>>
>>>
>>>
>>>
>>> Tool Placement:
>>> No Placement
>>>
>>>
>>>
>>>
>>> Request:
>>> : AuthType:null
>>> : CharEncoding:utf-8
>>> : ContentLength:2424331
>>> : ContentType:multipart/form-data; boundary=----
>>> WebKitFormBoundaryGWsufi2XRbBeRkSh
>>> : ContextPath:/portal
>>> : LocalAddress:41.222.50.13
>>> : LocalName:41.222.50.13
>>> : LocalPort:8080
>>> : Method:POST
>>> : PathInfo:/tool/0f0813e3-aafb-4d95-bc48-c561168a811e/jsf/
>>> delivery/deliverAssessment
>>> : Protocol:HTTP/1.1
>>> : QueryString:null
>>> : RemoteAddress:41.78.190.64
>>> : RemoteHost:41.78.190.64
>>> : RemotePort:60843
>>> : Requested URL:
>>> http://clientdomain.com/portal/tool/0f0813e3-aafb-4d95-bc48-c561168a811e/jsf/delivery/deliverAssessment
>>> : Scheme:http
>>> : ServerName:clientdomain.com
>>> : Headers:
>>> : Header:host:clientdomain
>>> : Header:connection:keep-alive
>>> : Header:content-length:2424331
>>> : Header:cache-control:max-age=0
>>> : Header:accept:text/html,application/xhtml+xml,
>>> application/xml;q=0.9,*/*;q=0.8
>>> : Header:origin:http://c <http://aptassist.co.za/>lientdomain.com
>>> : Header:user-agent:Mozilla/5.0 (Windows NT 6.1; WOW64)
>>> AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36
>>> : Header:content-type:multipart/form-data; boundary=----
>>> WebKitFormBoundaryGWsufi2XRbBeRkSh
>>> : Header:referer:
>>> http://clientdomain.com/portal/tool/0f0813e3-aafb-4d95-bc48-c561168a811e/jsf/delivery/deliverAssessment
>>> : Header:accept-encoding:gzip,deflate,sdch
>>> : Header:accept-language:en-US,en;q=0.8
>>> : Header:cookie:---censored---
>>> : Parameters:
>>> : Attributes:
>>> : Attribute:sakai.character.encoding.done:sakai.character.
>>> encoding.done
>>> : Attribute:tool.url.manager:org.sakaiproject.portal.util.
>>> ToolURLManagerImpl at 71f023ae
>>> : Attribute:sakai.html.body.onload:setMainFrameHeight('
>>> Main0f0813e3xaafbx4d95xbc48xc561168a811e');setFocus(focus_path);
>>> : Attribute:sakai.request.native.url:sakai.request.native.url
>>> : Attribute:sakai.filtered:sakai.filtered
>>> : Attribute:sakai.html.head.css:<link href="/skin/tool_base.css"
>>> type="text/css" rel="stylesheet" media="all" />
>>> <link href="/skin/client/tool.css" type="text/css" rel="stylesheet"
>>> media="all" />
>>>
>>> : Attribute:sakai.session:org.sakaiproject.tool.impl.
>>> MySession at edda3186
>>> : Attribute:sakai.html.head.css.skin:<link
>>> href="/skin/client/tool.css" type="text/css" rel="stylesheet"
>>> media="all" />
>>>
>>> : Attribute:sakai.html.head.js:<script type="text/javascript"
>>> language="JavaScript" src="/library/js/headscripts.js"></script>
>>> <script type="text/javascript" language="JavaScript">var sakai = sakai
>>> || {}; sakai.editor = sakai.editor || {};
>>> sakai.editor.collectionId = '/group/c13670e1-ffab-47b1-
>>> 8d30-4df9716e3839/';
>>> sakai.editor.enableResourceSearch = false;</script>
>>> <script type="text/javascript" language="JavaScript"></script>
>>> <script type="text/javascript" language="JavaScript"
>>> src="/library/editor/FCKeditor/fckeditor.js"></script>
>>> <script type="text/javascript" language="JavaScript"
>>> src="/library/editor/fckeditor.launch.js"></script>
>>>
>>> : Attribute:sakai.html.head:<link href="/skin/tool_base.css"
>>> type="text/css" rel="stylesheet" media="all" />
>>> <link href="/skin/client/tool.css" type="text/css" rel="stylesheet"
>>> media="all" />
>>> <script type="text/javascript" language="JavaScript"
>>> src="/library/js/headscripts.js"></script>
>>> <script type="text/javascript" language="JavaScript">var sakai = sakai
>>> || {}; sakai.editor = sakai.editor || {};
>>> sakai.editor.collectionId = '/group/c13670e1-ffab-47b1-
>>> 8d30-4df9716e3839/';
>>> sakai.editor.enableResourceSearch = false;</script>
>>> <script type="text/javascript" language="JavaScript"></script>
>>> <script type="text/javascript" language="JavaScript"
>>> src="/library/editor/FCKeditor/fckeditor.js"></script>
>>> <script type="text/javascript" language="JavaScript"
>>> src="/library/editor/fckeditor.launch.js"></script>
>>>
>>> : Attribute:sakai.html.head.css.base:<link
>>> href="/skin/tool_base.css" type="text/css" rel="stylesheet" media="all" />
>>>
>>> Session:
>>> : Created:1374069099701
>>> : LastAccess:1374069844899
>>> : MaxInactive:18900
>>> : Attributes:
>>> : Attribute:portalskin:defaultskin
>>>
>>> --
>>> *Francois Campbell*
>>> Java Developer
>>> *opencollab*
>>> *Tel*: +27 21 970 4000 | *Fax*: +27 21 914 3098
>>> *Mobile*: 083 273 3530
>>> *Web*: www.opencollab.co.za
>>>
>>> ------------------------------
>>> See OpenCollab email disclaimer at http://www.opencollab.co.**
>>> za/email-disclaimer <http://www.opencollab.co.za/email-disclaimer>
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>>
>>
>>
>
>
> --
> *Francois Campbell*
> Java Developer
> *opencollab*
> *Tel*: +27 21 970 4000 | *Fax*: +27 21 914 3098
> *Mobile*: 083 273 3530
> *Web*: www.opencollab.co.za
>
--
*Francois Campbell*
Java Developer
*opencollab*
*Tel*: +27 21 970 4000 | *Fax*: +27 21 914 3098
*Mobile*: 083 273 3530
*Web*: www.opencollab.co.za
--
------------------------------
See OpenCollab email disclaimer at
http://www.opencollab.co.za/email-disclaimer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130719/ebcb726f/attachment.html
More information about the sakai-dev
mailing list