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

Create index fails when scope name/ collection name exceeds 30 characters

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • No

    Description

      Looks like length of collection name and scope name has been increased from 30 to 251 characters (MB-41836).

      If we try to create index on such collection/scope we see that the create index is timing out.

      <error message>:
      2021-01-30 19:38:09,609 | test | INFO | MainThread | [tuq_helper:run_cbq_query:149] RUN QUERY CREATE PRIMARY INDEX on default:`IaFA2lrqZQrmflmyJPsXV82s7Z-tELupOObMhSuwjKl2sQoKQhrt--mKBPsE49G%qU-sNRQ3Xt%WR%_EEVSxGM9-30-87000`.`_default`.`EXmuP0urJgNJe-N4VgYeWcQLMImxq9u1JNnQ0ZA7oZCNiekw9_htG7PbXRJURHwycZKrTVnGK3N-52YzRWjBsT5k7PiqRVK7ox2BXUUzFIJj_n3OoiL9-30-90000` USING GSI
      2021-01-30 19:38:09,611 | test | INFO | MainThread | [tuq_helper:run_cbq_query:165] query_params is {'creds': [

      {'pass': 'password', 'user': 'Administrator'}

      ,

      {'pass': u'b4f7a8eb6017b7904764a5d274fa2b69', 'user': 'local:IaFA2lrqZQrmflmyJPsXV82s7Z-tELupOObMhSuwjKl2sQoKQhrt--mKBPsE49G%qU-sNRQ3Xt%WR%_EEVSxGM9-30-87000'}

      ], 'scan_consistency': 'REQUEST_PLUS'}
      2021-01-30 19:39:49,619 | test | ERROR | MainThread | [rest_client:_http_request:751] Socket error while connecting to http://10.112.190.101:8093/query?scan_consistency=REQUEST_PLUS&statement=CREATE+PRIMARY+INDEX+on+default%3A%60IaFA2lrqZQrmflmyJPsXV82s7Z-tELupOObMhSuwjKl2sQoKQhrt--mKBPsE49G%25qU-sNRQ3Xt%25WR%25_EEVSxGM9-30-87000%60.%60_default%60.%60EXmuP0urJgNJe-N4VgYeWcQLMImxq9u1JNnQ0ZA7oZCNiekw9_htG7PbXRJURHwycZKrTVnGK3N-52YzRWjBsT5k7PiqRVK7ox2BXUUzFIJj_n3OoiL9-30-90000%60+USING+GSI error timed out

      attached logs:
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/increased_limit/collectinfo-2021-01-30T141206-ns_1%4010.112.190.101.zip
      https://cb-jira.s3.us-east-2.amazonaws.com/logs/increased_limit/collectinfo-2021-01-30T141206-ns_1%4010.112.190.102.zip

      Attachments

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

        Activity

          People

            amit.kulkarni Amit Kulkarni
            anitha.kuberan Anitha Kuberan
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                PagerDuty