Hi Team,
We getting alert CPU has gone above 50% then checked in mongod.logs as below log message found so can any one clarify that issue ? and how do i fix the issue ?
{“t”:{“$date”:“2023-10-10T11:23:02.682+00:00”},“s”:“I”, “c”:“NETWORK”, “id”:51800,
“ctx”:“conn332707”,“msg”:“client metadata”,“attr”:{“remote”:“192.168.250.177:65253”,“client”:“conn332707”,
“doc”:{“driver”:{“name”:“mongo-java-driver|sync|spring-boot”,“version”:“4.6.1”},“os”:{“type”:“Linux”,“name”:“Linux”,“architecture”:“amd64”,
“version”:“5.10.184-175.731.amzn2.x86_64”},“platform”:“Java/Oracle Corporation/1.8.0_342-b07”}}}
{“t”:{“$date”:“2023-10-10T11:23:02.682+00:00”},“s”:“I”, “c”:“ACCESS”, “id”:20249,
“ctx”:“conn332707”,“msg”:“Authentication failed”,“attr”:{“mechanism”:“SCRAM-SHA-256”,“speculative”:true,
“principalName”:“user1”,“authenticationDatabase”:“admin”,“remote”:“192.168.250.177:65253”,“extraInfo”:{},
“error”:“BadValue: SCRAM-SHA-256 authentication is disabled”}}
{“t”:{“$date”:“2023-10-10T11:23:02.849+00:00”},“s”:“I”, “c”:“ACCESS”, “id”:20250,
“ctx”:“conn332707”,“msg”:“Authentication succeeded”,“attr”:{“mechanism”:“SCRAM-SHA-1”,“speculative”:false,
“principalName”:“user1”,“authenticationDatabase”:“admin”,“remote”:“192.168.250.177:65253”,“extraInfo”:{}}}
{“t”:{“$date”:“2023-10-10T11:23:06.409+00:00”},“s”:“I”, “c”:“-”, “id”:20883, “ctx”:“conn332707”,“msg”:“Interrupted operation as its client disconnected”,“attr”:{“opId”:122533176}}
{“t”:{“$date”:“2023-10-10T11:23:06.412+00:00”},“s”:“W”, “c”:“COMMAND”, “id”:20525, “ctx”:“conn332707”,“msg”:“Failed to gather storage statistics for slow operation”,“attr”:{“opId”:122533176,“error”:“lock acquire timeout”}}
{“t”:{“$date”:“2023-10-10T11:23:06.412+00:00”},“s”:“I”, “c”:“COMMAND”, “id”:51803,
“ctx”:“conn332707”,“msg”:“Slow query”,“attr”:{“type”:“command”,“ns”:“testdb.test”,
“command”:{“aggregate”:“test”,“pipeline”:[{“$match”:{“$and”:[{“status”:“Open”},{“appDateTime”:{“$gte”:{“$date”:“2023-10-10T11:23:01.804Z”}}}
,{“appDateTime”:{“$lt”:{“$date”:“2023-11-09T11:23:01.804Z”}}}]}},{“$group”:{“_id”:“$storeNumber”,“totalSlotCount”:{“$sum”:1},
“minSlotDate”:{“$min”:“$appDateTime”}}}],“cursor”:{},“allowDiskUse”:false,“$db”:“testdb”,“lsid”:{“id”:{“$uuid”:“be34abfe-238c-4734-994b-61d47f252dbd”}}},“planSummary”:“IXSCAN { status: 1, DateTime: 1, Time: 1 }”,“numYields”:657,“queryHash”:“E2C2E097”,“planCacheKey”:“6DD10207”,
“ok”:0,“errMsg”:“Error in $cursor stage :: caused by :: operation was interrupted because a client disconnected”,
“errName”:“ClientDisconnect”,“errCode”:279,“reslen”:311,“locks”:{“FeatureCompatibilityVersion”:{“acquireCount”:{“r”:680}},“ReplicationStateTransition”:{“acquireCount”:{“w”:680}},“Global”:{“acquireCount”:{“r”:680}},“Database”:{“acquireCount”:{“r”:680}},“Collection”:{“acquireCount”:{“r”:680}},“Mutex”:{“acquireCount”:{“r”:23}}},“protocol”:“op_msg”,“durationMillis”:3517}}
{“t”:{“$date”:“2023-10-10T11:23:06.412+00:00”},“s”:“I”, “c”:“NETWORK”, “id”:22944,
“ctx”:“conn332707”,“msg”:“Connection ended”,“attr”:{“remote”:“192.168.250.177:65253”,“connectionId”:332707,“connectionCount”:261}}