Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mongodb-atlas]

20 questions
9
votes
3 answers

How to restore .wt backup file to local MongoDB?

This is a question that was asked before, but I have tried all solutions, and simply cannot get it right. I have spent quite some time researching before posting this question. I have looked at the official MongoDB documents and many other…
Saketh
  • 123
  • 1
  • 2
  • 4
4
votes
2 answers

How to add userAdmin user in Mongodb Atlas

How to add a user with userAdmin role in Atlas? The Cluster Security "Add New User" UI https://cloud.mongodb.com/v2/.....#clusters/security/users shows only limited set of built-in roles without any option to enter role name manually: So I am a bit…
Alex Blex
  • 185
  • 1
  • 9
3
votes
1 answer

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 created admin user with password: Set up IP…
invzbl3
  • 217
  • 1
  • 4
  • 8
3
votes
1 answer

How to copy wt files from another mongo instance?

I received a copy of mongo dbpath directory copy from a peer. I copied entire content to my local dbpath with an intention to work on the collections. However, my local is not recognizing the databases or the collections. Am I missing anything?
Saketh
  • 123
  • 1
  • 2
  • 4
2
votes
0 answers

MongoDB - 100% CPU - recovering shard (after killing updates)

Can a recovering shard (as shown below) drive CPU to 100% for hours and hours? I have killed all the queries and updates (based on db.currentOp()) and stopped the flow of new data, but the CPU stays at 100%. I can run little queries, but deleting…
NealWalters
  • 537
  • 5
  • 18
2
votes
3 answers

How can you view the IP addresses of active MongoDB Atlas connections?

Some posts show you can use db.currentOp(true) to show active connections, but when I do that I get this error { "ok" : 0, "errmsg" : "Using $all for currentOp is disallowed in this atlas tier", "code" : 8000, …
A_toaster
  • 145
  • 1
  • 5
1
vote
2 answers

how to run mongo export on macbook?

I am using mongodb Atlas (M0), which does not provide db backup feature. I am creating a nodejs script that will export all the collections automatically periodically. So far I have done the following: created a programmatic api from my…
Jasmohan Singh
  • 11
  • 2
1
vote
1 answer

MongoDB - Replication Oplog Window has gone below 1 hours

I'm working with MongoDB Atlas and I have a cluster of 3 with M30 and 100gb of storage. My current usecase is the following: - An user dispatches one search in my platform - The platform dispatches this search to other providers (12) - I get like 2k…
Tzn
  • 53
  • 1
  • 7
1
vote
0 answers

How to reclaim disk space on a MongoDB Atlas replica set?

I migrated a replica set from mLab to MongoDB Atlas. mLab offered an automated process to reclaim disk space after dropping large amounts of documents from a collection. Compacting (or resyncing) basically happened with the click of a button with a…
Manuel
  • 121
  • 3
1
vote
1 answer

Migrating from MongoDB Atlas to self managed Mongo (EC2) server

There is an abundance of info about migrating TO Atlas but not too much I could find specifically about going the other direction. I am migrating a collection which is 250GB in size. I have tried using mongodump from the remote EC2 server…
ronnz
  • 9
  • 3
1
vote
1 answer

My MongoDB Atlas Operations graph has doubled in the last few hours. How do I go about debugging this?

I noticed this graph in my MongoDB Atlas dashboard: I'm not sure what is causing the increased Disk IOPS and Operations counts... Can I use the oplog to figure out what is causing this massive increase in operations?
A_toaster
  • 145
  • 1
  • 5
1
vote
1 answer

How to monitor Mongo databases and Cloud servers?

We have mongo databases installed in AWS and Azure based servers. We need to monitor the Mongo databases and Cloud servers on daily basis. Is there any way to healthcheck the databases and servers ? Thanks,
Mr Surya
  • 11
  • 1
1
vote
1 answer

Mongo Atlas API - Get Databases and Collections in a Cluster

So with Mongo Atlas I can easily list clusters in a project by calling the API as follows: curl -i -u ":" --digest "https://cloud.mongodb.com/api/atlas/v1.0/groups//clusters" I want to list all database (and if…
Molenpad
  • 1,703
  • 2
  • 16
  • 35
0
votes
1 answer

How to do a mongo restore with Atlas URI

I am trying to do a mongorestore of a few collections . I am trying to use the Atlas URI to do this and it throws an error saying that positional arguments not allowed: [mongodb+srv://hostname.mongodb.net] When I try to connect with a mongo client…
Suresh C Nair
  • 1
  • 2
0
votes
0 answers

request conversion is not supported from SQL Server to MongoDB

I'm using a Linked server from SQL Server 2012 to connect to MongoDB via BI Connector ( MongoDB Atlas ). I can retrieve some info that is int for example, but when running the query below, I receive an error: select * from openquery([MONGO],'select…
Racer SQL
  • 7,004
  • 9
  • 49
  • 101
1
2