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

sgw indexes failed to create with ipv6only setup

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 7.0.2
    • 7.0.2
    • secondary-index
    • None
    • Untriaged
    • 1
    • No

    Description

      *CBS version : *7.0.2:6611
      Steps to reproduce :
      1. Set up server and have server with ipfamily = ipv6only
      2. Set up SGW
      3. SGW fails to start as it tries to create index on the server

      CREATE INDEX `sg_syncDocs_x1` ON `data-bucket`(META().id) WHERE META().id LIKE '\\_sync:%' with {"defer_build":true}
      

      Result :
      with following error

      Error creating index sg_channels_x1: Error creating index with statement: CREATE INDEX `sg_channels_x1` ON `data-bucket`(ALL (ARRAY [op.name, LEAST(meta().xattrs._sync.sequence,op.val.seq), IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] FOR op IN OBJECT_PAIRS(meta().xattrs._sync.channels) END), meta().xattrs._sync.rev, meta().xattrs._sync.sequence, meta().xattrs._sync.flags) with {"retain_deleted_xattr":true,"defer_build":true}.  Error: internal server failure | {"statement":"CREATE INDEX `sg_channels_x1` ON `data-bucket`(ALL (ARRAY [op.name, LEAST(meta().xattrs._sync.sequence,op.val.seq), IFMISSING(op.val.rev,null), IFMISSING(op.val.del,null)] FOR op IN OBJECT_PAIRS(meta().xattrs._sync.channels) END), meta().xattrs._sync.rev, meta().xattrs._sync.sequence, meta().xattrs._sync.flags) with {\"retain_deleted_xattr\":true,\"defer_build\":true}","client_context_id":"6fd77521-f33c-4666-ab94-c78987f22cd1","errors":[{"Code":5000,"Message":"GSI CreateIndex() - cause: Index creation for index sg_channels_x1, bucket data-bucket, scope _default, collection _default cannot start. Reason: Fails to create index.  There is no available index service that can process this request at this time. Index Service can be in bootstrap, recovery, or non-reachable. Please retry the operation at a later time.."}]} - will retry. -- db.(*SGIndex).createIfNeeded.func1() at indexes.go:264
      

      Expected :
      SGW should successfully connect

      Logs:
      CBS logs : cbcollect_sgwfails.zip
      SGW logs : sgcollect_sgwfails.zip

      Build it worked : It worked fine with ipv4only

      Screenshot :

      Attachments

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

        Activity

          jeelan.poola Jeelan Poola added a comment - - edited

          Sridevi Saragadam Could you please try with build 6623 or later? Please see https://issues.couchbase.com/browse/MB-48146. You may please resolve the issue as duplicate if build 6623 works for you. Thank you!

          jeelan.poola Jeelan Poola added a comment - - edited Sridevi Saragadam Could you please try with build 6623 or later? Please see https://issues.couchbase.com/browse/MB-48146 . You may please resolve the issue as duplicate if build 6623 works for you. Thank you!

          Ran with 6623 today morning and SGW able to start successfully. Closing the ticket

          sridevi.saragadam Sridevi Saragadam added a comment - Ran with 6623 today morning and SGW able to start successfully. Closing the ticket

          People

            sridevi.saragadam Sridevi Saragadam
            sridevi.saragadam Sridevi Saragadam
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty