[xwiki-users] Photo Upload errors

[jeremi joslin]

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

jeremi

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.saveAttachmentContent(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.performExecutions(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.saveAttachmentContent(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)
>
> --
> View this message in context: http://www.nabble.com/Photo-Upload-errors-tf3365393.html#a9363517
> Sent from the XWiki- Users mailing list archive at Nabble.com.
>
>
>
>
> --
> You receive this message as a subscriber of the xwiki-users at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-users-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>


-- 
Jeremi Joslin (http://www.jeremi.info)
skype: jeremi23 - jabber: jeremi23 at gmail.com
http://www.xwiki.com - http://www.pengyou-project.info