Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-18411

bad hint when using named indexes

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.0.2
    • Component/s: Storage
    • Labels:
      None
    • ALL
    • Hide

      db version v3.0.2
      git version: 83419b7d5a78599e4b8449e10b0d38878ce624c0
      OpenSSL version: OpenSSL 1.0.1f 6 Jan 2014

      Show
      db version v3.0.2 git version: 83419b7d5a78599e4b8449e10b0d38878ce624c0 OpenSSL version: OpenSSL 1.0.1f 6 Jan 2014

      2015-05-11T17:02:29.804+0200 I INDEX    [conn24] build index on: mydb.mycol properties: { v: 1, key: { i: 1 }, name: "test_index", ns: "mydb.mycol" }
      2015-05-11T17:02:29.804+0200 I INDEX    [conn24] 	 building index using bulk method
      2015-05-11T17:02:29.805+0200 I INDEX    [conn24] build index done.  scanned 101 total records. 0 secs
      2015-05-11T17:02:29.806+0200 I QUERY    [conn24] assertion 17007 Unable to execute query: error processing query: ns=mydb.mycol limit=0 skip=0
      Tree: $and
      Sort: {}
      Proj: {}
       planner returned error: bad hint ns:mydb.mycol query:{ $hint: { test_index: 1 }, $query: {} }
      

      I see this when using the mongoshell as well as with PyMongo and TxMongo.

      The query works when using:

      { $hint: { i: 1 }, $query: {} }
      

            Assignee:
            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            Reporter:
            psi29a Bret Curtis
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: