tullis commented on issue #23483: URL: https://github.com/apache/superset/issues/23483#issuecomment-1759979401
I've found another missing sequence in my upgraded 2.1.1 instance. I attempted to add the Alpha role to my account and received the following error.  ``` Oct 12 16:15:15 an-tool1005 superset[3608822]: 2023-10-12 16:15:15,189:ERROR:flask_appbuilder.models.sqla.interface:Edit record error: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) Oct 12 16:15:15 an-tool1005 superset[3608822]: (sqlalchemy.exc.ProgrammingError) (MySQLdb.ProgrammingError) (1146, "Table 'superset_staging.ab_user_role_id_seq' doesn't exist") Oct 12 16:15:15 an-tool1005 superset[3608822]: [SQL: INSERT INTO ab_user_role (id, user_id, role_id) VALUES (%s, %s, %s)] Oct 12 16:15:15 an-tool1005 superset[3608822]: [parameters: [{'user_id': 447, 'role_id': 3}]] Oct 12 16:15:15 an-tool1005 superset[3608822]: (Background on this error at: https://sqlalche.me/e/14/f405) Oct 12 16:15:15 an-tool1005 superset[3608822]: Traceback (most recent call last): Oct 12 16:15:15 an-tool1005 superset[3608822]: File "/srv/deployment/analytics/superset/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1897, in _cursor_execute Oct 12 16:15:15 an-tool1005 superset[3608822]: self.dialect.do_execute(cursor, statement, parameters, context) Oct 12 16:15:15 an-tool1005 superset[3608822]: File "/srv/deployment/analytics/superset/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute Oct 12 16:15:15 an-tool1005 superset[3608822]: cursor.execute(statement, parameters) Oct 12 16:15:15 an-tool1005 superset[3608822]: File "/srv/deployment/analytics/superset/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 179, in execute Oct 12 16:15:15 an-tool1005 superset[3608822]: res = self._query(mogrified_query) Oct 12 16:15:15 an-tool1005 superset[3608822]: File "/srv/deployment/analytics/superset/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 330, in _query Oct 12 16:15:15 an-tool1005 superset[3608822]: db.query(q) Oct 12 16:15:15 an-tool1005 superset[3608822]: File "/srv/deployment/analytics/superset/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 255, in query Oct 12 16:15:15 an-tool1005 superset[3608822]: _mysql.connection.query(self, query) Oct 12 16:15:15 an-tool1005 superset[3608822]: MySQLdb.ProgrammingError: (1146, "Table 'superset_staging.ab_user_role_id_seq' doesn't exist") ``` Presumably I can just create the sequence like I did for `ab_permission_id_seq`, `ab_view_menu_id_seq`, `ab_permission_view_id_seq` and `ab_permission_view_role_id_seq`, but it would be better if we could fix the broken migrations with the mariadb dialect. Is there an easy way to check what sequences should be present? -- 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]
