Activity Stream Gadget Not Editable and Loading Slowly on Dashboard

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: Low
    • None
    • Affects Version/s: 10.3.19
    • Component/s: Dashboard & Gadgets
    • None
    • 10.03
    • 1
    • Severity 2 - Major
    • 0

      Issue Summary

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Install Jira Data Center v10.3.19 with an internal directory and one LDAP having 10k users and several groups.
      2. Login to Jira using a user from Ldap and load the dashboard.
      3. Observe the activity stream

      Expected Results

      • The Activity Stream gadget should load promptly.
      • The gadget should be editable once loaded.
      • Clicking on "Filter" should allow for editing and customisation of the gadget settings.

      Actual Results

      • The Activity Stream gadget takes a long time to load.
      • Once loaded, the gadget is highlighted in grey and is not editable.
      • Clicking on "Filter" removes the grey highlight but does not make the gadget editable.

      Observed multiple select queries getting executed while loading the dashboard in atlassian-jira-sql.log. Make sure to enable the SQL debug logs to check below mentioned logs:

      grep -i "StreamsCompletionService::thread" ./atlassian-jira-sql.log* | grep admin | sort |  grep cwd_user 
2024-08-29 13:11:28,341+0000 StreamsCompletionService::thread-2 admin    1ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:28,591+0000 StreamsCompletionService::thread-2 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:43,642+0000 StreamsCompletionService::thread-5 admin    7ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:43,814+0000 StreamsCompletionService::thread-5 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:43,824+0000 StreamsCompletionService::thread-5 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:43,827+0000 StreamsCompletionService::thread-5 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:44,696+0000 StreamsCompletionService::thread-6 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:44,988+0000 StreamsCompletionService::thread-7 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:11:45,077+0000 StreamsCompletionService::thread-7 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:03,052+0000 StreamsCompletionService::thread-8 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:03,054+0000 StreamsCompletionService::thread-8 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:03,239+0000 StreamsCompletionService::thread-8 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:03,240+0000 StreamsCompletionService::thread-8 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,557+0000 StreamsCompletionService::thread-11 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,558+0000 StreamsCompletionService::thread-11 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,563+0000 StreamsCompletionService::thread-11 admin    1ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,564+0000 StreamsCompletionService::thread-11 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,565+0000 StreamsCompletionService::thread-11 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,568+0000 StreamsCompletionService::thread-11 admin    1ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,577+0000 StreamsCompletionService::thread-11 admin    1ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,578+0000 StreamsCompletionService::thread-11 admin    1ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,653+0000 StreamsCompletionService::thread-12 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,655+0000 StreamsCompletionService::thread-12 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,947+0000 StreamsCompletionService::thread-13 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:12,948+0000 StreamsCompletionService::thread-13 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"
2024-08-29 13:13:13,034+0000 StreamsCompletionService::thread-13 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '10000' ) ORDER BY lower_user_name"
2024-08-29 13:13:13,036+0000 StreamsCompletionService::thread-13 admin    0ms "SELECT user_name FROM public.cwd_user WHERE (lower_user_name =  'admin' ) AND (directory_id =  '1' ) ORDER BY lower_user_name"

      appuser@instenv-715692-djd9-78dc4bbbbf-t9hzl:/data/Jira_jiraeu-preprod-euc1-02_ip-10-79-40-12-eu-central-1-compute-internal_support_2026-04-29-11-12-41_2026-04-29T11:13:33.066Z/application-logs$ grep -i 'StreamsCompletionService::thread-26' atlassian-jira-sql.log | grep -i -c 'Select' 
36331

      Workaround

      Currently, there is no known workaround for this behaviour. A workaround will be added here when available

              Assignee:
              Unassigned
              Reporter:
              Vedika Tambolkar
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: