11 Dec
2007
11 Dec
'07
7:01 p.m.
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: esbachb(a)tycoelectronics.com
11 Dec
11 Dec
10:47 p.m.
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>>
------------------------***------------------------
12 Dec
12 Dec
10:02 a.m.
Hi Sergiu,
Can do, are there any directions for that?
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
6:58 p.m.
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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] 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
6176
days inactive
6177
days old
3 comments
2 participants
participants (2)
-
Esbach, Brandon -
Sergiu Dumitriu