Details
-
Improvement
-
Resolution: Done
-
Major - P3
-
None
-
2.6.8
-
None
Description
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.
Attachments
Issue Links
- is related to
-
SERVER-14642 running compact resets systemFlag to 0
-
- Closed
-
-
SERVER-15625 systemFlags missing from collStats command result
-
- Closed
-