Couchbase 4 cant create indexes

When i navigate to the Index page in the Couchbase management page, i see this message: Warning: We are having troubles communicating to the indexer process. The information might be stale.

I am trying to create an index on the default bucket

cbq> CREATE PRIMARY INDEX ON default USING GSI;
{
“requestID”: “0b79e962-fc4e-4fca-b686-41ef007a04a8”,
“signature”: null,
“results”: [
],
“errors”: [
{
“code”: 5000,
“msg”: “GSI CreatePrimaryIndex() - cause: Fails to create index. There is no available index service that can process this request at this time. Index Service can be in bootstrap, recovery, or non-reachable. Please retry the operation at a later time.”
}
],
“status”: “errors”,
“metrics”: {
“elapsedTime”: “10.082420949s”,
“executionTime”: “10.078441965s”,
“resultCount”: 0,
“resultSize”: 0,
“errorCount”: 1
}

what could be wrong?

Thanks
Jason

could you get us a cb_collectinfo? sounds like the indexer service is not present on your installation.
thanks
-cihan

Hi,

I am pretty new using couchbase i ran the command and attached the zip file that was created.

I just installed on ubuntu 14 using couchbase-server-enterprise_4.0.0-rc0-ubuntu14.04_amd64.deb and i did not do anything extra for the index services, so if there is somewhere you can point me to that, i would be great!
Thanks!
Jason

out.zip (2.6 MB)

Hello @cihangirb.

I am having some trouble with creating N1QL indexes.
I am using an Amazon t2.large (2 CPU, 8GB RAM) AMI with CentOS Linux release 7.1.1503 (Core) and couchbase-server-community-4.0.0-4051.x86_64.
The cbcollect_info is attached.cbInfo.txt.zip (896.1 KB)

Your help will be very appreciated.

Hi, looks like attaching just didn’t work. I cannot download the zip file for some reason. Could you send me a direct from onedrive or googledrive?
thanks
-cihan

Hello @cihangirb.

Here is the Google Drive link to cbcollect_info.
https://drive.google.com/a/virtualmarket.mx/file/d/0B60rAHSChUoIVmJSeWc5NFVuUGM/view?usp=sharing

You indexer log does not exist which mean you do not have the index service enabled. You can add a new node and choose index service in the "add server dialog"
thanks
-cihan

Hi,
I faced this problem too.
I have three CentOS7 machine:
one of them : Data and query,
Second one : Only Index
last one : Only data

but I saw that warning also when i tried to create Index I got below message:

[
{
“code”: 5000,
“msg”: “GSI CreatePrimaryIndex() - cause: Fails to create index. There is no available index service that can process this request at this time. Index Service can be in bootstrap, recovery, or non-reachable. Please retry the operation at a later time.”
}
]

and this is log from web managment

Service ‘indexer’ exited with status 1. Restarting. Messages: github.com/couchbase/indexing/secondary/common.ExitOnStdinClose()
/home/couchbase/jenkins/workspace/sherlock-unix/goproj/src/github.com/couchbase/indexing/secondary/common/util.go:313
created by main.main

/home/couchbase/jenkins/workspace/sherlock-unix/goproj/src/github.com/couchbase/indexing/secondary/cmd/indexer/main.go:75
+0xc48
[goport] 2016/04/20 08:22:33 /opt/couchbase/bin/indexer terminated: exit status

could you please assist me?

@vhp1360 , when you started cbq … and did something like

./cbq -engine=localhost:8093

which node where you on in the list below?
if you where not on the Index node can you point to it when you start cbq -engine=(index_node_ip):8093

Hi,
thanks.
on first machine.
but i found temporary solution: when I checked the index log file, I found there was a permission issue.
although I put “couchbase” user in “wheel” group with no password but this problem occurred,
any way i did command that provide by log file and my issue solved, but I guessed it should solve permanently.

Regards

That’s so annoying. After I created already bucket & data, how to create index for querying? I use couchbase 5.0.1 & centos.

If it’s for development and you just need functional completeness, you can define the index with “USING VIEWS”. That said, the best approach is probably to backup the data and reinstall selecting all services at installation time (which is the default).

Sorry for the trouble. I passed along your feedback to others as well.

I have the same issue
Service on server is runing

error when try to index on windows 10 enterpris edition
[
{
“code”: 5000,
“msg”: “GSI CreatePrimaryIndex() - cause: Fails to create index. There is no available index service that can process this request at this time. Index Service can be in bootstrap, recovery, or non-reachable. Please retry the operation at a later time.”,
“query”: “CREATE PRIMARY INDEX ON Customer360 USING GSI;”
}
]

Please check the indexer process log file to see if its running normally under /opt/couchbase/var/lib/couchbase/logs/indexer.log.

It would be good to double check the ports required by the indexer service are open
https://docs.couchbase.com/server/current/install/install-ports.html

1 Like

Thanks a lot it work for me. I got two task runing on port 9998 and 9999. I kill them all and it work!