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

Maximum open cursors exceeded during Organization upgrade

Details

    Description

      Upgrading from 6.2 to 7.1, if there are too many Organizations with logo exists under 6.2, the 7.1 upgrade process fails with ORA-01000: maximum open cursors exceeded error, if Oracle DB is used.
      This might affect other DB vendors as well, but due to time constraints, I was unable to test it.

      We suspect that the cause of this issue lies in UpgradeOrganization.java, where multiple prepared statements remain unclosed.

      As the code for this process is unchanged on master, I did not perform any additional tests with branch bundles.

      Reproduction steps:

      1. Start Liferay Portal 6.2
      2. Run attached CreateOrganization.groovy script after modifying the image path to point to an existing image file to your
      3. Stop the Portal then run the 7.1 upgrade process

      Attachments

        Activity

          People

            jeremy.chen Jeremy Chen
            norbert.kocsis Norbert Kocsis (Inactive)
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              3 years, 26 weeks, 1 day ago

              Packages

                Version Package
                7.0.0 DXP FP82
                7.0.10.12 DXP SP12
                7.0.X
                7.1.3 CE GA4
                7.1.10 DXP FP11
                7.1.X
                Master