Uploaded image for project: '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

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  4 years, 31 weeks, 3 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