GitHub user Kranthi32 added a comment to the discussion: Production deployment issue in
i create postgre and redis image like this but still facing issue is @dosu [@dosu](https://go.dosu.dev/dosubot). kubectl logs superset-init-db-599hb -n superset --all-containers=true 2025/06/27 16:57:03 Waiting for: tcp://appsqlsscind01.private.postgres.database.azure.com:5432 2025/06/27 16:57:03 Connected to tcp://appsqlsscind01.private.postgres.database.azure.com:5432 Upgrading DB schema... Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py] 2025-06-27 16:57:06,010:ERROR:superset.app:Failed to create app Traceback (most recent call last): File "/app/superset/app.py", line 40, in create_app app_initializer.init_app() File "/app/superset/initialization/__init__.py", line 476, in init_app self.setup_db() File "/app/superset/initialization/__init__.py", line 667, in setup_db pessimistic_connection_handling(db.engine) File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 998, in engine return self.get_engine() File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1017, in get_engine return connector.get_engine() File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 594, in get_engine self._engine = rv = self._sa.create_engine(sa_url, options) File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1027, in create_engine return sqlalchemy.create_engine(sa_url, **engine_opts) File "<string>", line 2, in create_engine File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned return fn(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 544, in create_engine dbapi = dialect_cls.dbapi(**dbapi_args) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 811, in dbapi import psycopg2 ModuleNotFoundError: No module named 'psycopg2' Traceback (most recent call last): File "/usr/local/bin/superset", line 8, in <module> 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 1685, in invoke super().invoke(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 355, in decorator app = __ctx.ensure_object(ScriptInfo).load_app() File "/usr/local/lib/python3.10/site-packages/flask/cli.py", line 309, in load_app app = locate_app(import_name, name) File "/usr/local/lib/python3.10/site-packages/flask/cli.py", line 238, in locate_app return find_app_by_string(module, app_name) File "/usr/local/lib/python3.10/site-packages/flask/cli.py", line 166, in find_app_by_string app = attr(*args, **kwargs) File "/app/superset/app.py", line 40, in create_app app_initializer.init_app() File "/app/superset/initialization/__init__.py", line 476, in init_app self.setup_db() File "/app/superset/initialization/__init__.py", line 667, in setup_db pessimistic_connection_handling(db.engine) File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 998, in engine return self.get_engine() File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1017, in get_engine return connector.get_engine() File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 594, in get_engine self._engine = rv = self._sa.create_engine(sa_url, options) File "/usr/local/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1027, in create_engine return sqlalchemy.create_engine(sa_url, **engine_opts) File "<string>", line 2, in create_engine File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned return fn(*args, **kwargs) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 544, in create_engine dbapi = dialect_cls.dbapi(**dbapi_args) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 811, in dbapi import psycopg2 ModuleNotFoundError: No module named 'psycopg2' FROM apache/superset:4.1.2 RUN pip install --no-cache-dir redis psycopg2-binary steps to push docker build -t reddy2210/superset-custom:4.1.2 . docker push reddy2210/superset-custom:4.1.2 my values.yaml # Use your custom Superset image (built with redis & psycopg2-binary) image: repository: reddy2210/superset-custom tag: 2.1.0 pullPolicy: Always # Enable internal Redis (optional: use external by changing redis.enabled: false) redis: enabled: true auth: enabled: false # Disable internal PostgreSQL postgresql: enabled: false # Secret key for Flask sessions extraSecretEnv: SUPERSET_SECRET_KEY: 'OG6tANx8xP8QAo9sabJAwUAjUs2OO7hEPmTqjgxqnj5TnjLouQP1tULQ' # Configure Superset to use external Azure PostgreSQL supersetNode: connections: db_host: myhost db_port: "5432" db_user: sspsqladmin db_pass: 'PAssW0rd123' # Make sure to avoid special characters or quote properly db_name: superset redis_host: superset-redis-master redis_port: "6379" redis_cache_db: "1" redis_celery_db: "0" extraEnv: - name: DB_HOST value: appsqlsscind01.private.postgres.database.azure.com - name: DB_PORT value: "5432" # Add Redis cache config to superset_config.py configOverrides: superset_config.py: | ENABLE_PROXY_FIX = True from flask_caching import Cache RESULTS_BACKEND = Cache( config={ 'CACHE_TYPE': 'RedisCache', 'CACHE_DEFAULT_TIMEOUT': 300, 'CACHE_KEY_PREFIX': 'superset_results', 'CACHE_REDIS_URL': 'redis://superset-redis-master:6379/0' } ) # Create admin user init: createAdmin: true adminUser: username: admin firstname: Superset lastname: Admin email: [email protected] password: C@reS0ft loadExamples: false # Optional: Resource limits resources: limits: cpu: 1000m memory: 2Gi requests: cpu: 500m memory: 1Gi GitHub link: https://github.com/apache/superset/discussions/33957#discussioncomment-13599962 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
