[xwiki-users] Upgrade process - 1.2rc1 from 1.1RC1
Sergiu Dumitriu
sergiu at xwiki.com
Tue Dec 11 22:47:40 CET 2007
Hi,
Just tried to generate 3000 documents in a 1.1 wiki, then update.
Worked without any problems in about a minute.
The time needed to update a document is proportional to the history
length (number of versions), still, updating a document with 300
versions took only about two seconds.
My take is that somehow the indexes weren't correctly created for your
database. Try to manually add them to the xwikircs table, then restart
tomcat and see how fast the update process goes.
Sergiu
Esbach, Brandon wrote:
> Got a rejection notice, message too long. Shortened to specifics:
> 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 **
>
> _____________________________________________
> *From: * Esbach, Brandon
> *Sent: * 11 December 2007 17:57
> *To: * 'XWiki Users'
> *Subject: * Upgrade process - 1.2rc1 from 1.1RC1
>
> Hi Guys,
>
> I realise I've sent a few queries on this, just trying to keep all data
> together. Got an exception while processing one of the documents. I
> think it could be MySQL timing out though?
>
> I should point out that a clean, new install of 1.2rc1 works perfectly
> for me. Just upgrading from 1.1 seems to be a bit dodgy for some reason!
>
>
> *Error below from tomcat log*
> ------------------------***------------------------
> <<snipped>>
> ------------------------***------------------------
More information about the users
mailing list