Index Scan times out


#1

Hello,

I need help trying to figure out the cause of my ‘index scan timeout’ when I am executing a query a long query. Does anyone of you have has or has had this type of problem? I am using the node sdk. It also times out when I use the query workbench.


#2

What version of couchbase are you on and what size is your dataset? My team is having the same issue on couchbase 4.1.0 running a query against about 20 Million documents. This error is printed:

“code”: 12015,
“msg”: “Index scan timed out - cause: Index scan timed out”

Not very descriptive or helpful


#3

I am using the same version and my data set is less than one million.


#4

Have you done an EXPLAIN to check whether the query is using a useful index?

Also, it is possible to set a timeout parameter for N1QL queries.

http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-rest-api/extimeout.html