[SERVER-84395] Create Index in Prod server getting stuck Created: 22/Dec/23  Updated: 08/Jan/24  Resolved: 08/Jan/24

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: 5.0.2
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Rana Saha Assignee: Alison Rhea Thorne
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Production


Operating System: ALL
Steps To Reproduce:

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 }

);

Participants:

 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.



 Comments   
Comment by Alison Rhea Thorne [ 08/Jan/24 ]

Hello Rana,

As mentioned before, we strongly recommend reaching out to the community for assistance with this matter via the MongoDB Developer Community Forums. If the discussion there leads you to suspect a bug in the MongoDB server, then we'd want to investigate it as a possible bug here in the SERVER project. For now, we're going to close this issue pending a bug report.

Thank you.

Comment by Rana Saha [ 08/Jan/24 ]

Hi Alison,

Is there any update?

Thanks,
Rana

Comment by Rana Saha [ 04/Jan/24 ]

Hi Alison,

Good Morning.

Is there any update?

We are completely stuck for this bug in our production environment.

Thanks,
Rana Saha

Comment by Rana Saha [ 03/Jan/24 ]

Hi,

This issue is now a blocker in Production, and there is no response from your end, kindly let us know the process to escalate this.

Thanks,
Rana

Comment by Rana Saha [ 02/Jan/24 ]

Hi Alison,

Is there any update on the JIRA?
We are stuck here; can you please expedite the process?

Thanks,
Rana

Comment by Rana Saha [ 28/Dec/23 ]

HI Alison,

can you please help me with this issue? Please let me know if you'd require any infromation from my end.

Thanks,
Rana

Comment by Rana Saha [ 26/Dec/23 ]

Hi Team,

Good Morning.

Can anyone please look into this issue and help me with.

Note: My work hours are 9am to 6pm IST

Thanks,
Rana

Generated at Thu Feb 08 06:54:55 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.