-
Type:
Bug
-
Resolution: Incomplete
-
Priority:
Major - P3
-
None
-
Affects Version/s: 2.0.3
-
Component/s: Sharding
-
None
-
Environment:Linux OEL
-
Linux
-
None
-
3
-
None
-
None
-
None
-
None
-
None
-
None
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