Error during cursor sorting (across shard)

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.0.6
    • Component/s: Querying
    • Environment:
      OS: Linux ip-....... 2.6.32-220.23.1.el6.centos.plus.x86_64 #1 SMP Tue Jun 19 04:14:37 BST 2012 x86_64 x86_64 x86_64 GNU/Linux
      Driver: pymongo 2.1.1
    • Linux
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We're constantly getting next error (often, but NOT all the times):

      OperationFailure: database error: could not initialize cursor across all shards because : too much data for sort() with no index. add an index or specify a smaller limit @ bill1shard3/shard3bill1a.ninternal.com:27018,shard3bill1b.ninternal.com:27018

      BUT, during querying, we're specifying hint() with 100% existed index.
      Limit, used in this particular query is 5020.

      Thank you.

            Assignee:
            sam.helman@10gen.com
            Reporter:
            Anton Koval'
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: