Uploaded image for project: 'Camunda Optimize'
  1. Camunda Optimize
  2. OPT-412

Optimize issues ACT_VARINST queries without parameters

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 1.0.0
    • None
    • None
    • None

      Problem:

      On AWS, we see following query a number of times which takes a long time to complete:

      17-May-2017 13:04:40.261 WARNING [http-nio-127.0.0.1-8080-exec-9] org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport.reportFailedQuery Failed Query Report SQL=select RES.*
    from ACT_HI_VARINST RES
    order by RES.ID_ asc
    LIMIT ? OFFSET ?; time=60091 ms;

      They do not have any parameters, which results in querying the whole thing instead of process instance specific entities.

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              lipphardt Christian
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: