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

sgw indexes failed to create with ipv6only setup

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 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

          People

            sridevi.saragadam Sridevi Saragadam (Inactive)
            sridevi.saragadam Sridevi Saragadam (Inactive)
            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