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

[CX] Index intersection query hangs when issued from Analytics workbench

    XMLWordPrintable

Details

    • Untriaged
    • Unknown
    • CX Sprint 175

    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

          For Gerrit Dashboard: MB-36791
          # Subject Branch Project Status CR V

          Activity

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              dmitry.lychagin Dmitry Lychagin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty