// db.js var DB; (function() { var _defaultWriteConcern = {w: 'majority', wtimeout: 10 * 60 * 1000}; if (DB === undefined) { DB = function(mongo, name) { this._mongo = mongo; this._name = name; }; } /** * Rotate certificates, CRLs, and CA files. * @param {String} message optional message for server to log at rotation time */ DB.prototype.rotateCertificates = function(message) { return this._adminCommand({rotateCertificates: 1, message: message}); }; DB.prototype.getMongo = function() { assert(this._mongo, "why no mongo!"); return this._mongo; }; DB.prototype.getSiblingDB = function(name) { return this.getSession().getDatabase(name); }; DB.prototype.getSisterDB = DB.prototype.getSiblingDB; DB.prototype.getName = function() { return this._name; }; DB.prototype.stats = function(scale) { return this.runCommand({dbstats: 1, scale: scale}); }; DB.prototype.getCollection = function(name) { return new DBCollection(this._mongo, this, name, this._name + "." + name); }; DB.prototype.commandHelp = function(name) { var c = {}; c[name] = 1; c.help = true; var res = this.runCommand(c); if (!res.ok) throw _getErrorWithCode(res, res.errmsg); return res.help; }; // utility to attach readPreference if needed. DB.prototype._attachReadPreferenceToCommand = function(cmdObj, readPref) { "use strict"; // if the user has not set a readpref, return the original cmdObj if ((readPref === null) || typeof (readPref) !== "object") { return cmdObj; } // if user specifies $readPreference manually, then don't change it if (cmdObj.hasOwnProperty("$readPreference")) { return cmdObj; } // copy object so we don't mutate the original var clonedCmdObj = Object.extend({}, cmdObj); // The server selection spec mandates that the key is '$query', but // the shell has historically used 'query'. The server accepts both, // so we maintain the existing behavior var cmdObjWithReadPref = {query: clonedCmdObj, $readPreference: readPref}; return cmdObjWithReadPref; }; /** * If someone passes i.e. runCommand("foo", {bar: "baz"}), we merge it in to * runCommand({foo: 1, bar: "baz"}). * If we already have a command object in the first argument, we ensure that the second * argument 'extraKeys' is either null or an empty object. This prevents users from accidentally * calling runCommand({foo: 1}, {bar: 1}) and expecting the final command invocation to be * runCommand({foo: 1, bar: 1}). * This helper abstracts that logic. */ DB.prototype._mergeCommandOptions = function(obj, extraKeys) { "use strict"; if (typeof (obj) === "object") { if (Object.keys(extraKeys || {}).length > 0) { throw Error("Unexpected second argument to DB.runCommand(): (type: " + typeof (extraKeys) + "): " + tojson(extraKeys)); } return obj; } else if (typeof (obj) !== "string") { throw Error("First argument to DB.runCommand() must be either an object or a string: " + "(type: " + typeof (obj) + "): " + tojson(obj)); } var commandName = obj; var mergedCmdObj = {}; mergedCmdObj[commandName] = 1; if (!extraKeys) { return mergedCmdObj; } else if (typeof (extraKeys) === "object") { // this will traverse the prototype chain of extra, but keeping // to maintain legacy behavior for (var key in extraKeys) { mergedCmdObj[key] = extraKeys[key]; } } else { throw Error("Second argument to DB.runCommand(" + commandName + ") must be an object: (type: " + typeof (extraKeys) + "): " + tojson(extraKeys)); } return mergedCmdObj; }; // Like runCommand but applies readPreference if one has been set // on the connection. Also sets slaveOk if a (non-primary) readPref has been set. DB.prototype.runReadCommand = function(obj, extra, queryOptions) { "use strict"; // Support users who call this function with a string commandName, e.g. // db.runReadCommand("commandName", {arg1: "value", arg2: "value"}). obj = this._mergeCommandOptions(obj, extra); queryOptions = queryOptions !== undefined ? queryOptions : this.getQueryOptions(); { const session = this.getSession(); const readPreference = session._getSessionAwareClient().getReadPreference(session); if (readPreference !== null) { obj = this._attachReadPreferenceToCommand(obj, readPreference); if (readPreference.mode !== "primary") { // Set slaveOk if readPrefMode has been explicitly set with a readPreference // other than primary. queryOptions |= 4; } } } // The 'extra' parameter is not used as we have already created a merged command object. return this.runCommand(obj, null, queryOptions); }; // runCommand uses this impl to actually execute the command DB.prototype._runCommandImpl = function(name, obj, options) { const session = this.getSession(); return session._getSessionAwareClient().runCommand(session, name, obj, options); }; DB.prototype.runCommand = function(obj, extra, queryOptions) { "use strict"; // Support users who call this function with a string commandName, e.g. // db.runCommand("commandName", {arg1: "value", arg2: "value"}). var mergedObj = this._mergeCommandOptions(obj, extra); // if options were passed (i.e. because they were overridden on a collection), use them. // Otherwise use getQueryOptions. var options = (typeof (queryOptions) !== "undefined") ? queryOptions : this.getQueryOptions(); try { return this._runCommandImpl(this._name, mergedObj, options); } catch (ex) { // When runCommand flowed through query, a connection error resulted in the message // "error doing query: failed". Even though this message is arguably incorrect // for a command failing due to a connection failure, we preserve it for backwards // compatibility. See SERVER-18334 for details. if (ex.message.indexOf("network error") >= 0) { throw new Error("error doing query: failed: " + ex.message); } throw ex; } }; DB.prototype.runCommandWithMetadata = function(commandArgs, metadata) { const session = this.getSession(); return session._getSessionAwareClient().runCommandWithMetadata( session, this._name, metadata, commandArgs); }; DB.prototype._dbCommand = DB.prototype.runCommand; DB.prototype._dbReadCommand = DB.prototype.runReadCommand; DB.prototype.adminCommand = function(obj, extra) { if (this._name == "admin") return this.runCommand(obj, extra); return this.getSiblingDB("admin").runCommand(obj, extra); }; DB.prototype._adminCommand = DB.prototype.adminCommand; // alias old name DB.prototype._runCommandWithoutApiStrict = function(command) { let commandWithoutApiStrict = Object.assign({}, command); if (this.getMongo().getApiParameters().strict) { // Permit this command invocation, even if it's not in the requested API version. commandWithoutApiStrict["apiStrict"] = false; } return this.runCommand(commandWithoutApiStrict); }; DB.prototype._runAggregate = function(cmdObj, aggregateOptions) { assert(cmdObj.pipeline instanceof Array, "cmdObj must contain a 'pipeline' array"); assert(cmdObj.aggregate !== undefined, "cmdObj must contain 'aggregate' field"); assert(aggregateOptions === undefined || aggregateOptions instanceof Object, "'aggregateOptions' argument must be an object"); // Make a copy of the initial command object, i.e. {aggregate: x, pipeline: [...]}. cmdObj = Object.extend({}, cmdObj); // Make a copy of the aggregation options. let optcpy = Object.extend({}, (aggregateOptions || {})); if ('batchSize' in optcpy) { if (optcpy.cursor == null) { optcpy.cursor = {}; } optcpy.cursor.batchSize = optcpy['batchSize']; delete optcpy['batchSize']; } else if ('useCursor' in optcpy) { if (optcpy.cursor == null) { optcpy.cursor = {}; } delete optcpy['useCursor']; } const maxAwaitTimeMS = optcpy.maxAwaitTimeMS; delete optcpy.maxAwaitTimeMS; // Reassign the cleaned-up options. aggregateOptions = optcpy; // Add the options to the command object. Object.extend(cmdObj, aggregateOptions); if (!('cursor' in cmdObj)) { cmdObj.cursor = {}; } const res = this.runReadCommand(cmdObj); if (!res.ok && (res.code == 17020 || res.errmsg == "unrecognized field \"cursor") && !("cursor" in aggregateOptions)) { // If the command failed because cursors aren't supported and the user didn't explicitly // request a cursor, try again without requesting a cursor. delete cmdObj.cursor; res = doAgg(cmdObj); if ('result' in res && !("cursor" in res)) { // convert old-style output to cursor-style output res.cursor = {ns: '', id: NumberLong(0)}; res.cursor.firstBatch = res.result; delete res.result; } } assert.commandWorked(res, "aggregate failed"); if ("cursor" in res) { let batchSizeValue = undefined; if (cmdObj["cursor"]["batchSize"] > 0) { batchSizeValue = cmdObj["cursor"]["batchSize"]; } return new DBCommandCursor(this, res, batchSizeValue, maxAwaitTimeMS); } return res; }; DB.prototype.aggregate = function(pipeline, aggregateOptions) { assert(pipeline instanceof Array, "pipeline argument must be an array"); const cmdObj = this._mergeCommandOptions("aggregate", {pipeline: pipeline}); return this._runAggregate(cmdObj, (aggregateOptions || {})); }; /** Create a new collection in the database. Normally, collection creation is automatic. You would use this function if you wish to specify special options on creation. If the collection already exists, no action occurs.
Options:
Example:
db.createCollection("movies", { size: 10 * 1024 * 1024, capped:true } );
* @param {String} name Name of new collection to create
* @param {Object} options Object with options for call. Options are listed above.
* @return {Object} returned has member ok set to true if operation succeeds, false otherwise.
*/
DB.prototype.createCollection = function(name, opt) {
var options = opt || {};
var cmd = {create: name};
Object.extend(cmd, options);
return this._dbCommand(cmd);
};
/**
* Command to create a view based on the specified aggregation pipeline.
* Usage: db.createView(name, viewOn, pipeline: [{ $operator: {...}}, ... ])
*
* @param name String - name of the new view to create
* @param viewOn String - name of the backing view or collection
* @param pipeline [{ $operator: {...}}, ... ] - the aggregation pipeline that defines the view
* @param options { } - options on the view, e.g., collations
*/
DB.prototype.createView = function(name, viewOn, pipeline, opt) {
var options = opt || {};
var cmd = {create: name};
if (viewOn == undefined) {
throw Error("Must specify a backing view or collection");
}
// Since we allow a single stage pipeline to be specified as an object
// in aggregation, we need to account for that here for consistency.
if (pipeline != undefined) {
if (!Array.isArray(pipeline)) {
pipeline = [pipeline];
}
}
options.pipeline = pipeline;
options.viewOn = viewOn;
Object.extend(cmd, options);
return this._dbCommand(cmd);
};
/**
* @deprecated use getProfilingStatus
* Returns the current profiling level of this database
* @return SOMETHING_FIXME or null on error
*/
DB.prototype.getProfilingLevel = function() {
var res = assert.commandWorked(this._dbCommand({profile: -1}));
return res ? res.was : null;
};
/**
* @return the current profiling status
* example { was : 0, slowms : 100 }
* @return SOMETHING_FIXME or null on error
*/
DB.prototype.getProfilingStatus = function() {
var res = this._dbCommand({profile: -1});
if (!res.ok)
throw _getErrorWithCode(res, "profile command failed: " + tojson(res));
delete res.ok;
return res;
};
/**
* Erase the entire database.
* @params writeConcern: (document) expresses the write concern of the drop command.
* @return Object returned has member ok set to true if operation succeeds, false otherwise.
*/
DB.prototype.dropDatabase = function(writeConcern) {
return this._dbCommand(
{dropDatabase: 1, writeConcern: writeConcern ? writeConcern : _defaultWriteConcern});
};
/**
* Shuts down the database. Must be run while using the admin database.
* @param opts Options for shutdown. Possible options are:
* - force: (boolean) if the server should shut down, even if there is no
* up-to-date secondary
* - timeoutSecs: (number) the server will continue checking over timeoutSecs
* if any other servers have caught up enough for it to shut down.
*/
DB.prototype.shutdownServer = function(opts) {
if ("admin" != this._name) {
return "shutdown command only works with the admin database; try 'use admin'";
}
var cmd = {'shutdown': 1};
opts = opts || {};
for (var o in opts) {
cmd[o] = opts[o];
}
try {
var res = this.runCommand(cmd);
if (!res.ok) {
throw _getErrorWithCode(res, 'shutdownServer failed: ' + tojson(res));
}
throw Error('shutdownServer failed: server is still up.');
} catch (e) {
// we expect the command to not return a response, as the server will shut down
// immediately.
if (isNetworkError(e)) {
print('server should be down...');
return;
}
throw e;
}
};
DB.prototype.help = function() {
print("DB methods:");
print(
"\tdb.adminCommand(nameOrDocument) - switches to 'admin' db, and runs command [just calls db.runCommand(...)]");
print(
"\tdb.aggregate([pipeline], {options}) - performs a collectionless aggregation on this database; returns a cursor");
print("\tdb.auth(username, password)");
print("\tdb.commandHelp(name) returns the help for the command");
print("\tdb.createUser(userDocument)");
print("\tdb.createView(name, viewOn, [{$operator: {...}}, ...], {viewOptions})");
print("\tdb.currentOp() displays currently executing operations in the db");
print("\tdb.dropDatabase(writeConcern)");
print("\tdb.dropUser(username)");
print("\tdb.eval() - deprecated");
print("\tdb.fsyncLock() flush data to disk and lock server for backups");
print("\tdb.fsyncUnlock() unlocks server following a db.fsyncLock()");
print("\tdb.getCollection(cname) same as db['cname'] or db.cname");
print("\tdb.getCollectionInfos([filter]) - returns a list that contains the names and options" +
" of the db's collections");
print("\tdb.getCollectionNames()");
print("\tdb.getLastError() - just returns the err msg string");
print("\tdb.getLastErrorObj() - return full status object");
print("\tdb.getLogComponents()");
print("\tdb.getMongo() get the server connection object");
print("\tdb.getMongo().setSecondaryOk() allow queries on a replication secondary server");
print("\tdb.getName()");
print("\tdb.getProfilingLevel() - deprecated");
print("\tdb.getProfilingStatus() - returns if profiling is on and slow threshold");
print("\tdb.getReplicationInfo()");
print("\tdb.getSiblingDB(name) get the db at the same server as this one");
print(
"\tdb.getWriteConcern() - returns the write concern used for any operations on this db, inherited from server object if set");
print("\tdb.hostInfo() get details about the server's host");
print("\tdb.isMaster() check replica primary status");
print("\tdb.hello() check replica primary status");
print("\tdb.killOp(opid) kills the current operation in the db");
print("\tdb.listCommands() lists all the db commands");
print("\tdb.loadServerScripts() loads all the scripts in db.system.js");
print("\tdb.logout()");
print("\tdb.printCollectionStats()");
print("\tdb.printReplicationInfo()");
print("\tdb.printShardingStatus()");
print("\tdb.printSecondaryReplicationInfo()");
print("\tdb.resetError()");
print(
"\tdb.rotateCertificates(message) - rotates certificates, CRLs, and CA files and logs an optional message");
print(
"\tdb.runCommand(cmdObj) run a database command. if cmdObj is a string, turns it into {cmdObj: 1}");
print("\tdb.serverStatus()");
print("\tdb.setLogLevel(level,Evaluate a js expression at the database server.
* *Useful if you need to touch a lot of data lightly; in such a scenario * the network transfer of the data could be a bottleneck. A good example * is "select count(*)" -- can be done server side via this mechanism. *
* ** If the eval fails, an exception is thrown of the form: *
*{ dbEvalException: { retval: functionReturnValue, ok: num [, errno: num] [, errmsg:
*str] } }
*
* Example:
*print( "mycount: " + db.eval( function(){db.mycoll.find({},{_id:ObjId()}).length();}
*);
*
* @param {Function} jsfunction Javascript function to run on server. Note this it not a
*closure, but rather just "code".
* @return result of your function, or null if error
*
*/
DB.prototype.eval = function(jsfunction) {
print("WARNING: db.eval is deprecated");
var cmd = {$eval: jsfunction};
if (arguments.length > 1) {
cmd.args = Array.from(arguments).slice(1);
}
var res = this._dbCommand(cmd);
if (!res.ok)
throw _getErrorWithCode(res, tojson(res));
return res.retval;
};
DB.prototype.dbEval = DB.prototype.eval;
/**
* * An array of grouped items is returned. The array must fit in RAM, thus this function is not * suitable when the return set is extremely large. *
** To order the grouped data, simply sort it client side upon return. *
Defaults cond may be null if you want to run against all rows in the collection keyf is a function which takes an object and returns the desired key. set either key or keyf (not both). *
*/ DB.prototype.groupeval = function(parmsObj) { var groupFunction = function() { var parms = args[0]; var c = db[parms.ns].find(parms.cond || {}); var map = new Map(); var pks = parms.key ? Object.keySet(parms.key) : null; var pkl = pks ? pks.length : 0; var key = {}; while (c.hasNext()) { var obj = c.next(); if (pks) { for (var i = 0; i < pkl; i++) { var k = pks[i]; key[k] = obj[k]; } } else { key = parms.$keyf(obj); } var aggObj = map.get(key); if (aggObj == null) { var newObj = Object.extend({}, key); // clone aggObj = Object.extend(newObj, parms.initial); map.put(key, aggObj); } parms.$reduce(obj, aggObj); } return map.values(); }; return this.eval(groupFunction, this._groupFixParms(parmsObj)); }; DB.prototype._groupFixParms = function(parmsObj) { var parms = Object.extend({}, parmsObj); if (parms.reduce) { parms.$reduce = parms.reduce; // must have $ to pass to db delete parms.reduce; } if (parms.keyf) { parms.$keyf = parms.keyf; delete parms.keyf; } return parms; }; DB.prototype.resetError = function() { return this.runCommand({reseterror: 1}); }; DB.prototype.forceError = function() { return this.runCommand({forceerror: 1}); }; DB.prototype.getLastError = function(w, wtimeout) { var res = this.getLastErrorObj(w, wtimeout); if (!res.ok) throw _getErrorWithCode(ret, "getlasterror failed: " + tojson(res)); return res.err; }; DB.prototype.getLastErrorObj = function(w, wtimeout, j) { var cmd = {getlasterror: 1}; if (w) { cmd.w = w; if (wtimeout) cmd.wtimeout = wtimeout; if (j != null) cmd.j = j; } var res = this.runCommand(cmd); if (!res.ok) throw _getErrorWithCode(res, "getlasterror failed: " + tojson(res)); return res; }; DB.prototype.getLastErrorCmd = DB.prototype.getLastErrorObj; DB.prototype._getCollectionInfosCommand = function( filter, nameOnly = false, authorizedCollections = false, options = {}) { filter = filter || {}; const cmd = { listCollections: 1, filter: filter, nameOnly: nameOnly, authorizedCollections: authorizedCollections }; const res = this.runCommand(Object.merge(cmd, options)); if (!res.ok) { throw _getErrorWithCode(res, "listCollections failed: " + tojson(res)); } return new DBCommandCursor(this, res).toArray().sort(compareOn("name")); }; DB.prototype._getCollectionInfosFromPrivileges = function() { let ret = this.runCommand({connectionStatus: 1, showPrivileges: 1}); if (!ret.ok) { throw _getErrorWithCode(res, "Failed to acquire collection information from privileges"); } // Parse apart collection information. let result = []; let privileges = ret.authInfo.authenticatedUserPrivileges; if (privileges === undefined) { return result; } privileges.forEach(privilege => { let resource = privilege.resource; if (resource === undefined) { return; } let db = resource.db; if (db === undefined || db !== this.getName()) { return; } let collection = resource.collection; if (collection === undefined || typeof collection !== "string" || collection === "") { return; } result.push({name: collection}); }); return result.sort(compareOn("name")); }; /** * Returns a list that contains the names and options of this database's collections, sorted * by collection name. An optional filter can be specified to match only collections with * certain metadata. */ DB.prototype.getCollectionInfos = function( filter, nameOnly = false, authorizedCollections = false) { try { return this._getCollectionInfosCommand(filter, nameOnly, authorizedCollections); } catch (ex) { if (ex.code !== ErrorCodes.Unauthorized) { // We cannot recover from this error, propagate it. throw ex; } // We may be able to compute a set of *some* collections which exist and we have access // to from our privileges. For this to work, the previous operation must have failed due // to authorization, we must be attempting to recover the names of our own collections, // and no filter can have been provided. if (nameOnly && authorizedCollections && Object.getOwnPropertyNames(filter).length === 0 && ex.code === ErrorCodes.Unauthorized) { print( "Warning: unable to run listCollections, attempting to approximate collection names by parsing connectionStatus"); return this._getCollectionInfosFromPrivileges(); } throw ex; } }; DB.prototype._getCollectionNamesInternal = function(options) { return this._getCollectionInfosCommand({}, true, true, options).map(function(infoObj) { return infoObj.name; }); }; /** * Returns this database's list of collection names in sorted order. */ DB.prototype.getCollectionNames = function() { return this._getCollectionNamesInternal({}); }; DB.prototype.tojson = function() { return this._name; }; DB.prototype.toString = function() { return this._name; }; DB.prototype.isMaster = function() { return this.runCommand("isMaster"); }; DB.prototype.hello = function() { return this.runCommand("hello"); }; var commandUnsupported = function(res) { return (!res.ok && (res.errmsg.startsWith("no such cmd") || res.errmsg.startsWith("no such command") || res.code === 59 /* CommandNotFound */)); }; DB.prototype.currentOp = function(arg) { var q = {}; if (arg) { if (typeof (arg) == "object") Object.extend(q, arg); else if (arg) q["$all"] = true; } var commandObj = {"currentOp": 1}; Object.extend(commandObj, q); var res = this.adminCommand(commandObj); if (commandUnsupported(res)) { // always send legacy currentOp with default (null) read preference (SERVER-17951) const session = this.getSession(); const readPreference = session.getOptions().getReadPreference(); try { session.getOptions().setReadPreference(null); res = this.getSiblingDB("admin").$cmd.sys.inprog.findOne(q); } finally { session.getOptions().setReadPreference(readPreference); } } return res; }; DB.prototype.currentOP = DB.prototype.currentOp; DB.prototype.killOp = function(op) { if (!op) throw Error("no opNum to kill specified"); var res = this.adminCommand({'killOp': 1, 'op': op}); if (commandUnsupported(res)) { // fall back for old servers const session = this.getSession(); const readPreference = session.getOptions().getReadPreference(); try { session.getOptions().setReadPreference(null); res = this.getSiblingDB("admin").$cmd.sys.killop.findOne({'op': op}); } finally { session.getOptions().setReadPreference(readPreference); } } return res; }; DB.prototype.killOP = DB.prototype.killOp; DB.tsToSeconds = function(x) { if (x.t && x.i) return x.t; return x / 4294967296; // low 32 bits are ordinal #s within a second }; /** Get a replication log information summary.This command is for the database/cloud administer and not applicable to most databases. It is only used with the local database. One might invoke from the JS shell:
use local db.getReplicationInfo();* @return Object timeSpan: time span of the oplog from start to end if secondary is more out * of date than that, it can't recover without a complete resync */ DB.prototype.getReplicationInfo = function() { var localdb = this.getSiblingDB("local"); var result = {}; var oplog; var localCollections = localdb.getCollectionNames(); if (localCollections.indexOf('oplog.rs') >= 0) { oplog = 'oplog.rs'; } else { result.errmsg = "replication not detected"; return result; } var ol = localdb.getCollection(oplog); var ol_stats = ol.stats(); if (ol_stats && ol_stats.maxSize) { result.logSizeMB = ol_stats.maxSize / (1024 * 1024); } else { result.errmsg = "Could not get stats for local." + oplog + " collection. " + "collstats returned: " + tojson(ol_stats); return result; } result.usedMB = ol_stats.size / (1024 * 1024); result.usedMB = Math.ceil(result.usedMB * 100) / 100; var firstc = ol.find().sort({$natural: 1}).limit(1); var lastc = ol.find().sort({$natural: -1}).limit(1); if (!firstc.hasNext() || !lastc.hasNext()) { result.errmsg = "objects not found in local.oplog.$main -- is this a new and empty db instance?"; result.oplogMainRowCount = ol.count(); return result; } var first = firstc.next(); var last = lastc.next(); var tfirst = first.ts; var tlast = last.ts; if (tfirst && tlast) { tfirst = DB.tsToSeconds(tfirst); tlast = DB.tsToSeconds(tlast); result.timeDiff = tlast - tfirst; result.timeDiffHours = Math.round(result.timeDiff / 36) / 100; result.tFirst = (new Date(tfirst * 1000)).toString(); result.tLast = (new Date(tlast * 1000)).toString(); result.now = Date(); } else { result.errmsg = "ts element not found in oplog objects"; } return result; }; DB.prototype.printReplicationInfo = function() { var result = this.getReplicationInfo(); if (result.errmsg) { var isMaster = this.isMaster(); if (isMaster.arbiterOnly) { print("cannot provide replication status from an arbiter."); return; } else if (!isMaster.ismaster) { print("this is a secondary, printing secondary replication info."); this.printSecondaryReplicationInfo(); return; } print(tojson(result)); return; } print("configured oplog size: " + result.logSizeMB + "MB"); print("log length start to end: " + result.timeDiff + "secs (" + result.timeDiffHours + "hrs)"); print("oplog first event time: " + result.tFirst); print("oplog last event time: " + result.tLast); print("now: " + result.now); }; DB.prototype.printSlaveReplicationInfo = function() { print( "WARNING: printSlaveReplicationInfo is deprecated and may be removed in the next major release. Please use printSecondaryReplicationInfo instead."); this.printSecondaryReplicationInfo(); }; DB.prototype.printSecondaryReplicationInfo = function() { var startOptimeDate = null; var primary = null; function getReplLag(st) { assert(startOptimeDate, "how could this be null (getReplLag startOptimeDate)"); print("\tsyncedTo: " + st.toString()); var ago = (startOptimeDate - st) / 1000; var hrs = Math.round(ago / 36) / 100; var suffix = ""; if (primary) { suffix = "primary "; } else { suffix = "freshest member (no primary available at the moment)"; } print("\t" + Math.round(ago) + " secs (" + hrs + " hrs) behind the " + suffix); } function getPrimary(members) { for (i in members) { var row = members[i]; if (row.state === 1) { return row; } } return null; } function printNodeReplicationInfo(node) { assert(node); if (node.state === 1 || node.state === 7) { // ignore primaries (1) and arbiters (7) return; } print("source: " + node.name); if (node.optime && node.health != 0) { getReplLag(node.optimeDate); } else { print("\tno replication info, yet. State: " + node.stateStr); } } function printNodeInitialSyncInfo(syncSourceString, remainingMillis) { print("\tInitialSyncSyncSource: " + syncSourceString); let minutes = Math.floor((remainingMillis / (1000 * 60)) % 60); let hours = Math.floor(remainingMillis / (1000 * 60 * 60)); print("\tInitialSyncRemainingEstimatedDuration: " + hours + " hour(s) " + minutes + " minute(s)"); } var L = this.getSiblingDB("local"); if (L.system.replset.count() != 0) { const status = this.getSiblingDB('admin')._runCommandWithoutApiStrict({'replSetGetStatus': 1}); primary = getPrimary(status.members); if (primary) { startOptimeDate = primary.optimeDate; } // no primary, find the most recent op among all members else { startOptimeDate = new Date(0, 0); for (i in status.members) { if (status.members[i].optimeDate > startOptimeDate) { startOptimeDate = status.members[i].optimeDate; } } } for (i in status.members) { if (status.members[i].self && status.members[i].state === 5) { print("source: " + status.members[i].name); if (!status.initialSyncStatus) { print("InitialSyncStatus information not found"); continue; } // Print initial sync info if node is in the STARTUP2 state. printNodeInitialSyncInfo( status.members[i].syncSourceHost, status.initialSyncStatus.remainingInitialSyncEstimatedMillis); } else { printNodeReplicationInfo(status.members[i]); } } } }; DB.prototype.serverBuildInfo = function() { return this.getSiblingDB("admin")._runCommandWithoutApiStrict({buildinfo: 1}); }; // Used to trim entries from the metrics.commands that have never been executed getActiveCommands = function(tree) { var result = {}; for (var i in tree) { if (!tree.hasOwnProperty(i)) continue; if (tree[i].hasOwnProperty("total")) { if (tree[i].total > 0) { result[i] = tree[i]; } continue; } if (i == "