The broker is failing to find the available servers for a lot of segments. This is the log message:

Failed to find servers hosting segment: <segment> for table: <tableName>_REALTIME (all ONLINE/CONSUMING instances: [] and OFFLINE instances: [] are disabled, counting segment as unavailable)

How can I: 1- Make the brokers find the segments? 2- If 1 is not possible, how can I make the servers download or fetch all the missing segments?

You can try: (swagger apis)

- Rebuild routing table for broker: In case routing table got out of sync for some reason.
- Reload api to reload segments 
- Use debug api to see if there are any issues it surfaces

Rebuild routing table for broker: In case routing table got out of sync for some reason.

I don't see this in swagger and I couldn't find in the docs also. swagger has the

tables/tableNameWithType/rebuildBrokerResourceFromHelixTags

But this one only runs if I update the broker's tags.

I also had this issue before and what I did is restart the servers

Thanks, @User!