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

            • Assignee:
              jeremy.chen Jeremy Chen
              Reporter:
              norbert.kocsis Norbert Kocsis
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                15 weeks, 4 days ago

                Packages

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