|
I ran the following aggregation to determine the number of cases where a BF ticket that we addressed had only ever failed against Windows build variants.
db.issues.aggregate([
|
{$match: {$and: [
|
{"jira.fields.project.key": "BF"},
|
{"jira.fields.created": {$gte: new ISODate("2018-09-18")}},
|
{"jira.fields.resolution.name": "Fixed"},
|
{$or: [
|
{"jira.fields.customfield_14277": /^enterprise-windows/},
|
{"jira.fields.customfield_14277": /^windows/},
|
]},
|
]}},
|
{$project: {
|
_id: 0,
|
key: "$jira.key",
|
tasks: "$jira.fields.customfield_12950",
|
num_variants: {$size:
|
{$filter: {
|
input: "$jira.fields.customfield_14277",
|
cond: {$lt: [{$indexOfBytes: ["$$this", "windows"]}, 0]},
|
}}
|
}
|
}},
|
{$match: {num_variants: 0}},
|
{$unwind: "$tasks"},
|
{$group: {
|
_id: "$tasks",
|
count: {$sum: 1},
|
tickets: {$push: "$key"},
|
}},
|
{$sort: {count: -1}},
|
{$limit: 10},
|
])
|
{ "_id" : "noPassthrough", "count" : 24, "tickets" : [ "BF-7927", "BF-8721", "BF-8698", "BF-9108", "BF-9392", "BF-10624", "BF-10654", "BF-10783", "BF-11036", "BF-11113", "BF-11137", "BF-11218", "BF-11256", "BF-11289", "BF-11412", "BF-12341", "BF-11488", "BF-11548", "BF-11623", "BF-11994", "BF-12148", "BF-12234", "BF-12405", "BF-12544" ] }
|
{ "_id" : "compile_all", "count" : 21, "tickets" : [ "BF-8486", "BF-8531", "BF-8596", "BF-8697", "BF-8951", "BF-9081", "BF-9280", "BF-9342", "BF-9491", "BF-9699", "BF-9710", "BF-9871", "BF-10181", "BF-10255", "BF-10594", "BF-10978", "BF-11249", "BF-11535", "BF-11527", "BF-11823", "BF-12631" ] }
|
{ "_id" : "compile", "count" : 18, "tickets" : [ "BF-7915", "BF-8531", "BF-8724", "BF-8935", "BF-9081", "BF-9342", "BF-9491", "BF-9710", "BF-9751", "BF-9952", "BF-10162", "BF-10908", "BF-11441", "BF-11831", "BF-12530", "BF-12560", "BF-12662", "BF-12819" ] }
|
{ "_id" : "unittests!", "count" : 17, "tickets" : [ "BF-9699", "BF-9775", "BF-9901", "BF-10099", "BF-10173", "BF-10203", "BF-10239", "BF-10258", "BF-10421", "BF-11487", "BF-12503", "BF-12513", "BF-12533", "BF-12609", "BF-12662", "BF-12807", "BF-12865" ] }
|
{ "_id" : "unittests", "count" : 17, "tickets" : [ "BF-10173", "BF-10239", "BF-10421", "BF-10572", "BF-10594", "BF-10628", "BF-10737", "BF-10756", "BF-11016", "BF-11068", "BF-11090", "BF-11487", "BF-11569", "BF-11661", "BF-11798", "BF-12079", "BF-12381" ] }
|
{ "_id" : "compile_unittests", "count" : 14, "tickets" : [ "BF-10255", "BF-10517", "BF-10628", "BF-10634", "BF-10895", "BF-10908", "BF-10954", "BF-11249", "BF-11419", "BF-11441", "BF-11535", "BF-11658", "BF-11790", "BF-12120" ] }
|
{ "_id" : "powercycle_replication", "count" : 9, "tickets" : [ "BF-7821", "BF-8533", "BF-9095", "BF-9130", "BF-9490", "BF-10216", "BF-11588", "BF-12243", "BF-12233" ] }
|
{ "_id" : "jstestfuzz_concurrent", "count" : 8, "tickets" : [ "BF-7494", "BF-8010", "BF-8214", "BF-8424", "BF-8669", "BF-9343", "BF-10347", "BF-10364" ] }
|
{ "_id" : "sharding", "count" : 7, "tickets" : [ "BF-8106", "BF-8252", "BF-8698", "BF-10099", "BF-10744", "BF-12032", "BF-12056" ] }
|
{ "_id" : "powercycle_kill_mongod", "count" : 6, "tickets" : [ "BF-9780", "BF-10215", "BF-10216", "BF-11588", "BF-12242", "BF-12233" ] }
|
|