[xwiki-notifications] [Issue] Commented: (XE-172) Cannot upgrade to from 1.1.2 to 1.2 RC2
Daniel Guenther (JIRA)
jira at xwiki.org
Tue Jan 8 09:43:32 CET 2008
[ http://jira.xwiki.org/jira/browse/XE-172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_20657 ]
Daniel Guenther commented on XE-172:
------------------------------------
Hello,
I got the same error. Neither it is possible to upgrade an 1.1.2 to 1.2 RC2 nor it is possible to set up a new 1.2 RC2 repository in a empty database schema. But there is another error message in the log file just before the ORA-00942 - table not found. It might be help.
SW: Solaris 10 + SUN JAVA AS 9.1 + Oracle 10.2.0.3
[#|2008-01-07T18:50:44.640+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|18:50:44,625 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] ERROR store.XWikiHibernateBaseStore - Failed creating schema update script
java.lang.ArrayIndexOutOfBoundsException: 2
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.isTable(DatabaseMetadata.java:147)
at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:935)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.getSchemaUpdateScript(XWikiHibernateBaseStore.java:361)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:249)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
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)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:270)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:339)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:261)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:212)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
I played a little bit with the log4.properties and set the log level for hibernate to debug and got the following output in the logfile while upgrading:
[#|2008-01-07T13:58:19.979+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|13:58:19,
979 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] INFO hbm2ddl.DatabaseMetadata - table not found: xwikistats
referer
|#]
[#|2008-01-07T13:58:19.985+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|13:58:19,
985 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] INFO hbm2ddl.DatabaseMetadata - table not found: xwikistats
visit
|#]
[#|2008-01-07T13:58:19.989+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|13:58:19,
989 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] INFO hbm2ddl.DatabaseMetadata - table not found: xwikistringclasses
|#]
[#|2008-01-07T13:58:19.997+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|13:58:19,
996 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] INFO hbm2ddl.DatabaseMetadata - table not found: xwikistrings
|#]
[#|2008-01-07T13:58:20.012+0100|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=17;_ThreadName=httpSSLWorkerThread-8230-0;|13:58:20,
012 [http://deapview:8230/xwiki/bin/view/Main/WebHome] [httpSSLWorkerThread-8230-0] INFO hbm2ddl.DatabaseMetadata - table not found: xwiki.hibernate_sequence
It seems there is a explicit sc hema reference for the hibernate_sequence.
Daniel
> Cannot upgrade to from 1.1.2 to 1.2 RC2
> ---------------------------------------
>
> Key: XE-172
> URL: http://jira.xwiki.org/jira/browse/XE-172
> Project: XWiki Enterprise
> Issue Type: Bug
> Components: Other
> Affects Versions: 1.2 RC1
> Reporter: Martin Vanek
>
> 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