We notice the following query taking longer time around 2hrs to finish
SELECT JIRAISSUE.ID FROM JIRAISSUE JIRAISSUE INNER JOIN JIRAACTION ACTION ON JIRAISSUE.ID = ACTION.ISSUEID WHERE (JIRAISSUE.PROJECT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (ACTION.AUTHOR IN (?)) ORDER BY ACTION.CREATED DESC
Want to understand when this query will be invoked in JIRA, is there any specific gadgets or JIRA app invoking this query.
Please provide your thoughts
It looks like one of your users has created a search for "all issues with comments in a long list of projects". You should ask them to stop
Thanks looks like the "Assigned to me" gadget on the users dashboard is triggering this query
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I get this query from several users in the organization to pin point one particular user and when i checked one of their dashboard, theya re pulling reports on a particular project.
does any jira internal code make this call?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, that's why we're looking at users - the internals won't do this, but the users can.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nic,
I was checking the user dashboards and they are specific to a project does any gadget you are aware of internally make this call.
does "assigned to me" gadget make this call?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is possible based upon the query which looks like find reporter (which could be yourself) in these projects.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.