Queries are returning No Results

Couchbase Server
1

I’ve installed the travel-sample db and when I go to the Query section of the CouchBase web console, it shows travel-sample as a Fully Queryable Bucket.
However, a query like SELECT * FROM travel-sample limit 1; does not return a result.
A query like SELECT * FROM system:indexes WHERE name = ‘#primary’; does not return a result either.
It just doesn’t seem to be working, I’ve restarted the server and everything seems to be fine, no error in logs all services running, etc. but I just can’t seem to get any results.
The travel-sample bucket shows 31,591 documents so why isn’t this working?

Thanks.

2

Did your Indexer service is running. Check Index Status in the Indexes tab

3

Yes, indexer service is running and all the index have a status of ready and build progress at 100%. Everything looks good but just not working.

4

After execution paste the output of Plan Text tab here.

Also run the following query and see if that working

SELECT t.* 
FROM `travel-sample` AS t USE KEYS [  "airline_10",  "airline_10123","airline_10226"];
5

returns the following Plan:
{
“plan”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “PrimaryScan”,
“index”: “def_primary”,
“keyspace”: “travel-sample”,
“limit”: “1”,
“namespace”: “default”,
“using”: “gsi”
},
{
“#operator”: “Fetch”,
“keyspace”: “travel-sample”,
“namespace”: “default”
},
{
“#operator”: “Parallel”,
“~child”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “InitialProject”,
“result_terms”: [
{
“expr”: “self”,
“star”: true
}
]
},
{
“#operator”: “FinalProject”
}
]
}
}
]
},
{
“#operator”: “Limit”,
“expr”: “1”
}
]
},
“text”: “SELECT * FROM travel-sample limit 1;”
}

The query you provided worked and returned back 3 records.
Here’s the plan for that query:
{
“plan”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “KeyScan”,
“keys”: “["airline_10", "airline_10123", "airline_10226"]”
},
{
“#operator”: “Fetch”,
“as”: “t”,
“keyspace”: “travel-sample”,
“namespace”: “default”
},
{
“#operator”: “Parallel”,
“~child”: {
“#operator”: “Sequence”,
“~children”: [
{
“#operator”: “InitialProject”,
“result_terms”: [
{
“expr”: “t”,
“star”: true
}
]
},
{
“#operator”: “FinalProject”
}
]
}
}
]
},
“text”: “SELECT t.* \r\nFROM travel-sample AS t USE KEYS [ "airline_10", "airline_10123","airline_10226"];”
}

6

It looks like index might not indexed properly.
Go to Index Statistics and check number of indexed items.

You can drop the index and and re-create it and see if that works

DROP INDEX  `travel-sample`.def_primary;
CREATE PRIMARY INDEX ON `travel-sample`;

OR DROP the bucket and re-install travel-sample bucket

7

Thank you that was it. I noticed most of the indexes don’t have any items indexed. Not sure how that happend, when I first installed the bucket I was able to execute queries without any problems then it just stopped working. I never dropped an index. I will delete the bucket and re-install to fix all the other index. Thanks.