Skip to content

Instantly share code, notes, and snippets.

@fazlurr
Created January 27, 2025 08:48
Show Gist options
  • Save fazlurr/03382cacf5ac68b55c197db533de2b83 to your computer and use it in GitHub Desktop.
Save fazlurr/03382cacf5ac68b55c197db533de2b83 to your computer and use it in GitHub Desktop.

Revisions

  1. fazlurr created this gist Jan 27, 2025.
    26 changes: 26 additions & 0 deletions kill-slow-ops.js
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,26 @@
    var killLongRunningOps = function (table = 'submission', maxSecsRunning = 5000, kill = false) {
    var ns = 'orderonline_db.' + table;
    if (table === '*') {
    ns = /^orderonline_db\./;
    }
    var currOp = db.currentOp({"active" : true,"secs_running" : { "$gt" : maxSecsRunning },"ns" : ns});
    var operations = currOp.inprog;
    for (var i = 0; i < operations.length; i++) {
    var operation = operations[i];
    print(i + ". Operation: " + operation.opid);
    print("- NS: " + operation.ns);
    print("- OP: " + operation.op);
    print("- Secs Running: " + operation.secs_running);
    if (kill) {
    print("- Killing operation: " + operation.opid);
    try {
    db.killOp(operation.opid);
    } catch (error) {
    console.log('- Error Killing: ', error);
    }
    }
    print("--------------------");
    }
    }

    killLongRunningOps('*', 1000, false)