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

Sync gateway fails to start with multiple couchbase servers on 6.0.0-1643

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Test Blocker
    • Resolution: Fixed
    • 6.0.0
    • 6.0.0
    • query
    • None
    • Yes

    Description

      Sync Gateway version

      SG version - 2.1.0-121

      Couchbase server

      CBS - 6.0.0-1643

      Operating system

      Centos for CBS and Sync gateway

      Sync gateway Config file

       

      {{ "interface":":4984",
      "adminInterface": "0.0.0.0:4985",
      "maxIncomingConnections": 0,
      "maxCouchbaseConnections": 16,
      "maxFileDescriptors": 90000,
      "slowServerCallWarningThreshold": 500,
      "compressResponses": false,

      "logging": {"debug":

      {"enabled": true}

      },
      "databases":{
      "db":

      { "import_docs": "continuous", "enable_shared_bucket_access": true, "num_index_replicas": 0, "server":"http://192.168.33.10,192.168.33.11,192.168.33.12:8091", "bucket":"data-bucket", "username":"data-bucket", "password": "password" }

      }
      }}}

      Sync gateway Log output

      https://gist.github.com/sridevi-15/f64ac3ba064e887188938478142f7265

      Steps to reproduce

      1. Set up 3 couchbase servers in the CBS cluster.
      2. Start sync-gateway with above config by providing 3 cbs urls on the config

      Expected behavior

      It should start successfully

      Actual behavior

      Sync gateway failed to start

      Note : It passed with previous version 5.5.2-3733 and also 6.0.0-1592. It passed in DI mode(sg accel) with CBS 6.0.0-1643.
      It passed with use views in CC mode with CBS 6.0.0-1643

      It failed only with GSI

      Attachments

        1. cbs1.zip
          4.10 MB
        2. cbs2.zip
          2.69 MB
        3. cbs3.zip
          2.67 MB
        4. index-logs.txt
          7 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          verified on 6.0.0-1658 and 6.5.0-1343. Test has passed now on both the builds

          sridevi.saragadam Sridevi Saragadam (Inactive) added a comment - verified on 6.0.0-1658 and 6.5.0-1343. Test has passed now on both the builds
          lynn.straus Lynn Straus added a comment -

          Approved for 6.0.  Will add to Alice release ticket shortly.

          lynn.straus Lynn Straus added a comment - Approved for 6.0.  Will add to Alice release ticket shortly.

          Build couchbase-server-6.5.0-1343 contains query commit 7b4d40c with commit message:
          MB-31367. Copy expression when it is not nil

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.5.0-1343 contains query commit 7b4d40c with commit message: MB-31367 . Copy expression when it is not nil

          Raju Suravarjjala, Keshav Murthy If this need for 6.0.0 please triage this.

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Raju Suravarjjala , Keshav Murthy If this need for 6.0.0 please triage this.
          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - - edited

          CREATE INDEX `ix20` ON `default`(ALL (ARRAY [op.name, LEAST(`self`._sync.sequence,op.val.seq), IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] FOR op IN OBJECT_PAIRS(`self`._sync.channels) END), `self`._sync.rev, `self`._sync.sequence, `self`._sync.flags);
           
          SELECT  [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)][1] AS sequence FROM `default` UNNEST OBJECT_PAIRS(`d`._sync.channels) AS op WHERE [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)]  BETWEEN  ['foo', 0] AND ['foo', 1] ORDER BY sequence LIMIT 1;
          

          Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - - edited CREATE INDEX `ix20` ON ` default `(ALL (ARRAY [op.name, LEAST(`self`._sync.sequence,op.val.seq), IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )] FOR op IN OBJECT_PAIRS(`self`._sync.channels) END), `self`._sync.rev, `self`._sync.sequence, `self`._sync.flags);   SELECT [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )][ 1 ] AS sequence FROM ` default ` UNNEST OBJECT_PAIRS(`d`._sync.channels) AS op WHERE [op.name, LEAST(`d`._sync.sequence, op.val.seq),IFMISSING(op.val.rev, null ), IFMISSING(op.val.del, null )] BETWEEN [ 'foo' , 0 ] AND [ 'foo' , 1 ] ORDER BY sequence LIMIT 1 ;

          People

            sridevi.saragadam Sridevi Saragadam (Inactive)
            sridevi.saragadam Sridevi Saragadam (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty