-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 8.20.9, 9.4.14, 9.4.18, 9.12.10, 10.3.9, 10.3.19
-
Component/s: Dashboard & Gadgets
-
8.2
-
10
-
Severity 2 - Major
-
10
Issue Summary
This is reproducible on Data Center: (yes)
Steps to Reproduce
- Install Jira Data Center v9.12.10 with an internal directory and one LDAP having 10k users and several groups.
- Login to Jira using a user from Ldap and load the dashboard.
- 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"
Workaround
Potential workarounds:
- Resolve the duplicate user accounts https://support.atlassian.com/jira/kb/health-check-duplicate-user-accounts-jira-server-and-data-center/ If there are a lot of duplicate users, fixing this should be help to address the issue.
- We also propose to scope the Activity Stream gadgets to a specific project or filter (instead of All projects)
