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

XWiki still fails to start on Oracle Database

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 11.3-rc-1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Edge 18, using a local instance of XWiki 11.3.2, 11.5RC1, 11.6 RC1 on Oracle 12c
    • Difficulty:
      Unknown
    • Similar issues:

      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

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

                Dates

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