Details

      Description

      Trying to upgrade from 5.2.3 to 6.0.4, and getting the following.

      07:00:49,796 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeExpando
      07:00:50,263 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.k ernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10155-0' for key 'IX_9DDD21E5'
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.m ysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10155-0' for key 'IX_9DDD21E5'
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1160)
      at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
      at javax.servlet.GenericServlet.init(GenericServlet.java:212)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
      at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
      at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
      at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
      at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
      at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
      at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
      at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
      at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
      at org.apache.catalina.core.StandardService.start(StandardService.java:519)
      at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
      at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityCons traintViolationException: Duplicate entry '10155-0' for key 'IX_9DDD21E5'
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
      at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
      at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
      at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
      at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
      at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
      at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
      ... 29 more
      Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10155-0' for key 'IX_9DDD21E5'
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
      at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.java:49)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 36 more
      Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '10155-0' for key 'IX_9DDD21E5'
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
      at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1355)
      at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1270)
      at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
      at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:225)
      at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:192)
      at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:179)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:80)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeExpando.updateValues(UpgradeExpando.java:214)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeExpando.updateRows(UpgradeExpando.java:123)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeExpando.updateColumns(UpgradeExpando.java:75)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeExpando.updateTables(UpgradeExpando.java:170)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeExpando.doUpgrade(UpgradeExpando.java:30)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 39 more
      Stopping the server due to unexpected startup errors

      http://www.liferay.com/community/forums/-/message_boards/message/5451172

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  9 years, 18 weeks, 5 days ago

                  Packages

                  Version Package
                  6.0.4 GA
                  6.0.5 GA