[SERVER-50113] Data in the table can be queried in the Shard node, but not in the Mongos node. Created: 05/Aug/20  Updated: 19/Nov/20  Resolved: 19/Nov/20

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

Type: Bug Priority: Major - P3
Reporter: Eric Jones Assignee: Eric Sedor
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Participants:

 Description   

I have a cluster with 10 shards, and now One of my tables is having a problem querying the data.
It normally returns the results when I query the table for data on each shard node, on each shard node.
But when I searched the data again at the Mongos node, he got stuck and couldn't return the data.



 Comments   
Comment by Eric Sedor [ 19/Nov/20 ]

Hi irybatty@gmail.com

We haven’t heard back from you for some time, so I’m going to close this ticket. If this is still an issue for you, please provide additional information and we will reopen the ticket.

Sincerely,
Eric

Comment by Eric Sedor [ 15/Sep/20 ]

Hi irybatty@gmail.com,

We haven’t heard back from you for some time. If you are still noticing an issue, are you able to provide the information above?

Sincerely,
Eric

Comment by Eric Sedor [ 05/Aug/20 ]

Hi irybatty@gmail.com, we'd be happy to help but will need more specifics to diagnose.

Can you please provide:

  • The db and collection name showing the problem
  • The output of sh.status(true)
  • The query you are running
  • mongod log files from the mongos where you run the problem query
  • some timestamps (within the time range provided in the log above) when the query is run
  • a timeline of any DDL operations run on the collection (examples of DDL operations include dropping the collection, sharding or unsharding the collection, adding or removing indexes, etc)

It's possible we will also need to see a mongodump of the config database. For that and for the logs, I've created a secure upload portal for you. Files uploaded to this portal are visible only to MongoDB employees and are routinely deleted after some time.

Please let me know if I can clarify any of the above.

Sincerely,
Eric

Generated at Thu Feb 08 05:21:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.