rodionxabibov commented on issue #23483: URL: https://github.com/apache/superset/issues/23483#issuecomment-1697343807
I checked the connection using mysql-connector-python `SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://superset:[email protected]/superset"` and pymysql `SQLALCHEMY_DATABASE_URI = "mysql+pymysql://superset:[email protected]/superset"` but I also get an error ``` sqlalchemy.exc.ProgrammingError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (pymysql.err.ProgrammingError) (1146, "Table 'supersetdb.ab_permission_view_role_id_seq' doesn't exist") [SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval(ab_permission_view_role_id_seq), %(permission_view_id)s, %(role_id)s)] [parameters: ({'permission_view_id': 19, 'role_id': 6}, {'permission_view_id': 2, 'role_id': 6}, {'permission_view_id': 165, 'role_id': 6}, {'permission_view_id': 164, 'role_id': 6}, {'permission_view_id': 79, 'role_id': 6}, {'permission_view_id': 109, 'role_id': 6}, {'permission_view_id': 128, 'role_id': 6}, {'permission_view_id': 132, 'role_id': 6} ... displaying 10 of 14 total bound parameter sets ... {'permission_view_id': 167, 'role_id': 6}, {'permission_view_id': 169, 'role_id': 6})] (Background on this error at: https://sqlalche.me/e/14/f405) ``` -- 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]
