Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-5372

Can't delete big page like xwiki:Scheduler.WatchListHourlyNotifier

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.4
    • Fix Version/s: None
    • Component/s: Old Core
    • Labels:
      None
    • Environment:
      Tomcat, MySQL
    • keywords:
      watchlist, mysql,
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      I've got this error while trying to delete page xwiki:Scheduler.WatchListHourlyNotifier :

      Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDeletedDocument]
      com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDeletedDocument]
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1069)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1115)
      	at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.saveToRecycleBin(XWikiHibernateRecycleBinStore.java:69)
      	at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:4299)
      	at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:4291)
      	at com.xpn.xwiki.web.DeleteAction.action(DeleteAction.java:94)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:214)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
      	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.doGet(ActionServlet.java:414)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.airfrance.wiki.filter.CrossSessionWikiHabileFilter.doFilter(CrossSessionWikiHabileFilter.java:131)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processChain(LdapProcessor.java:326)
      	at com.airfrance.habile.filter.engine.LdapProcessor.dispatchForward(LdapProcessor.java:286)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processAction(LdapProcessor.java:242)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processAction(LdapProcessor.java:222)
      	at com.airfrance.habile.filter.engine.LdapProcessor.process(LdapProcessor.java:203)
      	at com.airfrance.habile.filter.HabileFilter.doFilter(HabileFilter.java:207)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
      	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:210)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      	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:151)
      	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
      	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
      	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
      	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
      	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      	at java.lang.Thread.run(Thread.java:595)
      
      
      Wrapped Exception:
      
      com.mysql.jdbc.PacketTooBigException: Packet for query is too large (41055055 > 33553408). You can change this value on the server by setting the max_allowed_packet' variable.
      	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      	at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
      	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
      	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)
      	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)
      	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
      	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
      	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
      	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
      	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
      	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
      	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
      	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
      	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
      	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
      	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
      	at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore$1.doInHibernate(XWikiHibernateRecycleBinStore.java:73)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1063)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1115)
      	at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.saveToRecycleBin(XWikiHibernateRecycleBinStore.java:69)
      	at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:4299)
      	at com.xpn.xwiki.XWiki.deleteDocument(XWiki.java:4291)
      	at com.xpn.xwiki.web.DeleteAction.action(DeleteAction.java:94)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:214)
      	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)
      	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.doGet(ActionServlet.java:414)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.airfrance.wiki.filter.CrossSessionWikiHabileFilter.doFilter(CrossSessionWikiHabileFilter.java:131)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processChain(LdapProcessor.java:326)
      	at com.airfrance.habile.filter.engine.LdapProcessor.dispatchForward(LdapProcessor.java:286)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processAction(LdapProcessor.java:242)
      	at com.airfrance.habile.filter.engine.LdapProcessor.processAction(LdapProcessor.java:222)
      	at com.airfrance.habile.filter.engine.LdapProcessor.process(LdapProcessor.java:203)
      	at com.airfrance.habile.filter.HabileFilter.doFilter(HabileFilter.java:207)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      	at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
      	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:210)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      	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:151)
      	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
      	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
      	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
      	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
      	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      	at java.lang.Thread.run(Thread.java:595)
      

      I don't know exactly what is the problem... maybe history is to big ? the wiki page have no attachment...
      I don't want increase the MySQL 'max_allowed_packet' variable because in my opinion 33553408 is enought.

      Julien

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jurevert Julien Revert
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Date of First Response: