You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "worker24h (via GitHub)" <gi...@apache.org> on 2025/01/15 06:23:10 UTC
[I] Cant start superset [superset]
worker24h opened a new issue, #31852:
URL: https://github.com/apache/superset/issues/31852
### Bug description
1. I have changed the default metadata databaseļ¼to `MySQL`
2. SQLGLOT_DIALECTS_EXTENSIONS has exception, as follower
```python
2025-01-15 14:14:47,830: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 487, in init_app
self.configure_sqlglot_dialects()
File "/app/superset/initialization/__init__.py", line 550, in configure_sqlglot_dialects
SQLGLOT_DIALECTS.update(self.config["SQLGLOT_DIALECTS_EXTENSIONS"])
KeyError: 'SQLGLOT_DIALECTS_EXTENSIONS'
[2025-01-15 14:14:47 +0800] [37] [ERROR] Exception in worker process
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py", line 609, in spawn_worker
worker.init_process()
File "/usr/local/lib/python3.10/site-packages/gunicorn/workers/gthread.py", line 95, in init_process
super().init_process()
File "/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py", line 134, in init_process
self.load_wsgi()
File "/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py", line 146, in load_wsgi
self.wsgi = self.app.wsgi()
File "/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py", line 67, in wsgi
self.callable = self.load()
File "/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py", line 58, in load
return self.load_wsgiapp()
File "/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py", line 48, in load_wsgiapp
return util.import_app(self.app_uri)
File "/usr/local/lib/python3.10/site-packages/gunicorn/util.py", line 424, in import_app
app = app(*args, **kwargs)
File "/app/superset/app.py", line 40, in create_app
app_initializer.init_app()
File "/app/superset/initialization/__init__.py", line 487, in init_app
self.configure_sqlglot_dialects()
File "/app/superset/initialization/__init__.py", line 550, in configure_sqlglot_dialects
SQLGLOT_DIALECTS.update(self.config["SQLGLOT_DIALECTS_EXTENSIONS"])
KeyError: 'SQLGLOT_DIALECTS_EXTENSIONS'
[2025-01-15 14:14:47 +0800] [37] [INFO] Worker exiting (pid: 37)
```
### Screenshots/recordings
_No response_
### Superset version
4.1.1
### Python version
3.10
### Node version
18 or greater
### 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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Cant start superset - throw a exception on v4.1.1 [superset]
Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #31852:
URL: https://github.com/apache/superset/issues/31852#issuecomment-2591747119
<!-- Answer -->
The error you're encountering is due to a missing configuration key, `SQLGLOT_DIALECTS_EXTENSIONS`, in your Superset configuration. This key is expected to be present in the configuration but is currently missing, leading to a `KeyError`.
To resolve this issue, you can add the `SQLGLOT_DIALECTS_EXTENSIONS` configuration to your `superset_config.py` file. By default, this should be an empty dictionary if you do not have any custom SQL dialects to add. Here is how you can define it:
```python
SQLGLOT_DIALECTS_EXTENSIONS = {}
```
Add this line to your `superset_config.py` file, and then try restarting Superset. This should resolve the `KeyError` related to `SQLGLOT_DIALECTS_EXTENSIONS` <sup>[[1]](https://github.com/apache/superset/blob/master/superset/config.py)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/7ec64233-c637-4073-b675-8b763b870eb3?feedback_type=other)</sup>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Cant start superset - throw a exception on v4.1.1 [superset]
Posted by "worker24h (via GitHub)" <gi...@apache.org>.
worker24h closed issue #31852: Cant start superset - throw a exception on v4.1.1
URL: https://github.com/apache/superset/issues/31852
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org