-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
ALL
-
None
-
3
-
TBD
-
None
-
None
-
None
-
None
-
None
-
None
-
None
"Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"test.regex_expr_limit","collectionType":"normal","appName":"MongoDB Shell","command":{"getMore":3363164617034693338,"collection":"regex_expr_limit","lsid":{"id":{"$uuid":"b471bf03-97ea-4317-b673-7268226a2f1a"},"uid":{"$binary":{"base64":"47DEQpj8HBSa+/TImW+5JCeuQeRkm5NMpJWZG3hSuFU=","subType":"0"}}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1753136171,"i":3}}},"$configTime":{"$timestamp":{"t":1753136171,"i":3}},"$topologyTime":{"$timestamp":{"t":1753136119,"i":9}},"$client":{"application":{"name":"MongoDB Shell"},"driver":{"name":"MongoDB Internal Client","version":"8.2.0-alpha2-85-gdafcedb-patch-687eb8f2c92ec700079bd5cd"},"os":{"type":"Linux","name":"Amazon Linux release 2023.8.20250707 (Amazon Linux)","architecture":"aarch64","version":"Kernel 6.1.141-165.249.amzn2023.aarch64"},"mongos":{"host":"ip-10-128-194-11.ec2.internal:20253","client":"127.0.0.1:54904","version":"8.2.0-alpha2-85-gdafcedb-patch-687eb8f2c92ec700079bd5cd"}},"mayBypassWriteBlocking":false,"$db":"test"},"originatingCommand":{"aggregate":"regex_expr_limit","pipeline":[{"$project":{"matches":{"$regexMatch":{"input":"$z","regex":{"$const":"(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)(d)e"}}},"_id":false}}],"cursor":{"batchSize":0},"needsMerge":true,"let":{},"fromRouter":true,"collation":{"locale":"simple"},"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":0,"provenance":"implicitDefault"},"shardVersion":{"e":{"$oid":"687ebc2267236d3b6e6e584c"},"t":{"$timestamp":{"t":1753136162,"i":200}},"v":{"$timestamp":{"t":1,"i":0}}},"clientOperationKey":{"$uuid":"6fb093bd-e9ea-4414-bd2e-99cb10837bad"},"lsid":{"id":{"$uuid":"b471bf03-97ea-4317-b673-7268226a2f1a"},"uid":{"$binary":{"base64":"47DEQpj8HBSa+/TImW+5JCeuQeRkm5NMpJWZG3hSuFU=","subType":"0"}}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1753136171,"i":3}}},"$configTime":{"$timestamp":{"t":1753136171,"i":3}},"$topologyTime":{"$timestamp":{"t":1753136119,"i":9}},"$client":{"application":{"name":"MongoDB Shell"},"driver":{"name":"MongoDB Internal Client","version":"8.2.0-alpha2-85-gdafcedb-patch-687eb8f2c92ec700079bd5cd"},"os":{"type":"Linux","name":"Amazon Linux release 2023.8.20250707 (Amazon Linux)","architecture":"aarch64","version":"Kernel 6.1.141-165.249.amzn2023.aarch64"},"mongos":{"host":"ip-10-128-194-11.ec2.internal:20253","client":"127.0.0.1:54904","version":"8.2.0-alpha2-85-gdafcedb-patch-687eb8f2c92ec700079bd5cd"}},"mayBypassWriteBlocking":false,"$db":"test"},"planSummary":"COLLSCAN","cursorid":3363164617034693338,"keysExamined":0,"docsExamined":1,"nBatches":1,"cursorExhausted":true,"numYields":1,"nreturned":1,"planCacheShapeHash":"53E74551","queryHash":"53E74551","planCacheKey":"33BB9223","queryFramework":"classic","reslen":234,"locks":{"Global":{"acquireCount":{"r":2}}},"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":0,"provenance":"implicitDefault"},"storage":{"timeWaitingMicros":{"storageExecutionMicros":9111}},"cpuNanos":1088806124,"remote":"127.0.0.1:51570","protocol":"op_msg","delinquencyInfo":{"totalDelinquentAcquisitions":1,"totalAcquisitionDelinquencyMillis":1152,"maxAcquisitionDelinquencyMillis":1152},"queues":{"ingress":{"admissions":1},"execution":{"admissions":3}},"workingMillis":1153,"durationMillis":1153}
Please close this ticket as “Work as Design” or “Won’t Do” if this is expected or the testing issue.
- is related to
-
SERVER-82167 $regex may use unbounded cpu and memory
-
- Open
-