PUBLIC - Liferay Portal Community Edition
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-29860

Missing Indexes in indexes.sql cause upgrades from 5.x to 6.1.20 to take > 65 days

    Details

    • Branch Version/s:
      6.1.x, 6.0.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 4 results 

      Description

      While working on LPP-4193, it was mentioned that I should log an LPS ticket for the general fix.
      When working with very large databases, several SQL queries were doing a full-table-scan which was causing upgrades from 5.x to 6.1.20 to take > 65 days.

      The fix is to add several table indexes to indexes.sql

      In discussion about this, it was mentioned that this perhaps could be categorized as a bug instead of a new feature/improvement because an SQL query that takes over 65 days to complete does not seem like functioning code.

        Issue Links

          Activity

          Hide
          James Lefeu (Inactive) added a comment -

          Upon discussion with Angelo Jefferson, this code update will not go in trunk, but will go in 6.1.x after which, it will be backported to 6.1.20 for a customer.

          Show
          James Lefeu (Inactive) added a comment - Upon discussion with Angelo Jefferson, this code update will not go in trunk, but will go in 6.1.x after which, it will be backported to 6.1.20 for a customer.
          Hide
          James Lefeu (Inactive) added a comment -

          Importing code from LPP-4193 debugging (6.1.20) and testing on 6.1.x before I send out a pull request review.

          Show
          James Lefeu (Inactive) added a comment - Importing code from LPP-4193 debugging (6.1.20) and testing on 6.1.x before I send out a pull request review.
          Hide
          Michael Saechang added a comment -

          Committed on:
          Portal 6.2.x GIT ID: 1af31e6c386615cd2c4fdf3587f8debf195d5232.

          Show
          Michael Saechang added a comment - Committed on: Portal 6.2.x GIT ID: 1af31e6c386615cd2c4fdf3587f8debf195d5232.
          Hide
          Ginson Ren added a comment -

          Close this ticket since we passed LPS-31099.

          Show
          Ginson Ren added a comment - Close this ticket since we passed LPS-31099.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 17 weeks, 5 days ago

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 weeks, 7 hours
                2w 7h

                  Development

                    Structure Helper Panel