Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.5.0, 6.0.0
-
None
-
Untriaged
-
Unknown
Description
1. Create a partitioned index on 2 nodes
CREATE INDEX idx1 on default(name) PARTITION BY HASH(meta().id) with {"nodes": ["10.100.172.173:9000","127.0.0.1:9001"]}
2. Move to 2 different nodes
ALTER INDEX default.idx1 WITH {"action":"move", "nodes": ["127.0.0.1:9002", "127.0.0.1:9003"]}
3. Try scanning the index:
SELECT name FROM default WHERE name IS NOT NULL
[
]
4. Try to drop the index
{ "code": 5000, "msg": "GSI index idx1 not found.", "query": "DROP INDEX default.idx1" }
5. Move back to original nodes
ALTER INDEX default.idx1 WITH {"action":"move", "nodes": ["10.100.172.173:9000","127.0.0.1:9001"]}
{ "code": 5000, "msg": "GSI index idx1 not found.", "query": "ALTER INDEX default.idx1 WITH \{\"action\":\"move\", \"nodes\": [\"10.100.172.173:9000\",\"127.0.0.1:9001\"]}
"
}
gsiclient doesn't seem to have the metadata of the index anymore. Restarting the cbq-engine makes it work again.
Note: This is not an issue with non-partitioned index
Attachments
Issue Links
- is a backport of
-
MB-36282 alter index of partitioned index renders the index unusable
- Closed