aamir306 opened a new issue #10496:
URL: https://github.com/apache/incubator-superset/issues/10496
A clear and concise description of what the bug is.
I am using superset for 4 month now. It was working fine for me but few days
back when i tried to open database section it was showing me
```
Sorry, something went wrong
500 - Internal Server Error
```
Same with table and user datascoure. Also i am unable to select datasource
in sqllab. It is showing nothing there.
### Expected results
/databaseview/list/ should show me the list of all database .
### Actual results
It is showing error.
#### Screenshots
for mycompany.superset.com/databaseview/list/
https://i.stack.imgur.com/n5iED.png
### Environment
FROM python:3.8-slim
RUN apt-get update && \
apt-get install -y build-essential
Run apt-get install --no-install-recommends --yes \
libssl-dev libffi-dev libsasl2-dev libldap2-dev
default-libmysqlclient-dev \
firefox-esr wget
RUN wget
https://github.com/mozilla/geckodriver/releases/download/v0.26.0/geckodriver-v0.26.0-linux64.tar.gz
RUN tar -x geckodriver -zf geckodriver-v0.26.0-linux64.tar.gz -O >
/usr/bin/geckodriver
RUN chmod +x /usr/bin/geckodriver
RUN rm geckodriver-v0.26.0-linux64.tar.gz
COPY requirements.txt requirements.txt
RUN pip --no-cache-dir install -r requirements.txt
COPY . /app
WORKDIR /app
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
logs
```
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.588965332Z
[2020-07-25 11:49:34 +0000] [1] [INFO] Starting gunicorn 20.0.4
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.589512018Z
[2020-07-25 11:49:34 +0000] [1] [INFO] Listening at: http://0.0.0.0:9000 (1)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.589593219Z
[2020-07-25 11:49:34 +0000] [1] [INFO] Using worker: gevent
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.591815143Z
[2020-07-25 11:49:34 +0000] [8] [INFO] Booting worker with pid: 8
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.616097418Z
[2020-07-25 11:49:34 +0000] [9] [INFO] Booting worker with pid: 9
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.662698666Z
[2020-07-25 11:49:34 +0000] [10] [INFO] Booting worker with pid: 10
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.735632903Z
[2020-07-25 11:49:34 +0000] [11] [INFO] Booting worker with pid: 11
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.745240034Z
[2020-07-25 11:49:34 +0000] [12] [INFO] Booting worker with pid: 12
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.814846675Z
[2020-07-25 11:49:34 +0000] [13] [INFO] Booting worker with pid: 13
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.882702998Z
[2020-07-25 11:49:34 +0000] [14] [INFO] Booting worker with pid: 14
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:34.986121665Z
[2020-07-25 11:49:34 +0000] [15] [INFO] Booting worker with pid: 15
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:35.080984341Z
[2020-07-25 11:49:35 +0000] [16] [INFO] Booting worker with pid: 16
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:35.149155707Z
[2020-07-25 11:49:35 +0000] [17] [INFO] Booting worker with pid: 17
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.447767238Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.477300260Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.675676185Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.680448885Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.845280983Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.845331523Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.923926128Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:48.923972888Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.066573491Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.066618811Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.152217019Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.152263879Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.338376883Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.338421404Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.602983869Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.603036010Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.728776213Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.773329456Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.913350201Z logging
was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:49:49.913632434Z
INFO:superset.utils.logging_configurator:logging was configured successfully
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681820957Z
/usr/local/lib/python3.8/site-packages/flask_caching/__init__.py:191:
UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively
disabled.
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681879958Z
warnings.warn(
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681891208Z
ERROR:root:string argument without an encoding
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681899908Z
Traceback (most recent call last):
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681907668Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/utils.py", line 349, in
_get_value_for_key
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681914538Z
return obj[key]
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681920718Z
TypeError: 'Database' object is not subscriptable
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681927488Z
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681933528Z During
handling of the above exception, another exception occurred:
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681951989Z
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681957969Z
Traceback (most recent call last):
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681963699Z File
"/usr/local/lib/python3.8/site-packages/flask_appbuilder/api/__init__.py", line
83, in wraps
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681969249Z
return f(self, *args, **kwargs)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681973719Z File
"/usr/local/lib/python3.8/site-packages/flask_appbuilder/api/__init__.py", line
153, in wraps
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681978399Z
return f(self, *args, **kwargs)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681982479Z File
"/usr/local/lib/python3.8/site-packages/flask_appbuilder/api/__init__.py", line
1473, in get_list
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681987239Z
return self.get_list_headless(**kwargs)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681991669Z File
"/usr/local/lib/python3.8/site-packages/flask_appbuilder/api/__init__.py", line
1410, in get_list_headless
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.681997559Z
_response[API_RESULT_RES_KEY] = _list_model_schema.dump(lst, many=True).data
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682003089Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/schema.py", line 513, in
dump
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682008999Z
preresult = marshal(
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682013769Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/marshalling.py", line 114,
in serialize
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682020379Z ret
= [self.serialize(d, fields_dict, many=False,
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682025579Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/marshalling.py", line 114,
in <listcomp>
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682030629Z ret
= [self.serialize(d, fields_dict, many=False,
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682035740Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/marshalling.py", line 135,
in serialize
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682040620Z
value = self.call_and_store(
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682045260Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/marshalling.py", line 63,
in call_and_store
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682050000Z
value = getter_func(data)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682055120Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/marshalling.py", line 134,
in <lambda>
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682059860Z
getter = lambda d: field_obj.serialize(attr_name, d, accessor=accessor)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682064830Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/fields.py", line 243, in
serialize
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682070180Z
value = self.get_value(attr, obj, accessor=accessor)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682075060Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/fields.py", line 186, in
get_value
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682080090Z
return accessor_func(check_key, obj, default)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682085100Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/schema.py", line 415, in
get_attribute
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682090050Z
return utils.get_value(attr, obj, default)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682094880Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/utils.py", line 336, in
get_value
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682100160Z
return _get_value_for_keys(key.split('.'), obj, default)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682105150Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/utils.py", line 341, in
_get_value_for_keys
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682110070Z
return _get_value_for_key(keys[0], obj, default)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682115140Z File
"/usr/local/lib/python3.8/site-packages/marshmallow/utils.py", line 352, in
_get_value_for_key
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682121460Z attr
= getattr(obj, key)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682126431Z File
"/usr/local/lib/python3.8/site-packages/superset/models/core.py", line 203, in
backend
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682132611Z
sqlalchemy_url = make_url(self.sqlalchemy_uri_decrypted)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682137581Z File
"/usr/local/lib/python3.8/site-packages/superset/models/core.py", line 614, in
sqlalchemy_uri_decrypted
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682151371Z
conn.password = self.password
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682156951Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line
287, in __get__
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682161841Z
return self.impl.get(instance_state(instance), dict_)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682167391Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line
721, in get
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682172391Z
value = callable_(state, passive)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682177301Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line
449, in __call__
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682182231Z
return strategy._load_for_state(state, passive)
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682187321Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line
427, in _load_for_state
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682192391Z
loading.load_on_ident(
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682197161Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 201,
in load_on_ident
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682201991Z
return load_on_pk_identity(
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682207061Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 287,
in load_on_pk_identity
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682211972Z
return q.one()
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682230781Z File
"/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3458, in
one
webserver-866d7db958-kvzzs webserver 2020-07-25T11:54:50.682238101Z
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
