Incorrect sort when viewing the oplog collection

Thank you for your feedback.

Opening the collection with the same code template does not solve the problem. For a collection without the _id field, we need another code template.

To avoid slow execution when opening the collection, 　you can hold "SHIFT" key to bypass auto-exec when opening "oplog.rs" collection, then comment the ".sort({_id:-1})" line.

Hi,

Another problem that I noticed today. My template is configured according to the image, but when I check for currentOp() there is another different operation running.

db.currentOp({ns: "local.oplog.rs"})
{
        "inprog" : [
                {
                        "host" : "127.0.0.1:27017",
                        "desc" : "conn158947",
                        "connectionId" : 158947,
                        "appName" : "sergio",
                        "active" : true,
                        "currentOpTime" : "2018-12-27T18:35:52.794+0000",
                        "opid" : 675542849,
                        "secs_running" : NumberLong(732),
                        "microsecs_running" : NumberLong(732214376),
                        "op" : "query",
                        "ns" : "local.oplog.rs",
                        "command" : {
                                "find" : "oplog.rs",
                                "filter" : {

                                },
                                "sort" : {
                                        "_id" : -1
                                },
                                "projection" : {

                                },
                                "limit" : 32,
                                "returnKey" : false,
                                "showRecordId" : false,
                                "$readPreference" : {
                                        "mode" : "secondaryPreferred"
                                },
                                "$db" : "local"
                        },
                        "planSummary" : "COLLSCAN",
                }
        ],
        "ok" : 1
}

This happens even by holding the "SHIFT" key.

Thank you!

Please turn off auto-complete feature and try it again.

Menu->Options-> Options That May Affect Performance -> Enable Fields/Collection Auto Complete

I noticed that the op's "appName" is "sergio" rather than "NoSQLBooster". It doesn't look like a query generated by NoSQLBooster.

I added the "appName" in the NoSQLBooster options.

All options in the menu "Options That May Affect Performance" are disabled.

Thanks!

Thank you for you feedback.

We have worked out a test build to try to resolve this issue, please download and give it a try.

Windows: https://s3.mongobooster.com/download/releasesv5/nosqlbooster4mongo-5.0.4-beta.1.exe

This version fixed the problem.

Thank you!

Resolved in version 5.1.0