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

Query Tab in UI:Incorrect behavior seen when a long running index join query is executed on beer-sample

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • 4.6.0
    • tools
    •  4.6.0-3453
    • Untriaged
    • Unknown

    Description

      I have seen this hang/incorrect behavior before also, but could not reproduce it consistenty before.

      1. Load beer-sample
      2. create primary index on beer-sample.
      3. CREATE INDEX `bid` ON `beer-sample`(`brewery_id`)
      4. Execute following query:
      SELECT b1 from `beer-sample` b1
      LEFT OUTER JOIN `beer-sample` b2 ON KEY b2.brewery_id FOR b1
      INNER JOIN `beer-sample` b3 ON KEYS b2.brewery_id
      LEFT OUTER JOIN `beer-sample` b4 ON KEYS b3.brewery_id
      LEFT OUTER JOIN `beer-sample` b5 ON KEY b5.brewery_id FOR b4;
      5. Results are displayed correctly, but after that UI just hangs, click next or previous gives result as "processing".

      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:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty