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

Create Index in Prod server getting stuck

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 5.0.2
    • Component/s: Index Maintenance
    • None
    • Environment:
      Production
    • ALL
    • Hide

      mongo -host HOSTNAME:27017 --tls  -tlsCertificateKeyFile "xxxx\server32.pem" --tlsCAFile "xxxxx\CA.crt" -u USERNAME -p

       

      rs0:PRIMARY>db.Collection_Name.createIndex(

      { "ProjectId": 1, "ArtifactId": 1, "ArtifactVersion": 1, "IsActive": 1 }

      ,

      { background: true }

      );

      Show
      mongo - host HOSTNAME:27017 --tls   -tlsCertificateKeyFile "xxxx\server32.pem" --tlsCAFile "xxxxx\CA.crt" -u USERNAME -p   rs0:PRIMARY>db.Collection_Name.createIndex( { "ProjectId": 1, "ArtifactId": 1, "ArtifactVersion": 1, "IsActive": 1 } , { background: true } );

      Hi Team,

      We are running CreateIndex query for a Production database and the collection on which we ran the createIndex query is stuck for more than 48hrs now.

      We tried to run the CreateIndex via DevOps Pipeline and from Mongosh, either way the query gets stuck.

      Production Env: ReplicaSet (3nodes)
      SSL: SSL certificates are installed.
      keyfile: Keyfile authentication is available in all 3 nodes.

            Assignee:
            rhea.thorne@mongodb.com Rhea Thorne
            Reporter:
            r.saha10051989@gmail.com Rana Saha
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: