I know this issue has been raised before, but since the fix seems to require a cluster-level update, I'll share my logs here.
The task checks a database for records with a specific set of criteria every 5-10 seconds, it's been running since October, and this error did not seem to appear until mid-November, at which point it began to present on a non-uniform cadence. Sometimes multiple times per minute, sometimes only once per day. I edited the server name in the logs for security reasons, but if the exact host name is needed I can share with support over email.
Nov 17 06:46:51 ERROR 2025-11-17 06:46:51,648 __main__ Error in main loop: could not translate host name "redacted-for-forum-post.supabase.com" to address: Temporary failure in name resolution
<redacted by admin>
Dec 16 09:03:39 ERROR 2025-12-16 09:03:39,877 __main__ Error in main loop: could not translate host name "redacted-for-forum-post.supabase.com" to address: Temporary failure in name resolution