Details

    • Type: Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: 6.0.3 GA
    • Fix Version/s: 6.0.6 GA
    • Labels:
      None
    • Branch Version/s:
      5.2.x

      Description

      I want to update from Liferay 5.2.3 to Liferay 6.0.3
      For this upgrade I changed the portal-ext.properties to

      permissions.user.check.algorithm=5
      image.hook.impl=com.liferay.portal.image.DatabaseHook

      The upgrade results in an Duplicate entry error within:
      Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary

      08:35:52,169 ERROR [JDBCExceptionReporter:101] Table 'lportal6.lock_' doesn't exist
      08:35:53,092 INFO [BaseDB:393] Database does not support case sensitive queries
      08:35:53,109 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
      08:35:53,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
      08:37:59,743 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
      08:41:34,656 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
      08:41:42,203 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
      08:41:42,233 INFO [Table:371] Starting backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232
      08:41:43,329 INFO [Table:407] Finished backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232 in 1096 ms
      08:41:51,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
      08:41:55,995 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
      at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
      at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
      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:592)
      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.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
      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 '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
      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:48)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 36 more
      Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
      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:3256)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.addFileVersion(UpgradeDocumentLibrary.java:86)
      at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:133)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
      ... 39 more

        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, 16 weeks, 5 days ago

                  Packages

                  Version Package
                  6.0.6 GA