Details
-
Bug
-
Resolution: Duplicate
-
Critical
-
4.0.0
-
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.