You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/12/30 16:08:22 UTC
[GitHub] [incubator-superset] eohulse opened a new issue #12228: "TypeError: string argument without an encoding after" error after upgrading from 0.36 to 0.38
eohulse opened a new issue #12228:
URL: https://github.com/apache/incubator-superset/issues/12228
When upgrading superset from 0.36 to 0.38 and running the command
`> superset init`
I get an error
```
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/sql/sqltypes.py", line 944, in process
value = bytes(value)
TypeError: string argument without an encoding
```
After that, I can run superset, but most of the functions break with the same error when I click.
I guess it is related to the configuration of the one dataset I have.
Everything was working on 0.36 but not in 0.38.
#### How to reproduce the bug
I had superset installed in a conda environment, so in order to upgrade I did the following:
```
> conda activate superset_env #(python 3.8)
> pip install --upgrade apache-superset #(no errors)
> superset db upgrade #(no errors)
> superset init #(link to error)
```
With the stacktrace:
```
(superset) xxxx@xxxx:~$ superset init
logging was configured successfully
INFO:superset.utils.logging_configurator:logging was configured successfully
/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/flask_caching/__init__.py:188: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled.
warnings.warn(
No PIL installation found
INFO:superset.utils.screenshots:No PIL installation found
Syncing role definition
INFO:superset.security.manager:Syncing role definition
Syncing Admin perms
INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
INFO:superset.security.manager:Fetching a set of all perms to lookup which ones are missing
Creating missing datasource permissions.
INFO:superset.security.manager:Creating missing datasource permissions.
Traceback (most recent call last):
File "/home/user/bin/miniconda3/envs/superset/bin/superset", line 8, in <module>
sys.exit(superset())
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 586, in main
return super(FlaskGroup, self).main(*args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/decorators.py", line 21, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 426, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/decorators.py", line 21, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/flask/cli.py", line 426, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/superset/cli.py", line 75, in init
security_manager.sync_role_definitions()
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/superset/security/manager.py", line 632, in sync_role_definitions
self.create_missing_perms()
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/superset/security/manager.py", line 571, in create_missing_perms
merge_pv("datasource_access", datasource.get_perm())
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 590, in get_perm
return f"[{self.database}].[{self.table_name}](id:{self.id})"
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 286, in __get__
return self.impl.get(instance_state(instance), dict_)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 722, in get
value = self.callable_(state, passive)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 749, in _load_for_state
return self._emit_lazyload(
File "<string>", line 1, in <lambda>
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 837, in _emit_lazyload
q(session)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/ext/baked.py", line 615, in _load_on_pk_identity
result = list(bq.for_session(self.session).params(**params))
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 101, in instances
cursor.close()
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
compat.raise_(
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 81, in instances
rows = [proc(row) for row in fetch]
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 81, in <listcomp>
rows = [proc(row) for row in fetch]
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 580, in _instance
_populate_full(
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/orm/loading.py", line 726, in _populate_full
dict_[key] = getter(row)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/sql/type_api.py", line 1278, in process
return process_value(impl_processor(value), dialect)
File "/home/user/bin/miniconda3/envs/superset/lib/python3.8/site-packages/sqlalchemy/sql/sqltypes.py", line 944, in process
value = bytes(value)
TypeError: string argument without an encoding
```
### Environment
- superset version: 0.38
- python version: 3.8
- node.js version: 6.13.1
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org