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

Publication on "fake" remote live fails due to a database lock as a result of export/import running in the same transaction

    Description

    To reproduce:

    1. Restart portal bundle on an empty MySQL database
    2. Create site "staging site"
    3. Add widget type page
    4. Create a site "remote live", note the site ID
    5. Navigate back to "staging site"
    6. Setup remote staging to "remote live" site (in the same bundle, with localhost, 8080, site ID)
    7. Publish to live via simple publication

    Expected result:
    Successful publication

    Actual result:
    Publication fails with "Lock wait timeout exceeded" - stacktrace

    master 82d5f0c7

    Staging#StagingRemoteLivePolls

    PGStaging#ActivateDeactivateRemoteStaging

    Staging#StagingRemoteLiveBlogsWithWorkflow

    Staging#StagingRemoteLiveBlogsPG

    PGStaging#PublishWCViaRemoteStaging

    --------------

    Background information:

    There are customers using staging with this type of "fake" remote configuration so it should be supported.

    The origin of the problem is that export and import processes of the staging publication were moved into a single transaction as part of LPS-80781. It was a requirement of the new changeset framework (7.1 feature) in order to avoid deleting changeset entries in case the publication fails during the import phase.

    Solution is to move export and import processes back to separate transactions (it caused other problems too earlier) and solve the requirement of the changeset framework in a different way.

      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:
                1 year, 8 weeks, 4 days ago

                Packages

                Version Package
                7.1.X
                Master