wildsonc opened a new issue #13183: URL: https://github.com/apache/superset/issues/13183
I'm trying to link the superset to postgres, but when I try to import a dashboard it crashes. I also can't save charts. #### Screenshots   #### How to reproduce the bug 1. Go to Import Dashboard 2. Click on Upload 3. See error. ### Environment - superset version: 1.0.1 - python version: Python 3.8.5 - postgres version: psql (PostgreSQL) 12.6 (Ubuntu 12.6-0ubuntu0.20.04.1) - Instaled from Scratch ### 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. ### Log ERROR:superset.app:Exception on /superset/import_dashboards [POST] Traceback (most recent call last): File "/root/superset/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app response = self.full_dispatch_request() File "/root/superset/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request rv = self.handle_user_exception(e) File "/root/superset/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception reraise(exc_type, exc_value, tb) File "/root/superset/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise raise value File "/root/superset/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "/root/superset/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/root/superset/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps return f(self, *args, **kwargs) File "/root/superset/lib/python3.8/site-packages/superset/utils/log.py", line 164, in wrapper value = f(*args, **kwargs) File "/root/superset/lib/python3.8/site-packages/superset/views/core.py", line 660, in import_dashboards databases = db.session.query(Database).all() File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3373, in all return list(self) File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__ return self._execute_and_instances(context) File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3556, in _execute_and_instances conn = self._get_bind_args( File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3571, in _get_bind_args return fn( File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3550, in _connection_from_session conn = self.session.connection(**kw) File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1142, in connection return self._connection_for_bind( File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 1150, in _connection_for_bind return self.transaction._connection_for_bind( File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 409, in _connection_for_bind self._assert_active() File "/root/superset/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 289, in _assert_active raise sa_exc.InvalidRequestError( sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: 'ascii' codec can't encode character '\xe1' in position 7: ordinal not in range(128) (Background on this error at: http://sqlalche.me/e/13/7s2a) INFO:werkzeug:170.83.134.254 - - [17/Feb/2021 18:50:15] "POST /superset/import_dashboards HTTP/1.1" 500 - INFO:werkzeug:170.83.134.254 - - [17/Feb/2021 18:54:59] "GET /superset/import_dashboards HTTP/1.1" 200 - ---------------------------------------------------------------- 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]
