Audit log filter results in "There was an error loading data" error message

XMLWordPrintable

    • 1
    • 15

      Symptoms

      Due to a code timeout, the Audit Log page (System -> Troubleshooting and Support -> Audit Log) is not able to render requests if the processing time on server side takes more than 25 seconds. It will fail with a message stating "There was an error loading data".

      Steps to Reproduce

      You can either:

      • Generate XX million rows of audit log data (audit_log table), that would significantly increase the database processing time and reduce the page response to above 25 seconds.
      • Load into the audit_log table a couple of million rows into a database instance running on a server with few resources, the low processing capacity should provide very long response time.

      Then attempt to search for a specific string.

      Suggestion

      Create a feature making these timeouts customisable.

      Workaround

      • Customize your search, for example, narrow it down to a shorter period using the date filter;
      • Export the data outside browser using curl
        • <JIRA_URL>/rest/jira-auditing-plugin/1/view?count=1&page=1&filter=XXXXXXXX
      • Truncate the audit_log table to fewer rows;
      • Move (archive) events to another database/table so they won't increase the time of search request;
      • Increase your database server capacity to reduce processing time.

              Assignee:
              Unassigned
              Reporter:
              Alessandro Macedo
              Votes:
              13 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: