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

[Query TAB IN UI] UI stops responding on long running queries for some time, but eventually comes back

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • UI
    • 5.0.0-2759
    • Triaged
    • Yes

    Description

      Give a long running query with forestdb indexer storage mode.

      Example:

      SELECT tb_G2324.* FROM ( SELECT t_5.*,(SELECT min(t_1.productId) 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_2089_simple_table_1 t_5 WHERE NOT EXISTS     (SELECT * FROM  multiple_table_db_2089_simple_table_1  t_1   USE KEYS [t_5.primary_key_id] WHERE     (((t_1.int_field1 >= 4941 AND t_1.varchar_field1 NOT BETWEEN "ADdJWOgabw" and "zyIoRqXGFe" AND t_1.bool_field1 = false)) OR ((t_1.bool_field1 != true AND t_1.primary_key_id LIKE '%549%'))) AND (((NOT ((((NOT (((t_1.bool_field1 = false OR t_1.int_field1 >= 4941)) OR (t_1.decimal_field1 IS NULL))) AND (NOT (((t_1.bool_field1 = false) AND ((t_1.decimal_field1 IS NOT NULL AND ((t_1.primary_key_id  IN [  "1" , "10" , "100" , "1000" , "101"  ]) OR (t_1.primary_key_id  IN [  "1" , "10" , "100" , "1000" , "101"  ])) OR (t_1.char_field1 IS NOT NULL) AND t_1.bool_field1 = true)) OR ((NOT (t_1.bool_field1) OR t_1.primary_key_id IS NULL)) AND ((NOT (t_1.bool_field1) AND t_1.int_field1 > 4941))) AND (NOT (((t_1.int_field1 IS NULL OR t_1.primary_key_id NOT LIKE "549")) AND ((t_1.bool_field1 != false OR t_1.primary_key_id LIKE '549%')) OR ((t_1.bool_field1 = true OR t_1.varchar_field1 NOT LIKE "ZZoCkwEdTf")) AND (t_1.bool_field1 = false)))))) AND ((((t_1.bool_field1 = true OR t_1.primary_key_id IS NOT NULL)) OR ((t_1.varchar_field1 IS NOT NULL AND t_1.int_field1 > 4941))) OR (NOT (t_1.varchar_field1  IN [  "ADdJWOgabw" , "AMhtKtoSvS" , "ARbPXkhaMp" , "ARjUlGZevq" , "ARphGaTplS"  ])))) AND (((NOT (t_1.varchar_field1 NOT LIKE '%ZZoCkwEdTf') AND t_1.decimal_field1 != 4789)) AND ((t_1.bool_field1 AND t_1.decimal_field1 = 4789))))) AND (((t_1.primary_key_id <= "549" AND t_1.decimal_field1  IN [  0 , 6 , 9 , 10 , 16  ])) AND (((t_1.int_field1 < 4941) AND (t_1.decimal_field1 = 4789) AND t_1.char_field1 NOT BETWEEN "A" and "Z" AND t_1.bool_field1 = true)) OR (t_1.char_field1 < "N") AND ((t_1.char_field1 <> "N" AND t_1.decimal_field1 IS NOT NULL)))) AND (NOT (((((NOT ((t_1.int_field1  IN [  10 , 37 , 41 , 48 , 55  ]) OR (t_1.decimal_field1 = 4789)) AND t_1.varchar_field1 IS NOT NULL AND t_1.bool_field1 != true)) AND ((t_1.int_field1  IN [  10 , 37 , 41 , 48 , 55  ] AND t_1.primary_key_id  IN [  "1" , "10" , "100" , "1000" , "101"  ] AND t_1.bool_field1 != true)) OR ((NOT (t_1.decimal_field1  IN [  0 , 6 , 9 , 10 , 16  ])) AND (t_1.int_field1 < 4941)) AND (t_1.bool_field1)) AND (((t_1.bool_field1 = true OR t_1.varchar_field1  IN [  "ADdJWOgabw" , "AMhtKtoSvS" , "ARbPXkhaMp" , "ARjUlGZevq" , "ARphGaTplS"  ])) OR (((t_1.decimal_field1 > 4789 OR t_1.primary_key_id NOT BETWEEN "1" and "999")) AND ((t_1.bool_field1 OR t_1.decimal_field1 > 4789))))) OR (((t_1.int_field1 >= 4941) OR (t_1.decimal_field1 BETWEEN 0 and 9991)) OR ((NOT (t_1.bool_field1) AND t_1.int_field1 >= 4941))))))     )      ) tb_G2324 order by meta().id limit 5 ;

       

       

      Please feel free to use the cluster: 

      http://172.23.109.38:8091/

      Not able to click on monitoring tab or any other tab after running the query. Once the web page cancel/wait page appears, you can click on wait and then you are able to click on monitoring or other tabs.

      Attachments

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

        Activity

          People

            eben Eben Haber
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty