Questions tagged [mongodb-3.6]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
182 views

How to warm a MongoDB index

We're running a huge MongoDB with a large index (made of of four fields) which was created ad-hoc and should now be superseded by slimmer one (of the first two fields). But the problem is we can't ...
user avatar
1 vote
1 answer
238 views

Shell Script to kill slow running Mongo Queries

I need to create a shell script that finds and kills long running mongo queries more than a specified threshold e.g. 15sec I plan to use db.currentOp(); and db.killOp(); to find and kill queries but I ...
user avatar
  • 69
1 vote
0 answers
334 views

How to simulate slow queries on MongoDB

I need to write a shell script that finds and kills long running mongodb queries, but I don't have access to the database that runs slow queries, how to I simulate running slow queries on my local ...
user avatar
  • 69
0 votes
1 answer
600 views

MongoDB Aggregate Poor Index Usage

I've been trying to understand the MongoDB Aggregate process so I can better optimize my queries and I'm confused by usage and $match and $sort together. Sample DB has only one collection people [{ ...
user avatar
0 votes
0 answers
59 views

Appropriate language to write a Script that Kills Long running query MongoDB

I want to create a script that kills queries when they reach specific time threshold, I will be using db.currentOp() method to get information about currently running queries, and use db.killOp to ...
user avatar
  • 69
0 votes
0 answers
143 views

MongoDB 3.6.21 crash and not reIndex

I try to reIndex() my collection but not working and It removed all indexes. I checked mongod.log and see: 2021-01-18T05:56:59.492-0600 E STORAGE [conn1] WiredTiger error (5) [1610971019:492802][...
user avatar
  • 101
0 votes
0 answers
26 views

MongoDB 3.6 fresh install

I'm using mongodb 3.6.18 I'm running a cluster of 2 shards and 1 config replicaset. I get this error when trying to set the compatibility version to 3.6: global:PRIMARY> db.adminCommand( { ...
user avatar
3 votes
0 answers
1k views

MongoDump Failed: error writing data for collection `collection` to disk: error reading collection: EOF

[BACKUP COMMAND] mongodump --host 127.0.0.1 -d database --port 27017 --username username --password password --out /output/path/mongodump_DATE_12_00_AM [ISSUE] Failed: error writing data for ...
user avatar
  • 31
1 vote
1 answer
2k views

Cannot restart or repair mongodb database after the crash (***aborting after invariant() failure) [closed]

After an unexpected crash, I can't restart or --repair the mongodb database anymore. While restarting the server with systemctl restart mongodb I am getting the following: 2020-09-16T20:25:23.835+...
user avatar
  • 113
-1 votes
1 answer
279 views

Migrate data from an older version of mongodb

How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical. We've tried by making a straight copy ...
user avatar
0 votes
1 answer
2k views

how to run db.adminCommand() using pymongo for mongodb 3.6

I want to run this command and get it's output using pymongo module. db.adminCommand({getParameter: 1, logLevel: 1}) or say I want to run this command db.adminCommand( { setParameter: 1, ...
user avatar
0 votes
0 answers
38 views

Migrate MongoDB 2.4.14 to MongoDB 3.6 [duplicate]

I have a database with MongoDB 2.4.14 and I want to migrate the database to MongoDB 3.6. Note: the file is original from the db path. Not from mongodump. This process is messy as it requires doing ...
user avatar
1 vote
1 answer
641 views

Restoring from MongoDB Atlas (4.2.5) to DocumentDB (3.6) do no succeed due to error "Unsupported BSON : type Decimal128"

MongoDB Atlas (4.2.5) to DocumentDB (3.6) Below is the command I used for mongodump on my MongoDB shell. I had received a warning, but it was successfully completed. C:\MongoDB\bin>mongodump --...
user avatar
  • 121
0 votes
1 answer
77 views

Chunk size bigger than configured

We have a sharded mongo cluster. We have configured the chunk size to be 256M but they are ~1.5G each. There are no jumbo chunks as our shard key is well balanced (we have also checked for them ...
user avatar
  • 101
0 votes
1 answer
709 views

How to use mongoexport command with ssl?

I am trying to export collection data from (SSL MongoDB 4.x), for this I am running below command on linux terminal. Earlier I used mongoexport command in Linux terminal without SSL which works ...
user avatar
  • 101
0 votes
1 answer
883 views

Mongo E11000 duplicate key error collection after mongo 3.4 to 3.6 upgrade

I have a Mongo replica set on Ubuntu with three members configured for my information system and am having issues when I try to upgrade MongoDB from version 3.4 to 3.6 After setting the "...
user avatar
  • 1
0 votes
1 answer
245 views

Can't migrate standalone MongoDB to Cluster

I'm trying to convert a standalone MongoDB database into a cluster in order to migrate my database to MongoDB Atlas. I've followed the following steps to try and convert it: Stop my mongodb instance ...
user avatar
0 votes
1 answer
337 views

We use MongoDB 3.6 community version, How can i get the number of hits on single collection as well as bandwith usage?

Is it possible to get the number of hits on single collection as well as bandwith usage in mongodb ?
user avatar
1 vote
0 answers
339 views

Why did mongoDB reads from disk into cache suddenly increase?

This is a mongoDB replica set with 1 primary, 1 secondary and 1 arbiter. Suddenly the reads from disk into cache and cache page evictions increased 2x-3x and stay elevated since then (all metrics ...
user avatar
  • 121
1 vote
0 answers
2k views

MongoDB replica set Network Interface exceeded time limit

I am using MongoDB version 3.6.12 and saw one of running secondary node keeps getting this error from log: 2019-09-23T12:24:48.921-0400 I REPL [replication-791] Restarting oplog query due to ...
user avatar
  • 21
0 votes
2 answers
2k views

MongoDB Replica Set InitialSyncOplogSourceMissing error

I am setting up a 3 nodes MongoDB replica set with one node in AWS using Mongo 3.6.12. There are about 400GB data need to sync to secondary nodes. Initial sync starts fine. However, after data sync ...
user avatar
  • 21
2 votes
1 answer
7k views

Converting MongoDB instance from Standalone to Replica Set and Backing Up

I want to convert my MongoDB 3.6 standalone server to a replica set so I can watch a collection using change streams, which requires an oplog. I only want to use change streams so will keep this as a ...
user avatar
  • 23
0 votes
1 answer
2k views

mongodb - Replica set creation error: Quorum check failed because not enough voting nodes responded

I am configuring a mongodb replica set. From my current primary node, when rs.add('host1:27017'), it yields this error Quorum check failed because not enough voting nodes responded; required 2 but ...
user avatar
  • 119
0 votes
0 answers
514 views

How to delete a user in MongoDB 3.6

I was in trouble with deleting the users in mongodb3.6. I created a user with: db.createUser({ user: "username" , pwd: "password", roles: ["root"]}) And I deleted it with: db.dropUser("username") ...
user avatar
0 votes
1 answer
438 views

Slow performance of query with $and & $or operators

My query with $and, $or operators is performing poorly. Even though I've built a compound index on all three fields that are specified in my query criteria, the query does a complete collection scan. ...
user avatar
  • 7
0 votes
1 answer
38 views

Why a query is not covered when using a range operator on documents?

I have created the following 1000 documents: for(i=0;i<1000;i++){db.doc.insert({"doc":{"k1":"v_"+i,"k2":i},"scal":i})} So a document looks like this: var d1 = db.doc.findOne() { "_id" : ...
user avatar
  • 211
0 votes
1 answer
119 views

Mongo Memory management

I had a few questions If there is sufficient RAM, does Mongo load entire collection into memory? Suppose I had two collections A & B and I know that there is not enough RAM to hold both - and if ...
user avatar
  • 125
0 votes
1 answer
1k views

Is it possible to retrieve a history of the remote connections to the MongoDB including the IP addresses and the executed commands?

For some reasons I disabled the user access control and somehow all collections have been wiped out. So I want an activity log to find out how this happened I need a list like this: | Date/Time ...
user avatar
  • 1
3 votes
1 answer
8k views

Why $group is very slow in aggregation and how can faster it in MongoDB [closed]

My query is taking ~3 seconds to execute with the $group stage, How can I faster this? My query is: db.getCollection('employee_data').aggregate([ { $match: //Filter }, { $group: { ...
user avatar
1 vote
1 answer
249 views

Import indexes from MongoDB v2.4 to MonDB v3.6.4

I have migrated the collection.bson file from MongoDB 2.4 to MongoDB 3.6.4 as collection.json. But their is 1 more file collection.metadata.json in MongoDB 2.4. How can I import this to MongoDB 3....
user avatar
0 votes
2 answers
3k views

MongoDB CSV Export: One Array/Column & Array Index on rows, or vice versa

I have a MongoDB schema that looks like this: const batchSchema = mongoose.Schema({ _id: mongoose.Schema.Types.ObjectId, time: {type: [Number]}, tmp: {type: [Number]}, hum: {type: [Number]}, ...
user avatar
0 votes
1 answer
1k views

MongoDB, Getting Started and Connecting with Compass

I'm trying to connect to my mongoDB running as a service on my rPi3B+, using openSuse Tumbleweed 64bit, mongo version 3.6.2, from my laptop sharing the same LAN/Wifi (pi on LAN & laptop on Wifi). ...
user avatar
1 vote
2 answers
888 views

I am trying to achieve a Disaster recovery for Mongo DB

Right now i have a MongoDb HA in site one and i need another site with asynchronous replication enables in another location.This is a base plan of mine to achieve a disaster recovery . I dont have ...
user avatar
0 votes
1 answer
3k views

MongoDB 3.6 crashed due to invariant() failure

MongoDB crashed twice in 6 hours today due to invariant() failure. We have been using MongoDB 3.6.3 for more than a year now, but this is the first time that we saw this issue. The extract from the ...
user avatar
3 votes
2 answers
5k views

MongoDB does not allow to create unique partial index in field that contains null

I'm using MongoDB 3.6.9 (with Ubuntu) to save a set of documents that contain one field named rss_id and for some documents, this field has the value null. I want to create a unique index in that ...
user avatar
  • 139
1 vote
1 answer
298 views

No output when use pymongo watch()

I try to access real-time data changes with pymongo.mongo_client.MongoClient.watch(), code example (Python 3.5.3, pymongo==3.7.2): from pymongo import MongoClient DB_CON_STR = "mongodb://10.10.10....
user avatar
0 votes
1 answer
1k views

Why am I seeing these mongodb 3.6.5 server log messages in huge amounts?

Could someone please shed some light on these mongodb 3.6.5 server log messages on the primary node of a 3-member replicaset? rs.status() says all the nodes are up and running but seeing a ton of (I)...
user avatar
0 votes
1 answer
55 views

mongodb array query woes

I am struggling with array matching and getting multiple records back. "players" : [ { "pname" : "player_4", "loc" : [ -2.2, 1, 0] }, { "pname" : "player_2", ...
user avatar
  • 1
1 vote
2 answers
591 views

Is it possible to run an arbiter on a machine that also hosts a secondary member?

I have two machines (it is a restriction) configured as a replica set with MongoDB 3.6.5. Is it possible to run an arbiter on a machine that also hosts a secondary member? Even if it is not ...
user avatar
0 votes
1 answer
319 views

Replica Set Oplog Maxsize

I have two databases (Mongodb 3.6.5) using ReplicaSet, when I made a split in the network, I am forcing the secondary database to be the primary. cfg = rs.conf() cfg.members[0].votes = 0 cfg.members[...
user avatar
0 votes
1 answer
179 views

How to solve replication in MongoDB only with two machines?

I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary. ...
user avatar
0 votes
1 answer
5k views

mongodb - what roles the user to grant access to all databases

I have created mongouser as testuser with below roles. I want to give access for new databases for this user. what roles the user to grant access to all databases. db.createUser({ user: "testuser" , ...
user avatar
1 vote
0 answers
51 views

Changing collection path and index path in mongod.conf file

I want to have collection path and index path in different folders of my mongodb. What are the required changes? My current configuration file is this: storage: dbPath: /db/mongodb journal: ...
user avatar
3 votes
1 answer
7k views

Not authorized on admin to execute command mongoDB: Atlas M0 Free Tier cluster

My MongoDB shell has version v3.6.5 (the same with older versions) & MongoDB server has version: 3.6.8 I have MongoDB M0 Free Tier cluster and I want to use from shell different commands. So, I ...
user avatar
  • 227
1 vote
0 answers
282 views

timeout while dropping database - MongoDB

Getting time out issue while dropping database from mongoDB. Database size is around 200GB. {          "code" : 46,          "ok" : 0,          "errmsg" : "timed out waiting for DBNAME....
user avatar
2 votes
0 answers
593 views

getIndexes returns empty array on MongoDB collection

I'm trying creating indexes on a MongoDB collection and while they are correctly created and they work (I can see the index in the executionStats), the output of the getIndexes() function is an empty ...
user avatar
0 votes
1 answer
797 views

Query sharded collection returns all the results from the primary shard AND from the other shards

I tried to set up a shard to test this functionality and maybe migrate some of our data into it. I followed the documentation guide https://docs.mongodb.com/v3.4/tutorial/convert-replica-set-to-...
user avatar
  • 13
0 votes
1 answer
108 views

dokku-mongo Export Database Error

dokku-mongo export Database command is showing error "This does not look like a tar archive" $ ssh svuser@dbexample.com $ dokku mongo:export database > backup.tar $ tar -xfv backup.tar tar: This ...
user avatar
0 votes
1 answer
277 views

unable to add a range to a tag using sh.addTagRange command

Have setup a 4 node test shard cluster: 1- mongos 1- config server 2- shard nodes hosting 1 shard each for a collection. Cluster is working perfectly, but when trying to run the following command: ...
user avatar
  • 1
0 votes
1 answer
631 views

Mongo doesn't restore user password

I have following scenario: Dump Mongo database (cmd mongodump) Change password from one of admin users Restore Mongo database (cmd mongorestore) EDIT: I use following command for db dump: ...
user avatar
  • 11