Geo: Add logging to help diagnose why syncing is not working

What does this MR do?

When a shard is down, syncing just doesn't happen, and there is no indication why. This should make it faster to diagnose the problem.

Resolves #323750 (closed)

Does this MR meet the acceptance criteria?

Conformity

• 📋 Does this MR need a changelog?
  • I have included a changelog entry.
  • I have not included a changelog entry because it is not user facing.
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content

Availability and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.