N1QL failed due to Indexer warmup state

Hello,

We have 10+ node in our Couchbase setup and we want to change the data node size and index node size. We are using Couchbase community version 5.1. While changing the index memory quota we are getting warning.

code": 5000,
“msg”: "Indexer In Warmup State. Please retry the request later.

I can understand that due to memory size change the indexes can rebuild again and it will take some time.
N1QL’s that is using the indexes is not working till the indexes are ready.
How can we avoid the N1QL failed during warmup state?
Is there any recommendation to handle this situation? or Is there any recommendation to change the memory quota for index node and data node?

@vinpokale,

In 5.1CE, when there is a change in memory quota, it causes the indexer to restart. When indexer restarts, the indexes warm-up from storage. Until all the indexes are warmed-up, we do not allow scans. However, ideally it should not take long time for indexes to warm-up.

For how long are you seeing the indexes in warm-up state? Also, how many indexer nodes do you have in the cluster?

Reg. change of memory quota, please go through our sizing guidelines: https://docs.couchbase.com/server/5.1/install/sizing-general.html

Thanks,
Varun

1 Like

Thank you @varun.velamuri for reply.
I understood your point.

For how long are you seeing the indexes in warm-up state?
It is around 2 min only but we have very high QPS so even within 2 minutes some of the N1QLs which are using indexes are failed.

Also, how many indexer nodes do you have in the cluster?
All the nodes have index service because we are using Couchbase community version 5.1 so it does not support multi-dimensional scaling.

Regards,
Vinay