Uploaded image for project: 'Jetspeed 2'
  1. Jetspeed 2
  2. JS2-324

Missing index from db(oracle) causes userManagement portlets stop working when lots of users in system

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.2.0
    • Component/s: None
    • Labels:
      None
    • Environment:
      Linux

      Description

      I bulk loaded 500 users to jetspeed and noticed that management portlets(add user, add user to group and so on) don't work any more.
      I found out that queries to db are slow and creation of one index is good workaround. I haven't tested latest version that will it be fixed there.

      Workaround: create index SECURITY_CREDENTIAL_PRINID_IDX on SECURITY_CREDENTIAL (PRINCIPAL_ID)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lallutei Teijo Lallukka
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: