View source for MONGODB - Troubleshoot

[[Category:Wiki]]

==== Checking MongoDB Logs ====

To check MongoDB logs for errors, navigate to the log directory and examine the `mongod.log` file. The default location for MongoDB logs is `/var/log/mongodb/mongod.log` on Linux-based systems.

 <nowiki>
tail -f /var/log/mongodb/mongod.log</nowiki>

This command shows the latest log entries. Look for error messages that might indicate issues such as corrupted data files or network issues.

==== Error: "Failed to connect to [address] after [time]" ====

This error can occur when MongoDB cannot connect to the database. Possible causes include:

* Network issues
* Firewall blocking the connection
* MongoDB not running on the specified host or port

To check whether MongoDB is running, use:

 <nowiki>
ps aux | grep mongod</nowiki>

If MongoDB is running, verify the port number in the connection string, usually port `27017` by default.

You can also attempt to connect to MongoDB locally:

 <nowiki>
mongo --host localhost --port 27017</nowiki>

If the connection fails, check your firewall and network settings.

=== Performance Troubleshooting ===

MongoDB's performance can degrade due to various factors, including query inefficiencies, disk I/O bottlenecks, and lack of indexing. The following methods can help identify and resolve performance issues.

==== Query Performance Analysis ====

MongoDB provides a tool called `explain()` to analyze the execution plan of queries. It helps identify if MongoDB is using the correct index for a query or performing a collection scan.

For example, to analyze a query on a collection:

 <nowiki>
db.users.find({ "name": "Alice" }).explain("executionStats")</nowiki>

This will show how MongoDB executes the query, including whether it uses an index or performs a full collection scan. If it performs a full scan, you should consider creating an appropriate index.

==== Indexes and Slow Queries ====

Indexes are essential for performance. If MongoDB is running slow, check the indexes on your collections. You can list the indexes of a collection with the following command:

 <nowiki>
db.collection.getIndexes()</nowiki>

To create an index on a field, use:

 <nowiki>
db.collection.createIndex({ "fieldname": 1 })</nowiki>

You can also check slow queries by enabling the slow query log. Modify the `mongod.conf` file to enable slow query logging:

 <nowiki>
operationProfiling:
  slowOpThresholdMs: 100
  mode: slowOp</nowiki>

This configuration logs queries that take longer than 100 milliseconds to execute.

==== Analyzing System Resources ====

MongoDB can be resource-intensive, particularly with large datasets. If MongoDB is consuming excessive CPU or memory, it's important to check the system's resource usage. Tools like `top`, `htop`, or `iotop` can be used to monitor system resource usage.

To monitor memory usage, run:

 <nowiki>
free -m</nowiki>

If MongoDB is using more memory than expected, consider optimizing your queries and indexes. You can also configure MongoDB to use the WiredTiger storage engine, which is more efficient than the MMAPv1 storage engine for many workloads.

==== Disk Space and I/O Issues ====

MongoDB stores its data files on disk, and running out of disk space can cause it to stop functioning properly. Ensure that there is sufficient disk space available for the data files and logs.

Check the available disk space with:

 <nowiki>
df -h</nowiki>

If MongoDB is consuming a lot of disk space, you might want to consider removing unused indexes or running a `compact` command to optimize storage:

 <nowiki>
db.collection.compact()</nowiki>

Also, check if the storage is experiencing high I/O latency using tools like `iostat`:

 <nowiki>
iostat -x 1</nowiki>

=== Replica Set Troubleshooting ===

In a MongoDB replica set, multiple nodes synchronize data. If a replica set member falls behind, it can lead to problems with data consistency and availability.

==== Checking Replica Set Status ====

To check the status of a replica set, use the following command:

 <nowiki>
rs.status()</nowiki>

This will provide information on each node in the replica set, including whether any nodes are experiencing issues.

If a node is stuck in a secondary state or failing to sync, check its logs for errors or issues with disk space.

==== Elections and Primary Node Failures ====

In case of a primary node failure, MongoDB automatically triggers an election to select a new primary. If elections are not occurring or fail repeatedly, inspect the log files for any network or communication errors among the nodes.

You can force an election using:

 <nowiki>
rs.stepDown()</nowiki>

This forces the current primary to step down and triggers an election for a new primary.

=== Sharding Issues ===

Sharding in MongoDB allows horizontal scaling by splitting data across multiple servers. If you're facing issues with sharded clusters, it could be related to chunk migrations, balancing, or connectivity between shard servers.

==== Checking Shard Cluster Status ====

To check the status of the sharded cluster, use:

 <nowiki>
sh.status()</nowiki>

This will give you an overview of the shard configuration, including whether all shards are online and balanced.

==== Balancing and Chunk Migrations ====

If data is not evenly distributed across shards, you might need to check the balancer's status. To view the balancer status:

 <nowiki>
sh.getBalancerState()</nowiki>

If it's off, you can turn it on using:

 <nowiki>
sh.setBalancerState(true)</nowiki>

If the balancer is active but not moving chunks, investigate the shard key and make sure it's optimized for the data distribution.

=== Useful Links ===

* [MongoDB Official Documentation](https://docs.mongodb.com)
* [MongoDB Troubleshooting Guide](https://docs.mongodb.com/manual/reference/command/)
* [MongoDB Performance Tuning](https://docs.mongodb.com/manual/tutorial/optimize-queries/)
* [MongoDB Indexing](https://docs.mongodb.com/manual/indexes/)
* [MongoDB Replica Set Configuration](https://docs.mongodb.com/manual/core/replica-set-operations/)
* [MongoDB Sharding](https://docs.mongodb.com/manual/sharding/)