Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-31885

changeStream cursor is not returned on a mongos when the database does not exist

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 3.6.1, 3.7.1
    • Affects Version/s: 3.6.0-rc3
    • Component/s: Aggregation Framework
    • None
    • Fully Compatible
    • ALL
    • v3.6
    • Query 2017-12-18

      On a replica set a changeStream cursor can be created on a collection where the database does not exist yet:

      > db.dropDatabase()
      { "ok" : 1, "operationTime" : Timestamp(1510184057, 1) }
      > db.runCommand({"aggregate":"database-does-not-exist", "pipeline":[{'$changeStream': {}}], "cursor": {}})
      {
      	"cursor" : {
      		"firstBatch" : [ ],
      		"id" : NumberLong("5437951372965323737"),
      		"ns" : "test.database-does-not-exist"
      	},
      	"ok" : 1,
      	"operationTime" : Timestamp(1510184077, 1)
      }
      

      The same operation on a mongos does not return a cursor:

      MongoDB Enterprise mongos> db.dropDatabase()
      {
      	"dropped" : "test",
      	"ok" : 1,
      	"$clusterTime" : {
      		"clusterTime" : Timestamp(1510184413, 9),
      		"signature" : {
      			"hash" : BinData(0,"lFkT1OPozsQoRVqqU/5bXxUNhng="),
      			"keyId" : NumberLong("6486191337619062789")
      		}
      	},
      	"operationTime" : Timestamp(1510184413, 9)
      }
      MongoDB Enterprise mongos> db.runCommand({"aggregate":"database-does-not-exist", "pipeline":[{'$changeStream': {}}], "cursor": {}})
      {
      	"result" : [ ],
      	"cursor" : {
      		"id" : NumberLong(0),
      		"ns" : "test.database-does-not-exist",
      		"firstBatch" : [ ]
      	},
      	"ok" : 1,
      	"$clusterTime" : {
      		"clusterTime" : Timestamp(1510184417, 1),
      		"signature" : {
      			"hash" : BinData(0,"KsuOoKtQYUkl2peKWjMv4kJHzzE="),
      			"keyId" : NumberLong("6486191337619062789")
      		}
      	},
      	"operationTime" : Timestamp(1510184417, 1)
      }
      

      This is surprising when combined with the fact that wired tiger drops databases when there are no more collections.

            Assignee:
            bernard.gorman@mongodb.com Bernard Gorman
            Reporter:
            shane.harvey@mongodb.com Shane Harvey
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: