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
- duplicates
-
XWIKI-16593 activitystream_events table is not created on Oracle
- Closed
- is related to
-
XWIKI-16470 XWiki fails to start on Oracle Database
- Closed
-
XWIKI-15215 XWiki 10.3 fails to start on MySQL with utf8mb4 encoding
- Closed