EMCP opened a new issue, #23631:
URL: https://github.com/apache/superset/issues/23631
I've hit the upgrade changes going from `v2.0.1` to `v2.1.0` .. so far It
seems I must now use a `SECURE_KEY` within my `superset_config.py` .. that was
fixed I think .. but now on a fresh install I goto hit the website and can see
in the logs of gunicorn
#### How to reproduce the bug
1. run the from scratch installation on Ubuntu 22.04 LTS
2. Set the `superset_config.py` to have the `SECRET_KEY` and nothing else
3. Navigate to `<ip_address>:8088` , you will see a 500 error
4. See error
```
Class 'werkzeug.local.LocalProxy' is not mapped
DBEventLogger failed to log event(s)
_log() got an unexpected keyword argument 'exc_info'
Traceback (most recent call last):
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py",
line 732, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: logs
```
### Expected results
I should be able to login
### Actual results
Error 500 page is shown
#### Screenshots
```
Class 'werkzeug.local.LocalProxy' is not mapped
[94/1865]
DBEventLogger failed to log event(s)
_log() got an unexpected keyword argument 'exc_info'
Traceback (most recent call last):
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py",
line 732, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: logs
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/ubuntu/.local/lib/python3.8/site-packages/superset/utils/log.py", line
368, in log
sesh.bulk_save_objects(logs)
File "<string>", line 2, in bulk_save_objects
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/session.py",
line 3627, in bulk_save_objects
self._bulk_save_mappings(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/session.py",
line 3843, in _bulk_save_mappings
transaction.rollback(_capture_exception=True)
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py",
line 70, in __exit__
compat.raise_(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/session.py",
line 3831, in _bulk_save_mappings
persistence._bulk_insert(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py",
line 107, in _bulk_insert
_emit_insert_statements(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/persistence.py",
line 1097, in _emit_insert_statements
c = connection._execute_20(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py",
line 325, in _execute_on_connection
return connection._execute_clauseelement(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1498, in _execute_clauseelement
ret = self._execute_context(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1862, in _execute_context
self._handle_dbapi_exception(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 2043, in _handle_dbapi_exception
util.raise_(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py",
line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table:
logs
[SQL: INSERT INTO logs (action, slice_id, json, dttm, duration_ms, referrer)
VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('welcome', 0, '{"path": "/superset/welcome/", "object_ref":
"Superset.welcome"}', '2023-04-09 17:23:11.503984', 0,
'http://10.10.200.177:8088/superset/welcom
e/')]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
During handling of the above exception, another exception occurred:
```
### Environment
(please complete the following information):
- browser type and version: Firefox
- superset version: `2.1.0`
- python version: `3.8`
- node.js version: `node -v`
- any feature flags active:
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
