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

Create Index in Prod server getting stuck

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 5.0.2
    • Index Maintenance
    • None
    • 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 } );

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: