Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-4107

Opening a Folio times out due to query constraints

XMLWordPrintable

    • 3
    • Severity 2 - Major
    • No

      Issue Summary

      In cases where a Folio contains a large number of work items, the RPM_GET_FOLIO_INFO_FOR_STORY and RPM_GET_FOLIO_INFO_FOR_FEATURE stored procedures are timing out because they're querying a large data set. The sproc does not have any filters in the where clause, which causes the whole table to be returned.

      Steps to Reproduce

      1. Use an instance with a large dataset of features and stories
      2. Create and attempt to open a Folio that has all toggles enabled
      3. Await the timeout Whoops error

      Expected Results

      The Folio opens to all work items in the selected Folio

      Actual Results

      The database is queried for the entire table, causing a timeout if there are too many items to index and return.

      Workaround

      Smaller number of work items will not be impacted by this.
      No workaround available for tables with large number of work items

            9ca9aa5ad14e Sam Tsubota
            120524bf6ade Jose Sanchez
            Votes:
            9 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved: