GitHub user stgztsw created a discussion: When Gunicorn workers are set to more than 1, some workers will fail to load sqlalchemy.dialects:doris
Superset version 4.0.2 When Gunicorn workers are set to more than 1, some workers will fail to load sqlalchemy.dialects:doris, but anything is ok when work =1 . When Gunicorn workers are set to more than 1, some chart can not be loaded whith "DB engine Error" <img width="2272" height="992" alt="image" src="https://github.com/user-attachments/assets/a9a74642-5641-4275-bc6d-0552c7266825"; /> error log like this: 2025-09-26 01:50:19,170:ERROR:superset.views.base:Can't load plugin: sqlalchemy.dialects:doris Traceback (most recent call last): File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1823, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1799, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) File "/usr/local/lib/python3.9/site-packages/flask_appbuilder/security/decorators.py", line 95, in wraps return f(self, *args, **kwargs) File "/app/superset/views/base_api.py", line 127, in wraps raise ex File "/app/superset/views/base_api.py", line 121, in wraps duration, response = time_function(f, self, *args, **kwargs) File "/app/superset/utils/core.py", line 1470, in time_function response = func(*args, **kwargs) File "/app/superset/utils/log.py", line 255, in wrapper value = f(*args, **kwargs) File "/app/superset/charts/data/api.py", line 262, in data return self._get_data_response( File "/app/superset/charts/data/api.py", line 418, in _get_data_response result = command.run(force_cached=force_cached) File "/app/superset/commands/chart/data/get_data_command.py", line 45, in run payload = self._query_context.get_payload( File "/app/superset/common/query_context.py", line 100, in get_payload return self._processor.get_payload(cache_query_context, force_cached) File "/app/superset/common/query_context_processor.py", line 647, in get_payload query_results = [ File "/app/superset/common/query_context_processor.py", line 648, in <listcomp> get_query_results( File "/app/superset/common/query_actions.py", line 227, in get_query_results return result_func(query_context, query_obj, force_cached) File "/app/superset/common/query_actions.py", line 103, in _get_full payload = query_context.get_df_payload(query_obj, force_cached=force_cached) File "/app/superset/common/query_context.py", line 121, in get_df_payload return self._processor.get_df_payload( File "/app/superset/common/query_context_processor.py", line 128, in get_df_payload cache_key = self.query_cache_key(query_obj) File "/app/superset/common/query_context_processor.py", line 208, in query_cache_key extra_cache_keys = datasource.get_extra_cache_keys(query_obj.to_dict()) File "/app/superset/connectors/sqla/models.py", line 2000, in get_extra_cache_keys sqla_query = self.get_sqla_query(**query_obj) File "/app/superset/models/helpers.py", line 1510, in get_sqla_query template_processor = self.get_template_processor(**template_kwargs) File "/app/superset/connectors/sqla/models.py", line 1414, in get_template_processor return get_template_processor(table=self, database=self.database, **kwargs) File "/app/superset/jinja_context.py", line 665, in get_template_processor return template_processor(database=database, table=table, query=query, **kwargs) File "/app/superset/jinja_context.py", line 466, in __init__ self.set_context(**kwargs) File "/app/superset/jinja_context.py", line 509, in set_context dialect=self._database.get_dialect(), File "/app/superset/models/core.py", line 957, in get_dialect return sqla_url.get_dialect()() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/url.py", line 679, in get_dialect entrypoint = self._get_entrypoint() File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/url.py", line 661, in _get_entrypoint cls = registry.load(name) File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load raise exc.NoSuchModuleError( sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:doris GitHub link: https://github.com/apache/superset/discussions/35299 ---- 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]
