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. Transactions.png
          135 kB
          Ilya Zinoviev
        2. ThreadHistrory.png
          24 kB
          Ilya Zinoviev
        3. calltree2.png
          505 kB
          Ilya Zinoviev
        4. calltree1.png
          507 kB
          Ilya Zinoviev

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

                Created:
                Updated:
                Resolved: