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

XWiki still fails to start on Oracle Database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Blocker
    • None
    • 11.3-rc-1
    • None
    • Windows 10 Pro 64 bit, Edge 18, using a local instance of XWiki 11.3.2, 11.5RC1, 11.6 RC1 on Oracle 12c
    • Unknown

    Description

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

      2019-07-30 14:06:25,995 [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.base/java.lang.Thread.run(Thread.java:834)
      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
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
      	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
      	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
      	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
      	at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:1626)
      	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1613)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:282)
      	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233)
      	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233)
      	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:233)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:519)
      	... 24 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-01754: o tabelă poate să conţină numai o coloană de tip LONG

      Please find attached the full log from XWiki 11.3.2 (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.5RC1 or 11.6RC1.

      Attachments

        Issue Links

          Activity

            People

              tmortagne Thomas Mortagne
              iandriuta Ilie Andriuta
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: