[SERVER-19976] Slow log has many killcursors Created: 16/Aug/15  Updated: 17/Aug/15  Resolved: 17/Aug/15

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 3.0.2, 3.0.4
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: SamPeng Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Our application have lag 1-2s when Interval little minute。
We have 3 instance of Mongodb. 1 write,2 read.
I can see many killcursors command at slow log file.this command time is same as application lag time;
please help me,how to fixed this lag?or how to find what problem with this?

2015-08-15T10:05:52.797+0800 I QUERY    [conn5172367] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1666ms
2015-08-15T10:06:54.257+0800 I QUERY    [conn5169478] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1406ms
2015-08-15T10:06:54.292+0800 I QUERY    [conn5172314] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1436ms
2015-08-15T10:06:54.303+0800 I QUERY    [conn5172334] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1046ms
2015-08-15T10:06:54.315+0800 I QUERY    [conn5172333] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1001ms
2015-08-15T10:06:54.319+0800 I QUERY    [conn5172335] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1038ms
2015-08-15T10:06:54.419+0800 I QUERY    [conn5169475] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1578ms
2015-08-15T10:06:54.609+0800 I QUERY    [conn5172327] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1402ms
2015-08-15T10:07:10.831+0800 I QUERY    [conn5169820] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1493ms
2015-08-15T10:07:10.963+0800 I QUERY    [conn5172739] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1559ms
2015-08-15T10:16:05.285+0800 I QUERY    [conn5169754] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1484ms
2015-08-15T10:20:38.320+0800 I QUERY    [conn5169773] killcursors  keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 1 } }, Database: { acquireCount: { r: 1 } }, Collection: { acquireCount: { r: 1 } } } 1503ms



 Comments   
Comment by Ramon Fernandez Marina [ 17/Aug/15 ]

Thanks for your report sampeng. Please note that the SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag, where your question will reach a larger audience. A question like this involving more discussion would be best posted on the mongodb-user group. See also our Technical Support page for additional support resources.

Regards,
Ramón.

Generated at Thu Feb 08 03:52:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.