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

XWiki fails to start on Oracle Database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 11.5-rc-1, 11.3.2
    • 11.3-rc-1
    • Event Stream
    • Windows 10 Pro 64 bit, Chrome 74, IE11, Edge 18, Firefox 67, using a local instance of XWiki 11.3RC1, 11.3, 11.3.1, 11.4, 10.11.8 on Oracle 12c
    • Unknown
    • N/A

    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

          is related to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-15215 XWiki 10.3 fails to start on MySQL with utf8mb4 encoding

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16495 Cannot create subwikis on Oracle: ORA-00942: table or view does not exist

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16528 Errors when running XWiki on Oracle, subwikis still cannot be created: ORA-00942: table or view does not exist

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16624 XWiki still fails to start on Oracle Database

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-16327 Cannot create subwiki with Oracle database: ORA-01950: no privileges on tablespace 'USERS'

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: