[xwiki-users] Photo Upload errors

[Vincent Massol]

Hi mwiley,

On Mar 8, 2007, at 8:56 AM, jeremi joslin wrote:

> hi,
> it's a problem with your mysql. you need to increase your
> 'max_allowed_packet' in /etc/mysql/my.cnf

See also http://www.xwiki.org/xwiki/bin/view/AdminGuide/ 
InstallationMySQL

Thanks
-Vincent

> On 3/7/07, mwiley <mwiley at wabtec.com> wrote:
>>
>> I was getting the tempdirnotset error so I added the tmp setting  
>> in the
>> xwiki.cfg file.  But now I am geeting this error.
>>
>> Error number 3232 in 3: Exception while saving attachment  
>> IMG_2023.jpg of
>> document Photos.Winterof06
>> Wrapped Exception: Could not execute JDBC batch update
>> com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception  
>> while saving
>> attachment IMG_2023.jpg of document Photos.Winterof06
>> Wrapped Exception: Could not execute JDBC batch update
>>         at
>> com.xpn.xwiki.store.XWikiHibernateAttachmentStore.saveAttachmentConte 
>> nt(XWikiHibernateAttachmentStore.java:99)
>>         at
>> com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent 
>> (XWikiDocument.java:2298)
>>         at
>> com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent 
>> (XWikiDocument.java:2284)
>>         at com.xpn.xwiki.web.UploadAction.action(UploadAction.java: 
>> 114)
>>         at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java: 
>> 149)
>>         at
>> org.apache.struts.action.RequestProcessor.processActionPerform 
>> (RequestProcessor.java:431)
>>         at
>> org.apache.struts.action.RequestProcessor.process 
>> (RequestProcessor.java:236)
>>         at org.apache.struts.action.ActionServlet.process 
>> (ActionServlet.java:1196)
>>         at org.apache.struts.action.ActionServlet.doPost 
>> (ActionServlet.java:432)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 709)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 802)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:252)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at
>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter 
>> (SetCharacterEncodingFilter.java:121)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:202)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at
>> org.apache.catalina.core.StandardWrapperValve.invoke 
>> (StandardWrapperValve.java:213)
>>         at
>> org.apache.catalina.core.StandardContextValve.invoke 
>> (StandardContextValve.java:178)
>>         at
>> org.apache.catalina.core.StandardHostValve.invoke 
>> (StandardHostValve.java:126)
>>         at
>> org.apache.catalina.valves.ErrorReportValve.invoke 
>> (ErrorReportValve.java:105)
>>         at
>> org.apache.catalina.core.StandardEngineValve.invoke 
>> (StandardEngineValve.java:107)
>>         at
>> org.apache.catalina.connector.CoyoteAdapter.service 
>> (CoyoteAdapter.java:148)
>>         at
>> org.apache.coyote.http11.Http11Processor.process 
>> (Http11Processor.java:856)
>>         at
>> org.apache.coyote.http11.Http11Protocol 
>> $Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>         at
>> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
>> (PoolTcpEndpoint.java:527)
>>         at
>> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
>> (LeaderFollowerWorkerThread.java:80)
>>         at
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run 
>> (ThreadPool.java:684)
>>         at java.lang.Thread.run(Thread.java:595)
>>
>>
>> Wrapped Exception:
>>
>> java.sql.BatchUpdateException: Packet for query is too large  
>> (1193355 >
>> 1048576). You can change this value on the server by setting the
>> max_allowed_packet' variable.
>>         at
>> com.mysql.jdbc.PreparedStatement.executeBatch 
>> (PreparedStatement.java:1612)
>>         at
>> org.apache.commons.dbcp.DelegatingStatement.executeBatch 
>> (DelegatingStatement.java:294)
>>         at
>> org.apache.commons.dbcp.DelegatingStatement.executeBatch 
>> (DelegatingStatement.java:294)
>>         at
>> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch 
>> (BatchingBatcher.java:58)
>>         at
>> org.hibernate.jdbc.AbstractBatcher.executeBatch 
>> (AbstractBatcher.java:195)
>>         at
>> org.hibernate.jdbc.AbstractBatcher.prepareStatement 
>> (AbstractBatcher.java:91)
>>         at
>> org.hibernate.jdbc.AbstractBatcher.prepareStatement 
>> (AbstractBatcher.java:86)
>>         at
>> org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement 
>> (AbstractBatcher.java:171)
>>         at
>> org.hibernate.persister.entity.AbstractEntityPersister.insert 
>> (AbstractEntityPersister.java:2048)
>>         at
>> org.hibernate.persister.entity.AbstractEntityPersister.insert 
>> (AbstractEntityPersister.java:2427)
>>         at
>> org.hibernate.action.EntityInsertAction.execute 
>> (EntityInsertAction.java:51)
>>         at org.hibernate.engine.ActionQueue.execute 
>> (ActionQueue.java:243)
>>         at org.hibernate.engine.ActionQueue.executeActions 
>> (ActionQueue.java:227)
>>         at org.hibernate.engine.ActionQueue.executeActions 
>> (ActionQueue.java:140)
>>         at
>> org.hibernate.event.def.AbstractFlushingEventListener.performExecutio 
>> ns(AbstractFlushingEventListener.java:296)
>>         at
>> org.hibernate.event.def.DefaultFlushEventListener.onFlush 
>> (DefaultFlushEventListener.java:27)
>>         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java: 
>> 1009)
>>         at org.hibernate.impl.SessionImpl.managedFlush 
>> (SessionImpl.java:356)
>>         at
>> org.hibernate.transaction.JDBCTransaction.commit 
>> (JDBCTransaction.java:106)
>>         at
>> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction 
>> (XWikiHibernateBaseStore.java:573)
>>         at
>> com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction 
>> (XWikiHibernateBaseStore.java:547)
>>         at
>> com.xpn.xwiki.store.XWikiHibernateAttachmentStore.saveAttachmentConte 
>> nt(XWikiHibernateAttachmentStore.java:94)
>>         at
>> com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent 
>> (XWikiDocument.java:2298)
>>         at
>> com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent 
>> (XWikiDocument.java:2284)
>>         at com.xpn.xwiki.web.UploadAction.action(UploadAction.java: 
>> 114)
>>         at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java: 
>> 149)
>>         at
>> org.apache.struts.action.RequestProcessor.processActionPerform 
>> (RequestProcessor.java:431)
>>         at
>> org.apache.struts.action.RequestProcessor.process 
>> (RequestProcessor.java:236)
>>         at org.apache.struts.action.ActionServlet.process 
>> (ActionServlet.java:1196)
>>         at org.apache.struts.action.ActionServlet.doPost 
>> (ActionServlet.java:432)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 709)
>>         at javax.servlet.http.HttpServlet.service(HttpServlet.java: 
>> 802)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:252)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at
>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter 
>> (SetCharacterEncodingFilter.java:121)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter 
>> (ApplicationFilterChain.java:202)
>>         at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter 
>> (ApplicationFilterChain.java:173)
>>         at
>> org.apache.catalina.core.StandardWrapperValve.invoke 
>> (StandardWrapperValve.java:213)
>>         at
>> org.apache.catalina.core.StandardContextValve.invoke 
>> (StandardContextValve.java:178)
>>         at
>> org.apache.catalina.core.StandardHostValve.invoke 
>> (StandardHostValve.java:126)
>>         at
>> org.apache.catalina.valves.ErrorReportValve.invoke 
>> (ErrorReportValve.java:105)
>>         at
>> org.apache.catalina.core.StandardEngineValve.invoke 
>> (StandardEngineValve.java:107)
>>         at
>> org.apache.catalina.connector.CoyoteAdapter.service 
>> (CoyoteAdapter.java:148)
>>         at
>> org.apache.coyote.http11.Http11Processor.process 
>> (Http11Processor.java:856)
>>         at
>> org.apache.coyote.http11.Http11Protocol 
>> $Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>         at
>> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket 
>> (PoolTcpEndpoint.java:527)
>>         at
>> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt 
>> (LeaderFollowerWorkerThread.java:80)
>>         at
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run 
>> (ThreadPool.java:684)
>>         at java.lang.Thread.run(Thread.java:595)
>>