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

Missing [resolvedViews] field for inserts and commands on time series collections and views

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 5.0.0-rc0
    • Component/s: None
    • Query Integration
    • Query Execution 2021-07-26, QE 2021-08-09, QE 2021-08-23, QE 2021-09-06, QE 2021-09-20, QE 2021-10-04, QE 2021-10-18, QE 2021-11-01, QE 2021-11-15, QE 2021-11-29, QE 2021-12-13, QE 2021-12-27, QE 2022-01-10, QE 2022-01-24

      Description

      In SERVER-50286, the `resolvedViews field was added to slow query log entries for views and time series collections.

      The current issue is that the `resolvedViews` field is not present on all slow query logs including insert and create logs. 

       Example Time Series Insert Log

      {"t":{"$date":"2021-06-28T16:56:57.528-04:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn4263","msg":"Slow query","attr":{"type":"command","ns":"timeDB.timeseriesCollection","appName":"MongoDB Shell","command":{"insert":"timeseriesCollection","ordered":true,"lsid":{"id":{"$uuid":"37b18558-878f-4403-8d50-375c4d4714f0"}},"$db":"timeDB"},"ninserted":1,"keysInserted":0,"numYields":0,"reslen":45,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"ReplicationStateTransition":{"acquireCount":{"w":1}},"Global":{"acquireCount":{"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{},"remote":"127.0.0.1:63564","protocol":"op_msg","durationMillis":0}} 

      Example Time Series Create Log

      {"t":{"$date":"2021-06-28T15:44:26.178-04:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn151","msg":"Slow query","attr":{"type":"command","ns":"timeDB.timeseriesCollection","appName":"MongoDB Shell","command":{"create":"timeseriesCollection","timeseries":{"timeField":"tf"},"lsid":{"id":{"$uuid":"a7ce46ff-77ba-41e3-b0c8-adb39b1a7356"}},"$db":"timeDB"},"keysInserted":1,"numYields":0,"reslen":38,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":4}},"ReplicationStateTransition":{"acquireCount":{"w":6}},"Global":{"acquireCount":{"r":4,"w":2}},"Database":{"acquireCount":{"r":4,"w":2}},"Collection":{"acquireCount":{"r":3,"w":2,"W":1}},"Mutex":{"acquireCount":{"r":7}}},"flowControl":{"acquireCount":2,"timeAcquiringMicros":6},"storage":{},"remote":"127.0.0.1:51958","protocol":"op_msg","durationMillis":183}}
      

      Example View Create Log

      {"t":{"$date":"2021-06-28T15:59:47.589-04:00"},"s":"I",  "c":"COMMAND",  "id":51803,   "ctx":"conn151","msg":"Slow query","attr":{"type":"command","ns":"smol.managementFeedback","appName":"MongoDB Shell","command":{"create":"managementFeedback","pipeline":[{"$project":{"management":"$feedback.management","department":1}}],"viewOn":"survey","lsid":{"id":{"$uuid":"a7ce46ff-77ba-41e3-b0c8-adb39b1a7356"}},"$db":"smol"},"keysInserted":1,"numYields":0,"reslen":38,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":2}},"ReplicationStateTransition":{"acquireCount":{"w":4}},"Global":{"acquireCount":{"r":3,"w":1}},"Database":{"acquireCount":{"r":3,"w":1}},"Collection":{"acquireCount":{"r":2,"w":1,"W":1}},"Mutex":{"acquireCount":{"r":4}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":1},"storage":{},"remote":"127.0.0.1:51958","protocol":"op_msg","durationMillis":133}}
      

       

       

       

       

            Assignee:
            backlog-query-integration Backlog - Query Integration
            Reporter:
            george.zhuang@mongodb.com George Zhuang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: