Details
-
Bug
-
Resolution: Done
-
Critical
-
None
-
4.5.0
-
None
Description
When upgrading the cluster, if you add a 4.5 node to an existing 4.1 cluster, you can not create an index on the 4.5 node. This means that a rolling upgrade would mean downtime for N1QL requests.
When you try to create an index on the 4.5 node, you receive the following error:
[
{
"code": 5000,
"msg": "GSI CreateIndex() - cause: Please Set Indexer Storage Mode Before Create Index",
"query_from_user": "CREATE INDEX productName_inasdex3 ON default(productName, ProductID) \n WHERE type=\"product\" USING GSI WITH
;"
}
]
If you try to set the "Indexer Storage Mode" from the GUI you get an "Found unsupported key storageMode " error.
I was able to graceful failover, upgrade, and re-add the node as a way of preserving the indexes.
Steps to reproduce:
1.) have a 4.1.0 cluster with indexes
2.) add a 4.5.0 node with index, data, and query service.
3.) try to create a new index on the 4.5.0 node "CREATE INDEX productName_index1 ON bucket_name(productName, ProductID)
WHERE type="product" USING GSI WITH
;"
STEP 3 FAILS