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

[system test] create index on bucket w/ incoming load is stuck.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • 400-3248
      Attached screenshot for cluster config
      Index RAM quota : 2G
      9 buckets, 17 gsi indexes.
    • Untriaged
    • Unknown

    Description

      1. drop index default.min_price_min_stop- success
      2. create index again - ( There is incoming load on the bucket)
      CREATE INDEX min_price_min_stop ON default((((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[0]).`DepartureAirport`).`LocationCode`),(((((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)[1]).`ArrivalAirport`).`LocationCode`),array_length(((((`AirItinerary`.`OriginDestinationOptions`).`OriginDestinationOption`)[0]).`FlightSegment`)),(((((`AirItineraryPricingInfo`.`PTC_FareBreakdowns`).`PTC_FareBreakdown`).`PassengerFare`).`TotalFare`).`Amount`)) USING GSI

      After about an hour - I see this index is consistently at 77% complete.
      "default:min_price_min_stop:avg_scan_latency": 0,
      "default:min_price_min_stop:avg_scan_wait_latency": 0,
      "default:min_price_min_stop:avg_ts_interval": 0,
      "default:min_price_min_stop:build_progress": 77,
      "default:min_price_min_stop:data_size": 5497874,
      "default:min_price_min_stop:delete_bytes": 0,
      "default:min_price_min_stop:disk_size": 5554176,
      "default:min_price_min_stop:flush_queue_size": 0,
      "default:min_price_min_stop:get_bytes": 0,
      "default:min_price_min_stop:insert_bytes": 1909282,
      "default:min_price_min_stop:items_count": 0,
      "default:min_price_min_stop:num_commits": 0,
      "default:min_price_min_stop:num_compactions": 0,
      "default:min_price_min_stop:num_docs_indexed": 17571,
      "default:min_price_min_stop:num_docs_pending": 5110,
      "default:min_price_min_stop:num_docs_queued": 97,
      "default:min_price_min_stop:num_flush_queued": 19057,
      "default:min_price_min_stop:num_requests": 0,
      "default:min_price_min_stop:num_rows_returned": 0,
      "default:min_price_min_stop:num_snapshots": 0,
      "default:min_price_min_stop:scan_bytes_read": 0,
      "default:min_price_min_stop:scan_wait_duration": 0,
      "default:min_price_min_stop:total_scan_duration": 0,
      "default:mutation_queue_size": 36066,
      "default:num_mutations_queued": 55123,
      "memory_quota": 2097152000,
      "memory_used": 268435456,
      "needs_restart": false,

      the total indexed items from the UI - 0

      Indexer log contains most messages for ..

      2015-06-24T12:11:32.598Z-07:00 [Warn] Indexer::MutationQueue Waiting for Node Alloc for 296940 Milliseconds Vbucket 943
      2015-06-24T12:11:32.628Z-07:00 [Warn] Indexer::MutationQueue Waiting for Node Alloc for 296970 Milliseconds Vbucket 943
      2015-06-24T12:11:32.658Z-07:00 [Warn] Indexer::MutationQueue Waiting for Node Alloc for 297000 Milliseconds Vbucket 943
      2015-06-24T12:11:32.688Z-07:00 [Warn] Indexer::MutationQueue Waiting for Node Alloc for 297030 Milliseconds Vbucket 943

      Liekwise for index ORDER_LINE

      It appears to have indexed only 1M of 6M items and shows 57% complete and appears to be stuck.

      Attachments

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

        Activity

          People

            deepkaran.salooja Deepkaran Salooja
            ketaki Ketaki Gangal (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty