LDAP synchronisation makes too much db queries for audit events

XMLWordPrintable

    • 7.03
    • Severity 3 - Minor
    • 0

      Summary

      While synchronising with LDAP directory JIRA creates too many audit log entries.

      Environment

      • Local OpenLDAP (60k users, 50k groups)
      • Postgres db
      • JIRA 7.3.1

      Steps to Reproduce

      1. Configure LDAP directory and start synchronization.
      2. Profile it.

      Expected Results

      All the time is spent synchronising LDAP

      Actual Results

      30% of time is taken by creating entries in audit log table for each synchronised LDAP entry(users, groups, memberships).
      Each insert is done in separate transaction which takes almost half of time spent in audit log
      See screenshots from profiler.

        1. calltree2.png
          calltree2.png
          505 kB
        2. ThreadHistrory.png
          ThreadHistrory.png
          24 kB
        3. Transactions.png
          Transactions.png
          135 kB
        4. calltree1.png
          calltree1.png
          507 kB

              Assignee:
              Unassigned
              Reporter:
              Ilya Zinoviev (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: