[SERVER-8027] inserting data into mongodb taking 37 sec Created: 25/Dec/12  Updated: 28/Dec/12  Resolved: 28/Dec/12

Status: Closed
Project: Core Server
Component/s: Sharding
Affects Version/s: 2.0.3
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: jitendra Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux OEL


Attachments: File mongod_10000.log_5     File mongos_35000.log_1    
Operating System: Linux
Participants:

 Description   

Hi,

We have mongodb Setup are following
Mongod shards : 4
Mongod config server : 3
Mongos : 1

All mongo instance running on single machine.

We have a application, which insert data into mongodb.
It have insertion timeout is 5 sec.

We are getting insertion timeout in between.

mongod show following logs
Taking 28 sec
Mon Dec 24 07:18:00 [conn37210] SocketException: remote: 192.168.159.100:40265 error: 9001 socket exception [0] server [192.168.159.100:40265]
Mon Dec 24 07:18:01 [conn37115] SocketException: remote: 192.168.159.100:39854 error: 9001 socket exception [0] server [192.168.159.100:39854]
Mon Dec 24 07:18:01 [conn37108] SocketException: remote: 192.168.159.100:39843 error: 9001 socket exception [0] server [192.168.159.100:39843]
Mon Dec 24 07:18:02 [conn36928] SocketException: remote: 192.168.159.100:39133 error: 9001 socket exception [0] server [192.168.159.100:39133]
Mon Dec 24 07:18:02 [conn36460] SocketException: remote: 192.168.159.100:37218 error: 9001 socket exception [0] server [192.168.159.100:37218]
Mon Dec 24 07:18:02 [conn37029] SocketException: remote: 192.168.159.100:39538 error: 9001 socket exception [0] server [192.168.159.100:39538]
Mon Dec 24 07:18:02 [conn37031] SocketException: remote: 192.168.159.100:39546 error: 9001 socket exception [0] server [192.168.159.100:39546]
Mon Dec 24 07:18:02 [conn37107] SocketException: remote: 192.168.159.100:39841 error: 9001 socket exception [0] server [192.168.159.100:39841]
Mon Dec 24 07:18:02 [conn37080] SocketException: remote: 192.168.159.100:39745 error: 9001 socket exception [0] server [192.168.159.100:39745]
Mon Dec 24 07:18:02 [conn37091] SocketException: remote: 192.168.159.100:39787 error: 9001 socket exception [0] server [192.168.159.100:39787]
Mon Dec 24 07:18:02 [conn37102] SocketException: remote: 192.168.159.100:39832 error: 9001 socket exception [0] server [192.168.159.100:39832]
Mon Dec 24 07:18:02 [conn37114] SocketException: remote: 192.168.159.100:39855 error: 9001 socket exception [0] server [192.168.159.100:39855]
Mon Dec 24 07:18:05 [conn37148] SocketException: remote: 192.168.159.100:40015 error: 9001 socket exception [0] server [192.168.159.100:40015]
Mon Dec 24 07:18:05 [conn36722] SocketException: remote: 192.168.159.100:38273 error: 9001 socket exception [0] server [192.168.159.100:38273]
Mon Dec 24 07:18:05 [conn36870] SocketException: remote: 192.168.159.100:38901 error: 9001 socket exception [0] server [192.168.159.100:38901]
Mon Dec 24 07:18:05 [conn37022] SocketException: remote: 192.168.159.100:39510 error: 9001 socket exception [0] server [192.168.159.100:39510]
Mon Dec 24 07:18:05 [conn37038] SocketException: remote: 192.168.159.100:39574 error: 9001 socket exception [0] server [192.168.159.100:39574]
Mon Dec 24 07:18:05 [conn37043] SocketException: remote: 192.168.159.100:39594 error: 9001 socket exception [0] server [192.168.159.100:39594]
Mon Dec 24 07:18:05 [conn36913] SocketException: remote: 192.168.159.100:39070 error: 9001 socket exception [0] server [192.168.159.100:39070]
Mon Dec 24 07:18:05 [conn37033] SocketException: remote: 192.168.159.100:39554 error: 9001 socket exception [0] server [192.168.159.100:39554]
Mon Dec 24 07:18:05 [conn36944] SocketException: remote: 192.168.159.100:39194 error: 9001 socket exception [0] server [192.168.159.100:39194]
Mon Dec 24 07:18:06 [conn37068] SocketException: remote: 192.168.159.100:39694 error: 9001 socket exception [0] server [192.168.159.100:39694]
Mon Dec 24 07:18:06 [conn37069] SocketException: remote: 192.168.159.100:39698 error: 9001 socket exception [0] server [192.168.159.100:39698]
Mon Dec 24 07:18:10 [conn36809] SocketException: remote: 192.168.159.100:38657 error: 9001 socket exception [0] server [192.168.159.100:38657]
Mon Dec 24 07:18:10 [conn37016] SocketException: remote: 192.168.159.100:39482 error: 9001 socket exception [0] server [192.168.159.100:39482]
Mon Dec 24 07:18:10 [conn36872] SocketException: remote: 192.168.159.100:38909 error: 9001 socket exception [0] server [192.168.159.100:38909]
Mon Dec 24 07:18:10 [conn37045] SocketException: remote: 192.168.159.100:39602 error: 9001 socket exception [0] server [192.168.159.100:39602]
Mon Dec 24 07:18:10 [conn37001] SocketException: remote: 192.168.159.100:39419 error: 9001 socket exception [0] server [192.168.159.100:39419]
Mon Dec 24 07:18:10 [conn36931] SocketException: remote: 192.168.159.100:39145 error: 9001 socket exception [0] server [192.168.159.100:39145]
Mon Dec 24 07:18:12 [conn36967] SocketException: remote: 192.168.159.100:39289 error: 9001 socket exception [0] server [192.168.159.100:39289]
Mon Dec 24 07:18:12 [conn37051] SocketException: remote: 192.168.159.100:39626 error: 9001 socket exception [0] server [192.168.159.100:39626]
Mon Dec 24 07:18:12 [conn36996] SocketException: remote: 192.168.159.100:39399 error: 9001 socket exception [0] server [192.168.159.100:39399]
Mon Dec 24 07:18:12 [conn37152] SocketException: remote: 192.168.159.100:40031 error: 9001 socket exception [0] server [192.168.159.100:40031]
Mon Dec 24 07:18:12 [conn37112] SocketException: remote: 192.168.159.100:39851 error: 9001 socket exception [0] server [192.168.159.100:39851]
Mon Dec 24 07:18:12 [conn37028] SocketException: remote: 192.168.159.100:39534 error: 9001 socket exception [0] server [192.168.159.100:39534]
Mon Dec 24 07:18:12 [conn37035] SocketException: remote: 192.168.159.100:39562 error: 9001 socket exception [0] server [192.168.159.100:39562]
Mon Dec 24 07:18:12 [conn37165] SocketException: remote: 192.168.159.100:40085 error: 9001 socket exception [0] server [192.168.159.100:40085]
Mon Dec 24 07:18:20 [conn37132] insert 00241212.Database 28116ms

taking 5 sec
Mon Dec 24 07:31:47 [conn37480] insert 00241212.Database 5839ms

I have following questions
1. what should be Insertion timeout ?
2. when insertion took 28 sec above it there is socket exception log
is socket exception can cause for insertion timeout?
4. when insertion took 5 sec ,there is no error logs. why taking 5 sec??
3. Can you explain why insertion taking that much time ?.

I am uploaded mongos and mongod logs.

Please help me to resolve this problem

Thanks in advance
JRV



 Comments   
Comment by Ian Whalen (Inactive) [ 28/Dec/12 ]

jitendra, for general questions such as this please begin a discussion in our forums at https://groups.google.com/forum/?fromgroups#!forum/mongodb-user

if that conversation turns to confirmation you have found a bug, please open a bug here.

Comment by jitendra [ 26/Dec/12 ]

Hi
please update.

Thanks,
JRV

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