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

Delete Query running for more than 3 days

    XMLWordPrintableJSON

Details

    • Icon: Question Question
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • 2.2.0
    • Performance
    • None
    • linux

    Description

      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") }

      }
      },

      Attachments

        Activity

          People

            Unassigned Unassigned
            mgandhi@seoclarity.net Dev
            Dev
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: