search

apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform
https://superset.apache.org/
Apache License 2.0
63.08k stars 13.97k forks source link

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

Open AlejandroGonzalR opened 5 months ago

AlejandroGonzalR commented 5 months ago

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_exceptionnoconnection 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

dosubot[bot] commented 5 months ago

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:

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.