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

Index scan timed out on 10 row query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 5.0.0
    • 4.5.0
    • forestdb, secondary-index
    • None
    • Untriaged
    • Unknown

    Description

      From longevity test, 11 days running.
      Tried query:
      select rating from default where rating > 10 limit 10;

      got response:
      2016-06-20T08:36:26.948-07:00 [Error] SCAN##38203994 RESPONSE rows:10, waitTime:8.055µs, totalTime:3m8.654686561s, status:(error = Index scan timed out), requestId:cf9ce2b7-5f27-42df-a65c-a6aeb2e64f6e

      Debug mode showing goroutine in iterator_next

      1 @ 0x4073cb 0x4b1cfd 0x4beca9 0x4da668 0x4f30c4 0x4f2aaf 0x4f24c5 0x56f931 0xa721ad 0x465091
      #       0x4b1cfd        github.com/couchbase/indexing/secondary/fdb._Cfunc_fdb_iterator_next+0x3d               ??:0
      #       0x4beca9        github.com/couchbase/indexing/secondary/fdb.(*Iterator).Next+0x1d9                      /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/fdb/iterator.go:93
      #       0x4da668        github.com/couchbase/indexing/secondary/indexer.(*ForestDBIterator).Next+0x58           /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/indexer/forestdb_iterator.go:148
      #       0x4f30c4        github.com/couchbase/indexing/secondary/indexer.(*fdbSnapshot).iterEqualKeys+0x184      /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/indexer/forestdb_snapshot_reader.go:205
      #       0x4f2aaf        github.com/couchbase/indexing/secondary/indexer.(*fdbSnapshot).Iterate+0x47f            /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/indexer/forestdb_snapshot_reader.go:143
      #       0x4f24c5        github.com/couchbase/indexing/secondary/indexer.(*fdbSnapshot).Range+0x95               /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/indexer/forestdb_snapshot_reader.go:111
      #       0x56f931        github.com/couchbase/indexing/secondary/indexer.(*IndexScanSource).Routine+0x581        /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/indexer/scan_pipeline.go:118
      #       0xa721ad        github.com/couchbase/indexing/secondary/pipeline.(*Pipeline).runIt.func1+0x5d           /home/couchbase/jenkins/workspace/watson-unix/goproj/src/github.com/couchbase/indexing/secondary/pipeline/pipeline.go:75
      

      Attachments

        Issue Links

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

          Activity

            People

              tommie Tommie McAfee (Inactive)
              tommie Tommie McAfee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty