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

Plan Error when creating SGW indexes

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes

    Description

      Build : 7.1.0-2388

      In system test environment, Sync gateway is also configured. Sync Gateway creates some GSI indexes on the server. One of these index creation is failing in 7.1.0-2388

      CREATE INDEX `sg_access_x1` ON `bucket7`(ALL (ARRAY (op.name) FOR op IN OBJECT_PAIRS(meta().xattrs._sync.access) END)) with {"retain_deleted_xattr":true,"defer_build":true}
       
      [
        {
          "code": 4321,
          "msg": "Plan error: Only a single user or system xattribute can be indexed.",
          "query": "CREATE INDEX `sg_access_x1` ON `bucket7`(ALL (ARRAY (op.name) FOR op IN OBJECT_PAIRS(meta().xattrs._sync.access) END)) with {\"retain_deleted_xattr\":true,\"defer_build\":true}"
        }
      ]
      

      This worked in 7.1.0-2371.

      This could be related to the following change :

      Commit: dd9560d5f3f09387e3f3c9e245303808291ba2fb in build: couchbase-server-7.1.0-2387
      MB-51136 skip system xattrs on fetch
       
      Change-Id: I6a8b0f37ede4aaf57e0b3ac945c08fd4a317b38e
      Reviewed-on: https://review.couchbase.org/c/query/+/171277
      Tested-by: Marco Greco <marco.greco@couchbase.com>
      Reviewed-by: Donald Haggart <donald.haggart@couchbase.com>
      Reviewed-by: Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com>
      Author: Marco Greco <marco.greco@couchbase.com>
      Committer: Marco Greco <marco.greco@couchbase.com>
      

      Attachments

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

        Activity

          People

            mihir.kamdar Mihir Kamdar (Inactive)
            mihir.kamdar Mihir Kamdar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty