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

XWiki sequence errors at startup on postgresql and oracle

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 8.4.4
    • Fix Version/s: None
    • Component/s: Old Core
    • Labels:
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      This is what I get:

      [...]
      xwiki-postgres-tomcat-web | 28-Feb-2017 17:08:34.711 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 32830 ms
      xwiki-postgres-db | ERROR:  relation "xwikidbversion" does not exist at character 45
      xwiki-postgres-db | STATEMENT:  select this_.XWV_VERSION as XWV1_26_0_ from xwikidbversion this_
      xwiki-postgres-db | ERROR:  relation "xwikidoc" does not exist at character 29
      xwiki-postgres-db | STATEMENT:  select count(*) as y0_ from xwikidoc this_
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:38,227 [XWiki initialization] INFO  .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 
      
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:40,293 [XWiki initialization] INFO  .HibernateDataMigrationManager - Storage schema updates and data migrations are enabled 
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:40,731 [XWiki initialization] INFO  .HibernateDataMigrationManager - No data migration to apply for wiki [xwiki] currently in version [73000] 
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:40,731 [XWiki initialization] INFO  .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 
      xwiki-postgres-db | ERROR:  relation "hibernate_sequence" already exists
      xwiki-postgres-db | STATEMENT:  create sequence public.hibernate_sequence
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:45,630 [solr/indexer job group daemon thread - org.xwiki.search.solr.internal.job.IndexerJob@359ab352] INFO  o.x.s.s.i.j.IndexerJob         - Starting job of type [solr.indexer] with identifier [[solr, indexer]] 
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:46,014 [solr/indexer job group daemon thread - org.xwiki.search.solr.internal.job.IndexerJob@359ab352] INFO  o.x.s.s.i.j.IndexerJob         - 0 documents added, 0 deleted and 0 updated during the synchronization of the Solr index. 
      xwiki-postgres-tomcat-web | 2017-02-28 17:14:46,014 [solr/indexer job group daemon thread - org.xwiki.search.solr.internal.job.IndexerJob@359ab352] INFO  o.x.s.s.i.j.IndexerJob         - Finished job of type [solr.indexer] with identifier [[solr, indexer]] 
      [...]
      

      The error is only at startup. I believe it's the db update script that's causing the issue somehow. The rest of XWiki works fine.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vmassol Vincent Massol
                Reporter:
                vmassol Vincent Massol
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: