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

XMLWordPrintable

    • 2
    • 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: