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

systemFlags reporting different values between our UAT and PROD servers.

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.6.8
    • Component/s: Diagnostics
    • None

      systemFlags in the Stats() collection is different between our UAT and PROD servers. Our UAT servers show 1 as the value and our PROD show 0.

      Below is an example of what's returned in our UAT env't. But in our Prod env't the systemFlags is zero.

      UA:SECONDARY> db.customer.stats()
      {
      "ns" : "portfoliomanager.customer",
      "count" : 14727628,
      "size" : 34247146304,
      "avgObjSize" : 2325,
      "storageSize" : 35169865536,
      "numExtents" : 35,
      "nindexes" : 20,
      "lastExtentSize" : 2146426864,
      "paddingFactor" : 1.0180000000000002,
      "systemFlags" : 1,
      "userFlags" : 1,
      "totalIndexSize" : 9303879200,
      "indexSizes" : {
      "_id_" : 477829968,
      "customerKey" : 260642704,
      "finRecordId" : 262948336,
      "account.contractDate" : 385097776,
      "account.estimatedEquity" : 361444608,
      "dealerCode_vehicle.vin" : 637654416,
      "personalInfo.fhash_dealerCode" : 491336720,
      "personalInfo.lhash_dealerCode" : 497493248,
      "personalInfo.sortHash_dealerCode" : 489660640,
      "dealerCode_account.maturityDate_source_account.accountType" : 720101200,
      "account.maturityDate_1_maturity.closed_1" : 405022688,
      "source_1_account.accountType_1_account.maturityDate_1_active_1" : 635373312,
      "source_1_account.accountType_1_account.accountModifiedTimestamp_1_active_1" : 618784208,
      "valuationRequired_1_active_1" : 267028160,
      "account.contractDay_1_active_1" : 387272592,
      "dealerCode_1_vehicle.year_1_vehicle.make_1_vehicle.model_1" : 731711120,
      "account.originalSalesPerson.sortHash_1_dealerCode_1" : 401359840,
      "account.currentSalesPerson.sortHash_1_dealerCode_1" : 383961312,
      "dealerCode_1_account.currentSalesPerson.userId_1_active_1" : 427694736,
      "dealerCode_1_account.originalSalesPerson.fhash_1_account.originalSalesPerson.lhash_1_active_1" : 461461616
      },
      "ok" : 1
      }
      

      http://docs.mongodb.org/v2.6/reference/command/collStats/ states that it "Reports the flags on this collection that reflect internal server options. Typically this value is 1 and reflects the existence of an index on the _id field."

      When querying UAT and PROD env'ts the getIndexes() show that an Index exists.

      db.customer.getIndexes()
      [
      {
      "v" : 1,
      "key" : {
      "_id" : 1
      },
      "name" : "_id_",
      "ns" : "portfoliomanager.customer"
      },......
      

      Please advise what the Server uses this flag for, and why it may be reporting differently across env'ts.

            Assignee:
            stephen.steneker@mongodb.com Stennie Steneker (Inactive)
            Reporter:
            sean.donders@autodata.net Sean Donders
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: