Different values returned for the same query in Nosqlbooster
Solved
We have a query that is executed in some moments returns the document and in others it does not return anything. The same happens when we execute a count, that sometimes returns 0 and in others returns 1. We execute the same query by the shell and in all the executions the value returned of the cout was 1. We test in different machines, different OS and the problem continues. We use the most current version of NoSQLBooster to 5.1.7.
Note: The document has not been deleted or updated during the tests.
The same problem 
Thanks for opening your issue here! From your description, it is difficult for me to guess what the problem is.
If you're reporting a bug, please make sure you include steps to reproduce it.
Thanks for opening your issue here! From your description, it is difficult for me to guess what the problem is.
If you're reporting a bug, please make sure you include steps to reproduce it.
In the search filter it uses a pid field which is a shardkey so it does not access all shards, but the document is in shard7 and when it returns nothing it examines only shard5 or shard2.
The same problem does not happen in the mongo shell.
NoSQLBooster Version: 5.1.7
Operating System (Windows/Mac/Ubuntu): Windows 10 / Ubuntu 18
MongoDB Version: 3.6.8
Expected /p>
Actual /p>
How to Reproduce (Please attach sample JSON data): 9 shards cluster, collection with bilions documents, indexes: {pid: 'hashed"}, {"pid": 1, universe_id: 1, account_id: 1, channel:1, normalized_shared_at:1}
{ "executionStats" : { "nReturned" : 0, "executionTimeMillis" : 37, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 0, "executionTimeMillis" : 37, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "totalChildMillis" : 32, "shards" : [ { "shardName" : "EndpoingGoogleShard_2", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 2, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 1, "restoreState" : 1, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 1, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 1, "restoreState" : 1, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 0, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "indexDef" : { "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "direction" : "forward" } } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710633, 1601), "$clusterTime" : { "clusterTime" : Timestamp(1558710633, 1709), "signature" : { "hash" : BinData(0,"6HHjPqv9rADBkaFV3mKFGDa9bFw="), "keyId" : NumberLong("6666498389737209860") } } } { "executionStats" : { "nReturned" : 0, "executionTimeMillis" : 16, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 0, "executionTimeMillis" : 16, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "totalChildMillis" : 12, "shards" : [ { "shardName" : "EndpoingGoogleShard_5", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 0, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710931, 210), "$clusterTime" : { "clusterTime" : Timestamp(1558710931, 900), "signature" : { "hash" : BinData(0,"9LMxeW99uImtfUUcIj2e+OfbW/A="), "keyId" : NumberLong("6666498389737209860") } } } { "executionStats" : { "nReturned" : 1, "executionTimeMillis" : 13, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 1, "executionTimeMillis" : 13, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "totalChildMillis" : 10, "shards" : [ { "shardName" : "EndpoingGoogleShard_7", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 3, "advanced" : 1, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 1, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710967, 1442), "$clusterTime" : { "clusterTime" : Timestamp(1558710968, 61), "signature" : { "hash" : BinData(0,"0GSN90ItfIwB8KOskIE7bAoRvpY="), "keyId" : NumberLong("6666498389737209860") } } }In the search filter it uses a pid field which is a shardkey so it does not access all shards, but the document is in shard7 and when it returns nothing it examines only shard5 or shard2.
The same problem does not happen in the mongo shell.
NoSQLBooster Version: 5.1.7
Operating System (Windows/Mac/Ubuntu): Windows 10 / Ubuntu 18
MongoDB Version: 3.6.8
Expected /p>
Actual /p>
How to Reproduce (Please attach sample JSON data): 9 shards cluster, collection with bilions documents, indexes: {pid: 'hashed"}, {"pid": 1, universe_id: 1, account_id: 1, channel:1, normalized_shared_at:1}
{ "executionStats" : { "nReturned" : 0, "executionTimeMillis" : 37, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 0, "executionTimeMillis" : 37, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "totalChildMillis" : 32, "shards" : [ { "shardName" : "EndpoingGoogleShard_2", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 2, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 1, "restoreState" : 1, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 0, "executionTimeMillisEstimate" : 10, "works" : 1, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 1, "restoreState" : 1, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 0, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0, "indexDef" : { "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "direction" : "forward" } } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710633, 1601), "$clusterTime" : { "clusterTime" : Timestamp(1558710633, 1709), "signature" : { "hash" : BinData(0,"6HHjPqv9rADBkaFV3mKFGDa9bFw="), "keyId" : NumberLong("6666498389737209860") } } } { "executionStats" : { "nReturned" : 0, "executionTimeMillis" : 16, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 0, "executionTimeMillis" : 16, "totalKeysExamined" : 0, "totalDocsExamined" : 0, "totalChildMillis" : 12, "shards" : [ { "shardName" : "EndpoingGoogleShard_5", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 0, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 0, "executionTimeMillisEstimate" : 0, "works" : 1, "advanced" : 0, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 0, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710931, 210), "$clusterTime" : { "clusterTime" : Timestamp(1558710931, 900), "signature" : { "hash" : BinData(0,"9LMxeW99uImtfUUcIj2e+OfbW/A="), "keyId" : NumberLong("6666498389737209860") } } } { "executionStats" : { "nReturned" : 1, "executionTimeMillis" : 13, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "executionStages" : { "stage" : "SINGLE_SHARD", "nReturned" : 1, "executionTimeMillis" : 13, "totalKeysExamined" : 1, "totalDocsExamined" : 1, "totalChildMillis" : 10, "shards" : [ { "shardName" : "EndpoingGoogleShard_7", "executionSuccess" : true, "executionStages" : { "stage" : "FETCH", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 3, "advanced" : 1, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "docsExamined" : 1, "alreadyHasObj" : 0, "inputStage" : { "stage" : "IXSCAN", "nReturned" : 1, "executionTimeMillisEstimate" : 0, "works" : 2, "advanced" : 1, "needTime" : 0, "needYield" : 0, "saveState" : 0, "restoreState" : 0, "isEOF" : 1, "invalidates" : 0, "keyPattern" : { "pid" : 1, "universe_id" : 1, "account_id" : 1, "channel" : 1, "normalized_shared_at" : 1 }, "indexName" : "pid_shared_at", "isMultiKey" : false, "multiKeyPaths" : { "pid" : [ ], "universe_id" : [ ], "account_id" : [ ], "channel" : [ ], "normalized_shared_at" : [ ] }, "isUnique" : false, "isSparse" : false, "isPartial" : false, "indexVersion" : 2, "direction" : "forward", "indexBounds" : { "pid" : [ "[\"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\", \"m_bUU3PbLyXYZYlWGnPZZVHV-kjCEQW6rTNT65mGu_n0cFLPDYVHjnAViCCMr9oi4q4c1kTxSriUEIr3njyU0MUw\"]" ], "universe_id" : [ "[4706392142249984.0, 4706392142249984.0]" ], "account_id" : [ "[5215959685005312.0, 5215959685005312.0]" ], "channel" : [ "[MinKey, MaxKey]" ], "normalized_shared_at" : [ "[MinKey, MaxKey]" ] }, "keysExamined" : 1, "seeks" : 1, "dupsTested" : 0, "dupsDropped" : 0, "seenInvalidated" : 0 } } } ] } }, "ok" : 1, "operationTime" : Timestamp(1558710967, 1442), "$clusterTime" : { "clusterTime" : Timestamp(1558710968, 61), "signature" : { "hash" : BinData(0,"0GSN90ItfIwB8KOskIE7bAoRvpY="), "keyId" : NumberLong("6666498389737209860") } } }Thanks.
Thanks.
Replies have been locked on this page!