Search code examples
pythondatabasemongodbruntime-errorpymongo

pymongo.errors.ServerSelectionTimeoutError:localhost:27017:[WinError 10061] No connection could be made because the target machine actively refused it


I am following the Python tutorial from W3Schools. I just started the MongoDB chapter. I installed MongoDB and checked it with:

import pymongo

without getting an error.

But as soon as I enter the following code:

import pymongo

myclient = pymongo.MongoClient("mongodb://localhost:27017/")
mydb = myclient["mydatabase"]
mycol = mydb["customers"]
mydict = { "name": "John", "address": "Highway 37" }

x = mycol.insert_one(mydict)

print(x.inserted_id)

I get these messages and an error message at the bottom in cmd:

cd C:\Users\xxx\myname
python index.py

Output:

Traceback (most recent call last):
  File "index.py", line 8, in <module>
    x = mycol.insert_one(mydict)
  File "C:\Users\path...\pymongo\collection.py", line 695, in insert_one
    self._insert(document,
  File "C:\Users\path...\pymongo\collection.py", line 610, in _insert
    return self._insert_one(
  File "C:\Users\path...\pymongo\collection.py", line 599, in _insert_one
    self.__database.client._retryable_write(
  File "C:\Users\path...\pymongo\mongo_client.py", line 1490, in _retryable_write
    with self._tmp_session(session) as s:
  File "C:\Program Files\WindowsApps\path...\lib\contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "C:\Users\path...\pymongo\mongo_client.py", line 1823, in _tmp_session
    s = self._ensure_session(session)
  File "C:\Users\path...\pymongo\mongo_client.py", line 1810, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "C:\Users\path...\pymongo\mongo_client.py", line 1763, in __start_session
    server_session = self._get_server_session()
  File "C:\Users\path...\pymongo\mongo_client.py", line 1796, in _get_server_session
    return self._topology.get_server_session()
  File "C:\Users\path...\pymongo\topology.py", line 482, in get_server_session
    self._select_servers_loop(
  File "C:\Users\path...\pymongo\topology.py", line 208, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: localhost: 27017: [WinError 10061] Could not connect because target computer actively refused connection

I also tried too disabling firewall temporarily, but the error kept coming up.

I used:

"python 3.8.2
, mongoDB 4.2.5.0
, pymongo 3.10.1
, windows 10 home"

What is going wrong?


Solution

  • There is nothing wrong with your code.

    If you have disabled your firewall, the most likely reason is that the MongoDB service is not installed or running. On Windows, press the Windows key and type services to open the services application. Check the service MongoDB Server is listed and has a Running status.

    You can test local connectivity by opening your favourite Windows terminal or PowerShell and typing mongo. If it is working you should see:

    PS> mongo
    MongoDB shell version v4.2.3
    connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
    Implicit session: session { "id" : UUID("1b5499b8-166a-4de6-a8c9-643499f04e66") }
    MongoDB server version: 4.2.3