[xwiki-notifications] [Issue] Commented: (XE-163) Upgrade from 1.1RC1 to 1.2RC1 eventually fails if documents have lots of objects OR lots of history
Brandon Esbach (JIRA)
jira at xwiki.org
Thu Dec 13 16:04:32 CET 2007
[ http://jira.xwiki.org/jira/browse/XE-163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_20146 ]
Brandon Esbach commented on XE-163:
-----------------------------------
Sergiu,
If I don't upgrade the main wiki database, and upgrade only the virtual wiki's it is hosting, will that cause any problems? And if I use the "...migration=0" will it work for new versions going forward, or will all future history also be broken? Just trying to assess the future impact, if any.
> Upgrade from 1.1RC1 to 1.2RC1 eventually fails if documents have lots of objects OR lots of history
> ---------------------------------------------------------------------------------------------------
>
> Key: XE-163
> URL: http://jira.xwiki.org/jira/browse/XE-163
> Project: XWiki Enterprise
> Issue Type: Bug
> Components: Other
> Affects Versions: 1.2 RC1
> 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
> Reporter: Brandon Esbach
>
> 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]
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the notifications
mailing list