[xwiki-users] Problem occured while trying to service a request
hi, I am trying to upgrade my XE 1.2.1 to XE 1.3.2 . When I tried to import the XAR file it shows the following . Why it is so? Can any one reply? A problem occured while trying to service your request. Please contact the support if this happens again. Detailed information: Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-installer-windows-1.2.1.xar of document XWiki.Import Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-installer-windows-1.2.1.xar of document XWiki.Import 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:2517) at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2499) at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:197) 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:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Wrapped Exception: java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1404) 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:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:783) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:754) at com.xpn.xwiki.store.XWikiHibernateAttachmentStore.saveAttachmentContent(XWikiHibernateAttachmentStore.java:94) at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2517) at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2499) at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:197) 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:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) Regards, Project trainees.
Hi, This is a known issue, see http://jira.xwiki.org/jira/browse/ XWIKI-2339 for a solution to the problem. Thanks -Vincent On May 13, 2008, at 10:09 AM, [email protected] wrote:
hi,
I am trying to upgrade my XE 1.2.1 to XE 1.3.2 . When I tried to import the XAR file it shows the following . Why it is so? Can any one reply?
A problem occured while trying to service your request. Please contact the support if this happens again.
Detailed information:
Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-installer-windows-1.2.1.xar of document XWiki.Import Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-installer-windows-1.2.1.xar of document XWiki.Import 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: 2517) at com .xpn .xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 2499) at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:197) 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:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler $CachedChain.doFilter(WebApplicationHandler.java:830) at com .xpn .xwiki .web .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 117) at org.mortbay.jetty.servlet.WebApplicationHandler $CachedChain.doFilter(WebApplicationHandler.java:821) at org .mortbay .jetty .servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java: 471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: 568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org .mortbay .jetty .servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java: 983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java: 244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Wrapped Exception:
java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: 1404) 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: 48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 246) at org .hibernate .jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92) at org .hibernate .jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87) at org .hibernate .jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222) at org .hibernate .persister .entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 2224) at org .hibernate .persister .entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 2660) at org .hibernate.action.EntityInsertAction.execute(EntityInsertAction.java: 56) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 141) at org .hibernate .event .def .AbstractFlushingEventListener .performExecutions(AbstractFlushingEventListener.java:298) at org .hibernate .event .def .DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org .hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java: 106) at com .xpn .xwiki .store .XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 783) at com .xpn .xwiki .store .XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java: 754) at com .xpn .xwiki .store .XWikiHibernateAttachmentStore .saveAttachmentContent(XWikiHibernateAttachmentStore.java:94) at com .xpn .xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 2517) at com .xpn .xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java: 2499) at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:129) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:197) 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:616) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler $CachedChain.doFilter(WebApplicationHandler.java:830) at com .xpn .xwiki .web .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: 117) at org.mortbay.jetty.servlet.WebApplicationHandler $CachedChain.doFilter(WebApplicationHandler.java:821) at org .mortbay .jetty .servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java: 471) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java: 568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at org .mortbay .jetty .servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at org.mortbay.http.HttpServer.service(HttpServer.java:954) at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java: 983) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java: 244) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Regards, Project trainees. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Vincent Massol wrote:
Hi,
This is a known issue, see http://jira.xwiki.org/jira/browse/ XWIKI-2339 for a solution to the problem.
Thanks -Vincent
On May 13, 2008, at 10:09 AM, [email protected] wrote:
java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: 1404)
No, it's not that one, it is a mysql setting. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html -- Sergiu Dumitriu http://purl.org/net/sergiu/
Vincent Massol wrote:
Hi,
This is a known issue, see http://jira.xwiki.org/jira/browse/ XWIKI-2339 for a solution to the problem.
Thanks -Vincent
On May 13, 2008, at 10:09 AM, [email protected] wrote:
java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: 1404)
No, it's not that one, it is a mysql setting. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, I started Mysql with > mysql -u root -p --max_allowed_packet=32M and again tried to import but it shows the same error. Thanks, Project trainees.
[email protected] wrote:
Vincent Massol wrote:
Hi,
This is a known issue, see http://jira.xwiki.org/jira/browse/ XWIKI-2339 for a solution to the problem.
Thanks -Vincent
On May 13, 2008, at 10:09 AM, [email protected] wrote:
java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: 1404) No, it's not that one, it is a mysql setting. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html -- Sergiu Dumitriu http://purl.org/net/sergiu/
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, I started Mysql with > mysql -u root -p --max_allowed_packet=32M and again tried to import but it shows the same error.
That starts a mysql client, not the server. The best would be to change the my.cnf configuration file with: [mysqld] max_allowed_packet=32M -- Sergiu Dumitriu http://purl.org/net/sergiu/
On May 14, 2008, at 2:15 PM, Sergiu Dumitriu wrote:
[email protected] wrote:
Vincent Massol wrote:
Hi,
This is a known issue, see http://jira.xwiki.org/jira/browse/ XWIKI-2339 for a solution to the problem.
Thanks -Vincent
On May 13, 2008, at 10:09 AM, [email protected] wrote:
java.sql.BatchUpdateException: Packet for query is too large (1458818 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com .mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: 1404) No, it's not that one, it is a mysql setting. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html -- Sergiu Dumitriu http://purl.org/net/sergiu/
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, I started Mysql with
mysql -u root -p --max_allowed_packet=32M and again tried to import but it shows the same error.
That starts a mysql client, not the server. The best would be to change the my.cnf configuration file with:
[mysqld] max_allowed_packet=32M
that's the best indeed. if you really want the command line, I use something like: sudo /usr/local/mysql/bin/mysqld_safe --user=mysql -- max_allowed_packet=32M -Vincent
participants (3)
-
project_trainees＠amritatech.com -
Sergiu Dumitriu -
Vincent Massol