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 <[email protected]> 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)