Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-31546

Write lock on one database causes lock on ALL databases

    XMLWordPrintableJSON

Details

    • Fully Compatible

    Description

      Hi,

      We are using Mongo replica-set (3 Mongo servers - 1 Primary, 1 secundary, 1 arbiter).
      Mongo version 3.2.17.

      We had a problem on 10.10.2017 between 11:44:10 - 11:51:00 hours.

      We know that we started dropIndex on one collection and commad executed ok:
      2017-10-10T09:44:06.738+0000 I COMMAND [conn92280] CMD: dropIndexes igraci.listici

      After that, all operation on+ all databases were very slow+ (about 5~6 minutes) , number of connections started to get very high and logs are full of
      2017-10-10T09:50:58.824+0000 I NETWORK [conn93396] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server x.z.y.a

      All our application were slowed in query execution, insert too.

      Based on documentation https://docs.mongodb.com/manual/reference/command/dropIndexes/index.html only the affected database shoud be lock, but not all others and we think this happend.

      In attachment are logs.

      We can't explain our self what happend so asking for your help?
      Thanks

      Attachments

        1. diagnostic.data00
          100.00 MB
        2. diagnostic.data00
          100.00 MB
        3. diagnostic.data01
          100.00 MB
        4. diagnostic.data02
          4.43 MB
        5. lag.png
          lag.png
          138 kB
        6. mongo_logs_2017-10-11.tar.gz
          38.76 MB
        7. mongo-000
          100.00 MB
        8. mongo-001
          100.00 MB
        9. mongo-002
          2.28 MB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mnuic Mario
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: