Adding index is frozen

Couchbase Server
1

I have 500 000 documents in bucket and trying to add index via Query window. Index query runs well, but when I open Index tab of workbench that index is in red state without any percentage “built process” next to that index. Many minutes passed by and it is still in red.

Is this behavior expected?

Thank you

2

If the index was created in deferred build mode, it needs to be built explicitly.

https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/build-index.html