Re: [xwiki-users] Error while parsing velocity page

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?

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 users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users