[xwiki-notifications] [Issue] Commented: (XWIKI-1993) Database schema update issue when migrating from XE 1.1.2 to 1.2 RC2
Daniel Guenther (JIRA)
jira at xwiki.org
Tue Jan 8 12:29:32 CET 2008
[ http://jira.xwiki.org/jira/browse/XWIKI-1993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_20674 ]
Daniel Guenther commented on XWIKI-1993:
----------------------------------------
Hi Vincent,
I had to modify xwiki.xwikistatsvisit due to following error:
[#|2008-01-08T11:10:38.766+0100|INFO|sun-ppserver9.1|javax.enterprise.system.stream.out|_ThreadID=37;_ThreadName=httpSSLWorkerThread-8230-2;|11:10:38,
763 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-2] ERROR store.XWikiHibernateBaseStore - Failed updating schema whil
e executing query "create table xwiki.xwikistatsvisit (XWV_ID number(10,0) not null, XWV_NUMBER number(10,0), XWV_NAME varchar2(255) not null, XWV_CLAS
SNAME varchar2(255) not null, XWV_IP varchar2(255) not null, XWV_USER_AGENT long not null, XWV_COOKIE long not null, XWV_UNIQUE_ID varchar2(255) not nu
ll, XWV_PAGE_VIEWS number(10,0), XWV_PAGE_SAVES number(10,0), XWV_DOWNLOADS number(10,0), XWV_START_DATE date, XWV_END_DATE date, primary key (XWV_ID))
"
java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG
create table xwiki.xwikistatsvisit
(XWV_ID number(10,0) not null
, XWV_NUMBER number(10,0)
, XWV_NAME varchar2(255) not null
, XWV_CLASSNAME varchar2(255) not null
, XWV_IP varchar2(255) not null
, XWV_USER_AGENT CLOB
, XWV_COOKIE CLOB
, XWV_UNIQUE_ID varchar2(255) not null
, XWV_PAGE_VIEWS number(10,0)
, XWV_PAGE_SAVES number(10,0)
, XWV_DOWNLOADS number(10,0)
, XWV_START_DATE date
, XWV_END_DATE date
, primary key (XWV_ID))
And XWIKI.XWIKIRCS
alter table XWIKI.XWIKIRCS modify (XWR_COMMENT NULL);
alter table XWIKI.XWIKIRCS modify (XWR_AUTHOR NULL);
After these changes I got running new RC2 instance.
Hope the these errors also fixed in 1.1.3.
Daniel
> Database schema update issue when migrating from XE 1.1.2 to 1.2 RC2
> --------------------------------------------------------------------
>
> Key: XWIKI-1993
> URL: http://jira.xwiki.org/jira/browse/XWIKI-1993
> Project: XWiki Platform
> Issue Type: Bug
> Components: Storage
> Affects Versions: 1.2 RC2
> Reporter: Martin Vanek
> Assigned To: Vincent Massol
> Fix For: 1.2 RC3, 1.1.3
>
>
> SW: OracleAS 10.1.3.2 + OracleDB 10.2.0.?
> Steps:
> 1. deploy 1.1.2 war
> 2. import enterprise 1.1.2 xar (works so far)
> 3. deploy 1.2 RC2 war
> 4. exception while accessing first page
> java.sql.SQLException: ORA-00942: table or view does not exist
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
> at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
> at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
> at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
> at org.hibernate.loader.Loader.doList(Loader.java:2145)
> at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
> at org.hibernate.loader.Loader.list(Loader.java:2024)
> at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
> at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
> at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64)
> at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
> at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
> at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
> at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
> at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
> at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
> at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
> Steps 2:
> 1. deploy 1.1.2 war
> 2. import enterprise 1.1.2 xar (works so far)
> 3. import enterprise 1.2 RC2 xar (works so far)
> 4. deploy 1.2 RC2 war
> 5. same exception while accessing first page
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the notifications
mailing list