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

Too many index spans generated for a query parameter that contains large number of elements

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • No

    Description

      When a query uses an IN predicate with a query parameter, and the supplied value for the query parameter contains a large number of elements, we could generate a large number of index spans which is undesirable.

      To repro, use the attachment of b1.sql in CBSE-14733.

      With the repro we generate 110000 spans in 7.2.0 and earlier. With master due to previous fix for MB-51114 we don't generate that many spans, however the problematic code still exists.

      Attachments

        For Gerrit Dashboard: MB-57900
        # Subject Branch Project Status CR V
        194019,2 MB-57900 Proper check for max limit of number of spans when composing multiple spans master query Status: MERGED +2 +1
        194022,2 MB-57900 Proper check for max limit of number of spans when composing multiple spans neo query Status: MERGED +2 +1

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            bingjie.miao Bingjie Miao
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty