GitHub user juanrondineau added a comment to the discussion: Issue in psycopg2 while upgrading from 4.x to 5.0
@dosu, I'm trying to deploy a superset 5.0.0 local environment on minikube from the superset-helm-chart-0.15.1 and I'm still having the "ModuleNotFoundError: No module named 'psycopg2'" this is my Chart.yml `apiVersion: v2 appVersion: "5.0.0" description: Apache Superset is a modern, enterprise-ready business intelligence web application name: superset icon: https://artifacthub.io/image/68c1d717-0e97-491f-b046-754e46f46922@2x home: https://superset.apache.org/ keywords: - business intelligence - data science sources: - https://github.com/apache/superset maintainers: - name: craig-rueda email: [email protected] url: https://github.com/craig-rueda version: 0.15.1 # See [README](https://github.com/apache/superset/blob/master/helm/superset/README.md#versioning) for version details. dependencies: - name: postgresql version: 13.4.4 repository: oci://registry-1.docker.io/bitnamicharts condition: postgresql.enabled - name: redis version: 17.9.4 repository: oci://registry-1.docker.io/bitnamicharts condition: redis.enabled` and this is my bootstrapScript after apply the changes you suggested `bootstrapScript: | #!/bin/bash # Install system-level dependencies apt-get update && apt-get install -y \ python3-dev \ default-libmysqlclient-dev \ build-essential \ pkg-config # Install required Python packages uv pip install \ psycopg2-binary==2.9.1 \ "sqlalchemy>=1.0.0, <2.0.0" \ # Create bootstrap file if it doesn't exist if [ ! -f ~/bootstrap ]; then echo "Running Superset with uid {{ .Values.runAsUser }}" > ~/bootstrap; fi` this is the full error `+ echo Upgrading DB schema... + superset db upgrade Upgrading DB schema... Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py] 2025-10-07 18:23:44,940:ERROR:superset.app:Failed to create app Traceback (most recent call last): File "/app/.venv/lib/python3.10/site-packages/superset/app.py", line 40, in create_app app_initializer.init_app() File "/app/.venv/lib/python3.10/site-packages/superset/initialization/__init__.py", line 466, in init_app self.setup_db() File "/app/.venv/lib/python3.10/site-packages/superset/initialization/__init__.py", line 662, in setup_db pessimistic_connection_handling(db.engine) File "/app/.venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 998, in engine return self.get_engine() File "/app/.venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1017, in get_engine return connector.get_engine() File "/app/.venv/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 "/app/.venv/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 "/app/.venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned return fn(*args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 544, in create_engine dbapi = dialect_cls.dbapi(**dbapi_args) File "/app/.venv/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 "/app/.venv/bin/superset", line 10, in <module> sys.exit(superset()) File "/app/.venv/lib/python3.10/site-packages/click/core.py", line 1157, in __call__ return self.main(*args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/click/core.py", line 1078, in main rv = self.invoke(ctx) File "/app/.venv/lib/python3.10/site-packages/click/core.py", line 1685, in invoke super().invoke(ctx) File "/app/.venv/lib/python3.10/site-packages/click/core.py", line 1434, in invoke return ctx.invoke(self.callback, **ctx.params) File "/app/.venv/lib/python3.10/site-packages/click/core.py", line 783, in invoke return __callback(*args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func return f(get_current_context(), *args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/flask/cli.py", line 355, in decorator app = __ctx.ensure_object(ScriptInfo).load_app() File "/app/.venv/lib/python3.10/site-packages/flask/cli.py", line 309, in load_app app = locate_app(import_name, name) File "/app/.venv/lib/python3.10/site-packages/flask/cli.py", line 238, in locate_app return find_app_by_string(module, app_name) File "/app/.venv/lib/python3.10/site-packages/flask/cli.py", line 166, in find_app_by_string app = attr(*args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/superset/app.py", line 40, in create_app app_initializer.init_app() File "/app/.venv/lib/python3.10/site-packages/superset/initialization/__init__.py", line 466, in init_app self.setup_db() File "/app/.venv/lib/python3.10/site-packages/superset/initialization/__init__.py", line 662, in setup_db pessimistic_connection_handling(db.engine) File "/app/.venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 998, in engine return self.get_engine() File "/app/.venv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py", line 1017, in get_engine return connector.get_engine() File "/app/.venv/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 "/app/.venv/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 "/app/.venv/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 375, in warned return fn(*args, **kwargs) File "/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 544, in create_engine dbapi = dialect_cls.dbapi(**dbapi_args) File "/app/.venv/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 811, in dbapi import psycopg2 ModuleNotFoundError: No module named 'psycopg2'` can you help me @dosu? GitHub link: https://github.com/apache/superset/discussions/34109#discussioncomment-14618458 ---- 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]
