How to close a mongodb python connection?

Question

I'm doing a python script that writes some data to a mongodb. I need to close the connection and free some resources, when finishing.

How is that done in Python?

score 161 · Accepted Answer · edited Jul 05 '22 at 18:43

161

Use close() method on your MongoClient instance:

client = pymongo.MongoClient()

# some code here

client.close()

Cleanup client resources and disconnect from MongoDB.

End all server sessions created by this client by sending one or more endSessions commands.

Close all sockets in the connection pools and stop the monitor threads.

edited Jul 05 '22 at 18:43

Gianfranco P.

10,049
6
51
68

answered Aug 23 '13 at 10:58

alecxe

462,703
120
1,088
1,195

24

And also `disconnect ` is no longer available from pymongo 3.x – sri85 Sep 23 '15 at 12:45
1

@alecxe, there any way or form of know if the connect daba base closed? – julian salas Aug 02 '16 at 22:24
4

in Jupyter Notebook, after .close() I'm still able to query the DB. Is it auto-reconnecting? – Nikhil VJ Jul 18 '20 at 05:18
4

@NikhilVJ In the above `answer`, it says: `Disconnecting will close all underlying sockets in the connection pool. If this instance is used again it will be automatically re-opened.` – NYCeyes Apr 27 '21 at 02:03

score 30 · Answer 2 · edited May 24 '21 at 00:20

30

The safest way to close a pymongo connection would be to use it with 'with':

with pymongo.MongoClient(db_config['HOST']) as client:
    db = client[ db_config['NAME']]
    item = db["document"].find_one({'id':1})
    print(item)

edited May 24 '21 at 00:20

Clinton

2,296
4
19
21

answered Dec 26 '19 at 17:00

Niraj Kale

459
4
5

1

Wouldn't this cause too much traffic when you have a real time application that can perform hundreds of thousands of operations in a matter of minutes? – Ionut-Alexandru Baltariu Jun 02 '22 at 09:21

score 0 · Answer 3 · answered Jun 08 '22 at 10:38

Adding to @alexce's answer, it's not always true. If your connection is encrypted, MongoClient won't reconnect:

    def close(self):
        ...
        if self._encrypter:
            # TODO: PYTHON-1921 Encrypted MongoClients cannot be re-opened.
            self._encrypter.close()

also, since version 4.0, after calling close() client won't reconnect in any case.

   def close(self) -> None:
        """Cleanup client resources and disconnect from MongoDB.
        End all server sessions created by this client by sending one or more
        endSessions commands.
        Close all sockets in the connection pools and stop the monitor threads.
        .. versionchanged:: 4.0
           Once closed, the client cannot be used again and any attempt will
           raise :exc:`~pymongo.errors.InvalidOperation`.

How to close a mongodb python connection?

3 Answers3