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

Upgrade from 1.1RC1 to 1.2RC1 eventually fails if documents have lots of objects OR lots of history

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2 RC1
    • Fix Version/s: 1.2 RC2
    • Component/s: Storage
    • Labels:
      None
    • Environment:
      Tomcat 6 (have tried with 5, same result with more pronounced issues)
      JDK 5&6 tried
      MySQL 4.1
      Windows 2003 with all current patches applied
    • keywords:
      1.2rc1 upgrade,upgrade failure,large document upgrade failure
    • Similar issues:

      Description

      Logging the issue so that it can be tracked and resolved.

      On upgrading from a working 1.1RC1 xwiki installation, the conversion process begins and can be monitored in the log files.
      For all but one of our xwiki databases, all worked relatively ok (120mins a bit long, but doable).
      The main xwiki database (our "master for all the virtual wiki's, and co-incidentally our largest database) does not finish, and crashes our. While it was running, it was observed that several documents take over 90minutes each; these documents are unique in that they have 350+ history revisions, and a large collection of objects. We can't remove them either as they're in-process project documents. The main xwiki database has clocked in at over 28 hours without completing.

      Below is a sample set of the errors we have been receiving:
      ------------------------------
      16:11:26,511 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] INFO bernate.R4359XWIKI1459Migrator - Updating document [Main.AlcatelDCS&GSMRX&TX]...
      17:38:26,478 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08S01
      17:38:26,478 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] ERROR util.JDBCExceptionReporter - Communications link failure due to underlying exception:

        • BEGIN NESTED EXCEPTION **

      java.io.EOFException

      STACKTRACE:

      java.io.EOFException
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1956)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2368)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2867)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:983)
      at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:305)
      at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
      at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:460)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:84)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:531)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:523)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:519)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore$1.doInHibernate(XWikiHibernateVersioningStore.java:145)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive(XWikiHibernateVersioningStore.java:135)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHibernate(R4359XWIKI1459Migrator.java:105)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)

        • END NESTED EXCEPTION **

      Last packet sent to the server was 406 ms ago.
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] ERROR util.JDBCExceptionReporter - Borrow prepareStatement from pool failed
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] ERROR .AbstractFlushingEventListener - Could not synchronize database state with session
      org.hibernate.exception.GenericJDBCException: could not insert: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo]
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2078)
      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:701)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:675)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)
      Caused by: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
      at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93)
      at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
      at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
      at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
      at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:93)
      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)
      ... 47 more
      Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

        • BEGIN NESTED EXCEPTION **

      com.mysql.jdbc.CommunicationsException
      MESSAGE: Communications link failure due to underlying exception:

        • BEGIN NESTED EXCEPTION **

      java.io.EOFException

      STACKTRACE:

      java.io.EOFException
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1956)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2368)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2867)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:983)
      at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:305)
      at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
      at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:460)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:84)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:531)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:523)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:519)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore$1.doInHibernate(XWikiHibernateVersioningStore.java:145)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive(XWikiHibernateVersioningStore.java:135)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHibernate(R4359XWIKI1459Migrator.java:105)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)

        • END NESTED EXCEPTION **

      Last packet sent to the server was 406 ms ago.

      STACKTRACE:

      com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

        • BEGIN NESTED EXCEPTION **

      java.io.EOFException

      STACKTRACE:

      java.io.EOFException
      at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1956)
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2368)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2867)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:983)
      at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:305)
      at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
      at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:460)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:84)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:531)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:523)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:519)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore$1.doInHibernate(XWikiHibernateVersioningStore.java:145)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive(XWikiHibernateVersioningStore.java:135)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHibernate(R4359XWIKI1459Migrator.java:105)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)

        • END NESTED EXCEPTION **

      Last packet sent to the server was 406 ms ago.
      at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2579)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2867)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:983)
      at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:305)
      at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189)
      at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:460)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:84)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:531)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:523)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:519)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore$1.doInHibernate(XWikiHibernateVersioningStore.java:145)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive(XWikiHibernateVersioningStore.java:135)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHibernate(R4359XWIKI1459Migrator.java:105)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)

        • END NESTED EXCEPTION **

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
      at com.mysql.jdbc.Connection.checkClosed(Connection.java:1931)
      at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4720)
      at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4686)
      at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188)
      at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:747)
      at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87)
      ... 54 more
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] ERROR util.JDBCExceptionReporter - Already closed.
      17:38:26,541 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-1] ERROR store.XWikiHibernateBaseStore - Exeption while close transaction
      org.hibernate.exception.GenericJDBCException: Cannot release connection
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:392)
      at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:322)
      at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:261)
      at org.hibernate.impl.SessionImpl.close(SessionImpl.java:316)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.closeSession(XWikiHibernateBaseStore.java:718)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:707)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:675)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:960)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:82)
      at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R4359XWIKI1459Migrator.java:72)
      at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.migrate(AbstractXWikiHibernateMigrator.java:38)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(AbstractXWikiMigrationManager.java:231)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:214)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:143)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:708)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:659)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:426)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
      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:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Unknown Source)
      Caused by: java.sql.SQLException: Already closed.
      at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
      at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
      at com.xpn.xwiki.store.DBCPConnectionProvider.closeConnection(DBCPConnectionProvider.java:217)
      at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:388)
      ... 41 more
      17:38:26,556 [] [http-8080-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException
      17:38:27,744 http://ieg08ap02:8080/xwiki/bin/view/Main/WebHome [http-8080-4] INFO .AbstractXWikiMigrationManager - Current storage version = [4341]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sdumitriu Sergiu Dumitriu
              Reporter:
              esbach Brandon Esbach
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response: