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

[BP MB-39857 to 6.6.1] - [N1QL] creating an index on bucket name with % in the name fails

    XMLWordPrintable

    Details

    • Triage:
      Untriaged
    • Story Points:
      1
    • Is this a Regression?:
      No

      Description

      While testing out the MP I ran into this error. I have a bucket named default%bucket. When I try to create an index on this bucket through various methods(curl, UI, cbq): it always fails with this error:
      create index idx on `default%bucket`(name)

      [

      { "code": 5000, "msg": "GSI CreateIndex() - cause: Encountered transient error. Index creation will be retried in background. Error: Index idx will retry building in the background for reason: Error Connecting KV 127.0.0.1:8091 Err HTTP error 404 Object Not Found getting \"http://127.0.0.1:8091/pools/default/buckets/default%2525bucket?bucket_uuid=7b1183539c684de465392fe007fa43d5\": Requested resource not found.\r\n.\n", "query": "create index idx on `default%bucket`(name)" }

      ]

      I do not see this issue with default.bucket, defferred indexes are created correctly. This issue is seen even before the fix on 6.5.1-6299

      Logs attached.

        Attachments

          Issue Links

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

            Activity

            Hide
            jeelan.poola Jeelan Poola added a comment -

            Discussed during GSI scrum today. Adding this to 6.6.1 approved list. Agreed to by Mihir Kamdar.

            Show
            jeelan.poola Jeelan Poola added a comment - Discussed during GSI scrum today. Adding this to 6.6.1 approved list. Agreed to by Mihir Kamdar .
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.1-9084 contains indexing commit 2a5b91e with commit message:
            MB-40042: Fix Bucket URI to avoid URL escape happening twice

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.1-9084 contains indexing commit 2a5b91e with commit message: MB-40042 : Fix Bucket URI to avoid URL escape happening twice
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.1-9085 contains indexing commit 22cb25a with commit message:
            Revert "MB-40042: Fix Bucket URI to avoid URL escape happening twice"

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.1-9085 contains indexing commit 22cb25a with commit message: Revert " MB-40042 : Fix Bucket URI to avoid URL escape happening twice"
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-6.6.1-9096 contains indexing commit d71677b with commit message:
            MB-40042: Fix Bucket URI to avoid URL escape happening twice

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.1-9096 contains indexing commit d71677b with commit message: MB-40042 : Fix Bucket URI to avoid URL escape happening twice
            Hide
            bhargava.yadavalli Bhargava Yadavalli (Inactive) added a comment -

            Build: 6.6.1-9126 contains total_indexer_gc_pause_ns

            Able to create index on bucket name containing "%" in it ex: "test%bucket" from UI query workbench and rest. Using both defer_build=True and defer_build=False.

            curl -u Administrator:password -v http://localhost:8093/query/service -d 'statement=CREATE INDEX curl_index_1 on `test%25bucket`(name)'

            curl -u Administrator:password -v http://localhost:8093/query/service -d 'statement=CREATE INDEX curl_index_2 on `test%25bucket`(name) with {"defer_build": true}'

             

            Show
            bhargava.yadavalli Bhargava Yadavalli (Inactive) added a comment - Build: 6.6.1-9126 contains total_indexer_gc_pause_ns Able to create index on bucket name containing "%" in it ex: "test%bucket" from UI query workbench and rest. Using both defer_build=True and defer_build=False. curl -u Administrator:password -v http://localhost:8093/query/service -d 'statement=CREATE INDEX curl_index_1 on `test%25bucket`(name)' curl -u Administrator:password -v http://localhost:8093/query/service -d 'statement=CREATE INDEX curl_index_2 on `test%25bucket`(name) with {"defer_build": true}'  

              People

              Assignee:
              bhargava.yadavalli Bhargava Yadavalli (Inactive)
              Reporter:
              jeelan.poola Jeelan Poola
              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