> IMO reimporting the database is not a good idea especially when you > upgrade from a version where the database structure was not exactly > the same. > > The safer way is generally to export the old wiki in a xar and then to > import it in the new one. Or you start the new wiki the first time > with the database already populated with the old one and it will > upgrade it automatically but doing it after is wrong for sure, it > means you are working with the old database and the new wiki think it > already upgraded it.
Now that it's been done, is there any advice for fixing it? I'd be very grateful for any suggestions. Thanks, Cristina On Mar 26, 2009, at 1:42 AM, Thomas Mortagne wrote: > Hi Cristina, > > On Tue, Mar 24, 2009 at 21:23, Cristina Williams <[email protected]> > wrote: >> Hello again, >> >> Here's my info: Xwiki Enterprise 1.7.2 with multiple spaces. I just >> migrated this wiki from another organization that was using version >> 1.4.2 (in case that makes a difference in my question). Environment: >> centos 5.2/apache 2.2/tomcat 6/mysql 5.1 >> >> Yesterday, we encountered errors on various pages (though not all) >> like the following: >> >> Error number 4001 in 4: Error while parsing velocity page /templates/ >> xwikivars.vm Wrapped Exception: Failed to evaluate content with id [/ >> templates/xwikivars.vm] Error >> number 4001 in 4: Error while parsing velocity page /templates/ >> htmlheader.vm Wrapped Exception: Failed to evaluate content with id >> [/ >> templates/htmlheader.vm] >> >> >> All the errors had some mention in the stack trace of trying to do an >> operation on the database after it's been disconnected. So we changed >> the JDBC url specified in the xwiki hibernate config file (/usr/ >> local/ >> tomcat/webapps/xwiki/WEB-INF/hibernate.cfg.xml) to add the >> "autoReconnect=true" attribute and restarted Tomcat. That did away >> with the errors and we thought it was fixed. >> >> Well it happened again today. Looks like xwiki is getting into some >> state in which things start failing, after being up for some period >> of >> time or getting some number of user requests or something. But we are >> having severe personnel issues - so don't have anyone who knows much >> about tomcat to help us debug. If anyone else has come across this it >> would be a big help. >> >> One possible thing I can think of - since it mentioned velocity >> templates - when i migrated the wiki, i installed the default XAR - >> then I imported the mysql dump - could this have overwritten the new >> templates? If so, is re-importing the default XAR advisable on a live >> wiki? > > IMO reimporting the database is not a good idea especially when you > upgrade from a version where the database structure was not exactly > the same. > > The safer way is generally to export the old wiki in a xar and then to > import it in the new one. Or you start the new wiki the first time > with the database already populated with the old one and it will > upgrade it automatically but doing it after is wrong for sure, it > means you are working with the old database and the new wiki think it > already upgraded it. > >> >> Thanks for any help, >> Cristina >> >> The following is a paste of the first error encountered (very long): >> >> Error number 4001 in 4: Error while parsing velocity page /templates/ >> menuview.vm Wrapped Exception: Failed to evaluate content with id [/ >> templates/menuview.vm] >> A problem occured while trying to service your request. Please >> contact >> the support if this happens again. >> Detailed information: >> Error number 3202 in 3: Exception while reading document >> BIRN-OTF-Public. NDAR-Autism-Modeling-Meetings-Minutes >> Wrapped Exception: could not load an entity: >> [com.xpn.xwiki.doc.XWikiDocument#-763803479] >> com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while >> reading document BIRN-OTF-Public. NDAR-Autism-Modeli >> Wrapped Exception: could not load an entity: >> [com.xpn.xwiki.doc.XWikiDocument#-763803479] >> at >> com >> .xpn >> .xwiki >> .store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java: >> 744) >> at >> com >> .xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java: >> 209) >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1335) >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1375) >> at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:4554) >> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:190) >> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) >> 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:617) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 290) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .wysiwyg >> .server.filter.ConversionFilter.doFilter(ConversionFilter.java: >> 145) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .web >> .SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java: >> 287) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .web >> .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: >> 112) >> 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: >> 191) >> at >> org >> .apache >> .catalina >> .authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) >> 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: >> 286) >> at >> org >> .apache.coyote.http11.Http11Processor.process(Http11Processor.java: >> 845) >> at org.apache.coyote.http11.Http11Protocol >> $Http11ConnectionHandler.process(Http11Protocol.java:583) >> at org.apache.tomcat.util.net.JIoEndpoint >> $Worker.run(JIoEndpoint.java: >> 447) >> at java.lang.Thread.run(Unknown Source) >> Wrapped Exception: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: >> No operations allowed after connection closed.Connect >> ** BEGIN NESTED EXCEPTION ** >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException >> MESSAGE: The last packet successfully received from the server >> was86399 milliseconds ago.The last packet sent successfully >> STACKTRACE: >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last >> packet successfully received from the server was86399 mil >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown >> Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at >> com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java: >> 1074) >> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3270) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1932) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) >> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) >> at >> com >> .mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: >> 1761) >> at >> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: >> 1912) >> at >> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: >> 186) >> at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) >> at org.hibernate.loader.Loader.doQuery(Loader.java:674) >> at >> org >> .hibernate >> .loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: >> 236) >> at org.hibernate.loader.Loader.doList(Loader.java:2213) >> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) >> at org.hibernate.loader.Loader.list(Loader.java:2099) >> at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) >> at >> org >> .hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: >> 338) >> at >> org >> .hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java: >> 172) >> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) >> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) >> at >> com >> .xpn >> .xwiki >> .store >> .XWikiHibernateStore >> .searchDocumentsNamesInternal(XWikiHibernateStore.java:2262) >> at >> com >> .xpn >> .xwiki >> .store >> .XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java: >> 2016) >> at >> com >> .xpn >> .xwiki >> .store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java: >> 439) >> at >> com >> .xpn >> .xwiki >> .plugin >> .watchlist >> .WatchListPlugin.globalSearchDocuments(WatchListPlugin.java: >> 603) >> at >> com >> .xpn >> .xwiki >> .plugin >> .watchlist >> .WatchListJob.retrieveNotificationSubscribers(WatchListJob.java:341) >> at >> com >> .xpn.xwiki.plugin.watchlist.WatchListJob.execute(WatchListJob.java: >> 152) >> at org.quartz.core.JobRunShell.run(JobRunShell.java:202) >> at org.quartz.simpl.SimpleThreadPool >> $WorkerThread.run(SimpleThreadPool.java:529) >> Caused by: java.net.SocketException: Broken pipe >> at java.net.SocketOutputStream.socketWrite0(Native Method) >> at java.net.SocketOutputStream.socketWrite(Unknown Source) >> at java.net.SocketOutputStream.write(Unknown Source) >> at java.io.BufferedOutputStream.flushBuffer(Unknown Source) >> at java.io.BufferedOutputStream.flush(Unknown Source) >> at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3251) >> ... 25 more >> ** END NESTED EXCEPTION ** >> at sun.reflect.GeneratedConstructorAccessor197.newInstance(Unknown >> Source) >> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown >> Source) >> at java.lang.reflect.Constructor.newInstance(Unknown Source) >> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) >> at com.mysql.jdbc.Util.getInstance(Util.java:381) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) >> at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java: >> 1115) >> at >> com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java: >> 4111) >> at >> com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java: >> 4077) >> at >> org >> .hibernate >> .jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) >> at >> org >> .hibernate >> .jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) >> at >> org >> .hibernate >> .jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) >> at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java: >> 1547) >> at org.hibernate.loader.Loader.doQuery(Loader.java:673) >> at >> org >> .hibernate >> .loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: >> 236) >> at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) >> at >> org >> .hibernate >> .loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java: >> 48) >> at >> org >> .hibernate >> .loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java: >> 42) >> at >> org >> .hibernate >> .persister >> .entity.AbstractEntityPersister.load(AbstractEntityPersister.java: >> 3049) >> at >> org >> .hibernate >> .event >> .def >> .DefaultLoadEventListener >> .loadFromDatasource(DefaultLoadEventListener.java:399) >> at >> org >> .hibernate >> .event >> .def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java: >> 375) >> at >> org >> .hibernate >> .event >> .def.DefaultLoadEventListener.load(DefaultLoadEventListener.java: >> 139) >> at >> org >> .hibernate >> .event >> .def >> .DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java: >> 195) >> at >> org >> .hibernate >> .event >> .def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java: >> 103) >> at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) >> at org.hibernate.impl.SessionImpl.load(SessionImpl.java:784) >> at >> com >> .xpn >> .xwiki >> .store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java: >> 631) >> at >> com >> .xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java: >> 209) >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1335) >> at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1375) >> at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:4554) >> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:190) >> at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) >> 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:617) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 290) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .wysiwyg >> .server.filter.ConversionFilter.doFilter(ConversionFilter.java: >> 145) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .web >> .SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java: >> 287) >> at >> org >> .apache >> .catalina >> .core >> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> org >> .apache >> .catalina >> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> com >> .xpn >> .xwiki >> .web >> .SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java: >> 112) >> 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: >> 191) >> at >> org >> .apache >> .catalina >> .authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) >> 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: >> 286) >> at >> org >> .apache.coyote.http11.Http11Processor.process(Http11Processor.java: >> 845) >> at org.apache.coyote.http11.Http11Protocol >> $Http11ConnectionHandler.process(Http11Protocol.java:583) >> at org.apache.tomcat.util.net.JIoEndpoint >> $Worker.run(JIoEndpoint.java: >> 447) >> at java.lang.Thread.run(Unknown Source) >> >> _______________________________________________ >> users mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/users >> > > > > -- > Thomas Mortagne > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
