重现步骤

反馈人：李冠

亚马逊t_amazon_automatic_replenishment_2025-10-13集合性能问题

解决方案：1、分片集合要带分片键；2、或减少数量；3、或寻找业务线的架构师沟通


存在插入、更新、查询的情况，以下是查询的命令：

{

 "username": "rwuser",

 "ns": "zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13",

 "op": "query",

 "millis": 16829,

 "docsExamined": 105,

 "keysExamined": 105,

 "nreturned": 101,

 "ndeleted": 0,

 "ninserted": 0,

 "nMatched": 0,

 "nModified": 0,

 "ts": {

   "date": 1760351115525

 },

 "clientIp": "10.17.27.126",

 "locks": {

   "Global": {

     "acquireCount": {

       "r": 2

     }

   },

   "Database": {

     "acquireCount": {

       "r": 2

     }

   },

   "Collection": {

     "acquireCount": {

       "r": 2

     },

     "acquireWaitCount": {

       "r": 1

     },

     "timeAcquiringMicros": {

       "r": 16822203

     }

   }

 },

 "command": "{ find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" }",

 "original_log": "2025-10-13T10:25:15.525+0000 I COMMAND  [conn8025] command zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13 clientIp: 10.17.27.126 username: rwuser command: find { find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" } planSummary: IXSCAN { sourceId: 1, status: 1, businessId: 1 } cursorid:4540529135866 keysExamined:105 docsExamined:105 numYields:1 nreturned:101 reslen:49256 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 }, acquireWaitCount: { r: 1 }, timeAcquiringMicros: { r: 16822203 } } } protocol:op_msg 16829ms"

}

from clipboard

from clipboard

历史记录  
  1. 2025-10-14 14:48:35, 由 陈莉珍 创建。
  2. 2025-10-14 14:49:14, 由 陈莉珍 编辑。
    修改了 所属项目，旧值为 "51"，新值为 "52"。
    修改了 所属模块，旧值为 "0"，新值为 "1955"。
    修改了 业务部门，旧值为 "0"，新值为 "2"。
    修改了 解决时效，旧值为 "0"，新值为 "-1"。
    修改了 重现步骤，区别为：
    001-
    001+ 反馈人：李冠
    002- 反馈人：李冠
    002+ 亚马逊t_amazon_automatic_replenishment_2025-10-13集合性能问题
    003-
    003+ 解决方案：1、分片集合要带分片键；2、或减少数量；3、或寻找业务线的架构师沟通
    004-
    004+
    005- 亚马逊t_amazon_automatic_replenishment_2025-10-13集合性能问题
    005+ 存在插入、更新、查询的情况，以下是查询的命令：
    006-
    006+ {
    007-
    007+ "username": "rwuser",
    008- 解决方案：1、分片集合要带分片键；2、或减少数量；3、或寻找业务线的架构师沟通
    008+ "ns": "zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13",
    009-
    009+ "op": "query",
    010-
    010+ "millis": 16829,
    011-
    011+ "docsExamined": 105,
    012-
    012+ "keysExamined": 105,
    013-
    013+ "nreturned": 101,
    014- 存在插入、更新、查询的情况，以下是查询的命令：
    014+ "ndeleted": 0,
    015-
    015+ "ninserted": 0,
    016-
    016+ "nMatched": 0,
    017- {
    017+ "nModified": 0,
    018-
    018+ "ts": {
    019-
    019+ "date": 1760351115525
    020- "username": "rwuser",
    020+ },
    021-
    021+ "clientIp": "10.17.27.126",
    022-
    022+ "locks": {
    023- "ns": "zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13",
    023+ "Global": {
    024-
    024+ "acquireCount": {
    025-
    025+ "r": 2
    026- "op": "query",
    026+ }
    027-
    027+ },
    028-
    028+ "Database": {
    029- "millis": 16829,
    029+ "acquireCount": {
    030-
    030+ "r": 2
    031-
    031+ }
    032- "docsExamined": 105,
    032+ },
    033-
    033+ "Collection": {
    034-
    034+ "acquireCount": {
    035- "keysExamined": 105,
    035+ "r": 2
    036-
    036+ },
    037-
    037+ "acquireWaitCount": {
    038- "nreturned": 101,
    038+ "r": 1
    039-
    039+ },
    040-
    040+ "timeAcquiringMicros": {
    041- "ndeleted": 0,
    041+ "r": 16822203
    042-
    042+ }
    043-
    043+ }
    044- "ninserted": 0,
    044+ },
    045-
    045+ "command": "{ find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" }",
    046-
    046+ "original_log": "2025-10-13T10:25:15.525+0000 I COMMAND [conn8025] command zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13 clientIp: 10.17.27.126 username: rwuser command: find { find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" } planSummary: IXSCAN { sourceId: 1, status: 1, businessId: 1 } cursorid:4540529135866 keysExamined:105 docsExamined:105 numYields:1 nreturned:101 reslen:49256 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 }, acquireWaitCount: { r: 1 }, timeAcquiringMicros: { r: 16822203 } } } protocol:op_msg 16829ms"
    047- "nMatched": 0,
    047+ }
    048-
    048+ <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/e1f6bdc199284db8a925c79cd1c5e81b/abfae2f6-5b2a-41e7-b5f6-9c0e55fb021b.png" title="from clipboard" alt="from clipboard" />
    049-
    049+ <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/9a51f55b2b68458d841fbd5b88985fe4/18f8737c-4bf9-4154-bea8-dd6a4b44a2ee.png" title="from clipboard" alt="from clipboard" />
    050- "nModified": 0,
    051-
    052-
    053- "ts": {
    054-
    055-
    056- "date": 1760351115525
    057-
    058-
    059- },
    060-
    061-
    062- "clientIp": "10.17.27.126",
    063-
    064-
    065- "locks": {
    066-
    067-
    068- "Global": {
    069-
    070-
    071- "acquireCount": {
    072-
    073-
    074- "r": 2
    075-
    076-
    077- }
    078-
    079-
    080- },
    081-
    082-
    083- "Database": {
    084-
    085-
    086- "acquireCount": {
    087-
    088-
    089- "r": 2
    090-
    091-
    092- }
    093-
    094-
    095- },
    096-
    097-
    098- "Collection": {
    099-
    100-
    101- "acquireCount": {
    102-
    103-
    104- "r": 2
    105-
    106-
    107- },
    108-
    109-
    110- "acquireWaitCount": {
    111-
    112-
    113- "r": 1
    114-
    115-
    116- },
    117-
    118-
    119- "timeAcquiringMicros": {
    120-
    121-
    122- "r": 16822203
    123-
    124-
    125- }
    126-
    127-
    128- }
    129-
    130-
    131- },
    132-
    133-
    134- "command": "{ find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" }",
    135-
    136-
    137- "original_log": "2025-10-13T10:25:15.525+0000 I COMMAND [conn8025] command zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13 clientIp: 10.17.27.126 username: rwuser command: find { find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" } planSummary: IXSCAN { sourceId: 1, status: 1, businessId: 1 } cursorid:4540529135866 keysExamined:105 docsExamined:105 numYields:1 nreturned:101 reslen:49256 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 }, acquireWaitCount: { r: 1 }, timeAcquiringMicros: { r: 16822203 } } } protocol:op_msg 16829ms"
    138-
    139-
    140- }
    141-
    142-
    143- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/e1f6bdc199284db8a925c79cd1c5e81b/abfae2f6-5b2a-41e7-b5f6-9c0e55fb021b.png" title="from clipboard" alt="from clipboard" />
    144-
    145-
    146- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/9a51f55b2b68458d841fbd5b88985fe4/18f8737c-4bf9-4154-bea8-dd6a4b44a2ee.png" title="from clipboard" alt="from clipboard" />
    147-
    001- <p>
    001+ <p>反馈人：李冠</p>
    002- 反馈人：李冠
    002+ <p>亚马逊t_amazon_automatic_replenishment_2025-10-13集合性能问题</p>
    003- </p>
    003+ <p>解决方案：1、分片集合要带分片键；2、或减少数量；3、或寻找业务线的架构师沟通</p>
    004- <p>
    004+ <p><br /></p>
    005- 亚马逊t_amazon_automatic_replenishment_2025-10-13集合性能问题
    005+ <p>存在插入、更新、查询的情况，以下是查询的命令：</p>
    006- </p>
    006+ <p>{</p>
    007- <p>
    007+ <p>"username": "rwuser",</p>
    008- 解决方案：1、分片集合要带分片键；2、或减少数量；3、或寻找业务线的架构师沟通
    008+ <p>"ns": "zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13",</p>
    009- </p>
    009+ <p>"op": "query",</p>
    010- <p>
    010+ <p>"millis": 16829,</p>
    011- <br />
    011+ <p>"docsExamined": 105,</p>
    012- </p>
    012+ <p>"keysExamined": 105,</p>
    013- <p>
    013+ <p>"nreturned": 101,</p>
    014- 存在插入、更新、查询的情况，以下是查询的命令：
    014+ <p>"ndeleted": 0,</p>
    015- </p>
    015+ <p>"ninserted": 0,</p>
    016- <p>
    016+ <p>"nMatched": 0,</p>
    017- {
    017+ <p>"nModified": 0,</p>
    018- </p>
    018+ <p>"ts": {</p>
    019- <p>
    019+ <p> "date": 1760351115525</p>
    020- "username": "rwuser",
    020+ <p>},</p>
    021- </p>
    021+ <p>"clientIp": "10.17.27.126",</p>
    022- <p>
    022+ <p>"locks": {</p>
    023- "ns": "zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13",
    023+ <p> "Global": {</p>
    024- </p>
    024+ <p> "acquireCount": {</p>
    025- <p>
    025+ <p> "r": 2</p>
    026- "op": "query",
    026+ <p> }</p>
    027- </p>
    027+ <p> },</p>
    028- <p>
    028+ <p> "Database": {</p>
    029- "millis": 16829,
    029+ <p> "acquireCount": {</p>
    030- </p>
    030+ <p> "r": 2</p>
    031- <p>
    031+ <p> }</p>
    032- "docsExamined": 105,
    032+ <p> },</p>
    033- </p>
    033+ <p> "Collection": {</p>
    034- <p>
    034+ <p> "acquireCount": {</p>
    035- "keysExamined": 105,
    035+ <p> "r": 2</p>
    036- </p>
    036+ <p> },</p>
    037- <p>
    037+ <p> "acquireWaitCount": {</p>
    038- "nreturned": 101,
    038+ <p> "r": 1</p>
    039- </p>
    039+ <p> },</p>
    040- <p>
    040+ <p> "timeAcquiringMicros": {</p>
    041- "ndeleted": 0,
    041+ <p> "r": 16822203</p>
    042- </p>
    042+ <p> }</p>
    043- <p>
    043+ <p> }</p>
    044- "ninserted": 0,
    044+ <p>},</p>
    045- </p>
    045+ <p>"command": "{ find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" }",</p>
    046- <p>
    046+ <p>"original_log": "2025-10-13T10:25:15.525+0000 I COMMAND [conn8025] command zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13 clientIp: 10.17.27.126 username: rwuser command: find { find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" } planSummary: IXSCAN { sourceId: 1, status: 1, businessId: 1 } cursorid:4540529135866 keysExamined:105 docsExamined:105 numYields:1 nreturned:101 reslen:49256 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 }, acquireWaitCount: { r: 1 }, timeAcquiringMicros: { r: 16822203 } } } protocol:op_msg 16829ms"</p>
    047- "nMatched": 0,
    047+ <p>}</p>
    048- </p>
    048+ <p><img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/e1f6bdc199284db8a925c79cd1c5e81b/abfae2f6-5b2a-41e7-b5f6-9c0e55fb021b.png" title="from clipboard" alt="from clipboard" /></p>
    049- <p>
    049+ <p><img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/9a51f55b2b68458d841fbd5b88985fe4/18f8737c-4bf9-4154-bea8-dd6a4b44a2ee.png" title="from clipboard" alt="from clipboard" /></p>
    050- "nModified": 0,
    051- </p>
    052- <p>
    053- "ts": {
    054- </p>
    055- <p>
    056- "date": 1760351115525
    057- </p>
    058- <p>
    059- },
    060- </p>
    061- <p>
    062- "clientIp": "10.17.27.126",
    063- </p>
    064- <p>
    065- "locks": {
    066- </p>
    067- <p>
    068- "Global": {
    069- </p>
    070- <p>
    071- "acquireCount": {
    072- </p>
    073- <p>
    074- "r": 2
    075- </p>
    076- <p>
    077- }
    078- </p>
    079- <p>
    080- },
    081- </p>
    082- <p>
    083- "Database": {
    084- </p>
    085- <p>
    086- "acquireCount": {
    087- </p>
    088- <p>
    089- "r": 2
    090- </p>
    091- <p>
    092- }
    093- </p>
    094- <p>
    095- },
    096- </p>
    097- <p>
    098- "Collection": {
    099- </p>
    100- <p>
    101- "acquireCount": {
    102- </p>
    103- <p>
    104- "r": 2
    105- </p>
    106- <p>
    107- },
    108- </p>
    109- <p>
    110- "acquireWaitCount": {
    111- </p>
    112- <p>
    113- "r": 1
    114- </p>
    115- <p>
    116- },
    117- </p>
    118- <p>
    119- "timeAcquiringMicros": {
    120- </p>
    121- <p>
    122- "r": 16822203
    123- </p>
    124- <p>
    125- }
    126- </p>
    127- <p>
    128- }
    129- </p>
    130- <p>
    131- },
    132- </p>
    133- <p>
    134- "command": "{ find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" }",
    135- </p>
    136- <p>
    137- "original_log": "2025-10-13T10:25:15.525+0000 I COMMAND [conn8025] command zhcxkj_java_center.t_amazon_automatic_replenishment_2025-10-13 clientIp: 10.17.27.126 username: rwuser command: find { find: "t_amazon_automatic_replenishment_2025-10-13", filter: { sourceId: 23385, status: 0, centerStrategyId: 1151, businessId: 4428586503423424 }, limit: 1000, shardVersion: [ Timestamp(13, 1), ObjectId(68ec08c47ee26a55cc6b5649) ], lsid: { id: UUID("ad41322f-558f-4bba-9e88-bbe5ac1e929b"), uid: BinData(0, 109178812F0C2E953B72EBAB4C7B30ADD8C5E612275C84C7DFBF7A9DE713ECF5) }, clusterTime: { clusterTime: Timestamp(1760351098, 11101), signature: { hash: BinData(0, AC84B27173FF9E97B06B62F328F00451046E0491), keyId: 7527127265109344260 } }, client: { driver: { name: "mongo-java-driver|sync", version: "4.6.1" }, os: { type: "Linux", name: "Linux", architecture: "amd64", version: "3.10.0-1160.25.1.el7.x86_64" }, platform: "Java/Oracle Corporation/17.0.2+8-86", mongos: { host: "host-192-168-63-158:8635", client: "10.17.27.126:55564", version: "4.0.3" }, username: "rwuser" }, configServerState: { opTime: { ts: Timestamp(1760351098, 10434), t: 6 } }, db: "zhcxkj_java_center" } planSummary: IXSCAN { sourceId: 1, status: 1, businessId: 1 } cursorid:4540529135866 keysExamined:105 docsExamined:105 numYields:1 nreturned:101 reslen:49256 locks:{ Global: { acquireCount: { r: 2 } }, Database: { acquireCount: { r: 2 } }, Collection: { acquireCount: { r: 2 }, acquireWaitCount: { r: 1 }, timeAcquiringMicros: { r: 16822203 } } } protocol:op_msg 16829ms"
    138- </p>
    139- <p>
    140- }
    141- </p>
    142- <p>
    143- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/e1f6bdc199284db8a925c79cd1c5e81b/abfae2f6-5b2a-41e7-b5f6-9c0e55fb021b.png" title="from clipboard" alt="from clipboard" />
    144- </p>
    145- <p>
    146- <img src="https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/Kindeditor/2025/10/14/9a51f55b2b68458d841fbd5b88985fe4/18f8737c-4bf9-4154-bea8-dd6a4b44a2ee.png" title="from clipboard" alt="from clipboard" />
    147- </p>
  3. 2025-10-14 15:37:58, 由 宋宁 指派给 何鹏高。
    修改了 指派给，旧值为 "songning"，新值为 "hepenggao"。

    我


    我把sql单独拿出来执行，速度很快，是不是受当时mongo cpu影响

  4. 2025-10-14 18:33:41, 由 何鹏高 解决，方案为 服务器原因 。
    修改了 解决方案，旧值为 ""，新值为 "server"。
    修改了 解决版本，旧值为 ""，新值为 "pro627"。
    修改了 解决日期，旧值为 ""，新值为 "2025-10-14 18:31:11"。
    修改了 指派给 ，旧值为 "hepenggao"，新值为 "chenlizhen"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "hepenggao"。
    13号mongoDB内存接近97%，导致该语句执行慢，单独执行是很快的，14号继续观察无慢SQL问题，判定是受数据库压力导致，可暂时忽略。
  5. 2025-10-15 08:44:43, 由 陈莉珍 编辑。
    修改了 开发责任人，旧值为 ""，新值为 "hepenggao"。
    修改了 测试责任人，旧值为 ""，新值为 "hepenggao"。
    修改了 解决时效 ，旧值为 "0"，新值为 "3.71"。
    修改了 上线时间 ，旧值为 "0000-00-00 00:00:00"，新值为 "2025-10-14 18:31:11"。
    修改了 上线时效 ，旧值为 "-1"，新值为 "3.71"。
  6. 2025-10-15 08:44:47, 由 陈莉珍 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "chenlizhen"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "chenlizhen"。
    修改了 关闭日期，旧值为 ""，新值为 "2025-10-15 08:44:47"。
所属项目 智能中心-需求池
所属模块 ERP系统（销售管理）   AMZ百货
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门 总经办
影响功能
开发责任人 何鹏高
测试责任人 何鹏高
解决时效 3.71
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-10-15 08:44:47
截止日期 0000-00-00
上线时间 2025-10-14 18:31:11
上线时效 3.71
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 陈莉珍 于 2025-10-14 14:48:35
影响环境 生产环境-业务反馈
由谁解决 何鹏高 于 2025-10-14 18:31:11
解决版本 生产环境-业务反馈
解决方案 服务器原因
由谁关闭 陈莉珍 于 2025-10-15 08:44:47
最后修改 陈莉珍 于 2025-10-15 08:44:47
相关Bug