Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-24216

[Query Monitoring RQG] Slow running subqueries not shown in active_requests

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.0.0
    • 5.0.0
    • query
    • 5.0.0-2759
    • Untriaged
    • No

    Description

      Test which shows the bug:

      ./testrunner -i rqg.ini -p gsi_type=forestdb -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/multiple_table_db/query_test_using_templates/query_10000_subqueries.txt.zip,password=password,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,use_mysql=True,replicas=0,nodes_init=1,total_queries=2000,password=password,subquery=True

      rqg.ini:
      [global]
      port:8091
      username:root
      password:couchbase
      index_port:9102
      [servers]
      1:SERVER_1
      [SERVER_1]
      ip:172.23.109.38
      services=n1ql,kv,index
      [membase]
      rest_username:Administrator
      rest_password:password
      [tuq_client]
      goroot:/root/n1ql/go
      sherlock_path=/opt/couchbase/bin
      Please feel free to use this cluster.
      What the test does?
      1.creates primary index.
      2.Runs long running subqueries with different combination of datatypes (subqueries created after subquery enhancement feature)
      3.Compares results with same query run against mysql.

      After the test runs 100 queries, run this query through UI or through cbq:

      SELECT tb_G615.* FROM (SELECT tb_N615.* FROM (SELECT tb_W615.* FROM (SELECT tb_H615.* FROM ( SELECT t_5.*,(SELECT sum(t_1.qty) FROM  t_5.simple_table_2 t_1   WHERE  t_1.primary_key_id=t_5.primary_key_id    GROUP BY  t_1.price   ORDER BY  t_1.price limit 1) ABC FROM multiple_table_db_1780_simple_table_1 t_5 WHERE EXISTS     (SELECT * FROM  t_5.simple_table_2  t_2   WHERE       t_2.qty < 5113     )      ) tb_H615) tb_W615) tb_N615) tb_G615 order by meta().id limit 5;
      

      This query takes more than 15 mins to complete, but does not show up in active requests.
      Adding a screenshot of active requests at the time when above query is running.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            marco.greco Marco Greco (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty