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?
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.