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

Erroneous document returned in query (wt) (mms-dev)

    • Fully Compatible
    • ALL

      The query below on a 2.8.0rc1 wiredtiger primary is returning a document with status: CLOSED when querying for status: OPEN.

      mmsdev:PRIMARY> db.version();
      2.8.0-rc1
      mmsdev:PRIMARY> db.data.alerts.v2.find({status: 'OPEN', cid:ObjectId('5401c3c2f64b2377fcd0aff2'), et: {$in: ['RESYNC_REQUIRED']}}).pretty()
      {
      	"_id" : ObjectId("547941dfe4b03b02cc78d079"),
      	"et" : "RESYNC_REQUIRED",
      	"rsId" : "config-a3377110b851dfb90a60b59a0b3cc3aa",
      	"clusterName" : "quark",
      	"st" : "CONFIG_SERVER",
      	"_t" : "BACKUP",
      	"cid" : ObjectId("5401c3c2f64b2377fcd0aff2"),
      	"acids" : [
      		ObjectId("5401e247e4b0eb78e88d3da1")
      	],
      	"status" : "CLOSED",
      	"cre" : ISODate("2014-11-29T03:47:43.114Z"),
      	"upd" : ISODate("2014-11-29T22:06:08.232Z"),
      	"ln" : [
      		{
      			"to" : "5401c3c2f64b2377fcd0aff2",
      			"sent" : ISODate("2014-11-29T22:05:44.637Z"),
      			"c" : 151
      		}
      	],
      	"lnd" : ISODate("2014-11-29T22:05:44.637Z"),
      	"res" : ISODate("2014-11-29T22:06:08.232Z")
      }
      mmsdev:PRIMARY> db.data.alerts.v2.getIndexes();
      [
      	{
      		"v" : 1,
      		"key" : {
      			"_id" : 1
      		},
      		"name" : "_id_",
      		"ns" : "mmsdb.data.alerts.v2"
      	},
      	{
      		"v" : 1,
      		"key" : {
      			"hid" : 1,
      			"status" : 1
      		},
      		"name" : "hostIdStatusIdx",
      		"ns" : "mmsdb.data.alerts.v2"
      	},
      	{
      		"v" : 1,
      		"key" : {
      			"cid" : 1,
      			"status" : 1,
      			"cre" : -1
      		},
      		"name" : "groupIdStatusCreatedIdx",
      		"ns" : "mmsdb.data.alerts.v2"
      	},
      	{
      		"v" : 1,
      		"key" : {
      			"status" : 1,
      			"acids" : 1
      		},
      		"name" : "status_1_acids_1",
      		"ns" : "mmsdb.data.alerts.v2"
      	}
      ]
      mmsdev:PRIMARY> db.runCommand({getCmdLineOpts:1})
      {
      	"argv" : [
      		"/var/lib/mongodb-mms-automation/mongodb-linux-x86_64-2.8.0-rc1-pre-6/bin/mongod",
      		"-f",
      		"/data/mmsdev_4/automation-mongod.conf"
      	],
      	"parsed" : {
      		"config" : "/data/mmsdev_4/automation-mongod.conf",
      		"net" : {
      			"port" : 27018
      		},
      		"processManagement" : {
      			"fork" : true
      		},
      		"replication" : {
      			"replSetName" : "mmsdev"
      		},
      		"storage" : {
      			"dbPath" : "/data/mmsdev_4",
      			"engine" : "wiredtiger"
      		},
      		"systemLog" : {
      			"destination" : "file",
      			"path" : "/data/mmsdev_4/mongodb.log"
      		}
      	},
      	"ok" : 1
      }
      

      The same query on the MMAPv1 secondary returns correctly:

      mmsdev:SECONDARY> db.data.alerts.v2.find({status: 'OPEN', cid:ObjectId('5401c3c2f64b2377fcd0aff2'), et: {$in: ['RESYNC_REQUIRED']}}).pretty()
      mmsdev:SECONDARY> 
      

            Assignee:
            mark.benvenuto@mongodb.com Mark Benvenuto
            Reporter:
            cailin.nelson@mongodb.com Cailin Nelson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            20 Start watching this issue

              Created:
              Updated:
              Resolved: