[SERVER-73509] timeseries_lastpoint_top.js is no longer working Created: 01/Feb/23  Updated: 29/Oct/23  Resolved: 25/Aug/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Charlie Swanson Assignee: Peter Volk
Resolution: Fixed Votes: 0
Labels: auto-reverted, greenerbuild
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Related
is related to SERVER-72517 Tests for former featureFlagTimeserie... Closed
is related to SERVER-75243 Disable broken timeseries_lastpoint_t... Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Operating System: ALL
Steps To Reproduce:

Remove the early return at the top of the test, and run the test.

Participants:
Linked BF Score: 158

 Description   

It has been silently not running for a while (see SERVER-72517), but when I go to turn it back on it fails:

[js_test:timeseries_lastpoint_top] 2023-02-01T02:28:10.112Z assert: [null] != [null] are equal : {
[js_test:timeseries_lastpoint_top]      "explainVersion" : "1",
[js_test:timeseries_lastpoint_top]      "stages" : [
[js_test:timeseries_lastpoint_top]              {
[js_test:timeseries_lastpoint_top]                      "$cursor" : {
[js_test:timeseries_lastpoint_top]                              "queryPlanner" : {
[js_test:timeseries_lastpoint_top]                                      "namespace" : "timeseries_lastpoint_top.system.buckets.in",
[js_test:timeseries_lastpoint_top]                                      "indexFilterSet" : false,
[js_test:timeseries_lastpoint_top]                                      "parsedQuery" : {
[js_test:timeseries_lastpoint_top] 
[js_test:timeseries_lastpoint_top]                                      },
[js_test:timeseries_lastpoint_top]                                      "queryHash" : "1EFD6FE8",
[js_test:timeseries_lastpoint_top]                                      "planCacheKey" : "1EFD6FE8",
[js_test:timeseries_lastpoint_top]                                      "maxIndexedOrSolutionsReached" : false,
[js_test:timeseries_lastpoint_top]                                      "maxIndexedAndSolutionsReached" : false,
[js_test:timeseries_lastpoint_top]                                      "maxScansToExplodeReached" : false,
[js_test:timeseries_lastpoint_top]                                      "winningPlan" : {
[js_test:timeseries_lastpoint_top]                                              "stage" : "PROJECTION_DEFAULT",
[js_test:timeseries_lastpoint_top]                                              "transformBy" : {
[js_test:timeseries_lastpoint_top]                                                      "meta.hostid" : 1,
[js_test:timeseries_lastpoint_top]                                                      "_id" : 0
[js_test:timeseries_lastpoint_top]                                              },
[js_test:timeseries_lastpoint_top]                                              "inputStage" : {
[js_test:timeseries_lastpoint_top]                                                      "stage" : "COLLSCAN",
[js_test:timeseries_lastpoint_top]                                                      "direction" : "forward"
[js_test:timeseries_lastpoint_top]                                              }
[js_test:timeseries_lastpoint_top]                                      },
[js_test:timeseries_lastpoint_top]                                      "rejectedPlans" : [ ]
[js_test:timeseries_lastpoint_top]                              }
[js_test:timeseries_lastpoint_top]                      }
[js_test:timeseries_lastpoint_top]              },
[js_test:timeseries_lastpoint_top]              {
[js_test:timeseries_lastpoint_top]                      "$group" : {
[js_test:timeseries_lastpoint_top]                              "_id" : "$meta.hostid"
[js_test:timeseries_lastpoint_top]                      }
[js_test:timeseries_lastpoint_top]              }
[js_test:timeseries_lastpoint_top]      ],
[js_test:timeseries_lastpoint_top]      "serverInfo" : {
[js_test:timeseries_lastpoint_top]              "host" : "ip-10-122-13-190",
[js_test:timeseries_lastpoint_top]              "port" : 30000,
[js_test:timeseries_lastpoint_top]              "version" : "6.3.0-alpha",
[js_test:timeseries_lastpoint_top]              "gitVersion" : "refs/heads/charlie.swanson/SERVER-72517-feature-flag-robustness"
[js_test:timeseries_lastpoint_top]      },
[js_test:timeseries_lastpoint_top]      "serverParameters" : {
[js_test:timeseries_lastpoint_top]              "internalQueryFacetBufferSizeBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalQueryFacetMaxOutputDocSizeBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalLookupStageIntermediateDocumentMaxSizeBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalDocumentSourceGroupMaxMemoryBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalQueryMaxBlockingSortMemoryUsageBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalQueryProhibitBlockingMergeOnMongoS" : 0,
[js_test:timeseries_lastpoint_top]              "internalQueryMaxAddToSetBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalDocumentSourceSetWindowFieldsMaxMemoryBytes" : 104857600,
[js_test:timeseries_lastpoint_top]              "internalQueryFrameworkControl" : "tryBonsai"
[js_test:timeseries_lastpoint_top]      },
[js_test:timeseries_lastpoint_top]      "command" : {
[js_test:timeseries_lastpoint_top]              "aggregate" : "system.buckets.in",
[js_test:timeseries_lastpoint_top]              "pipeline" : [
[js_test:timeseries_lastpoint_top]                      {
[js_test:timeseries_lastpoint_top]                              "$_internalUnpackBucket" : {
[js_test:timeseries_lastpoint_top]                                      "timeField" : "time",
[js_test:timeseries_lastpoint_top]                                      "metaField" : "tags",
[js_test:timeseries_lastpoint_top]                                      "bucketMaxSpanSeconds" : 3600,
[js_test:timeseries_lastpoint_top]                                      "assumeNoMixedSchemaData" : true,
[js_test:timeseries_lastpoint_top]                                      "usesExtendedRange" : false
[js_test:timeseries_lastpoint_top]                              }
[js_test:timeseries_lastpoint_top]                      },
[js_test:timeseries_lastpoint_top]                      {
[js_test:timeseries_lastpoint_top]                              "$group" : {
[js_test:timeseries_lastpoint_top]                                      "_id" : "$tags.hostid",
[js_test:timeseries_lastpoint_top]                                      "mostRecent" : {
[js_test:timeseries_lastpoint_top]                                              "$topN" : {
[js_test:timeseries_lastpoint_top]                                                      "sortBy" : {
[js_test:timeseries_lastpoint_top]                                                              "time" : -1
[js_test:timeseries_lastpoint_top]                                                      },
[js_test:timeseries_lastpoint_top]                                                      "output" : {
[js_test:timeseries_lastpoint_top]                                                              "usage_user" : {
[js_test:timeseries_lastpoint_top]                                                                      "usage_user" : "$usage_user"
[js_test:timeseries_lastpoint_top]                                                              },
[js_test:timeseries_lastpoint_top]                                                              "usage_guest" : {
[js_test:timeseries_lastpoint_top]                                                                      "usage_guest" : "$usage_guest"
[js_test:timeseries_lastpoint_top]                                                              },
[js_test:timeseries_lastpoint_top]                                                              "usage_idle" : {
[js_test:timeseries_lastpoint_top]                                                                      "usage_idle" : "$usage_idle"
[js_test:timeseries_lastpoint_top]                                                              }
[js_test:timeseries_lastpoint_top]                                                      },
[js_test:timeseries_lastpoint_top]                                                      "n" : 1
[js_test:timeseries_lastpoint_top]                                              }
[js_test:timeseries_lastpoint_top]                                      }
[js_test:timeseries_lastpoint_top]                              }
[js_test:timeseries_lastpoint_top]                      }
[js_test:timeseries_lastpoint_top]              ],
[js_test:timeseries_lastpoint_top]              "cursor" : {
[js_test:timeseries_lastpoint_top] 
[js_test:timeseries_lastpoint_top]              },
[js_test:timeseries_lastpoint_top]              "collation" : {
[js_test:timeseries_lastpoint_top]                      "locale" : "simple"
[js_test:timeseries_lastpoint_top]              }
[js_test:timeseries_lastpoint_top]      },
[js_test:timeseries_lastpoint_top]      "ok" : 1
[js_test:timeseries_lastpoint_top] }
[js_test:timeseries_lastpoint_top] doassert@src/mongo/shell/assert.js:20:14
[js_test:timeseries_lastpoint_top] assert.neq@src/mongo/shell/assert.js:276:17
[js_test:timeseries_lastpoint_top] expectCollScan@jstests/core/timeseries/libs/timeseries_lastpoint_helpers.js:181:16
[js_test:timeseries_lastpoint_top] verifyLastpoint@jstests/core/timeseries/libs/timeseries_lastpoint_helpers.js:21:16
[js_test:timeseries_lastpoint_top] testAllTimeMetaDirections@jstests/core/timeseries/libs/timeseries_lastpoint_helpers.js:243:32
[js_test:timeseries_lastpoint_top] @jstests/core/timeseries/timeseries_lastpoint_top.js:59:30
[js_test:timeseries_lastpoint_top] @jstests/core/timeseries/timeseries_lastpoint_top.js:168:3



 Comments   
Comment by Githook User [ 25/Aug/23 ]

Author:

{'name': 'Peter Volk', 'email': 'peter.volk@mongodb.com', 'username': 'HCSPete'}

Message: SERVER-73509 Re-enabled timeseries_lastpoint_top.js with additional tags
Branch: master
https://github.com/mongodb/mongo/commit/c13dd99398cd5d0c0ed31001e772f73ccc0153c1

Comment by Githook User [ 22/Jun/23 ]

Author:

{'name': 'Max Hirschhorn', 'email': 'max.hirschhorn@mongodb.com', 'username': 'visemet'}

Message: Revert "SERVER-73509 timeseries_lastpoint_top.js is no longer working"

This reverts commit 7643cfe957bf85e05c023d67390dff1899bf2390.
Branch: master
https://github.com/mongodb/mongo/commit/876f89082ce4115d3f391d3c4bee20f4ed6432e5

Comment by Githook User [ 22/Jun/23 ]

Author:

{'name': 'Peter Volk', 'email': 'peter.volk@mongodb.com', 'username': 'HCSPete'}

Message: SERVER-73509 timeseries_lastpoint_top.js is no longer working
Branch: master
https://github.com/mongodb/mongo/commit/7643cfe957bf85e05c023d67390dff1899bf2390

Comment by xgen-buildbaron-user [ 14/Jun/23 ]

Ticket re-opened due to revert. jsCore_wildcard_indexes began a consistent failure of jstests\core\timeseries\timeseries_lastpoint_top.js

Comment by Githook User [ 14/Jun/23 ]

Author:

{'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}

Message: Revert "SERVER-73509 timeseries_lastpoint_top.js is no longer working"

This reverts commit d1e54f4b601b519f651293a081770f89ef033304.
Branch: master
https://github.com/mongodb/mongo/commit/fc041f0f0a5e27ac723a3550e0249e2832e05b2b

Comment by Githook User [ 14/Jun/23 ]

Author:

{'name': 'Peter Volk', 'email': 'peter.volk@mongodb.com', 'username': 'HCSPete'}

Message: SERVER-73509 timeseries_lastpoint_top.js is no longer working
Branch: master
https://github.com/mongodb/mongo/commit/d1e54f4b601b519f651293a081770f89ef033304

Comment by Alya Berciu [ 24/Mar/23 ]

Sorry, this got a bit lost since I last commented. Flagging this for scheduling, since I think this is an actual bug (see my description above) and it looks like it affects multiple versions.

CC alexander.ignatyev@mongodb.com saw a related BF recently on 6.0: BF-27951

Comment by Charlie Swanson [ 01/Feb/23 ]

cc alya.berciu@mongodb.com - looks like you wrote the test originally.

Generated at Thu Feb 08 06:24:52 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.