Skip to content

db init error #287

@shadowhenry

Description

@shadowhenry

mysql 5.7

init error, logs from docker logs superset:

File "/usr/local/lib/python3.11/site-packages/MySQLdb/cursors.py", line 330, in _query
db.query(q)
File "/usr/local/lib/python3.11/site-packages/MySQLdb/connections.py", line 255, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.ProgrammingError: (MySQLdb.ProgrammingError) (1146, "Table 'superset.ab_permission_view_role' doesn't exist")
[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, ab_permission_1.id AS ab_permission_1_id, ab_permission_1.name AS ab_permission_1_name, ab_view_menu_1.id AS ab_view_menu_1_id, ab_view_menu_1.name AS ab_view_menu_1_name
FROM ab_permission_view INNER JOIN ab_permission_view_role ON ab_permission_view.id = ab_permission_view_role.permission_view_id INNER JOIN ab_role ON ab_role.id = ab_permission_view_role.role_id INNER JOIN ab_permission ON ab_permission.id = ab_permission_view.permission_id INNER JOIN ab_view_menu ON ab_view_menu.id = ab_permission_view.view_menu_id LEFT OUTER JOIN ab_permission AS ab_permission_1 ON ab_permission_1.id = ab_permission_view.permission_id LEFT OUTER JOIN ab_view_menu AS ab_view_menu_1 ON ab_view_menu_1.id = ab_permission_view.view_menu_id
WHERE ab_permission.name = %s AND ab_role.id IN (%s)]

Hello, I'm confused with this error, how could I solve it?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions