Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: Blocker
Fix Version/s: 11.5-rc-1, 11.3.2
Affects Version/s: 11.3-rc-1
Component/s: Event Stream
Labels:
Environment:
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

Difficulty:
Unknown
Documentation:
N/A
Documentation in Release Notes:
https://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/11.3.1/ https://www.xwiki.org/xwiki/bin/view/ReleaseNotes/Data/XWiki/11.4/
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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

2019_06_10.output Oracle.log
10/Jun/19 12:32
1.14 MB
Ilie Andriuta
2019_06_13_XWiki_11_5_Oracle_12c.log
13/Jun/19 13:34
198 kB
Ilie Andriuta
Subwiki_creation_11_5_Oracle_12c.jpg
13/Jun/19 13:40
307 kB
Ilie Andriuta

Issue Links

is related to

XWIKI-15215 XWiki 10.3 fails to start on MySQL with utf8mb4 encoding

Closed

relates to

XWIKI-16495 Cannot create subwikis on Oracle: ORA-00942: table or view does not exist

Closed

XWIKI-16528 Errors when running XWiki on Oracle, subwikis still cannot be created: ORA-00942: table or view does not exist

Closed

XWIKI-16624 XWiki still fails to start on Oracle Database

Closed

XWIKI-16327 Cannot create subwiki with Oracle database: ORA-01950: no privileges on tablespace 'USERS'

Closed

Activity

People

Assignee:: Thomas Mortagne

Reporter:: Ilie Andriuta

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 10/Jun/19 12:36

Updated:: 18/Sep/19 14:53

Resolved:: 17/Jun/19 15:14

Date of First Response:: 10/Jun/19 5:13 PM