Questions tagged [mongodb-3.6]
The mongodb-3.6 tag has no usage guidance.
75
questions
1
vote
0answers
8 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 ...
0
votes
0answers
10 views
How to add calculated value as a field into an existed array of sub document using MongodB aggregation
I'm working on MongoDB and I have a document like below structure. I am trying to calculate total services cost and each services lane cost. Here services are sub document.
My document structure:
{
...
0
votes
0answers
35 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")
...
0
votes
1answer
25 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. ...
0
votes
1answer
27 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" : ...
0
votes
1answer
11 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 ...
0
votes
1answer
20 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 ...
1
vote
1answer
34 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:
{
...
1
vote
1answer
38 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....
1
vote
2answers
151 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]},
...
0
votes
0answers
5 views
mongodb autinticationDatabase issue
I have already authenticationDatabase enabled on my MongoDB. Now I want to disable the authenticationDatabase for my MongoDB.
I have removed the --auth from the mongod.system file. After restart the ...
0
votes
1answer
312 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).
...
0
votes
1answer
30 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 ...
0
votes
1answer
246 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 ...
1
vote
1answer
191 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 ...
1
vote
1answer
59 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....
0
votes
1answer
77 views
MongoDB 3.6, adding replica set always fails as on production setup with cannot open /dev/urandom Too many open files
I am trying on add a 3.6 mongoDB node to a 3 member replica set running 3.4. Doing this as a part of DB upgrade from 3.4 to 3.6. When I add the new member to replica set, it goes to STARTUP2, data ...
0
votes
1answer
110 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)...
0
votes
1answer
49 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",
...
1
vote
2answers
66 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 ...
0
votes
1answer
46 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[...
0
votes
1answer
69 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.
...
0
votes
1answer
688 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" , ...
3
votes
1answer
267 views
MongoDB Facet Error pipeline requires text score metadata, but there is no text score available
I created a mongodb faceted pipeline that the following is a subset of:
db.books.aggregate( [
{
$facet: {
"categories": [
{
$match: {
$text:...
1
vote
0answers
31 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:
...
2
votes
1answer
1k 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 ...
1
vote
0answers
97 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....
2
votes
0answers
218 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 ...
0
votes
1answer
332 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-...
0
votes
1answer
61 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 ...
0
votes
1answer
98 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:
...
0
votes
1answer
186 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:
...
1
vote
0answers
22 views
How to do a find query on the result of another find query?
I'm working with MongoDB because the company where I work is doing a migration from pSQL. We have reports with filters: first the report lets you select a range of dates by year and month, then you ...
1
vote
0answers
165 views
It is possible to take incremental backup in mongoDB Shard cluster? without opsmanager
Shard MongoDB Cluster:
3-router
3-config
2-shard (3-replica's per shard)
We are tring to take incremental backup for every one hour. We gone through few google links, but no luck. As per our above ...
0
votes
3answers
6k views
mongodb: update string field to integer
I have a collection that has some fields that should be integers. Due to a software bug, some of these values are strings. I need to convert them. Here is an example document:
var coll = db....
1
vote
1answer
3k views
node is not in primary or recovering state
My config file is:
systemLog:
destination: file
logAppend: true
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
journal:
enabled: true
replication:
replSetName:...
1
vote
1answer
237 views
How to avoid warning with file system cache in mongodb?
OS Windows 10 x64. Version of MongoDB 3.6.5
When I'm starting mongo process, I'm always getting:
MongoDB shell version v3.6.5 connecting to: mongodb://127.0.0.1:27017/
MongoDB server version: 3.6.5 ...
1
vote
1answer
276 views
Mongodump Backup Resume
My database size is approx 1.5 TB and I have approx 2TB free on backup mount point. But after 10 hours my backup fail due to lack of storage and its just 60% complete. Is their any why through which i ...
0
votes
1answer
245 views
How to connect via config file in mongodb
In config file I have:
systemLog:
destination: file
logAppend: true
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
journal:
...
2
votes
1answer
520 views
MongoDB crashes with out-of-memory or is being killed by oom-killer
A two shards MongoDB database regularly crashes with out-of-memory error or is being killed by the oom-killer. The system runs on GCE Debian 9.4 with MongoDB v3.6.5, WiredTiger storage engine and ...
1
vote
0answers
15 views
How can I dump the data which has been added recently?
On a daily basis I will download the data from mongodb and make a backup. I use the command
mongodump -h $MONGODB_SERVICE_HOST -o /opp/rot/llc/ttc -u 'admin' \
-p $MONGODB_ADMIN_PASSWORD
So in ...
0
votes
1answer
79 views
Unable to perform queries through mongos
I have setup a minimal replicated configuration with mongodb 3.6.3,it seems to be everything fine but when I connect to the mongos (which as far as I understand acts like a kind of load balancer in ...
2
votes
0answers
712 views
MongoDB GridFS triples the file sizes
I really like using mongodb to store my data and recently I tried out GridFS and it really fits my use case.
My problem with it is the space requirement, which seems quite odd. I have ~107GB of ...
1
vote
2answers
93 views
Should I put users in admin DB or in the DB that they should have access to
What would the pros / cons be of putting users that should have access to one database in the admin database instead of the database that they should have access to?
Background:
I'm a C# developer. ...
2
votes
1answer
833 views
High CPU Utilization for Mongodb ReplicaSet Secondary Nodes
I am using MongoDB server version: 3.6.4 (WiredTiger storage engine) with 3 node replica set on AWS r4 large machines.
Sharing the CPU Utilization graph of all the nodes
Primary (with .33%)
...
2
votes
1answer
2k views
How to configure SSL mongodb connection in yml file spring boot? [closed]
I was trying to setup ssl mongodb connection from spring boot but I couldn't able to find a way. How can I add pem and ca file to below connection?
Please note I am using replica set
data:
...
2
votes
1answer
2k views
Mongodb create user with only read and write access
Hi I created a new using using following command in mongodb,
db.createUser({ user: 'csquad', pwd: 'somepass123', roles: [ { role: "readWrite", db: "cloud"}]});
Now this user is able to login to db ...
0
votes
1answer
101 views
MongoDB Ops Manager
I have few questions regarding backup process in MongoDB Ops Manager
1) How backup process works ?
2) According to documentation for production do we need to have 3 dedicated servers for ...
1
vote
1answer
151 views
Mongo Zone Sharding Implementation Issue
As I am new with MongoDB.
I have configured 2 config server, 2 shards and all are connected with mongod client. Also, One Mongos client is UP and Running.
I am currenctly implementing Sharding ...
0
votes
1answer
307 views
Allow only find and insert action to mongodb collection
I want to create collection. that allow only insert and find operation. i read Privilege Actions in mongodb and i applied that method but all actions are performed like remove and update
i tried ...
