mjdhasan opened a new issue #11612:
URL: https://github.com/apache/incubator-superset/issues/11612
A clear and concise description of what the bug is.
### Expected results
login panel
### Actual results
sqlalchemy.exc.ProgrammingError
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation
"ab_permission_view_role" does not exist
LINE 2: FROM ab_permission_view JOIN ab_permission_view_role ON ab_p...
^
[SQL: SELECT ab_permission_view.id AS ab_permission_view_id,
ab_permission_view.permission_id AS ab_permission_view_permission_id,
ab_permission_view.view_menu_id AS ab_permission_view_view_menu_id
FROM ab_permission_view JOIN ab_permission_view_role ON
ab_permission_view.id = ab_permission_view_role.permission_view_id JOIN ab_role
ON ab_role.id = ab_permission_view_role.role_id JOIN ab_permission ON
ab_permission.id = ab_permission_view.permission_id JOIN ab_view_menu ON
ab_view_menu.id = ab_permission_view.view_menu_id
WHERE ab_permission.name = %(name_1)s AND ab_role.id IN (%(id_1)s)]
[parameters: {'name_1': 'menu_access', 'id_1': 2}]
(Background on this error at: http://sqlalche.me/e/13/f405)
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
Following the instructions on
https://preset.io/blog/2020-05-11-getting-started-installing-superset/,
1. git clone https://github.com/apache/incubator-superset.git
2. cd incubator-superset
3. docker-compose up
but unable to get to the l
4.open: http://localhost:8088
**In the docker-compose up output, I see an error related to ab_permission,
pasted below**
superset_init | sqlalchemy_exception,
with_traceback=exc_info[2], from_=e
superset_init | File
"/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182,
in raise_
superset_init | raise exception
superset_init | File
"/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1277,
in _execute_context
superset_init | cursor, statement, parameters, context
superset_init | File
"/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line
593, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | sqlalchemy.exc.InternalError:
(psycopg2.errors.InFailedSqlTransaction) current transaction is aborted,
commands ignored until end of transaction block
superset_init |
superset_init | [SQL: SELECT ab_permission.id AS
ab_permission_id, ab_permission.name AS ab_permission_name
superset_init | FROM ab_permission
superset_init | WHERE ab_permission.name = %(name_1)s]
superset_init | [parameters: {'name_1': 'all_datasource_access'}]
superset_init | (Background on this error at:
http://sqlalche.me/e/13/2j85)
superset_app | 127.0.0.1 - - [07/Nov/2020 08:34:58] "GET /health
HTTP/1.1" 200 -
superset_app | INFO:werkzeug:127.0.0.1 - - [07/Nov/2020
08:34:58] "GET /health HTTP/1.1" 200 -
superset_init exited with code 1
### Environment
(please complete the following information):
- python version: Python 3.6.3
----------------------------------------------------------------
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]
