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

N1QL generated from Eventing is not using proper indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.5.1
    • 6.0.3, 6.5.0
    • eventing
    • Untriaged
    • Release Note
    • No

    Description

      Jon Strabala reports:
       
      I simplified the handler and wrote a 12 page report to highlights the issue (see: TESTV2.zip)I was testing with a build that failed Enterprise Edition 6.5.1 build 6192 (Feb 22 build) - and there are a lot of builds that fail as per my list below:We need to file a MB on this and also a release note for 6.03 GA and also 6.5 GA as it can lead to degenerate performance.
       
      WORKS SELECTS PROPER INDEX SELECTION EVENTING PERFORMS LIKE QUERY WORKBENCH AND JAVA SDK
      Enterprise Edition 6.0.0 build 1693 (Oct 11 2018 build) - I think this is GA 6.0.0
      Enterprise Edition 6.0.1 build 2037 (Jan 21 2019 build) - I think this is GA 6.0.1
      Enterprise Edition 6.0.2 build 2413 (Jun 12 2019 build) - I think this is GA 6.0.2
       
      WRONG BAD PERFORMANCE EVENTING HAS WRONG INDEX SELECTION
      Enterprise Edition 6.0.3 build 2895 (Oct 09 2019 build) - I think this is GA 6.0.3
       
      WORKS (AGAIN) SELECTS PROPER INDEX SELECTION EVENTING PERFORMS LIKE QUERY WORKBENCH AND JAVA SDK
      Enterprise Edition 6.0.4 build 3082 (Feb 13 Build) - I think this is GA 6.0.4
       
      WRONG (AGAIN) BAD PERFORMANCE EVENTING HAS WRONG INDEX SELECTION
      Enterprise Edition 6.5.0 build 4960 (Jan 13 Build) - I think this is GA 6.5
      Enterprise Edition 6.5.1 build 6120 (Feb 04 build)
      Enterprise Edition 6.5.1 build 6154 (Feb 11 build)
      Enterprise Edition 6.5.1 build 6168 (Feb 14 build)
      Enterprise Edition 6.5.1 build 6186 (Feb 20 build)
      Enterprise Edition 6.5.1 build 6191 (Feb 21 build)
      Enterprise Edition 6.5.1 build 6192 (Feb 22 build)
      Enterprise Edition 6.5.1 build 6193 (Feb 22 build)
       
      WORKS (AGAIN) SELECTS PROPER INDEX SELECTION EVENTING PERFORMS LIKE QUERY WORKBENCH AND JAVA SDK
      Enterprise Edition 6.5.1 build 6194 (Feb 24 build)
      *
      *
      Enterprise Edition 6.5.1 build 6218 (Feb 28 build)
      Enterprise Edition 6.5.1 build 6221 (Mar 02 build)
       
      Note: if you run my Eventing code "basic_index_path_issue.json" on versions 6.0.X (before 6.5) you must set var "ITER_CLOSE = false" as 6.0.X dose note support .close() on an iterable handle
       

      Attachments

        Issue Links

          backports to

          Bug - A problem which impairs or prevents the functions of the product. MB-38146 Backport MB-38145: N1QL generated form Eventing is not using proper indexes

          • Major - Major loss of function.
          • Resolved
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MB-37633 child process exited with status 137 with n1ql handler

          • 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

              amarantha.kulkarni Amarantha Kulkarni (Inactive)
              siri Sriram Melkote (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty