Resolved
This issue is now resolved.
Retroactive
It is observed that the Heroku Connect was unable to communicate with Salesforce in Dublin region and customers might have faced delays in data sync between 12:00 PM UTC and 15:26 PM UTC on August 17 2022.