GSI rebalance stuck on changing the shardAffinity to False post 1 min swap rebalancing.

Index:

CREATE INDEX default0_idx_VolumeCollection0_0 ON VolumeCollection0(country, DISTINCT ARRAY `r`.`ratings`.`Check in / front desk` FOR r in `reviews` END,array_count((`public_likes`)),array_count((`reviews`)) DESC,`type`,`phone`,`price`,`email`,`address`,`name`,`url`) PARTITION BY HASH (country) USING GSI WITH { "defer_build": true};

Query:

select meta().id from VolumeCollection0 where country is not null and `type` is not null and (any r in reviews satisfies r.ratings.`Check in / front desk` is not null end) limit 100

Index:

CREATE INDEX default0_idx_VolumeCollection0_1 ON VolumeCollection0(`free_breakfast`,`type`,`free_parking`,array_count((`public_likes`)),`price`,`country`) PARTITION BY HASH (type) USING GSI WITH { "defer_build": true};

Query:

select price, country from VolumeCollection0 where free_breakfast=True AND free_parking=True and price is not null and array_count(public_likes)>=0 and `type`= $type limit 100

Index:

CREATE INDEX default0_idx_VolumeCollection1_0 ON VolumeCollection1(`free_breakfast`,`free_parking`,`country`,`city`)  PARTITION BY HASH (country) USING GSI WITH { "defer_build": true};

Query:

select city,country from VolumeCollection1 where free_breakfast=True and free_parking=True order by country,city limit 100

Index:

CREATE INDEX default0_idx_VolumeCollection1_1 ON VolumeCollection1(`country`, `city`,`price`,`name`)  PARTITION BY HASH (country, city) USING GSI WITH { "defer_build": true};

Query:

WITH city_avg AS (SELECT city, AVG(price) AS avgprice FROM VolumeCollection1 WHERE country = $country GROUP BY city limit 10) SELECT h.name, h.price FROM city_avg JOIN VolumeCollection1 h ON h.city = city_avg.city WHERE h.price < city_avg.avgprice AND h.country=$country limit 100

Starting rebalance, KeepNodes = ['ns_1@svc-d-node-001.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-d-node-002.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-d-node-003.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-i-node-030.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-i-node-032.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-q-node-004.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com',

'ns_1@svc-q-node-005.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com'], EjectNodes = ['ns_1@svc-i-node-031.8jt8h1nr6ekeixaf.sandbox.nonprod-project-avengers.com'], Failed over and being ejected nodes = []; no delta recovery nodes; Operation Id = 4f19597ccf6e1ca1ac0fc06df2f1f94f