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

Delete Query running for more than 3 days

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

      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 Unassigned
            Reporter:
            mgandhi@seoclarity.net Dev
            Dev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: