Constantly getting 12003 error on sample bucket

SQL++
,
1

Hey there,
I am doing a school project on Couchbase DB and I can’t quite get the Query tab for my server to show me any results. The line I put in is

SELECT * from `beer-sample` WHERE state = 'California';

Sadly I get this as an output:

[
{
“code”: 12003,
“msg”: “Keyspace not found in CB datastore: default:beer-sample._default.beer-sample”,
“query”: “SELECT * from beer-sample WHERE state = ‘California’;”
}
]

I tried to start small, but I got set back by this, and can’t really progress. Any help on this topic would be much appreciated!

2

Hi @Maupken,

Next to history there is list box. make sure you selected bucket.scope
If you select beer-sample, _default after FROM you need to give collection name

3

It kind of worked, now I got this error:

"code": 4000,
"msg": "No index available on keyspace `default`:`beer-sample` that matches your query. Use CREATE PRIMARY INDEX ON `default`:`beer-sample` to create a primary index, or check that your expected index is online.",
"query": "SELECT * from `beer-sample` WHERE state = 'California';"

Sadly after I try to create the primary index I get the following:

"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 `default`:`beer-sample`"
4

Hum. It should have worked.

Try Drop the bucket and Then
Settings===> Sample Buckets ===> Install the bucket again.
It should have created indexes.

5

Still the same error, on different sample buckets. Maybe it could be the error with server setup?

6

Try restart the cluster. cc @varun.velamuri

7

@Maupken,

The indexer error means either index service is not configured in your cluster (or) the index service node is not available. What is your cluster configuration?

8

It looks something like this
image