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

Scheduled Web Content does not work with transaction isolation serializable

Details

    Description

      In general DefaultActionableDynamicQuery doesn't work if called inside a transaction and setting Propagation.REQUIRES_NEW.

       

      Steps to reproduce

      1. Add the following properties to the portal-ext.properties file
            transaction.isolation.portal=8
        
      1. Go to System Settings -> Web Content -> Virtual Instance Scope, Web Content and change the Check Interval to 2
      2. Go to Content & Data -> Web Content and create a new Basic Web Content
      3. Schedule the Display Date for the web content to be 2 minutes in the future
      4. Publish the web content and then wait

       

      Expected Results:

      The Web Content publishes and the status switches to "Approved" after a short while.

       

      Actual Results:

      The Web Content never publishes and remains as "Scheduled" and the following errors appear in the logs

          2021-10-08 16:02:49.821 ERROR [liferay/scheduler_dispatch-2][JDBCExceptionReporter:234] Lock wait timeout exceeded; try restarting transaction
          2021-10-08 16:03:40.835 ERROR [liferay/scheduler_dispatch-2][JDBCExceptionReporter:234] Lock wait timeout exceeded; try restarting transaction
          2021-10-08 16:03:40.842 ERROR [liferay/scheduler_dispatch-2][ParallelDestination:59] Unable to process message {destinationName=liferay/scheduler_dispatch, response=null, responseDestinationName=null, responseId=null, payload=null, values={GROUP_NAME=com.liferay.journal.web.internal.messaging.CheckArticleMessageListener, companyId=20097, groupId=0, DESTINATION_NAME=liferay/scheduler_dispatch, EXCEPTIONS_MAX_SIZE=0, [email protected], STORAGE_TYPE=MEMORY_CLUSTERED, JOB_NAME=com.liferay.journal.web.internal.messaging.CheckArticleMessageListener}}
          com.liferay.portal.kernel.messaging.MessageListenerException: com.liferay.portal.kernel.exception.SystemException: org.hibernate.exception.LockAcquisitionException: could not update: [com.liferay.journal.model.impl.JournalArticleImpl#37083]

       

      Attachments

        Issue Links

          Activity

            People

              support-lep@liferay.com SE Support
              mariano.alvaro Mariano Álvaro
              Kiyoshi Lee Kiyoshi Lee
              Mariano Álvaro Mariano Álvaro
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                41 weeks, 1 day ago

                Packages

                  Version Package