Legacy content report fails to generate due to statement timeout

XMLWordPrintable

    • 2
    • Minor

      Issue Summary

      For some spaces, the legacy content report will fail to generate a CSV. When checking the logs, errors are seen. An example: `PSQLException: ERROR: canceling statement due to statement timeout`.

       

      Notably, this exception is thrown AFTER eligibility statuses have been set, indicating a possible issue with the query used to build the report. This log is seen:

      `Completed scanning 111111 content items for space 123456789 in 0000ms`

      Steps to Reproduce

      1. Visit a space and generate a legacy content report
      2. The UI never refreshes or returns an error

      Expected Results

      A CSV is generated.

      Actual Results

      The below exception is thrown when attempting to query data for the report:

      PSQLException: ERROR: canceling statement due to statement timeout

      Workaround

      We have succeeded in using the workarounds listed in this internal document  to retrieve the report data on behalf of the customer.

              Assignee:
              Unassigned
              Reporter:
              Phuc Le
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: