GitHub user andrii-korotkov-verkada added a comment to the discussion: Db 
migrations getting stuck for a while with no logs until failure. What can be 
wrong?

I've made some progress. Apparently I didn't have an ingress security group 
rule for the DB (which is unclear why it's needed, since security group of pods 
and DB are the same and port is the same).

Now there's another issue according to pgbouncer logs:
```
2025-01-07 18:05:42.039 UTC [1] DEBUG S-0x7fc214953110: 
airflow-metadata/postgres@(bad-af):0 dns_callback: inet4: 
<ip-address-placeholder>:5432
2025-01-07 18:05:42.039 UTC [1] DEBUG S-0x7fc214953110: 
airflow-metadata/postgres@1<ip-address-placeholder>:5432 launching new 
connection to server
2025-01-07 18:05:42.039 UTC [1] DEBUG launch_new_connection: already progress
2025-01-07 18:05:42.039 UTC [1] DEBUG S-0x7fc214953110: 
airflow-metadata/postgres@<ip-address-placeholder>:5432 S: connect ok
2025-01-07 18:05:42.039 UTC [1] LOG S-0x7fc214953110: 
airflow-metadata/postgres@<ip-address-placeholder>:5432 new connection to 
server (from <ip-address-placeholder>:40000)
2025-01-07 18:05:42.039 UTC [1] DEBUG launch_new_connection: already progress
2025-01-07 18:05:42.044 UTC [1] WARNING server login failed: FATAL no 
pg_hba.conf entry for host "<ip-address-placeholder>", user "postgres", 
database "vairflow", no encryption
2025-01-07 18:05:42.044 UTC [1] LOG C-0x7fc2149a5930: 
airflow-metadata/[email protected]:58659 closing because: no pg_hba.conf 
entry for host "<ip-address-placeholder>", user "postgres", database 
"vairflow", no encryption (age=8s)
2025-01-07 18:05:42.044 UTC [1] WARNING C-0x7fc2149a5930: 
airflow-metadata/postgres@<ip-address-placeholder>:58659 pooler error: no 
pg_hba.conf entry for host "<ip-address-placeholder>", user "postgres", 
database "vairflow", no encryption
2025-01-07 18:05:42.044 UTC [1] LOG S-0x7fc214953110: 
airflow-metadata/postgres@<ip-address-placeholder>:5432 closing because: login 
failed (age=0s)
```

GitHub link: 
https://github.com/apache/airflow/discussions/45446#discussioncomment-11764157

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to