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

[CX] Index intersection query hangs when issued with timings profile

    XMLWordPrintable

Details

    • Untriaged
    • Unknown
    • CX Sprint 176, CX Sprint 177, CX Sprint 178, CX Sprint 179, CX Sprint 180, CX Sprint 181, CX Sprint 182, CX Sprint 183, CX Sprint 184, CX Sprint 185, CX Sprint 186, CX Sprint 187, CX Sprint 188, CX Sprint 189, CX Sprint 190, CX Sprint 191, CX Sprint 192, CX Sprint 193, CX Sprint 194, CX Sprint 195, CX Sprint 196, CX Sprint 197, CX Sprint 198, CX Sprint 213, CX Sprint 214, CX Sprint 215, CX Sprint 216, CX Sprint 217, CX Sprint 218, CX Sprint 219, CX Sprint 220, CX Sprint 221, CX Sprint 222, CX Sprint 223, CX Sprint 224, CX Sprint 225, CX Sprint 226, CX Sprint 227, CX Sprint 228, CX Sprint 229, CX Sprint 230, CX Sprint 231, CX Sprint 232, CX Sprint 233, CX Sprint 234, CX Sprint 235, CX Sprint 249, CX Sprint 250, CX Sprint 251, CX Sprint 252, CX Sprint 253, CX Sprint 254, CX Sprint 255, CX Sprint 256, CX Sprint 257, CX Sprint 258, CX Sprint 259, CX Sprint 260, CX Sprint 261, CX Sprint 262, CX Sprint 263, CX Sprint 264, CX Sprint 277, CX Sprint 278, CX Sprint 279, CX Sprint 280, CX Sprint 281, CX Sprint 282, CX Sprint 283, CX Sprint 284, CX Sprint 285, CX Sprint 286, Analytics Sprint 5, Analytics Sprint 6, Analytics Sprint 7, Analytics Sprint 8, Analytics Sprint 9, Analytics Sprint 10, Analytics CBO Sprint 11, Analytics CBO Sprint 12, Analytics CBO Sprint 13, Analytics CBO Sprint 14

    Description

      This issue was discovered while verifying fix for MB-32662. 

      Steps to reproduce are copied from there:
      1. 1 node cluster having kv & analytics service
      2. Install travel-sample bucket
      3. create dataset ts1 on `travel-sample`
      4. create index idx4 on ts1(callsign:string);
      5. create index idx5 on ts1(`type`:string);
      6. connect link Local;
      7. select callsign,`type` from ts1 where callsign="MILE-AIR" and `type`="airline";

      The query needs to be issued from the Analytics workbench. The workbench requests operator profiling ("profile":"timings" option in the request) which makes this query hang. Without operator profiling the query runs fine (cbq or curl).

      Attachments

        Issue Links

          Clones

          Bug - A problem which impairs or prevents the functions of the product. MB-36791 [CX] Index intersection query hangs when issued from Analytics workbench

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              ian.maxon Ian Maxon
              murtadha.hubail Murtadha Hubail
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty