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

[CX] Unresponsive Analytics service when using secondary indexes with numeric fields

    XMLWordPrintable

    Details

    • Triage:
      Untriaged
    • Story Points:
      1
    • Is this a Regression?:
      Unknown
    • Sprint:
      CX Sprint 214, CX Sprint 221

      Description

      When creating a secondary index with composite fields, and one or more of these fields have a numeric type (int, double), there is a chance that the Analytics will run into repeated ingestion failure when the following happens:
      A document is updated such that the indexed numeric field value changes between a real value and null/missing.
      As a workaround, make sure the indexed numeric fields always have values (i.e. not null or missing), or drop any composite fields indexes that have numeric fields.

        Attachments

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.0.0-3545 contains cbas-core commit 70e4676 with commit message:
            MB-40727, MB-41133: Allow active job recovery to start on REBALANCE_REQUIRED

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-3545 contains cbas-core commit 70e4676 with commit message: MB-40727 , MB-41133 : Allow active job recovery to start on REBALANCE_REQUIRED
            Hide
            umang.agrawal Umang added a comment -

            Verified with build 6.6.1-9147.

            Following scenarios were verified - 

            1. Upgrade from 6.6.0 to 6.6.1 with composite index.
            2. Upgrade from 6.6.0 to 6.6.1 with non-composite index.
            3. Upgrade from 6.6.0 to 6.6.1 with no index.

            All upgrades performed were offline upgrades.

             

            Show
            umang.agrawal Umang added a comment - Verified with build 6.6.1-9147. Following scenarios were verified -  Upgrade from 6.6.0 to 6.6.1 with composite index. Upgrade from 6.6.0 to 6.6.1 with non-composite index. Upgrade from 6.6.0 to 6.6.1 with no index. All upgrades performed were offline upgrades.  
            Hide
            till Till Westmann added a comment - - edited

            Description for release notes (Fixed Issue):

            Summary: After upgrading to 6.6.1 a rebalance might be required to repair composite secondary indexes that contain NULL or MISSING.

            Show
            till Till Westmann added a comment - - edited Description for release notes (Fixed Issue): Summary: After upgrading to 6.6.1 a rebalance might be required to repair composite secondary indexes that contain NULL or MISSING.
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.2-9599 contains cbas-core commit 70e4676 with commit message:
            MB-40727, MB-41133: Allow active job recovery to start on REBALANCE_REQUIRED

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9599 contains cbas-core commit 70e4676 with commit message: MB-40727 , MB-41133 : Allow active job recovery to start on REBALANCE_REQUIRED
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.2-9599 contains cbas-core commit f672435 with commit message:
            MB-40727: Fix upserting into secondary indexes

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9599 contains cbas-core commit f672435 with commit message: MB-40727 : Fix upserting into secondary indexes

              People

              Assignee:
              umang.agrawal Umang
              Reporter:
              murtadha.hubail Murtadha Hubail
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty