inserting data into mongodb taking 37 sec

XMLWordPrintableJSON

    • 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

        1. mongod_10000.log_5
          10.00 MB
        2. mongos_35000.log_1
          10.27 MB

            Assignee:
            Unassigned
            Reporter:
            jitendra
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: