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

            [OPT-412] Optimize issues ACT_VARINST queries without parameters

            Askar added a comment -

            there are still error in staging log 

            ### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricVariableInstance.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByQueryCriteria_postgres-Inline
### The error occurred while setting parameters
### SQL: select RES.*                      from ACT_HI_VARINST RES                               order by RES.ID_ asc     LIMIT ? OFFSET ?
### Cause: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request

            Askar added a comment - there are still error in staging log ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricVariableInstance.xml ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByQueryCriteria_postgres-Inline ### The error occurred while setting parameters ### SQL: select RES.* from ACT_HI_VARINST RES order by RES.ID_ asc LIMIT ? OFFSET ? ### Cause: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request

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

                Created:
                Updated:
                Resolved: