WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested WORKER thread is created on path: /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0 PLAYGROUND cancellation requested Provide completion items for a position: { line: 146, character: 6 } VISITOR completion state: { databaseName: 'xform_cloud', collectionName: 'cloud_last_ping_delta_doc', isObjectSelection: false, isArraySelection: false, isObjectKey: true, isIdentifierObjectValue: true, isTextObjectValue: false, isStage: true, stageOperator: null, isCollectionSymbol: false, isUseCallExpression: false, isGlobalSymbol: false, isDbSymbol: false, isCollectionName: false, isAggregationCursor: false, isFindCursor: false } /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85784 if (!schema[typeName]) { ^ TypeError: Cannot read properties of undefined (reading 'Number') at addToType (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85784:24) at addToField (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85823:13) at /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85802:67 at Array.forEach () at addToType (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85802:39) at addToField (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85823:13) at /Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85802:67 at Array.forEach () at addToType (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85802:39) at addToField (/Users/katya/.vscode/extensions/mongodb.mongodb-vscode-1.1.0/dist/languageServer.js:85823:13) [Info - 1:48:15 PM] Connection to server got closed. Server will restart. true Provide completion items for a position: { line: 146, character: 8 } VISITOR completion state: { databaseName: 'xform_cloud', collectionName: 'cloud_last_ping_delta_doc', isObjectSelection: false, isArraySelection: false, isObjectKey: true, isIdentifierObjectValue: true, isTextObjectValue: false, isStage: true, stageOperator: null, isCollectionSymbol: false, isUseCallExpression: false, isGlobalSymbol: false, isDbSymbol: false, isCollectionName: false, isAggregationCursor: false, isFindCursor: false } VISITOR found stage operator completions Provide completion items for a position: { line: 146, character: 13 } VISITOR completion state: { databaseName: 'xform_cloud', collectionName: 'cloud_last_ping_delta_doc', isObjectSelection: false, isArraySelection: false, isObjectKey: true, isIdentifierObjectValue: true, isTextObjectValue: false, isStage: true, stageOperator: null, isCollectionSymbol: false, isUseCallExpression: false, isGlobalSymbol: false, isDbSymbol: false, isCollectionName: false, isAggregationCursor: false, isFindCursor: false } VISITOR found stage operator completions Provide completion items for a position: { line: 146, character: 13 } VISITOR completion state: { databaseName: 'xform_cloud', collectionName: 'cloud_last_ping_delta_doc', isObjectSelection: false, isArraySelection: false, isObjectKey: true, isIdentifierObjectValue: true, isTextObjectValue: false, isStage: true, stageOperator: null, isCollectionSymbol: false, isUseCallExpression: false, isGlobalSymbol: false, isDbSymbol: false, isCollectionName: false, isAggregationCursor: false, isFindCursor: false } VISITOR found stage operator completions parseAST error: 'Unexpected token (150:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' \n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' parseAST error: 'Unexpected token (150:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' \n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' parseAST error: 'Unexpected token (150:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' \n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' parseAST error: 'Unexpected token (150:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' \n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' parseAST error: 'Unexpected token (150:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' \n' + ' {\n' + ' :\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' parseAST error: 'Unexpected token, expected "," (152:10)' parseAST error textFromEditor: 'use("xform_cloud");\n' + '//\n' + '// filter by version and run separate queries for 4.4, 5.0, 6.0, 7.0\n' + '//\n' + '\n' + '// p = [\n' + '// {\n' + '// $match: {\n' + '// "hostInfo.version": { $gte: "7" },\n' + '// // "hostInfo.version": { $lt: "7.0" },\n' + '// // "lastPingData.buildInfo.versionArray.0": 4,\n' + '// // "lastPingData.buildInfo.versionArray.1": 4,\n' + '// last_ping_date: { $gte: new Date("2023-06-17") },\n' + '// // last_ping_date: { $lt: new Date("2023-05-16") },\n' + '// // "lastPingData.serverStatus.metrics.commands.aggregate.total": { $gt: 0 },\n' + '// "lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed": {\n' + '// $gt: 0,\n' + '// },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit": {\n' + '// // $gt: 0,\n' + '// // },\n' + '// },\n' + '// },\n' + '// {\n' + '// $project: {\n' + '// version: "$hostInfo.version",\n' + '// changeStreams: "$lastPingData.serverStatus.metrics.changeStreams",\n' + '// // stages: "$lastPingData.serverStatus.metrics.aggStageCounters",\n' + '// groupId: 1,\n' + '// hostId: 1,\n' + '// last_ping_date: 1,\n' + '// },\n' + '// },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: null,\n' + '// // largeEventsFailed: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsFailed",\n' + '// // },\n' + '// // largeEventsSplit: {\n' + '// // $sum: "$lastPingData.serverStatus.metrics.changeStreams.largeEventsSplit",\n' + '// // },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // count: { $sum: 1 },\n' + '// // },\n' + '// // },\n' + '// ///\n' + '// // {\n' + '// // $addFields: {\n' + '// // groupAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$groupAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["group_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // windowAccumulators: {\n' + '// // $map: {\n' + '// // input: { $objectToArray: "$windowAccumulators" },\n' + '// // in: {\n' + '// // k: { $concat: ["window_", "$$this.k"] },\n' + '// // v: "$$this.v",\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: {\n' + '// // $mergeObjects: [\n' + '// // { $arrayToObject: "$groupAccumulators" },\n' + '// // { $arrayToObject: "$windowAccumulators" },\n' + '// // ],\n' + '// // },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $addFields: {\n' + '// // accumulators: { $objectToArray: "$accumulators" },\n' + '// // },\n' + '// // },\n' + '// // { $unset: ["groupAccumulators", "windowAccumulators"] },\n' + '// // {\n' + '// // $unwind: {\n' + '// // path: "$accumulators",\n' + '// // preserveNullAndEmptyArrays: false,\n' + '// // },\n' + '// // },\n' + '// // { $match: { "accumulators.v": { $gt: 0 } } },\n' + '// // {\n' + '// // $group: {\n' + '// // _id: { accumulator: "$accumulators.k" },\n' + '// // groups: { $addToSet: "$groupId" },\n' + '// // total: { $sum: "$accumulators.v" },\n' + '// // minVersion: { $min: "$version" },\n' + '// // maxVersion: { $max: "$version" },\n' + '// // minDate: { $min: "$last_ping_date" },\n' + '// // maxDate: { $max: "$last_ping_date" },\n' + '// // },\n' + '// // },\n' + '// // {\n' + '// // $set: {\n' + '// // groups: { $size: "$groups" },\n' + '// // accumulator: "$_id.accumulator",\n' + '// // },\n' + '// // },\n' + '// // { $unset: "_id" },\n' + '// ];\n' + '\n' + '// db.cloud_last_ping_delta_doc.aggregate(p);\n' + '\n' + '// db.cloud_last_ping_delta_doc.find({\n' + '// "hostInfo.version": { $gte: "7.0" },\n' + '// // "lastPingData.serverStatus.metrics.changeStreams": { $exists: true }\n' + '// // last_ping_date: { $gte: new Date("2023-07-01") },\n' + '// // "lastPingData.buildInfo.versionArray.0": 5,\n' + '// // "lastPingData.buildInfo.versionArray.1": 0,\n' + '// });\n' + '// // .sort({ last_ping_date: 1 })\n' + '// // .limit(10);\n' + '\n' + 'p2 = [\n' + ' {\n' + ' $match: {\n' + ' "hostInfo.version": { $gte: "7" },\n' + ' last_ping_date: { $gte: new Date("2023-07-15") },\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 0,\n' + ' // $or: [\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // {\n' + ' // "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' // { $gt: 0 },\n' + ' // },\n' + ' // ],\n' + ' },\n' + ' },\n' + ' {\n' + ' $project: {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile": 1,\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile": 1,\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile": 1\n' + ' {\n' + ' :\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' {\n' + ' "lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile":\n' + ' { $gt: 0 },\n' + ' },\n' + ' \n' + ' }\n' + ' }\n' + '// { $limit: 1 },\n' + ' // {\n' + ' // $group: {\n' + ' // _id: null,\n' + ' // "expr_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.expressions.percentile",\n' + ' // },\n' + ' // "group_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.groupAccumulators.percentile",\n' + ' // },\n' + ' // "window_%": {\n' + ' // $sum: "$lastPingData.serverStatus.metrics.operatorCounters.windowAccumulators.percentile",\n' + ' // },\n' + ' // unq_groups: { $addToSet: "$groupId" },\n' + ' // },\n' + ' // },\n' + '];\n' + '\n' + 'db.cloud_last_ping_delta_doc.aggregate(p2);' [Error - 1:51:23 PM] LS evaluate: extensionPath is undefined