sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "db" to address: Name or service not known

[AlejandroGonzalR]

Bug description

Hi, I'm using an external database with Docker configuration, after modifying the required environment variables seems Superset tries to target to "db" hostname, ignoring the variables, some migrations apparently executed as expected.

How to reproduce the bug

1. Go to Superset 'master' branch
2. Modify the docker/.env-local file with custom database information
3. Execute docker compose up targeting the non-dev compose file
4. See error on superset-init container

Screenshots/recordings

######################################################################

Init Step 1/4 [Starting] -- Applying DB migrations

######################################################################

Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py]
2024-07-04 17:15:03,109:DEBUG:superset.utils.logging_configurator:logging was configured successfully
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
INFO [alembic.runtime.migration] Running upgrade 5f57af97bc3f -> 3dfd0e78650e, add_query_sql_editor_id_index
INFO [alembic.runtime.migration] Running upgrade 5f57af97bc3f -> 4a33124c18ad, mig new columnar upload perm
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from Admin
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to Admin
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from Admin
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from Alpha
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to Alpha
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from Alpha
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-automation-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-automation-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-automation-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-autorizador-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-autorizador-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-autorizador-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-account-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-account-pix-br-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-account-pix-br-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-account-pix-br-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-additional-cards-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-additional-cards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-additional-cards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-ai-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-payments-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-payments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-payments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-banking-core-co
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-banking-core-co
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-banking-core-co
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-architecture-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from Query Databases
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to Query Databases
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from Query Databases
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-bill-payment-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-fraud-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-bouncer-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-card-basics-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-card-installments-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-movements-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-movements-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-movements-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-card-rda-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-frk-core-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-frk-core-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-frk-core-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-card-refinancing-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-card-statement-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-cashflow-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-checkout-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-checkout-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-checkout-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-gateway-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-gateway-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-gateway-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-clarifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-closed-loops-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-closed-loops-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-closed-loops-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-data-engineering-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-data-engineering-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-data-engineering-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-growth-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-growth-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-growth-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-help-center-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-onboarding-cx-int-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-onboarding-cx-int-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-onboarding-cx-int-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-insurance-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-insurance-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-insurance-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-integration-banorte-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-integration-banorte-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-integration-banorte-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-integration-cobis-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-integration-cobis-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-integration-cobis-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-integration-ibk-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-integration-ibk-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-integration-ibk-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-internal-tools-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-inventory-manager-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-kyc-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-kyc-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-kyc-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-kyc-public-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-kyc-public-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-kyc-public-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-notifications-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-onboarding-web-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-users-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-users-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-users-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-origination-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-payment-method-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-personal-loans-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-processor-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-processor-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-processor-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-rappipay-labs-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-rappipay-labs-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-rappipay-labs-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-rewards-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-datamart-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-datamart-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-datamart-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-risk-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-risk-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-risk-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-security-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-security-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-security-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-risk-gatekeeper-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-signup-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-transactional-fraud-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from mx-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to mx-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from mx-rpp-wallet-home-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-integration-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-integration-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-integration-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-interfaces-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-interfaces-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-interfaces-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-local-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-local-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-local-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_post ColumnarToDatabaseView from co-rpp-wallet-payments-int-public
INFO [superset.migrations.shared.security_converge] Add can_columnar_upload Database to co-rpp-wallet-payments-int-public
INFO [superset.migrations.shared.security_converge] Removing can_this_form_get ColumnarToDatabaseView from co-rpp-wallet-payments-int-public
INFO [superset.migrations.shared.security_converge] Going to delete pvm: can_this_form_post ColumnarToDatabaseView
INFO [superset.migrations.shared.security_converge] Going to delete pvm: can_this_form_get ColumnarToDatabaseView
INFO [superset.migrations.shared.security_converge] Going to delete view_menu: ColumnarToDatabaseView
INFO [alembic.runtime.migration] Running upgrade 4a33124c18ad -> 58d051681a3b, Add catalog_perm to tables
Traceback (most recent call last):
File "/usr/local/bin/superset", line 8, in
sys.exit(superset())
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1157, in call
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1078, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/flask/cli.py", line 358, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/flask_migrate/cli.py", line 149, in upgrade
_upgrade(directory, revision, sql, tag, x_arg)
File "/usr/local/lib/python3.10/site-packages/flask_migrate/init.py", line 98, in wrapped
f(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/flask_migrate/init.py", line 185, in upgrade
command.upgrade(config, revision, sql=sql, tag=tag)
File "/usr/local/lib/python3.10/site-packages/alembic/command.py", line 403, in upgrade
script.run_env()
File "/usr/local/lib/python3.10/site-packages/alembic/script/base.py", line 583, in run_env
util.load_python_file(self.dir, "env.py")
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 95, in load_python_file
module = load_module_py(module_id, path)
File "/usr/local/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 113, in load_module_py
spec.loader.exec_module(module) # type: ignore
File "", line 883, in exec_module
File "", line 241, in _call_with_frames_removed
File "/app/superset/extensions/../migrations/env.py", line 127, in
run_migrations_online()
File "/app/superset/extensions/../migrations/env.py", line 119, in run_migrations_online
context.run_migrations()
File "", line 8, in run_migrations
File "/usr/local/lib/python3.10/site-packages/alembic/runtime/environment.py", line 948, in run_migrations
self.get_context().run_migrations(**kw)
File "/usr/local/lib/python3.10/site-packages/alembic/runtime/migration.py", line 627, in run_migrations
step.migration_fn(**kw)
File "/app/superset/migrations/versions/2024-05-01_10-52_58d051681a3b_add_catalog_perm_to_tables.py", line 47, in upgrade
upgrade_catalog_perms(engines={"postgresql"})
File "/app/superset/migrations/shared/catalogs.py", line 121, in upgrade_catalog_perms
for schema in database.get_all_schema_names(
File "/app/superset/utils/cache.py", line 127, in wrapped_f
return f(*args, **kwargs)
File "/app/superset/models/core.py", line 846, in get_all_schema_names
raise self.db_engine_spec.get_dbapi_mapped_exception(ex) from ex
File "/app/superset/models/core.py", line 840, in get_all_schema_names
with self.get_inspector(
File "/usr/local/lib/python3.10/contextlib.py", line 135, in enter
return next(self.gen)
File "/app/superset/models/core.py", line 820, in get_inspector
yield sqla.inspect(engine)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 182, in _engine_insp
return Inspector._construct(Inspector._init_engine, bind)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 117, in _construct
init(self, bind)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/reflection.py", line 128, in _init_engine
engine.connect().close()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3325, in connect
return self._connection_cls(self, close_with_result=close_with_result)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 96, in init
else engine.raw_connection()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3404, in raw_connection
return self._wrap_pool_connect(self.pool.connect, _connection)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3374, in _wrap_pool_connect
Connection.handle_dbapi_exception_noconnection(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2208, in handle_dbapi_exception_noconnection
util.raise(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
raise exception
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 3371, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 327, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 894, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 493, in checkout
rec = pool._do_get()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/impl.py", line 256, in _do_get
return self._create_connection()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 273, in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 388, in init
self.__connect()
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 690, in connect
with util.safe_reraise():
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in exit
compat.raise(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise
raise exception
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 686, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 574, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 598, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "db" to address: Name or service not known

(Background on this error at: https://sqlalche.me/e/14/e3q8)

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Hey there, @AlejandroGonzalR! I'm here to assist you with any bugs, questions, or contributions while you wait for a human maintainer. Let's tackle this together!

The issue you're encountering seems to be related to the database service not being available when Superset tries to connect to it. This is a common problem when using Docker, where services might not start in the expected order.

Here are a few steps you can try to resolve this:

1. Ensure Database Service is Up: Start the database service separately to ensure it is running before starting Superset.

   docker-compose up db

2. Check Database Configuration: Verify that the environment variables in your docker/.env-local file are correctly set and that they match the database service configuration.

3. Remove Old Database Volume: If the database service has been previously initialized with a different version, it might cause compatibility issues. Remove the old database volume and try again.

   docker volume rm superset_db_home
   docker-compose up

4. Update Init Containers: Ensure that the init containers are getting the same environment variable setups as the final containers. This has been a known issue and is being addressed in the following PRs:

   • fix(helm): update init containers to include extra env vars
   • fix(helm): update init containers to include extra env vars (cont.)

Following these steps should help resolve the issue. If the problem persists, you might want to check the detailed logs of the database service for any specific errors ^[1].

To continue talking to Dosu, mention @dosu.