Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

how to convert mongodb db.currentOp() into json

J
jules last edited by

I want to create an interface for all running processes in Mongodb

How can I convert mongodb db.currentOp() output into json so that I can access that

The output currently is a BSON string and I cannot use any libraries that use json ... which would become convenient to develop an interface
Reply Quote 0
1 Reply Last reply
N
Nykeriab last edited by
I suspect the problem you are referring to is results returned in a MongoDB shell environment which use JavaScript helper syntax like ISODate() that is not compatible with JSON.

If so, the solution is to convert shell output into https://www.mongodb.com/docs/manual/reference/mongodb-extended-json/ which has JSON-compatible representations of all https://www.mongodb.com/docs/manual/reference/bson-types/ .

For example, using mongosh:
```
test> dt = new Date()
ISODate("2022-05-06T10:51:23.454Z")
test> EJSON.stringify(dt)

{"$date":"2022-05-06T10:51:23.454Z"}
```
If you want to convert db.currentOp() output into Extended JSON for use with standard libraries:

mongosh --eval "EJSON.stringify(db.currentOp())" --quiet

The --quiet option suppresses startup messages (for example, version info or startup warnings) so output should only include results of the --eval call.
Reply Quote 0
1 Reply Last reply

mongodb 3795

2
Posts

0
Views

Suggested Topics

MongoDb $regex fails when searching for numbers
Software Programming • mongodb regex • • Bogopo

2

0
Votes

2
Posts

0
Views

A

Try this:db.users.find({$where: "/13/i.test(this.account)"}); You can review this link https://stackoverflow.com/questions/2908100/mongodb-regex-search-on-integer-value
You can use node. js in the cpanel?
Software Programming • mongodb node. js c languagepanel • • jeanid

2

0
Votes

2
Posts

0
Views

T

Yes, but you need to request that they install the node. js, because the mariaDB by default already comes, here is a company that does it, I have already used it https://www.argohost.net/
converting mysql datebase
SQL, Database Testing • mysql collation • • inna

2

0
Votes

2
Posts

0
Views

R

Check This answer: change database, table and column collation https://stackoverflow.com/questions/5906585/change-database-collation
O

Do we need to shutdown DB/Stop DB service before Windows server patching
SQL, Database Testing • windows mongodb patc languagehing • • Oba22

2

0
Votes

2
Posts

0
Views

R

To upgrade a replicaset, please follow MongoDB upgrade process. Here's a quick summary: upgrade all secondary nodes - if necessary check if everything's working properly stepDown and upgrade the primary node set the setFeatureCompatibilityVersion to the version matching your upgrade
T

RegEx bug in MongoDB
SQL, Database Testing • mongodb regular expression • • tahishae

2

0
Votes

2
Posts

0
Views

O

There are multiple issues here: First, your console queries work fine in MongoDB v2.0.2 but don't work in MongoDB v2.2.1. This is probably a regression bug, but the JavaScript parser may have intentionally been changed between versions. The ... after entering a command means the console is waiting for a multi-line command to be completed; I'm not sure why in this specific situation. Also, the backslash character \ in the $regex string must itself be escaped. (The JavaScript parser consumes the escape first, before the regex engine gets to see it.) > db.test.find({word:{$regex:"["}}); // no result > db.test.find({word:{$regex:"\["}}); // returns result when escaped properly { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } MongoDB 2.0.2 console output: > db.test.drop(); version() version: 2.0.2 > > db.test.insert({_id: 0, word: '['}); > db.test.insert({_id: 1, word: '[]'}); > db.test.insert({_id: 2, word: ']'}); > db.test.insert({_id: 9, word: 'no brackets'}); > > db.test.find({word:/[[]/}); // could not be run in console { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } > db.test.find({word:/[/ }); // could not be run in console { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } > db.test.find({word:/]/}); //returns result { "_id" : 1, "word" : "[]" } { "_id" : 2, "word" : "]" } > db.test.find({word:/[\]]/}); //returns result { "_id" : 1, "word" : "[]" } { "_id" : 2, "word" : "]" } > db.test.find({word:{$regex:"["}}); //no result > db.test.find({word:{$regex:"\["}}); //returns result when escaped properly { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } > db.test.find({word:{$regex:"\[[]"}}); //returns result { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } MongoDB 2.2.1 console output: > db.test.drop(); version() version: 2.2.1 > > db.test.insert({_id: 0, word: '['}); > db.test.insert({_id: 1, word: '[]'}); > db.test.insert({_id: 2, word: ']'}); > db.test.insert({_id: 9, word: 'no brackets'}); > > db.test.find({word:/[[]/}); // could not be run in console ... db.test.find({word:/[/ }); // could not be run in console ... db.test.find({word:/]/}); // returns result ... db.test.find({word:/[\]]/}); // returns result { "_id" : 1, "word" : "[]" } { "_id" : 2, "word" : "]" } > db.test.find({word:{$regex:"["}}); // no result > db.test.find({word:{$regex:"\["}}); // returns result when escaped properly { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } > db.test.find({word:{$regex:"\[[]"}}); // returns result MongoDB 2.2.1 console output (commented out lines that don't parse as expected): > db.test.drop(); version() version: 2.2.1 > > db.test.insert({_id: 0, word: '['}); > db.test.insert({_id: 1, word: '[]'}); > db.test.insert({_id: 2, word: ']'}); > db.test.insert({_id: 9, word: 'no brackets'}); > > // db.test.find({word:/[[]/}); // could not be run in console > // db.test.find({word:/[/ }); // could not be run in console > db.test.find({word:/]/}); // returns result { "_id" : 1, "word" : "[]" } { "_id" : 2, "word" : "]" } > db.test.find({word:/[\]]/}); // returns result { "_id" : 1, "word" : "[]" } { "_id" : 2, "word" : "]" } > db.test.find({word:{$regex:"["}}); // no result > db.test.find({word:{$regex:"\["}}); // returns result when escaped properly { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } > db.test.find({word:{$regex:"\[[]"}}); // returns result { "_id" : 0, "word" : "[" } { "_id" : 1, "word" : "[]" } >
A

Does mongo *really* need a dedicated volume, if I need to back it up?
SQL, Database Testing • mongodb backup debian automation • • amarantha

2

0
Votes

2
Posts

0
Views

K

Yes, hot snapshot is easy and fast way to do backup... But of course there is also mongodump. Here is my crontab entry. Every hour, overriding current date backup. SHELL=/bin/bash DATEVAR=date +%d 31 * * * * /usr/bin/mongodump --host localhost -o /dbdata/dump$($DATEVAR) --gzip --oplog >> /dev/null 2>&1
E

Install MongoDB on Debian
SQL, Database Testing • mongodb installation debian mongodb 3.0 • • emerson

2

0
Votes

2
Posts

0
Views

To install specific version of mongodb you need to follow certain steps documented on MongoDB site: In my opinion it includes: sudo apt-get install -y mongodb-org=3.0.1 mongodb-org-server=3.0.1 mongodb-org-shell=3.0.1 mongodb-org-mongos=3.0.1 mongodb-org-tools=3.0.1 You can opt for packages by omitting it from above list. You can find detailed document here
D

ReplicaSet MongoDB
SQL, Database Testing • mongodb replication nosql • • derk

2

0
Votes

2
Posts

0
Views

S

I had similar issue, and the reason was connected than mongo was using my pc name instead of localhost.. start mongoD and search for this string: 2016-03-07T16:01:05.777+0000 I CONTROL [initandlisten] MongoDB starting : pid=26176 port=27017 dbpath=G:\data\db\ 64-bit host=MyLaptop So I had to switch from localhost to mylaptop in config please valid form of config var config={_id:"amir", "version" : 1, members:[ {_id:0,host:"localhost:27017"}, {_id:1,host:"localhost:27018"}, {_id:2,host:"localhost:27019"}] };
Z

Write Locks in Mongo DB
SQL, Database Testing • mongodb • • zymir

2

0
Votes

2
Posts

0
Views

C

Your interpretation matches the "How granular are locks in MongoDB?" part in MongoDB FAQ: How granular are locks in MongoDB? Beginning with version 2.2, MongoDB implements locks on a per-database basis for most read and write operations. Some global operations, typically short lived operations involving multiple databases, still require a global “instance” wide lock. Before 2.2, there is only one “global” lock per mongod instance. For example, if you have six databases and one takes a write lock, the other five are still available for read and write. As for the way the locking works: What type of locking does MongoDB use? MongoDB uses a readers-writer [ed: also known as “multi-reader” or “shared exclusive”] lock that allows concurrent reads access to a database but gives exclusive access to a single write operation. When a read lock exists, many read operations may use this lock. However, when a write lock exists, a single write operation holds the lock exclusively, and no other read or write operations may share the lock. Locks are “writer greedy,” which means writes have preference over reads. When both a read and write are waiting for a lock, MongoDB grants the lock to the write.
Mongodb creating historical cluster replicaset
SQL, Database Testing • mongodb replication mongodb 3.4 • • Marcee

2

0
Votes

2
Posts

0
Views

E

MongoDB does not (as at 4.0) have a supported feature or tool for selective replication or syncing between two distinct deployments. I would recommend upgrading from 3.4 to a newer version of MongoDB (ideally 4.0) and building a sync solution using the Change Streams API. You can choose which events to replicate to a historical archive or deployment based on the event type, namespace, or other criteria. Change streams are available for replica sets and sharded clusters using the WiredTiger storage engine and replication protocol version 1. MongoDB 3.6 is the first version to add the Change Streams API and includes support for watching individual collections. In MongoDB 4.0 the change stream support was extended to enable watching all non-system collection changes at a database or deployment scope. If you are unable to upgrade from MongoDB 3.4 in the near future, you could also consider the approach of directly tailing the replication oplog. This would be a less robust solution than the Change Streams API, but there are some third party tools such as mongo-connector that may be helpful. The Change Streams API also uses the oplog but adds a supported API, only includes majority-committed operations (that won't rollback), and scales to support sharded clusters. The oplog format is internal and subject to change between releases of MongoDB.
K

MongoDB using too much memory
SQL, Database Testing • mongodb memory wiredtiger • • kalena

2

0
Votes

2
Posts

0
Views

K

Okay, so after following the clues given by loicmathieu and jstell, and digging it up a little, these are the things I found out about MongoDB using WiredTiger storage engine. I'm putting it here if anyone encountered the same questions. The memory usage threads that I mentioned, all belonged to 2012-2014, all pre-date WiredTiger and are describing behavior of the original MMAPV1 storage engine which doesn't have a separate cache or support for compression. The WiredTiger cache settings only controls the size of memory directly used by the WiredTiger storage engine (not the total memory used by mongod). Many other things are potentially taking memory in a MongoDB/WiredTiger configuration, such as the following: WiredTiger compresses disk storage, but the data in memory are uncompressed. WiredTiger by default does not fsync the data on each commit, so the log files are also in RAM which takes its toll on memory. It's also mentioned that in order to use I/O efficiently, WiredTiger chunks I/O requests (cache misses) together, that also seems to take some RAM (In fact dirty pages (pages that has changed/updated) have a list of updates on them stored in a Concurrent SkipList). WiredTiger keeps multiple versions of records in its cache (Multi Version Concurrency Control, read operations access the last committed version before their operation). WiredTiger Keeps checksums of the data in cache. MongoDB itself consumes memory to handle open connections, aggregations, serverside code and etc. Considering these facts, relying on show dbs; was not technically correct, since it only shows the compressed size of the datasets. The following commands can be used in order to get the full dataset size. db.getSiblingDB('data_server').stats() # OR db.stats() This results is the following: { "db" : "data_server", "collections" : 11, "objects" : 266565289, "avgObjSize" : 224.8413545621088, "dataSize" : 59934900658, # 60GBs "storageSize" : 22959984640, "numExtents" : 0, "indexes" : 41, "indexSize" : 7757348864, # 7.7GBs "ok" : 1 } So it seems that the actual dataset size + its indexes are taking about 68GBs of that memory. Considering all these, I guess the memory usage is now pretty expected, good part being it's completely okay to limit the WiredTiger cache size, since it handles I/O operations pretty efficiently (as described above). There also remains the problem of OOM, to overcome this issue, since we didn't have enough resources to take out mongodb, we lowered the oom_score_adj to prevent OOM from killing important processes for the time being (Meaning we told OOM not to kill our desired processes).
R

Switching from 2 large collections to multiple small ones in MongoDB 3.4
SQL, Database Testing • mongodb mongodb 3.4 • • Rossere

2

0
Votes

2
Posts

0
Views

J

Multiple small collections will take more space than few big collections. Depending on amount of memory, big collections indexes are more effective than large amount of indexes of small collections.
Y

Which version of linux OS has support for MongoDB installation?
SQL, Database Testing • linux ubuntu mongodb installation • • yajahira

2

0
Votes

2
Posts

0
Views

O

You should be able to easily install on most (if not all) flavours of x86-based Linux distributions. There are officially packaged versions for: Ubuntu Debian RPM (Redhat, CentOS, Fedora, Amazon Linux) You can also install from tarball, or check if there are packages available in the "ports" equivalent for your distribution.
MariaDB: granting access to a DB before creating the DB
SQL, Database Testing • mariadb permissions • • briley

2

0
Votes

2
Posts

0
Views

G

I think I have the answer: it works. I leave it here just in case someone else run into the same doubt. Here is an example: D:\xampp\mysql\bin>mysql.exe -uroot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 6 Server version: 10.1.13-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CREATE USER foo2@localhost IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> GRANT SELECT, UPDATE, DELETE ON DBtest.* TO foo2@localhost; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> select host, user, password from mysql.user; +-----------+------+-------------------------------------------+ | host | user | password | +-----------+------+-------------------------------------------+ | localhost | root | | | 127.0.0.1 | root | | | ::1 | root | | | localhost | | | | localhost | pma | | | localhost | foo2 | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | +-----------+------+-------------------------------------------+ 6 rows in set (0.00 sec) MariaDB [(none)]> CREATE DATABASE DBtest CHARACTER SET utf8; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use DBtest; Database changed MariaDB [DBtest]> CREATE TABLE t1 (a int, b int); Query OK, 0 rows affected (0.23 sec) MariaDB [DBtest]> quit; Bye D:\xampp\mysql\bin>mysql.exe -ufoo2 -p Enter password: ******** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 7 Server version: 10.1.13-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use DBtest; Database changed MariaDB [DBtest]> show tables; +------------------+ | Tables_in_dbtest | +------------------+ | t1 | +------------------+ 1 row in set (0.00 sec) MariaDB [DBtest]> select * from t1; Empty set (0.00 sec) MariaDB [DBtest]> INSERT INTO t1 (a, b) VALUES (23, 23); ERROR 1142 (42000): INSERT command denied to user 'foo2'@'localhost' for table ' t1' MariaDB [DBtest]> The user can work in the specified DB, with the granted rights, even if it was created (and granted its rights) before the DB was created.
K

unable to aggregate and group by on one particular field
SQL, Database Testing • mongodb aggregate • • kalyn

2

0
Votes

2
Posts

0
Views

O

Make it short and simple: db.reportgraphs.aggregate([ { $match:{ d:{$gte:new Date("2001-01-01T00:00:00.000Z"), $lt:new Date()}, bId: ObjectId("5fc151b2c123574e0f835da4") } }, { $set: { yr:{"$year":"$d"}, mt:{"$month":"$d"}, dy:{"$dayOfMonth":"$d"}, h:{"$hour":"$d"}, m:{"$minute":"$d"}, } }, { $group: { "_id": {"yr": "$yr", "mt": "$mt", "dy": "$dy", "h": "$h", "m": "$m", "bId": "$bId", "cId": "$cId"}, "vs": { "$avg": "$vs"}, "vi": { "$avg": "$vi"}, "c": { "$avg": "$c"}, "tc": { "$avg": "$tc"}, "td": { "$avg": "$td"}, "ts": { "$avg": "$ts"}, }, }, ]);

how to convert mongodb db.currentOp() into json

Suggested Topics

MongoDb $regex fails when searching for numbers Software Programming • mongodb regex • • Bogopo

You can use node. js in the cpanel? Software Programming • mongodb node. js c languagepanel • • jeanid

converting mysql datebase SQL, Database Testing • mysql collation • • inna

Do we need to shutdown DB/Stop DB service before Windows server patching SQL, Database Testing • windows mongodb patc languagehing • • Oba22

RegEx bug in MongoDB SQL, Database Testing • mongodb regular expression • • tahishae

Does mongo *really* need a dedicated volume, if I need to back it up? SQL, Database Testing • mongodb backup debian automation • • amarantha

Install MongoDB on Debian SQL, Database Testing • mongodb installation debian mongodb 3.0 • • emerson

ReplicaSet MongoDB SQL, Database Testing • mongodb replication nosql • • derk

Write Locks in Mongo DB SQL, Database Testing • mongodb • • zymir

Mongodb creating historical cluster replicaset SQL, Database Testing • mongodb replication mongodb 3.4 • • Marcee

MongoDB using too much memory SQL, Database Testing • mongodb memory wiredtiger • • kalena

Switching from 2 large collections to multiple small ones in MongoDB 3.4 SQL, Database Testing • mongodb mongodb 3.4 • • Rossere

Which version of linux OS has support for MongoDB installation? SQL, Database Testing • linux ubuntu mongodb installation • • yajahira

MariaDB: granting access to a DB before creating the DB SQL, Database Testing • mariadb permissions • • briley

unable to aggregate and group by on one particular field SQL, Database Testing • mongodb aggregate • • kalyn

MongoDb $regex fails when searching for numbers
Software Programming • mongodb regex • • Bogopo

You can use node. js in the cpanel?
Software Programming • mongodb node. js c languagepanel • • jeanid

converting mysql datebase
SQL, Database Testing • mysql collation • • inna

Do we need to shutdown DB/Stop DB service before Windows server patching
SQL, Database Testing • windows mongodb patc languagehing • • Oba22

RegEx bug in MongoDB
SQL, Database Testing • mongodb regular expression • • tahishae

Does mongo really need a dedicated volume, if I need to back it up?
SQL, Database Testing • mongodb backup debian automation • • amarantha

Install MongoDB on Debian
SQL, Database Testing • mongodb installation debian mongodb 3.0 • • emerson

ReplicaSet MongoDB
SQL, Database Testing • mongodb replication nosql • • derk

Write Locks in Mongo DB
SQL, Database Testing • mongodb • • zymir

Mongodb creating historical cluster replicaset
SQL, Database Testing • mongodb replication mongodb 3.4 • • Marcee

MongoDB using too much memory
SQL, Database Testing • mongodb memory wiredtiger • • kalena

Switching from 2 large collections to multiple small ones in MongoDB 3.4
SQL, Database Testing • mongodb mongodb 3.4 • • Rossere

Which version of linux OS has support for MongoDB installation?
SQL, Database Testing • linux ubuntu mongodb installation • • yajahira

MariaDB: granting access to a DB before creating the DB
SQL, Database Testing • mariadb permissions • • briley

unable to aggregate and group by on one particular field
SQL, Database Testing • mongodb aggregate • • kalyn