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

XWiki fails to start on Oracle Database

    Details

    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Similar issues:

      Description

      When configured with ORACLE DB (11.2 or 12c), XWiki fails to initialize. Partial stacktrace from the console:

       2019-06-10 11:58:59,928 [XWiki initialization] ERROR .HibernateDataMigrationManager - The empty database xwiki seems to be not writable, please check your configuration! 
      com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:179)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:139)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:912)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1980)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2042)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1383)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1350)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1255)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1192)
      	at com.xpn.xwiki.XWiki.<init>(XWiki.java:1165)
      	at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: org.hibernate.HibernateException: Failed updating schema while executing query [create table xwiki.activitystream_events (ase_eventid varchar2(48 char) not null, ase_requestid varchar2(48 char), ase_stream varchar2(255 char), ase_date timestamp, ase_priority number(10,0), ase_type varchar2(255 char), ase_application varchar2(255 char), ase_user varchar2(255 char), ase_wiki varchar2(255 char), ase_space varchar2(255 char), ase_page varchar2(255 char), ase_hidden number(1,0), ase_url long, ase_title long, ase_body long, ase_version varchar2(30 char), ase_param1 long, ase_param2 long, ase_param3 long, ase_param4 long, ase_param5 long, primary key (ase_eventid))]
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:523)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:304)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:194)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:175)
      	... 21 common frames omitted
      Caused by: java.sql.SQLSyntaxErrorException: ORA-01754: o tabelă poate să conţină numai o coloană de tip LONG
      

      Please find attached the full log from XWiki 11.3.1 (the English translation for ORA-01754 is: a table may contain only one column of type LONG).

      Was used ojdbc8.jar connector.

      The issue could not be reproduced on XWiki 11.2 or 10.11.8.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                iandriuta Ilie Andriuta
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: