Activity Stream Times Out with One or more activity sources were slow to respond and are not included.

Description

Summary

Currently the Activity Stream by default will query every single issue in JIRA and then order by those results. For larger instances, the timeout of 10 seconds is not sufficient for this query and will often result in the stream timing out.

Environment

  • JIRA 5.2.9 - 5.2.0 stream

  • Mac OS X 10.7.5

  • PostgreSQL 9.1

Specs of instance verified with:

Steps to Reproduce

Load up a decent sized JIRA instance and access the activity stream.

Expected Results

The stream doesn't time out.

Actual Results

The stream times out sporadically.

Notes

This appears to be due to the Activity Stream querying for all issues from projects browsable by the current user. They are then sorted by updated date and the stream will only display 5-10 results. A suggested easy fix would be to only return issues from the past month as this would significantly reduce the amount of issues returned by the query.

We have a KB with suggested workarounds - please see JIRA Activity Stream returns One or more activity sources were slow to respond and are not included for further info.

Environment

None

Testing Notes

None

Assignee

Unassigned

Reporter

ChrisA

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Affects versions

Priority

Major
Configure