shell query blocked on Mongos and no way to kill it

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Cannot Reproduce
    • Priority: Minor - P4
    • None
    • Affects Version/s: 1.8.1
    • Component/s: Querying
    • None
    • Environment:
      Centos 5.4 x86_64
      3 shard
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Date range query via mongo shell with a typo (missing "new" in date var declaration) blocked all other queries using mongos. db.currentOp() did not show query but issue resolved by restarting mongos. Attempts to reproduce so far have been unsuccessful ... do you know of any scenario where this occurs and how to avoid/resolve without causing 100% outage?

      Query:
      var enddate = Date(2011,11,30)
      var tempdate = Date(2011,5,26)
      db.UserIdentity.find({ "acctMgmt.createTime" : {$gte: tempdate, $lt: enddate}},

      {username:1,'acctMgmt.createTime':1}

      )

      Abreviated doc schema:
      > db.UserIdentity.findOne()
      {
      "_id" : ObjectId("4e09eb8d16887e33bb1be8e4"),
      "field" : "yyyy",
      "username" : "xxxx",
      "acctMgmt" :

      { "createTime" : ISODate("2000-01-01T13:32:00Z"), <other fields ...> }

      ,

      "xxxxx" :

      { "field" : yyy, <other fields ...> }

      ,
      "xxxxx" :

      { "field" : yyy, <other fields ...> }

      }

            Assignee:
            Unassigned
            Reporter:
            Peter Thairu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: