Questions tagged [mongodb]
All versions of MongoDB - a scalable, high-performance, open source, document-oriented database.
2,022
questions
0
votes
2answers
423 views
What is Diagnostic.data file in MongoDb data folder?
I'm trying to create a backup server for my mongodb using the strategy of copying files.
I wonder what is Diagnostic.data folder? Should I copy that too? or I can simply ignore it?
My Diagnostic....
0
votes
1answer
1k views
MongoDB aggregation framework - group with the sum of the nested document in arrays and count with filter
MongoDB Aggregation Framework Query: $group, $project, $addFields with $reduce and sum.
Use Case: I have the multiple documents with nested documents array in the collection, need a result group by ...
1
vote
1answer
29 views
How to convert a datefield from string to date?
Here is the query that I am using. What I need to extract is the data for the last 10 minutes. But no records found is the output for this query, I think this is due to the type of data that were ...
1
vote
1answer
108 views
MongoDB sharding multiple collections with the same shard key
Lets imagine I have two mongodb sharded collection: likes & comments.
Both collections are sharded, both collections have userId as a sharded key.
Lets imagine that likes collection is huge and ...
0
votes
1answer
105 views
MongoDB admin user cannot access system.views collection
One of our MongoDB databases contains a collection called system.views and I cannot find any information for this collection in Mongo Doc:
https://docs.mongodb.com/manual/reference/system-collections/...
2
votes
1answer
42 views
Efficient way to store geographical routes in MongoDB
I need to store a taxi route into MongoDB, however I'm not sure what is the best way to do this.
Since the route is only needed for the taxi order, the first idea I had is to store it in the order, ...
0
votes
1answer
34 views
Solution for a readonly copy of a standalone MongoDB server
I store some data in many databases/collections on a standalone MongoDB server. This server is used for production.
I need to access those data (or at least nightly build data, and not all databases/...
0
votes
0answers
11 views
How to db.collection.watch() aggregated by fields and operationType?
I would like to watch the change stream of a collection, but filter it by operationType (insert, delete) and some fields.
collection.watch(
[{
$match: { 'fullDocument.name': 'Dave' } /*{
...
5
votes
2answers
2k views
Unable to start mongodb as a service - Exception; Collection does not have UUID in KVCatalog
I have installed Mongodb 4.2 through this guide]
and when running
sudo service mongod start|restart
It does not start the server and I have the log below in mongod.log file.
Exception in ...
0
votes
2answers
3k views
Failed to start of service MongoDB community4.2 using Homebrew in Mac OS Mojave 10.14
Error message while starting the mongoDB service.
Error:
Permission denied @ rb_sysopen -
/Users/syedahmed/Library/LaunchAgents/homebrew.mxcl.mongodb-community.plist
I installed/reinstall the ...
0
votes
0answers
35 views
How to get records from one collection based on role hierarchy assigned from another collection in mongodb using $graphLookup aggregation
I have a roles collection whose schema is like this :
{ name:String, parent:{type:Schema.Types.ObjectId, ref:"role"} }
it has 3 documents right now as shown below
{
"_id": "...
1
vote
0answers
238 views
mongorestore Failed: an inserted document is too large
I have my remote mongodb database backed up and downloaded it to my local machine at /var/www/mongobackups3/
So I do this to insert/ restore it to the mongodb in my local machine:
$ mongorestore /...
0
votes
0answers
48 views
Mongodb C-driver install fail on windows
when build c-driver libbson, I have a CMake error
C:\mongo-c-driver-1.15.0\src\libbson>cmake -DCMAKE_INSTALL_PREFIX=C:\mongo-c-driver -G "Visual Studio 14 2015 Win64"
CMake Warning:
No source ...
1
vote
0answers
47 views
MongoDB thinks it's not on XFS despite being on one
From what I can understand/read it should suffice to have the filesystem as XFS and the dbpath set to a folder on that disk. What else do I need to do to fix this? I moved the whole db folder from the ...
1
vote
1answer
32 views
Design datastore persistence based on state of the Entity
I have an entity Content to persist in the database. The entity has an attribute LifeCycleState that denotes the present state of the content.
For the sake of elaborating further, assume we have ...
1
vote
0answers
23 views
How to scale MongoDB/GridFS for fast ingestion on limited timescale
I'm working on a cloud-agnostic service which must allow the ingestion of a lot of media files in a very limited timeframe.
Some numbers:
3-4 hours total of workload: the service will be active ...
0
votes
0answers
27 views
Unable to connect with MongoDB when giving mongod command in Cli
I'm trying to install mongoDb on centos VM and followed few sites like https://linuxize.com/post/how-to-install-mongodb-on-centos-7/ , https://www.digitalocean.com/community/tutorials/how-to-install-...
0
votes
0answers
274 views
Show Collections in MongoDB throwing
I am connecting to MongoDB hosted on EC2 instance of AWS. I am connecting through ssh command.
Upon entering the command "show collections", I am getting uncaught exceptions. Please see the sequence ...
2
votes
1answer
41 views
Is searching faster if indexed values are the same?
Currently I have a collection events with an attribute createdAt of type date (for example 2019/09/09 10:32:12.123).
Because my users search a lot by date, I added an index on this attribute. There ...
2
votes
1answer
67 views
How to set a correct value for wiredTiger concurrentTransactions
I have a single instance in server with 7 Processor and 15 Gb.
In value default for wiredTigerConcurrentReadTransactions and wiredTigerConcurrentWriteTransactions is 128.
But is value default, how to ...
1
vote
0answers
28 views
Schema design: Anonymous user's data across registration
This is a schema design question; implementation is going to be Mongo, but answers are platform agnostic.
Given an app, which has users, sessions, and items.
All visitors will have a session ...
0
votes
1answer
70 views
MongoDB restoring to existing replica set (avoid creating a new one)
I have a MongoDB cluster runnning on 3 AWS EC2 instances, 1 for primary and 2 secondary nodes. I'm trying to perform a backup and restore without having to recreate the replica set. mongodump seems a ...
0
votes
0answers
36 views
MongoDB replica set in swarm gets very slow when one node is down
I created a 3 nodes replicaset with mongodb that I host in a swarm environment. To do so, I created 3 services mongo1, mongo2, mongo3 with the same configuration.
When I challenged the resiliency of ...
0
votes
1answer
15 views
Mongodb Index not used in case of $or query
I have added created a collection first
and created index
db.first.createIndex({a:1, b:1, c:1, d:1, e:1, f:1});
and inserted data
db.first.insert({a:1, b:2, c:3, d:4, e:5, f:6});
db.first.insert({a:...
1
vote
0answers
13 views
does mongodb have any compiled list of non compatible functions on sharded cluster?
does mongodb have any compiled list of non compatible functions on sharded cluster?
I was looking for a compile list of non compatible functions on sharded clusters, so we can anticipate the changes ...
0
votes
0answers
512 views
MongoDB insert data if not exists and update only the array if exists on large amount of documents
So I have about 1M records to first insert and then subsequently update an array in them whenever I run the script.
A typical record
{
"_id" : Object(),
"id" : "my_unique_id",
...
0
votes
1answer
87 views
How to store null in a double field in mongodb
My mongodb schema has a field of "double" data type. Sometimes, when there is no value for this field, mongo is storing it as 0.0 but I need it to store as null
My Schema:
db.createCollection("...
0
votes
0answers
30 views
indexSize mismatch between primary and secondary members on wired tiger engine
we are using mongoDB 4.0 on wired tiger engine. For the last couple of days, we are observing that indexSize of primary server(marked in blue in attached file) went up drastically compared to its ...
0
votes
1answer
130 views
MongoDB 4.2 using change streams with read concern majority disabled in a PSA deployment
I currently run a PSA (Primary, Secondary, Arbiter) deployment and thous only have two databearing nodes.
In case of a databearing node going down, read concern majority prevented the change stream to ...
0
votes
0answers
31 views
swap collections in mongoDB
I receive current day transactional data which I dump into a collection called 'collA'. The data will be reportable for max of 4 days, after this the data becomes useless to me.
Are the below two ...
0
votes
1answer
29 views
Benchmarking MongoDB full text search vs MSSQL full text search
I'm working on a project for comparing mongodb and mssql databases performance on full text search. I started with using YCSB benchmark but now that I have a deeper understanding about this benchmark, ...
0
votes
2answers
74 views
usage percentage of Mongodb internal cache
I've ran two performance test on a MongoDB server with identical environment/settings AFAIK.
I found that the throughput was 10% apart.
When I inspected the mongostat logs, I found that Mongodb in ...
0
votes
0answers
42 views
What does config shard mean here?
I created a MongoDB sharded cluster with replica set rsa, rsb and rsc. Configuration server replica set is configRS. Initially shard status listed only these shards as primary shard for the sharded ...
0
votes
1answer
213 views
MongoDB Replica Set Sync data by Copying Data Files from Another Member
I used MongoDB 3.6 and was following MongoDB documentation:
https://docs.mongodb.com/manual/tutorial/resync-replica-set-member
to do a full copy of data from Primary node to another mongod instance....
-1
votes
1answer
370 views
Connectivity issues in replication process
I've been trying to add a new node to a replica set without success due to these errors:
2019-08-12T06:48:15.031+0200 I ASIO [NetworkInterfaceASIO-RS-0]
Ending connection to host mongo03:...
0
votes
1answer
84 views
Add a new node to Mongo Replicaset using Rsync
I have a 3 shard mongo cluster. Each shard has a 3 node replica set. On each shard, the data size is 3 TB.
I want to add 1 more node to each replica set. But its taking lot of time. The initial sync ...
0
votes
2answers
22 views
MongoDB 2.0.9 IndexStats
I am trying to get the index usage statistics in a mongoDB 2.0.9.
I found a similar question in https://stackoverflow.com/questions/44813787/how-to-check-index-usage-in-mongodb but this only applies ...
1
vote
1answer
40 views
Sharded Mongodb stalls randomly
I have setup Sharded MongoDB cluster using hashed sharding in kuberenetes.I first created the config server Replicaset and then created 2 shard replicasets. Finally created mongos to connect to the ...
1
vote
1answer
100 views
MongoDB Server Log to file and rsyslog
I have to forward my logs to rsyslog via UDP, but due to the volatile nature of UDP and rsyslog I would like to also log to a file. However, AFAICT MongoDB only allows one target for its logs:
...
2
votes
1answer
79 views
mongorestore from multiple dumps
I have a mongo-database where existing entries never change but new entries are added every day. I have ~1000 dumps, each is the new data that was added on the corresponding day.
I.e. I have the ...
0
votes
1answer
38 views
MongoDB is not using the index I created for this specific query
MongoDB 4.0.
I have a simple query:
db.product.find({
modifiedOn: {
$gte: ISODate("2019-08-02T03:00:00.000Z")
}
})
.limit(10)
And a simple index on modifiedOn....
0
votes
0answers
279 views
mongodb keyfile permission denied
I configured in /etc/mongod.conf to enforce keyfile access control, in security option enabled, keyFile is /root/dbtest.key (the absolute path of keyfile). I already gave the ownership to mongodb user ...
0
votes
0answers
18 views
Backup and restore a subset of a mongo collection that includes all the GridFS references and related document?
I have a big collection in MongoDB GridFS database. How can I backup a subset of the collection by date filter and all the GridFS related collection in the chunks, files and gridfs bucket will be ...
0
votes
0answers
23 views
run cleanupOrphaned in a loop do not remove all orphaned documents from the shard
MongoDB v3.4.1, run cleanupOrphaned in a loop do not remove all orphaned documents from the shard,is there any prob?
1.use mongoshake migrate mongo sharding ,there is duplicate error ,key is _id ...
0
votes
0answers
19 views
Remove linked GitHub Repository from Mongo Stitch
MongoDb stitch is providing the continuous integration choice to maintain our stitch entities. For the testing, I have linked the sample repository to the stitch app's Deploy option. Now, I just want ...
0
votes
1answer
67 views
mongoDB won't stop with shutdown or kill
Not sure If I can make the same question already made here but here it goes.
I have a mongodb fork and running with high CPU usage. I'm trying to shut it down but nothing seems to work.
2729 mwon ...
0
votes
1answer
20 views
Need Another MongoDB Binary?
I have a three-node MongoDB test replica running normally. I want to add an Ops Manager to it also residing on these three nodes. Do I need to install another set of MongoDB binary for the Ops Manager'...
-1
votes
2answers
765 views
join two collections with group by and sum in Mongodb
i have this two collection and i want to join, after this I want to sum the value of TotalPrice each orderdate :
some line of my two collections
the first collection date :
{"Id_Date":1,"...
0
votes
1answer
31 views
How to add a fixed string to a mongoDB result like we do we in SQL Server?
We have this syntax with SQL server:
select name as 'database',
'I_Love_SQL' as 'feelings'
from sys.databases
which will return results like this:
database | feelings
database1 | ...
0
votes
1answer
118 views
High CPU usage on fresh new install of MongoDB
I read a lot of post about high CPU usage of Mongo but almost all relates to queries.
I just did a fresh install of MongoDB 4. I have no other databases than the default one.
As soon as I start the ...
