|
Slow query lines that exist in the PSC version that don't exist in the passing logs:
------------------------
createIndexes
[j3:s0:prim] | 2022-02-14T20:33:31.088+00:00 I COMMAND 51803 [ShardServerCatalogCacheLoader::runCollAndChunksTasks] "Slow query","attr":{"type":"command","ns":"config.cache.chunks.change_stream_check_resumability.test","command":{"createIndexes":"cache.chunks.change_stream_check_resumability.test","indexes":[{"name":"lastmod_1","key":{"lastmod":1}}],"$db":"config"},"numYields":0,"reslen":300,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":6}},"ReplicationStateTransition":{"acquireCount":{"w":6}},"Global":{"acquireCount":{"r":4,"w":2}},"Database":{"acquireCount":{"r":4,"w":2}},"Collection":{"acquireCount":{"r":3,"w":2}},"Mutex":{"acquireCount":{"r":8}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":5},"storage":{},"protocol":"op_msg","durationMillis":109}
|
------------------------
create: test (and create:test below)
[j3:s0:prim] | 2022-02-14T20:33:33.145+00:00 I COMMAND 51803 [conn50] "Slow query","attr":{"type":"command","ns":"change_stream_check_resumability.test","appName":"MongoDB Shell","command":{"create":"test","capped":false,"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":300321,"provenance":"clientSupplied"},"databaseVersion":{"uuid":{"$uuid":"94363c61-44b7-4cb9-a690-f0259dddc8bc"},"timestamp":{"$timestamp":{"t":1644870811,"i":43}},"lastMod":1},"lsid":{"id":{"$uuid":"9bca64e5-d96d-461a-8267-2b537b883a2b"},"uid":{"$binary":{"base64":"47DEQpj8HBSa+/TImW+5JCeuQeRkm5NMpJWZG3hSuFU=","subType":"0"}}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1644870812,"i":2}},"signature":{"hash":{"$binary":{"base64":"AAAAAAAAAAAAAAAAAAAAAAAAAAA=","subType":"0"}},"keyId":0}},"$configTime":{"$timestamp":{"t":1644870812,"i":1}},"$topologyTime":{"$timestamp":{"t":1644870804,"i":4}},"$client":{"application":{"name":"MongoDB Shell"},"driver":{"name":"MongoDB Internal Client","version":"5.3.0-alpha4-31-g724d7f8-patch-620aa5c3850e61197d495bfc"},"os":{"type":"Linux","name":"Red Hat Enterprise Linux release 8.0 (Ootpa)","architecture":"x86_64","version":"Kernel 4.18.0-80.1.2.el8_0.x86_64"},"mongos":{"host":"ip-10-122-29-8.ec2.internal:20752","client":"127.0.0.1:58162","version":"5.3.0-alpha4-31-g724d7f8-patch-620aa5c3850e61197d495bfc"}},"$db":"change_stream_check_resumability"},"numYields":0,"reslen":236,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":1}},"ReplicationStateTransition":{"acquireCount":{"w":2}},"Global":{"acquireCount":{"r":1,"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"r":1,"w":1}},"Mutex":{"acquireCount":{"r":3,"W":1}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":5},"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":300321,"provenance":"clientSupplied"},"storage":{},"remote":"127.0.0.1:42460","protocol":"op_msg","durationMillis":174}
|
[j3:s] | 2022-02-14T20:33:33.145+00:00 I COMMAND 51803 [conn24] "Slow query","attr":{"type":"command","ns":"change_stream_check_resumability.test","appName":"MongoDB Shell","command":{"create":"test","lsid":{"id":{"$uuid":"9bca64e5-d96d-461a-8267-2b537b883a2b"}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1644870811,"i":43}},"signature":{"hash":{"$binary":{"base64":"AAAAAAAAAAAAAAAAAAAAAAAAAAA=","subType":"0"}},"keyId":0}},"writeConcern":{"w":"majority","wtimeout":300321},"$db":"change_stream_check_resumability"},"numYields":0,"reslen":163,"readConcern":{"level":"local","provenance":"implicitDefault"},"remote":"127.0.0.1:58162","protocol":"op_msg","durationMillis":205}
|
------------------------
createIndexes
[j3:s0:prim] | 2022-02-14T20:33:33.384+00:00 I COMMAND 51803 [ShardingDDLCoordinator-1] "Slow query","attr":{"type":"command","ns":"change_stream_check_resumability.test","command":{"createIndexes":"test","indexes":[{"key":{"_id":"hashed"},"name":"_id_hashed"}],"writeConcern":{"w":"majority"},"$db":"change_stream_check_resumability"},"numYields":0,"reslen":300,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":11}},"ReplicationStateTransition":{"acquireCount":{"w":15}},"Global":{"acquireCount":{"r":15,"w":3}},"Database":{"acquireCount":{"r":9,"w":2}},"Collection":{"acquireCount":{"r":7,"w":1,"R":1,"W":1}},"Mutex":{"acquireCount":{"r":15,"W":1}}},"flowControl":{"acquireCount":2,"timeAcquiringMicros":8},"writeConcern":{"w":"majority","wtimeout":0,"provenance":"clientSupplied"},"storage":{},"protocol":"op_msg","durationMillis":105}
|
------------------------
createIndexes
[j3:s0:prim] | 2022-02-14T20:33:33.764+00:00 I COMMAND 51803 [ShardServerCatalogCacheLoader::runCollAndChunksTasks] "Slow query","attr":{"type":"command","ns":"config.cache.chunks.change_stream_check_resumability.test","command":{"createIndexes":"cache.chunks.change_stream_check_resumability.test","indexes":[{"name":"lastmod_1","key":{"lastmod":1}}],"$db":"config"},"numYields":0,"reslen":300,"locks":{"ParallelBatchWriterMode":{"acquireCount":{"r":6}},"ReplicationStateTransition":{"acquireCount":{"w":6}},"Global":{"acquireCount":{"r":4,"w":2}},"Database":{"acquireCount":{"r":4,"w":2}},"Collection":{"acquireCount":{"r":3,"w":2}},"Mutex":{"acquireCount":{"r":8}}},"flowControl":{"acquireCount":1,"timeAcquiringMicros":3},"storage":{},"protocol":"op_msg","durationMillis":260}
|
------------------------
The only commands that do exist in the non-PSC case are:
_shardsvrCreateCollection (and shardCollection below)
_shardsvrDropDatabase (and dropDatabase below)
_shardsvrCreateCollection (and shardCollection below)
|