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

Upgrade race condition for Form entries on 7.1

    Details

      Description

      Steps to Reproduce:

      1. Import attached database from 7.0.10.7 with a form and entry
      2. Upgrade to 7.1/master
      3. Repeat steps 1-2 as needed.

      Expected Result:
      No error on upgrade. User can access form entry records from 7.0

      Actual Result:
      Sometimes there is an error on upgrade. And sometimes the upgrade for the records fails and form entries are gone on starting the portal after upgrade.

      upgrade:check
      There is an upgrade process available for com.liferay.dynamic.data.lists.service from 1.2.0-step-2 to 1.2.1
      
      2018-06-07 21:43:51.679 INFO  [main][UpgradeProcess:86] Upgrading com.liferay.dynamic.data.lists.internal.upgrade.v1_2_0.UpgradeDDLRecordVersion
      INFO - Upgrading com.liferay.dynamic.data.lists.internal.upgrade.v1_2_0.UpgradeDDLRecordVersion
      2018-06-07 21:43:51.683 INFO  [main][UpgradeProcess:103] Failed upgrade process com.liferay.dynamic.data.lists.internal.upgrade.v1_2_0.UpgradeDDLRecordVersion in 4ms
      INFO - Failed upgrade process com.liferay.dynamic.data.lists.internal.upgrade.v1_2_0.UpgradeDDLRecordVersion in 4ms
      2018-06-07 21:43:51.692 ERROR [main][com_liferay_portal_upgrade_impl:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '31450' at line 1
      

      Manual 7.0 data setup steps:

      1. Add a new form
      2. Add a text field
      3. Publish form
      4. Go to Publication URL
      5. Submit an entry

      Reproduced on:
      Master f2628c52b46cf1b8c1a969a7852f6a1945e8664b
      with
      Master-private: df6a08d807714d5bf9b5f6aef64629869c6e75f9

        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, 20 weeks, 6 days ago

                  Packages

                  Version Package
                  7.1.X
                  Master