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. 2039.png
          196 kB
          Pavel Paulau
        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