We have mongo cluster(version: 4.4.10-11) running with one primary server and two secondary servers. With these setup we faced below errors multiple times.
com.mongodb.MongoQueryException: Query failed with error code 261 with name ‘TooManyLogicalSessions’
While digging deeper, We can able to find that local session cache refresh is not working. It has to keep on running for every 5 minutes. But somehow it got stopped and it doesn’t update the “lastSessionsCollectionJobTimestamp” for more than a day.
“logicalSessionRecordCache” : {
“activeSessionsCount” : 841353,
“sessionsCollectionJobCount” : 10959,
“lastSessionsCollectionJobDurationMillis” : 0,
“lastSessionsCollectionJobTimestamp” : ISODate(“2022-12-05T05:51:03.262Z”),
“lastSessionsCollectionJobEntriesRefreshed” : 803073,
“lastSessionsCollectionJobEntriesEnded” : 4,
“lastSessionsCollectionJobCursorsClosed” : 0,
“transactionReaperJobCount” : 12145,
“lastTransactionReaperJobDurationMillis” : 8,
“lastTransactionReaperJobTimestamp” : ISODate(“2022-12-06T11:12:28.805Z”),
“lastTransactionReaperJobEntriesCleanedUp” : 19,
“sessionCatalogSize” : 253
}
Since the refresh got stopped, old session has’t been cleared and the active session counts keeps on increasing and once its reached the limit, we are getting the error “TooManyLogicalSessions”.
I did’t able to find any logs regarding the cache refresh job too. Is there a way to troubleshoot this issue.
Note:
I think, this is the same issue faced here too. But the conversion hasn’t been completed with proper solution. Any help to overcome this or further step for troubleshoot will be appreciable.
type or paste code here