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

Occasional unique constraint violation error on IX_DD635956 stemming probably from cluster scheduler

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 6.1.20 EE GA2
    • Fix Version/s: 6.1.20 EE GA2
    • Labels:
    • Environment:
      Liferay Version: 6.1 GA 2
      Operating System: Red Hat
      Application Server: Tomcat 7.0.x
      Java Virtual Machine: Java 6
      Database: SQL Server 2008

      Description

      Customer receives the following error message and Tomcat needs to be killed:

      ERROR [JDBCExceptionReporter:75] Cannot insert duplicate key row in object 'dbo.Lock_' with unique index 'IX_DD635956'. The duplicate key value is (com.liferay.portal.kernel.scheduler.SchedulerEngine, com.liferay.portal.kernel.scheduler.SchedulerEngine,
      

      The error surfaces in multi-node cluster environment when restarting the second server (usually once in about 3-5 restarts).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                laszlo.csontos Laszlo Csontos (Inactive)
                Reporter:
                laszlo.csontos Laszlo Csontos (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  7 years, 2 weeks, 2 days ago

                  Packages

                  Version Package
                  6.1.20 EE GA2