Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-25183

DB Upgrade - Oracle - Throws Exceptions in the console and server stops due to unexpected startup errors - 5.2.3, 6.0.6 to 6.1.x, 6.2.x

    Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.1.1 CE GA2, 6.1.10 EE GA1, 6.2.0 CE M2
    • Labels:
      None
    • Environment:
      Tomcat 7.0.25 + Oracle 10. 6.1.x GIT ID: 203ce24ed59140e2765f3328a626c17a99305d79.
      Tomcat 7.0.25 + Oracle 10. 6.2.x GIT ID: 3c4f4b709e9e7e2f090c87327a1131d576e677c5.

      Description

      **This is an Oracle-specific issue and does NOT occur for upgrades from 6.0.12 to 6.1.x or 6.2.x.

      The upgrade from 5.2.3 or 6.0.6 to 6.1.x and 6.2.x fails. There are exceptions in the console and the server shuts down due to startup errors. I have attached the full console output for both errors.

      This issue PASSED on:

      • Tomcat 7.0.23 + Oracle 10. 6.2.x Revision: 97949.

      This issue FAILED on:

      • Tomcat 7.0.23 + Oracle 10. 6.2.x Revision: 97950.

      Steps to reproduce:

      1. Start up Liferay 6.1.x or 6.2.x referencing a 5.2.3 or 6.0.6 oracle database. Be sure to include all the necessary legacy properties.
        • When upgrading from 5.2.3 to 6.1.x or 6.2.x, there will be an "invalid modification of columns" error.
          22:55:29,968 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns
          
          com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns
          
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
                  at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
                  at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
                  at javax.servlet.GenericServlet.init(GenericServlet.java:160)
                  at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
                  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
                  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
                  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
                  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
                  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
                  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
                  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
                  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
                  at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
                  at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
                  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
                  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
                  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
                  at java.lang.Thread.run(Thread.java:662)
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns
          
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
                  at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
                  at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
                  at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
                  at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
                  ... 20 more
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns
          
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
                  at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:64)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
                  ... 27 more
          Caused by: java.sql.SQLException: ORA-22859: invalid modification of columns
          
                  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
                  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
                  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
                  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
                  at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:222)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117)
                  at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileVersions(UpgradeDocumentLibrary.java:292)
                  at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:88)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
                  ... 30 more
          Stopping the server due to unexpected startup errors
        • When upgrading from 6.0.6 to 6.1.x or 6.2.x, there will be an "invalid alteration of datatype" error.
          00:28:32,855 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype
          
          com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype
          
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
                  at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267)
                  at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
                  at javax.servlet.GenericServlet.init(GenericServlet.java:160)
                  at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
                  at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
                  at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
                  at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
                  at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
                  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
                  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
                  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
                  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
                  at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
                  at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
                  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
                  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
                  at java.util.concurrent.FutureTask.run(FutureTask.java:138)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
                  at java.lang.Thread.run(Thread.java:662)
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype
          
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
                  at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
                  at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81)
                  at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
                  at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
                  at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
                  at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
                  ... 20 more
          Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype
          
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
                  at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:64)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
                  ... 27 more
          Caused by: java.sql.SQLException: ORA-22858: invalid alteration of datatype
          
                  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
                  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
                  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
                  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
                  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
                  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
                  at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
                  at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
                  at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:222)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242)
                  at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117)
                  at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileVersions(UpgradeDocumentLibrary.java:292)
                  at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:88)
                  at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
                  ... 30 more
          Stopping the server due to unexpected startup errors

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.chiu Brian Chiu (Inactive)
              Reporter:
              brian.chiu Brian Chiu (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 26 weeks, 6 days ago

                  Packages

                  Version Package
                  6.1.1 CE GA2
                  6.1.20 EE GA2
                  6.2.0 CE M2