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

Index never gets created in MDS setup

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 5.0.0
    • 5.0.0
    • ns_server
    • None
    • 2 data nodes, 1 index node, 1 query node
    • Untriaged
    • Centos 64-bit
    • Yes

    Description

      Our N1QL/GSI performance tests stopped working in build 5.0.0-2039.

      changed projects : 
       
      	ns_server changed from 0531c5f87e5dcbf58e6fef04e2234710ad798e22 to 87e149df037fb64b558f7998da39d4cb9d64750f
      		[+] 87e149d MB-22703: Modify terse_bucket_info to omit...
      		[+] 0dc0316 MB-22703: Modify build_bucket_info to omit...
      		[+] eb48322 MB-22703: Update ephemeral bucket's capabilities.
      
      

      I was able to reproduce this issue manually by following these steps:

      1. Create 1 data service (no buckets)
      2. Add 1 more data service
      3. Add 1 index service (standard GSI)
      4. Add 1 query service
      5. Rebalance
      6. Create an empty bucket with password authentication
      7. Navigate to query bench
      8. Execute "CREATE INDEX by_email ON `bucket-1`(email);"

      Expected behavior: DDL statement succeeds and a new index is created.

      Actual behavior: Index remains in "Building" status indefinitely. DDL query times out.

      {
        "status": "Gateway Timeout",
        "status_detail": "The query workbench only supports queries running for 600 seconds. Use cbq from the command-line for longer running queries. Certain DML queries, such as index creation, will continue in the background despite the user interface timeout."
      }
      

      Attachments

        1. 172.23.96.112.zip
          1.97 MB
        2. 172.23.96.117.zip
          15.79 MB
        3. 172.23.96.118.zip
          15.50 MB
        4. 172.23.96.123.zip
          3.35 MB
        5. 2039.png
          2039.png
          196 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            dfinlay Dave Finlay
            pavelpaulau Pavel Paulau (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