Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-1994

Lot of init erros with PostgreSQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • None
    • 1.2 RC2
    • Storage
    • None
    • PostgreSQL 8.2.5, Ubuntu linux 7.10

    Description

      "updateSchema" generate lots of exceptions in the log with PostgreSQL database engine the first time a page is loaded. Here all generated log when loading the first page after starting xwiki:

      13:57:42,436 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Current storage version = [0]
      13:57:42,437 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - List of migrations that will be executed:
      13:57:42,438 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - R4340XWIKI883 - See http://jira.xwiki.org/jira/browse/XWIKI-883
      13:57:42,438 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - R4359XWIKI1459 - See http://jira.xwiki.org/jira/browse/XWIKI-1459
      13:57:42,438 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - R6079XWIKI1878 - See http://jira.xwiki.org/jira/browse/XWIKI-1878
      13:57:42,438 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - R6405XWIKI1933 - See http://jira.xwiki.org/jira/browse/XWIKI-1933
      13:57:42,438 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - R6430XWIKI1954 - See http://jira.xwiki.org/jira/browse/XWIKI-1954
      13:57:42,439 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Running migration [R4340XWIKI883] with version [4340]
      13:57:42,661 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - New storage version is now [4341]
      13:57:42,661 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Running migration [R4359XWIKI1459] with version [4359]
      13:57:42,708 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - New storage version is now [4360]
      13:57:42,708 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Running migration [R6079XWIKI1878] with version [6079]
      13:57:42,715 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - New storage version is now [6080]
      13:57:42,715 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Running migration [R6405XWIKI1933] with version [6405]
      13:57:42,719 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - New storage version is now [6406]
      13:57:42,720 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - Running migration [R6430XWIKI1954] with version [6430]
      13:57:42,723 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] INFO .AbstractXWikiMigrationManager - New storage version is now [6431]
      13:57:44,912 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query "create sequence PUBLIC.hibernate_sequence"
      org.postgresql.util.PSQLException: ERREUR: la relation « hibernate_sequence » existe déjà
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
      at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:415)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:271)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:475)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:931)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:964)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadAllRCSNodeInfo(XWikiHibernateVersioningStore.java:208)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive(XWikiHibernateVersioningStore.java:125)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArchive(XWikiHibernateVersioningStore.java:110)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:197)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:335)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)
      13:57:44,924 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] WARN util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
      13:57:44,924 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] ERROR util.JDBCExceptionReporter - ERREUR: La transaction courante est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction
      com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.CalendarEvent
      Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.CalendarEvent
      Wrapped Exception: Error number 3212 in 3: Exception while loading archive -237 561 194
      Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not execute query
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:414)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)

      Wrapped Exception:

      com.xpn.xwiki.XWikiException: Error number 3211 in 3: Exception while updating archive XWiki.CalendarEvent
      Wrapped Exception: Error number 3212 in 3: Exception while loading archive -237 561 194
      Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not execute query
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:203)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:335)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)

      Wrapped Exception:

      com.xpn.xwiki.XWikiException: Error number 3212 in 3: Exception while loading archive -237 561 194
      Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not execute query
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive(XWikiHibernateVersioningStore.java:129)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArchive(XWikiHibernateVersioningStore.java:110)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:197)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:335)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)

      Wrapped Exception:

      com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      Wrapped Exception: could not execute query
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:939)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:964)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadAllRCSNodeInfo(XWikiHibernateVersioningStore.java:208)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive(XWikiHibernateVersioningStore.java:125)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArchive(XWikiHibernateVersioningStore.java:110)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:197)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:335)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)

      Wrapped Exception:

      org.postgresql.util.PSQLException: ERREUR: La transaction courante est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      at org.hibernate.loader.Loader.doQuery(Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2145)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      at org.hibernate.loader.Loader.list(Loader.java:2024)
      at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
      at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore$3.doInHibernate(XWikiHibernateVersioningStore.java:213)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:935)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:964)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadAllRCSNodeInfo(XWikiHibernateVersioningStore.java:208)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive(XWikiHibernateVersioningStore.java:125)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArchive(XWikiHibernateVersioningStore.java:110)
      at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:197)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:335)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass(CalendarPlugin.java:82)
      at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init(CalendarPlugin.java:294)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:130)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:69)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)
      13:57:49,076 http://127.0.0.1:8180/xwiki/bin/view/WikiManager/CreateNewWiki [http-8180-Processor24] ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query "create sequence PUBLIC.hibernate_sequence"
      org.postgresql.util.PSQLException: ERREUR: la relation « hibernate_sequence » existe déjà
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:283)
      at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:415)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:271)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:475)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:931)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:964)
      at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.getAllDeletedDocuments(XWikiHibernateRecycleBinStore.java:99)
      at com.xpn.xwiki.XWiki.getDeletedDocuments(XWiki.java:1139)
      at com.xpn.xwiki.api.XWiki.getDeletedDocuments(XWiki.java:131)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)
      at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245)
      at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
      at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:419)
      at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:73)
      at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:125)
      at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
      at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238)
      at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152)
      at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
      at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1327)
      at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:607)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)
      at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245)
      at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
      at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294)
      at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
      at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194)
      at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170)
      at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
      at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
      at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107)
      at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
      at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238)
      at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152)
      at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
      at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1327)
      at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:105)
      at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:48)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:155)
      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:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      at java.lang.Thread.run(Thread.java:619)

      Attachments

        Activity

          People

            tmortagne Thomas Mortagne
            tmortagne Thomas Mortagne
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: