[xwiki-users] Upgrade process - 1.2rc1 from 1.1RC1
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:142 8) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapsh ot(AbstractEntityPersister.java:983) at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(Stat efulPersistenceContext.java:305) at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189) at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abstrac tSaveEventListener.java:460) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUp date(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(XWikiH ibernateVersioningStore.java:145) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseSt ore.java:918) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateB aseStore.java:960) at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive(XW ikiHibernateVersioningStore.java:135) at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInHib ernate(R4359XWIKI1459Migrator.java:105) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseSt ore.java:918) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateB aseStore.java:960) at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R 4359XWIKI1459Migrator.java:82) at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator.migrate(R 4359XWIKI1459Migrator.java:72) at com.xpn.xwiki.store.migration.hibernate.AbstractXWikiHibernateMigrator.m igrate(AbstractXWikiHibernateMigrator.java:38) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.migrate(Abst ractXWikiMigrationManager.java:231) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrati ons(AbstractXWikiMigrationManager.java:214) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrati onsForDatabase(AbstractXWikiMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrati ons(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(RequestPr ocessor.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(Applica tionFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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:2 63) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4) 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>> ------------------------***------------------------
Brandon Esbach Software Engineer Wireless Systems Segment Tyco Electronics 4 Eastgate Road Eastgate Little Island Co. Cork Ireland Tel: +353-21-4808305 Email: [email protected]
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>> ------------------------***------------------------
Hi Sergiu, Can do, are there any directions for that? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: 11 December 2007 21:48 To: XWiki Users Subject: Re: [xwiki-users] Upgrade process - 1.2rc1 from 1.1RC1 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.jav a:1293)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:142 8)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg atingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg atingPreparedStatement.java:92)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnap shot(AbstractEntityPersister.java:983)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(St atefulPersistenceContext.java:305)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189) at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abstr actSaveEventListener.java:460)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOr Update(DefaultSaveOrUpdateEventListener.java:84)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdat e(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(XWik iHibernateVersioningStore.java:145)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase Store.java:918)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernat eBaseStore.java:960)
at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive( XWikiHibernateVersioningStore.java:135)
at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInH ibernate(R4359XWIKI1459Migrator.java:105)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase Store.java:918)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernat eBaseStore.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(Ab stractXWikiMigrationManager.java:231)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tions(AbstractXWikiMigrationManager.java:214)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tionsForDatabase(AbstractXWikiMigrationManager.java:143)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tions(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(Request Processor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav a: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(Appli cationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi lterChain.java:206)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnco dingFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli cationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi lterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa lve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa lve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja va:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja va:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv e.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2 63)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84 4)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proces s(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>> ------------------------***------------------------
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
More for the xwiki team I guess, 1 day in update mode (browser in "loading" mode, tomcat+MySQL screaming away in the background) and counting for my main wiki. Documents inside the wiki have a varied status of: -> Multiple attachments -> Multiple revisions. Often 300+ -> Multiple objects per document (older legacy special class documents easily hit 30/40 objects). Which I guess affects it somewhat :o The virtual wiki's managed to update fairly quickly in comparison ( about 120mins ). If there is a faster way to do the update process, I would appreciate it greatly as I have to repeat the process on my test environment, and potentially again if there are many issues raised with the main classes. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Esbach, Brandon Sent: 12 December 2007 09:03 To: XWiki Users Subject: Re: [xwiki-users] Upgrade process - 1.2rc1 from 1.1RC1 Hi Sergiu, Can do, are there any directions for that? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergiu Dumitriu Sent: 11 December 2007 21:48 To: XWiki Users Subject: Re: [xwiki-users] Upgrade process - 1.2rc1 from 1.1RC1 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.jav a:1293)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:142 8)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg atingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg atingPreparedStatement.java:92)
at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnap shot(AbstractEntityPersister.java:983)
at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(St atefulPersistenceContext.java:305)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:189) at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(Abstr actSaveEventListener.java:460)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOr Update(DefaultSaveOrUpdateEventListener.java:84)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdat e(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(XWik iHibernateVersioningStore.java:145)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase Store.java:918)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernat eBaseStore.java:960)
at com.xpn.xwiki.store.XWikiHibernateVersioningStore.saveXWikiDocArchive( XWikiHibernateVersioningStore.java:135)
at com.xpn.xwiki.store.migration.hibernate.R4359XWIKI1459Migrator$1.doInH ibernate(R4359XWIKI1459Migrator.java:105)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase Store.java:918)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernat eBaseStore.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(Ab stractXWikiMigrationManager.java:231)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tions(AbstractXWikiMigrationManager.java:214)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tionsForDatabase(AbstractXWikiMigrationManager.java:143)
at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigra tions(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(Request Processor.java:431)
at
participants (2)
-
Esbach, Brandon -
Sergiu Dumitriu