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]
