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

"Deadlock found when trying to get lock; try restarting transaction" error occurs when adding a user with Public & Private pages or turning staging on having both Public & Private pages

    Details

      Description

      A.)

      1. Start portal
      2. Go to Admin/Control Panel/Users and Organizations
      3. Add a new user and select one of the predefined templates for both Public & Private pages on the "Personal site" tab
      4. Save

      B.)

      1. Start portal
      2. Go to Admin/Site Administration/Pages
      3. Create a private & a public page
      4. Turn local staging on

      Result: The following error occurs in the log:

      14:01:05,143 ERROR [liferay/background_task-2][JDBCExceptionReporter:82] Deadlock found when trying to get lock; try restarting transaction
      

      Note The deadlock occurs only the first time after server start on my side.

      Environment:

      DB Server MySQL 5.6.27
      JDBC Driver mysql-5.1.23.jar
      Java 1.7.0_79 64-bit

      Fixed in master/7.0 as part of the changes for LPS-56692: https://github.com/liferay/liferay-portal/commit/18b0149f88589ef0028216ce1906c37d3ab82d30

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                melody.wu Melody Wu
                Reporter:
                tibor.lipusz Tibor Lipusz
                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:
                  3 years, 50 weeks, 6 days ago

                  Packages

                  Version Package
                  6.2.X EE