Delete Query running for more than 3 days

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.2.0
    • Component/s: Performance
    • None
    • Environment:
      linux
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We have observed that we were running out of disk space on one of our mongodb servers. We create a query to delete unused/old data and that query has been running for more than 3 days. We would like to know if the issue is with the query or with the server running out of space to run the delete operation. Attached below is the query and the status of the query:

      Query:
      db.keyword_rank_entity.remove({"date":{"$lte":"20120101"}})

      Status:

      {
      "opid" : 267251799,
      "active" : true,
      "secs_running" : 288364,
      "op" : "remove",
      "ns" : "mongo_seoclarity_rankcheck.keyword_rank_entity",
      "query" : {
      "date" :

      { "$lte" : "20120101" }

      },
      "client" : "127.0.0.1:53073",
      "desc" : "conn1581319",
      "threadId" : "0x4eb54940",
      "connectionId" : 1581319,
      "locks" :

      { "^mongo_seoclarity_rankcheck" : "W" }

      ,
      "waitingForLock" : true,
      "numYields" : 572479,
      "lockStats" : {
      "timeLockedMicros" :

      { "r" : NumberLong(0), "w" : NumberLong("56591833246") }

      ,
      "timeAcquiringMicros" :

      { "r" : NumberLong(0), "w" : NumberLong("288363514470") }

      }
      },

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

              Created:
              Updated:
              Resolved: