Resolution: Works as Designed
Priority: Major - P3
Affects Version/s: 3.6.17, 4.0.18
We are running a mongodb v3.6 replSet for several months (or even years) already without any problems so far. However, recently our database client, which is using mongodb java driver v3.11 for a decent time already, got the following error:
It turned out that the default of 1 million logical sessions had been reached. We even could not kill any sesssion:
We had to restart mongod in order to reset all logical sessions.
We then upgraded from mongodb v3.6 to 4.0.18 to see if this solves the issue. It did not. After 12 days, the number of logical sessions is still constantly increasing:
I'll attach also a screenshot of our dashboard where you see that the number of logical sessions is constantly increasing.
The user "opensearch" is our usual database client. The number of logical sessions of 125 is reasonably low.
The user "mms" is mongodb's CloudManager agent. It's been updated recently to the newest version. However, the number of logical sessions of 1370 is quite high already.
Although we have been running dozens of mongodb v3.6 replSets in production for several years now, this has never happened before. Since everything is rolled out automatically, and therefore uses identical configuration, we cannot explain the error and therefore suspect a mongodb bug.