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

[JIRAALIGN-1636] Query timeout (again) when attempting to search the Administration -> Changes page

    XMLWordPrintable

Details

    • 1
    • Severity 2 - Major
    • Batman! - TART6

    Description

      Issue Summary

      This issue was reportedly 'fixed' via this bug report, but, customers are still running into it:

      https://jira.atlassian.com/browse/JIRAALIGN-1281

      In this case, the customer is only using a 7-day date range (which is the smallest data set that can be retrieved) and they are still encountering the timeout

      Steps to Reproduce

      1. Log in to Jira Align as a Super Admin
      2. Click Administration in the left navigation menu
      3. Under "Logs" click Changes
      4. Click inside the search box and enter a search term, select "7 days" for the date range.
      5. Press Enter to initiate the search

      Expected Results

      Search results should be returned

      Actual Results

      The search times out and the customer receives a 504 gateway timeout error.

      The following is seen in the backend logs:

      6/15/20
      9:28:38.590 AM	
      { [-]
         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: wTFyfUEIHJG9COh0fAVCw5PinUe9R4EZ1/+WbQXnZlk=
         customer_db: XXXX
         error_description: Query timeout expired
         error_id: 23358
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: EXEC RPM_GET_AUDIT_LIST 10, 1,' AND CONVERT(date, AuditTimeStamp) >= ''6/8/2020'' AND CONVERT(date, AuditTimeStamp) <= ''6/15/2020''', 'AuditTimeStamp DESC'
         timestamp: 2020-06-15T10:28:38.590000-04:00
         url: https://XXXXX.agilecraft.com:443/MasterLogs.asp?FirstTime=True
         urlverb: GET
         user: 8234
         version: 10.72.0.5646
      }
      

      Workaround

      Currently there is no known workaround for this behavior.

      Attachments

        Issue Links

          Activity

            People

              kpatel@atlassian.com Kishen Patel (Inactive)
              kbaxley Kent Baxley
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync