Questions tagged [mongodb-3.2]
MongoDB (v.3.2) is a scalable, high-performance, open source, document-oriented database. This is version tag to describe that your question is version 3.2 specific. Please add (general) 'mongodb' tag too, to get a wider audience.
118
questions
0
votes
0answers
15 views
How to show specific type record first in mongodb?
I want to show result in specific order. I have two categories on request instant and want to show instant record first.
Here is my data:
{
"_id" : ObjectId("...
3
votes
2answers
632 views
How can we use transaction in mongodb standalone connection?
I want to use transaction in mongodb but its told to replicaset can we perform transaction query with standalone mongodb if yes please share how to we can because when I try its give error
This ...
0
votes
0answers
30 views
MongoDB works only on user is assigned to admin database
I am using mongo db with authentication and it is working as expected when I map the user to the admin database like below,
use admin;
db.getUsers();
{
"_id" : "admin.test1",
...
3
votes
1answer
105 views
adding and removing a node from a mongo replica set
I have a new backup server I want to add to our mongo replica sets. As far as I can tell its as easy as logging on to the replica sets primary and adding the following command:
rs.add( { host: "...
0
votes
0answers
11 views
MongoDB Intermittent Little to No Insert/Write Activity
I have a MongoDB 3.2 WiredTiger Server running on Windows Server 2008 R2 Enterprise in Production while a MongoDB 3.2 WiredTiger Server running on Windows Server 2012 R2 in Testing. Production has ...
0
votes
1answer
48 views
Mongo DB Upgrade 3.0 to 3.2 Verification of Upgrade
We have a few environments with MongoDB 3.0, these are standalone servers.
These servers are already using WiredTiger Storage engine.
I am trying to upgrade them to 4.2.
As per the upgrade ...
0
votes
0answers
257 views
mongodb after restoring replica-set from backup the primary is not master
after recovering replica-set from a snapshot (for testing)
when I run commands on the primary I got error
not master and slaveOk=false
does primary not equal to master?
I got this output for the ...
3
votes
1answer
3k 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:
{
...
0
votes
2answers
155 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 ...
1
vote
0answers
54 views
Joining on nearest timestamp in MongoDB
MongoDB version: 3.2.11
Coming from using primarily PostgreSQL, I am new to MongoDB and am having trouble constructing complex queries in the required JSON format (where in SQL I would use CTEs). To ...
0
votes
0answers
30 views
Fetch only those record which do not have matching amounts
I have a mongo collection as shown below
{
"_id" : ObjectId("5c5c86633b897535539c1b36"),
"studentId" : "dsdlkjafhiuelfdldahfiu",
"marks" : [
"subject" : "Physics",
"...
0
votes
1answer
38 views
configsvr and nojournal
trying to start mongo config server :
mongod --configsvr --dbpath /data/config-1 --port 27019 --logpath /data/config-1.log --fork --journal
gives:
F CONTROL [main] Failed global initialization: ...
2
votes
1answer
112 views
Getting exception on running sh.status() command on MongoDB sharded cluster
I am running sh.status() command on my mongos instance of sharded Mongo cluster and I am getting below exception.
mongos> sh.status()
assert: command failed: {
"ok" : 0,
"errmsg" : "error ...
1
vote
0answers
33 views
Java app crash after shard failover
I am using a Mongo sharded cluster with 4 shards.
All shards are a 3 members replica set with a PRIMARY with priority 1, a SECONDARY with priority 0.5 and an arbiter.
The Mongo config server is a 3 ...
-1
votes
1answer
41 views
MongoDB replica set configuration problem
I'm facing some issues when trying the following:
I have a three-node MongoDB 4.0 cluster, no sharding, one mongodb instance as primary, the rest as secondaries.
When I shut down the primary, one of ...
1
vote
2answers
2k views
Update single field in a document (document.update($set)?)
Can't seem to figure out how to update a single field.
Whatever I try, to update one field (picture: "url") the rest of the fields are being removed and set to null.
I use the following command now:
...
0
votes
1answer
1k views
mongodb setFeatureCompatibilityVersion command not found
I'm trying to upgrade my mongodb from 3.2 to 3.4 and I try to set the compatibility version by:
db.adminCommand( { setFeatureCompatibilityVersion: "3.2" } )
But it says
{
"ok" : 0,
...
1
vote
1answer
526 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 ...
1
vote
1answer
372 views
mongodump: fact.bson: input/output error
We are trying to export 1.5TB database into mongodb. But its fail after 100gb and giving us below error. As we notice root mount point got 100% space. We are using below command:
mongodump -u admin -...
2
votes
2answers
2k views
MongoDB explain winning plan shows “EOF”
I've been working on optimizing my queries on some 2 million documents in MongoDB and I tried to use explain on aggregate functions, but it would display
"winningPlan" : {
"stage" : "EOF"
}...
2
votes
0answers
129 views
How to validate a mongorestore
I have a script that creates a zip dump file using mongodump for all of my sibling databases in Mongo. I then transfer these to a different mongoDB instance(having the same sibling dbs) and use ...
0
votes
1answer
402 views
Mongo 3.2.20 Invalid access at address
My mongodb local instance just crashed on its own with the following in its log:
Invalid access at address: 0x18
Got signal: 11 (Segmentation fault).
Environment:
Ubuntu 16.04
MongoDB v3.2....
1
vote
0answers
174 views
Why would MongoDB resident memory suddenly drop?
We run Mongo 3.2.8 on Windows 2008. Since the start of this week the server MongoDB runs on has effectively run out of memory every morning. The server has 16gb of RAM. When we see this behaviour ...
0
votes
1answer
2k views
mongodb set feature compatibility to 3.4 fail
I want to enable the features of my Mongodb 3.4 after upgrading. I have sharded cluster enviroment And after I ran the commands:
use admin
db.adminCommand ({setFeatureCompatibilityVersion: "3.4"})
...
0
votes
1answer
499 views
Do I need to perform db.fsyncLock() when running a replica set without journal enabled
I'm running MongoDB 3.2.9 with WiredTiger on 3 EC2 instances. When backing up the database volumes using elastic block store snapshots, do I need to perform db.fsyncLock() when running a 3 node ...
1
vote
0answers
205 views
List all connections, IP addresses and users in MongoDB 3.2
I'm attempting to create a list of all current connections to my MongoDB 3.2 database. So far I've been able to list connections using:
db.currentOp(true).inprog.forEach(function(x) { print(x....
5
votes
1answer
16k views
Mongodb: Document size of 29344731 is larger than maximum of 16777216
When we are upgrading AEM 6.1 instance with mongo (Mongo version: 2.6 ) to AEM 6.3 with mongo (Mongo version: 3.2) we are facing the exception.
org.apache.jackrabbit.oak.plugins.document....
0
votes
1answer
335 views
mongodump sharded collection size is smaller after restoring
I need to change shard index from range to hashed in a sharded collection. So I need to mongodump and restore the collection. I have 3 shards with 3 replica sets.MongoDB version is: 3.2.11
I started ...
0
votes
0answers
48 views
Scaling mongo db shard set up at run time in heavy load condition
I am running a mongo sharded set up where page id is shard key.
Site has almost 200k different pages which are accessed by millions of users.
Situation is when at some time some of page related to ...
1
vote
1answer
271 views
Slow MongoDB start time when data is replicated to a new machine
We have a 3.2.13 Mongodb replica set with WiredTiger on AWS.
We are observing a strange behaviour: when stopping and starting the mongod service, the start time is about 10 minutes, but when stopping ...
5
votes
0answers
645 views
MongoDB background index builds block secondary
We recently experienced a disruptive incident in a MongoDB 3.2 cluster related to index creation. Scenario:
Several indexes were created on the primary using background: true.
Indexes were ...
0
votes
1answer
495 views
Mongo replicaSet dispersed over all continents
I have problem in operating mongo replicaSet which works on all continents.
The primary data is located in Europe and want to replicate it distant locations in US, Brasil, Tokyo, Sydney and Dublin.
...
1
vote
0answers
266 views
MongoDB 64 on Raspberry Pi 3 with SLES 12 64 bit
I am trying to run MongoDB 3.4 on raspberry pi 3 with an OS which was made by SUSE and SUSE is the only official 64 bit OS for raspberry pi (SLES 12 SP2). I have downloaded the MongoDB from the link ...
1
vote
1answer
45 views
MongoS clients not seeing databases after config server change to CSRS
The three config servers were migrated to CSRS and WiredTiger last week. Followed the documentation here : https://docs.mongodb.com/manual/tutorial/upgrade-config-servers-to-replica-set/
Since the ...
0
votes
0answers
1k views
Error while connecting to Mongo cluster form app servers
We are running a Mongo Cluster with one primary / 2 secondary / 1 Arbiter.
We are getting this exception on our tomcat logs very often.
[cluster-ClusterId{value='5a002e946bf8526c15434b92', ...
1
vote
1answer
605 views
WiredTiger panic when attempting to rename .turtle leads to loss of all data
We've seen this twice this week on separate servers (one staging, one production).
2017-10-19T12:50:37.525-0400 I ACCESS [conn266] Successfully authenticated as principal ********* on admin
2017-10-...
1
vote
0answers
235 views
MongoDB slow $mergeCursors
I have Mongodb 3.2.6 with 4 shards. Each shards has 4 replica.
My db is working perfect but suddenly it is showing $mergeCursors on one collection is running slow and made whole DB response slow!!, ...
0
votes
1answer
574 views
Assertion failure _state.get() error in MongoDB during mongorestore
I would like to say i am newbie in mongodb,today i have tried to restore dump file .I am getting the Assertion failure _state.get() during mongorestore dump in my mongod and process has stuck at that ...
1
vote
1answer
85 views
Mongo shell 3.2 has different results on sh.isBalancerRunning() as mongo shell 3.4
I have a mongo shards cluster and a mongos instance. These servers are running on MongoDB 3.4.0. When I use mongo shell 3.4.0 to connect to the mongos, I got below output from sh.isBalancerRunning(),
...
1
vote
1answer
1k views
Transferring Mongodb database with rsync while working, is it okay?
I need to transfer MongoDB data from another server with rsync with MongoDB running. Making a dump is not an option for me, as it takes too much time.
What problems can I face doing it? Or, if this ...
0
votes
0answers
465 views
GetMore command executor error: DEAD in Mongodb
I am getting below error. I am clueless where I am getting this error from?
2017-10-03T01:41:31.919+0000 W QUERY [conn197802] Could not restore RecordCursor for CollectionScan: local.oplog.rs
2017-...
0
votes
1answer
193 views
Two arbiters in mongodb architecture
I am distributing several instances of mongoDB between two datacenters (DC). I want to have high availability (HA), which means that three instances must always be active if one of DC goes down.
My ...
1
vote
2answers
207 views
Keep Mongo DB set up up and running with two data center always
There is a scenario where we have 5 member replica set across two data centers.
Data center 1 : 3 Members
Data center 2 : 2 Members
Situation is if DC 1 goes down DC 2 becomes read only but we need ...
1
vote
1answer
2k views
Is there any correct way to convert file system from ext4 to xfs in centos? [closed]
I have deployed MongoDB Sharding Cluster(os-centos) on Azure with 2 disks each VM. But default file system is ext4 and I want xfs file system because of performance. I want to convert that file system....
0
votes
1answer
731 views
What does PROJECTION stage mean in mongo explain result
I am running a explain command on a shard cluster in mongodb shell. From the output I see the first stage under inputStage is PROJECTION. I don't quite understand what this stage means. And I couldn't ...
0
votes
3answers
7k views
Mongodb Not Restarting with Collections, WiredTiger.wt may be corrupt
I believe my MongoDB did not have a clean shutdown. I am able to restart it in a new location which doesn't have all of my collections. If I try to repair or start it in the old location, it gives the ...
2
votes
1answer
6k views
Recover MongoDB data without WiredTiger.wt file
We have recovered a MongoDB database from filesystem, but the WiredTiger.wt file has changed since then (i.e. the collection has been dropped).
So is it possible to read data (documents) from some ....
2
votes
1answer
4k views
MongoDB secondary node does not become primary when other nodes are stopped
I want to cluster MongoDB by using a replica set. I have created a three-node replicaset (rs0,rs1,rs2), and run the DBs in parallel with no issues. But when I shut down any two instance (one primary ...
1
vote
1answer
1k views
MongoDB: Database too big to resync?
we have a mongodb cluster which takes about 3.7TB on the filesystem. One of our secondary nodes died, so we replaced it and started the resync.
The resync was started on 12 Jul 2017 and took until ...
1
vote
1answer
425 views
MongoDB setting permission for functions
I want to create execute permission on some MongoDB functions
like permissions in Sql Server.
I want users access data that function provides for them. This is, because of security of application
...
