[
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
_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications
