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

Scheduled jobs do not get resolved in the default company with Database Partitioning enabled

    Details

      Description

      Description
      If database partitioning is enabled, scheduled jobs properly work only in companies that are not the default company

      Steps to Reproduce

      1. Start portal with clean DB MySQL 5.7
      2. Enable database partitioning, in portal-ext.properties set database.partition.enabled=true
      3. Restart
      4. Create a new company (assert that a new schema is created to assert DB Partitioning is still working as expected)
      5. Schedule a Web Content to be published in the future in both the Default Company as well as the newly created company (the default scheduler refresh time is 15minutes i believe, you can adjust this in instance settings for convenience)
      6. After each of the scheduled times are up, assert that both web contents created are now in the published state (they should be now visible in a site page as well)

      Expected Result
      Scheduled Web Contents will get resolved and publish in both the default and the newly created company

      Actual Result
      Scheduled Web Contents will only get resolved and published outside of the default company, but will never get resolved in the default company

      Tested on Tomcat 9.0.17 + PostgreSQL 10.6
      Portal master GIT ID: 0df14b8ed544d2c0286c4cc200703e3005e673ad strong text

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              victor.ware Victor Ware
              Reporter:
              kyle.miho Kyle Miho
              Participants of an Issue:
              Recent user:
              Brian Wulbern
              Engineering Assignee:
              Luis Ortiz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                8 weeks, 5 days ago

                  Packages

                  Version Package
                  7.4.3.25 CE GA25
                  7.4.3.29 CE GA29
                  7.4.3.30 CE GA30
                  Master