[SERVER-9010] Delete Query running for more than 3 days Created: 18/Mar/13  Updated: 18/Mar/13  Resolved: 18/Mar/13

Status: Closed
Project: Core Server
Component/s: Performance
Affects Version/s: 2.2.0
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: Dev Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

linux


Participants:
Dev

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

}
},


Generated at Thu Feb 08 03:19:04 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.