can't start with mysql 5.7.23

[vilmosnagy]

I tried to start this docker image with mysql:5.7.23, and the container can't create a few tables for itself.

Heer's my console history with each step: https://pastebin.com/WuABCLdu

TLDR:

• I start a MySQL 5.7.23
• I start this image
• I try to exec the superset init command

When the migrations are run they throw some error like:

2019-09-03 17:19:50,811:ERROR:flask_appbuilder.base:(MySQLdb._exceptions.ProgrammingError) (1146, "Table 'riport.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 
FROM ab_permission_view, ab_permission_view_role 
WHERE %s = ab_permission_view_role.role_id AND ab_permission_view.id = ab_permission_view_role.permission_view_id]
[parameters: (1,)]
(Background on this error at: http://sqlalche.me/e/f405)

My config is the following:

[vilmosnagy@vnagy-dell superset]$ cat etc/superset_config.py 
import os
from flask_appbuilder.security.manager import AUTH_OAUTH
basedir = os.path.abspath(os.path.dirname(__file__))

if "SUPERSET_HOME" in os.environ:
    DATA_DIR = os.environ["SUPERSET_HOME"]
else:
    DATA_DIR = os.path.join(os.path.expanduser("~"), ".superset")

ROW_LIMIT = 5000
SUPERSET_WORKERS = 4
SECRET_KEY = '>V=y|$Y:)!*n>+#%gQMw^lqzLa89-!<d@Lm3Hut_DM^O8PQVc5t}L+pF~.idF/1N<ADDGtSK65_w'
SQLALCHEMY_DATABASE_URI = 'mysql://riport:riport@momoriport/riport'
CSRF_ENABLED = True

[vikramsinghchandel]

Getting similar issue very frequently with mysql.
@amancevice any pointers

[vikramsinghchandel]

@vilmosnagy any solutions?

[vilmosnagy]

@vikramsinghchandel no. No-ish.

I was able to start the image, and I think the magic was to wait a bit after the MySQL starts to init properly, and do not open the site until the docker exec -it superset superset-init command finishes. But I wasn't able to reproduce the startup consistently.