Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-18836

cbq throws error:"msg": "Index scan timed out - cause: Index scan timed out"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Critical
    • 4.5.0
    • 4.5.0
    • query, secondary-index
    • None
    • 4.5.0-1897
    • Untriaged
    • Unknown

    Description

      1.create a 4 node cluster. I used the ycsb cluster with forestdb indexer storage mode
      2. Create index:
      CREATE INDEX `idx` ON `default`((meta().`id`)) WITH(

      {"index_type" : "forestdb"}

      )
      3. Issue this query:
      cbq> select count(meta().id) from default where meta().id is not null;
      {
      "requestID": "2aea2242-696f-43ac-8125-c30b83bd919e",
      "signature":

      { "$1": "number" }

      ,
      "results": [

      { "$1": 14853475 }

      ],
      "errors": [

      { "code": 12015, "msg": "Index scan timed out - cause: Index scan timed out" }

      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "2m0.361419812s", "executionTime": "2m0.361236106s", "resultCount": 1, "resultSize": 38, "errorCount": 1 }

      }

      Seems like the backfill issue we saw earlier.

      Uploading logs.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty