Re: [xwiki-users] Problems with installation on Tomcat6 & MySQL

Hi! I'm trying to install XWiki Enterprise 2.3.1 on Tomcat 6.0.20 with MySQL 5.0.32 (installing as WAR). I've deployed WAR, set up the database but when I connect to XWiki I get the following exception trace: (sorry if the message is big, but I'd better post the full trace) ------------------------ com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiGroupTemplate Wrapped Exception: Failed to commit or rollback transaction. Root cause []        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:369)        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:430)        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)        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.web.ActionFilter.doFilter(ActionFilter.java:129)        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:152)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)        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.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304)        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.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:293)        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)        at java.lang.Thread.run(Thread.java:619) Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document xwiki:XWiki.XWikiGroupTemplate Wrapped Exception: Failed to commit or rollback transaction. Root cause []        at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:643)        at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:182)        at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175)        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1358)        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1320)        at com.xpn.xwiki.XWiki.getGroupClass(XWiki.java:3239)        at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:824)        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:792)        at com.xpn.xwiki.XWiki.<init>(XWiki.java:713)        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:350)        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:430)        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)        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.web.ActionFilter.doFilter(ActionFilter.java:129)        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:152)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)        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.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304)        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.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:293)        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)        at java.lang.Thread.run(Thread.java:619) Wrapped Exception: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)        at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:853)        at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:824)        at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:633)        at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:182)        at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175)        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1358)        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1320)        at com.xpn.xwiki.XWiki.getGroupClass(XWiki.java:3239)        at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:824)        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:792)        at com.xpn.xwiki.XWiki.<init>(XWiki.java:713)        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:350)        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:430)        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135)        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.web.ActionFilter.doFilter(ActionFilter.java:129)        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:152)        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)        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.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:304)        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.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:293)        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)        at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xD0\xA1\xD0\xBE\xD0\xB7...' for column 'XWR_COMMENT' at row 1

       at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1443)        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)        at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)        ... 62 more --------------------- So, is there a known compatibility issue? P.S.: I've tried MySQL connectors 3.0.17, 5.0.2, 5.1.8, 5.1.9 (the last three I've downloaded directly from maven repository http://repo1.maven.org/maven2/mysql/mysql-connector-java/ as it was suggested somewhere in the MySQL troubleshooting section of xwiki.org). The last one does not produce an exception, but seems to "hang" Tomcat. It consumes 100% CPU and when I stop the server I see a lot of OutOfMemory exceptions in logs. _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users