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

shell query blocked on Mongos and no way to kill it

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Cannot Reproduce
    • Icon: Minor - P4 Minor - P4
    • None
    • 1.8.1
    • Querying
    • None
    • Centos 5.4 x86_64
      3 shard

    Description

      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 ...> }

      }

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: