|
I checked and the index exists:
db.system.sessions.getIndexes()
|
[
|
{
|
"v" : 2,
|
"key" : {
|
"_id" : 1
|
},
|
"name" : "_id_",
|
"ns" : "config.system.sessions"
|
},
|
{
|
"v" : 2,
|
"key" : {
|
"lastUse" : 1
|
},
|
"name" : "lsidTTLIndex",
|
"expireAfterSeconds" : 1800,
|
"ns" : "config.system.sessions"
|
}
|
]
|
|
And yet every five minutes:
2018-08-31T13:09:09.189+0000 I COMMAND [LogicalSessionCacheReap] command config.$cmd command: createIndexes { createIndexes: "system.sessions", indexes: [ { key: { lastUse: 1 }, name: "lsidTTLIndex", expireAfterSeconds: 1800 } ], $db: "config" } numYields:0 reslen:275 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: { acquireCount: { w: 1 } } } protocol:op_msg 0ms
|
2018-08-31T13:09:09.189+0000 I COMMAND [LogicalSessionCacheReap] command config.transactions command: find { find: "transactions", filter: { lastWriteDate: { $lt: new Date(1535719149189) } }, projection: { _id: 1 }, sort: { _id: 1 }, $db: "config" } planSummary: IXSCAN { _id: 1 } keysExamined:0 docsExamined:0 cursorExhausted:1 numYields:0 nreturned:0 reslen:233 locks:{ Global: { acquireCount: { r: 5, w: 2 } }, Database: { acquireCount: { r: 2, w: 1, W: 1 } }, Collection: { acquireCount: { r: 2, w: 1 } } }
|
2018-08-31T13:09:09.201+0000 I COMMAND [LogicalSessionCacheRefresh] command config.$cmd command: createIndexes { createIndexes: "system.sessions", indexes: [ { key: { lastUse: 1 }, name: "lsidTTLIndex", expireAfterSeconds: 1800 } ], $db: "config" } numYields:0 reslen:275 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 1, W: 1 } }, Collection: { acquireCount: { w: 1 } } } protocol:op_msg 0ms
|
|