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 Bug
    • Status: Closed
    • Priority: Minor 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)

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        1154d 18h 10m 1 Ate Douma 08/Oct/08 00:57
        Resolved Resolved Closed Closed
        1091d 21h 10m 1 Ate Douma 04/Oct/11 22:07
        Ate Douma made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Ate Douma made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Fix Version/s 2.2 [ 12312318 ]
        Hide
        Ate Douma added a comment -

        The new Jetspeed 2.2 security model no longer loads user credentials automatically.

        Show
        Ate Douma added a comment - The new Jetspeed 2.2 security model no longer loads user credentials automatically.
        Ate Douma made changes -
        Affects Version/s 2.0-M2 [ 11015 ]
        Affects Version/s 2.0-POST [ 12310617 ]
        Hide
        Ate Douma added a comment -

        Forgot to set the Fix Version to 2.0-FINAL

        Show
        Ate Douma added a comment - Forgot to set the Fix Version to 2.0-FINAL
        Ate Douma made changes -
        Assignee Ate Douma [ adouma ]
        Hide
        Ate Douma added a comment -

        I'm unassigning my last two 2.0-FINAL issues as I don't have time left to complete these.
        If someone else wants to pick these up, feel free to sign up for.

        Show
        Ate Douma added a comment - I'm unassigning my last two 2.0-FINAL issues as I don't have time left to complete these. If someone else wants to pick these up, feel free to sign up for.
        Ate Douma made changes -
        Field Original Value New Value
        Assignee Ate Douma [ adouma ]
        Teijo Lallukka created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development