dgarciabriseno opened a new issue, #37578:
URL: https://github.com/apache/superset/issues/37578

   ### Bug description
   
   I upgraded to superset 6.0.0. I have a custom lean image which installs 
pymsql for MySQL/MariaDB support.
   
   This is the only change I have to the Docker file, the line under `# 
Helioviewer addition`
   ```dockerfile
   ######################################################################
   # Final lean image...
   ######################################################################
   FROM python-common AS lean
   
   # Install Python dependencies using docker/pip-install.sh
   COPY requirements/base.txt requirements/
   RUN --mount=type=cache,target=${SUPERSET_HOME}/.cache/uv \
       /app/docker/pip-install.sh --requires-build-essential -r 
requirements/base.txt && \
       # Helioviewer addition
       /app/docker/pip-install.sh --requires-build-essential --no-cache pymysql 
flask-cors psycopg2
   # Install the superset package
   RUN --mount=type=cache,target=${SUPERSET_HOME}/.cache/uv \
       uv pip install -e .
   RUN python -m compileall /app/superset
   
   USER superset
   ```
   
   When I attempt to bring "up" this image with my MariaDB database I get:
   
   ```
   superset-worker-1  | sqlalchemy.exc.ProgrammingError: 
(pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; 
check the manual that corresponds to your MariaDB server version for the right 
syntax to use near 'CYCLE' at line 1")
   superset-worker-1  | [SQL: CREATE SEQUENCE ab_permission_id_seq INCREMENT BY 
1 START WITH 1 MINVALUE 1 NO CYCLE]
   superset-worker-1  | (Background on this error at: 
https://sqlalche.me/e/14/f405)
   ```
   
   The issue is sqlalchemy generating the wrong SQL for MariaDB when using `NO 
CYCLE`. This was apparently fixed in [sqlalchemy 
2.0.46](https://github.com/sqlalchemy/sqlalchemy/releases/tag/rel_2_0_46) (see 
mariadb section)
   
   I tried updating to 2.0.46 but it looks like other code changes are required 
to update sqlalchemy to 2.x. So for now I just wanted this documented that 
MariaDB won't work as the back end.
   
   If you know of a workaround please let me know.
   
   ### Screenshots/recordings
   
   _No response_
   
   ### Superset version
   
   6.0.0
   
   ### Python version
   
   3.11
   
   ### Node version
   
   18 or greater
   
   ### Browser
   
   Not applicable
   
   ### Additional context
   
   Full stack trace
   
   ```
   Attaching to superset-worker-1
   superset-worker-1  | Loaded your LOCAL configuration at 
[/app/superset_config.py]
   superset-worker-1  | 2026-01-30 
15:06:21,269:WARNING:superset.initialization:We haven't found any Content 
Security Policy (CSP) defined in the configurations. Please make sure to 
configure CSP using the TALISMAN_ENABLED and TALISMAN_CONFIG keys or any other 
external software. Failing to configure CSP have serious security implications. 
Check https://developer.mozilla.org/en-US/docs/Web/HTTP/CSP for more 
information. You can disable this warning using the 
CONTENT_SECURITY_POLICY_WARNING key.
   superset-worker-1  | 2026-01-30 15:06:21,279:ERROR:superset.app:Failed to 
create app
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, 
in _execute_context
   superset-worker-1  |     self.dialect.do_execute(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 
736, in do_execute
   superset-worker-1  |     cursor.execute(statement, parameters)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in 
execute
   superset-worker-1  |     result = self._query(query)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in 
_query
   superset-worker-1  |     conn.query(q)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 575, in 
query
   superset-worker-1  |     self._affected_rows = 
self._read_query_result(unbuffered=unbuffered)
   superset-worker-1  |                           
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 826, in 
_read_query_result
   superset-worker-1  |     result.read()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in 
read
   superset-worker-1  |     first_packet = self.connection._read_packet()
   superset-worker-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 782, in 
_read_packet
   superset-worker-1  |     packet.raise_for_error()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in 
raise_for_error
   superset-worker-1  |     err.raise_mysql_exception(self._data)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/err.py", line 150, in 
raise_mysql_exception
   superset-worker-1  |     raise errorclass(errno, errval)
   superset-worker-1  | pymysql.err.ProgrammingError: (1064, "You have an error 
in your SQL syntax; check the manual that corresponds to your MariaDB server 
version for the right syntax to use near 'CYCLE' at line 1")
   superset-worker-1  | 
   superset-worker-1  | The above exception was the direct cause of the 
following exception:
   superset-worker-1  | 
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 260, 
in wrapped
   superset-worker-1  |     result = func(*args, **kwargs)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
717, in configure_fab
   superset-worker-1  |     appbuilder.init_app(self.superset_app, db.session)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/base.py", line 201, 
in init_app
   superset-worker-1  |     self.sm = self.security_manager_class(self)
   superset-worker-1  |               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 100, in __init__
   superset-worker-1  |     self.create_db()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 126, in create_db
   superset-worker-1  |     self._create_db()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 134, in _create_db
   superset-worker-1  |     Model.metadata.create_all(engine)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 4930, 
in create_all
   superset-worker-1  |     bind._run_ddl_visitor(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3238, 
in _run_ddl_visitor
   superset-worker-1  |     conn._run_ddl_visitor(visitorcallable, element, 
**kwargs)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2221, 
in _run_ddl_visitor
   superset-worker-1  |     visitorcallable(self.dialect, self, 
**kwargs).traverse_single(element)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 855, in 
visit_metadata
   superset-worker-1  |     self.traverse_single(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 893, in 
visit_table
   superset-worker-1  |     self.traverse_single(column.default)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 937, in 
visit_sequence
   superset-worker-1  |     self.connection.execute(CreateSequence(sequence))
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1385, 
in execute
   superset-worker-1  |     return meth(self, multiparams, params, 
_EMPTY_EXECUTION_OPTS)
   superset-worker-1  |            
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 80, in 
_execute_on_connection
   superset-worker-1  |     return connection._execute_ddl(
   superset-worker-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1477, 
in _execute_ddl
   superset-worker-1  |     ret = self._execute_context(
   superset-worker-1  |           ^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1953, 
in _execute_context
   superset-worker-1  |     self._handle_dbapi_exception(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2134, 
in _handle_dbapi_exception
   superset-worker-1  |     util.raise_(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211, 
in raise_
   superset-worker-1  |     raise exception
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, 
in _execute_context
   superset-worker-1  |     self.dialect.do_execute(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 
736, in do_execute
   superset-worker-1  |     cursor.execute(statement, parameters)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in 
execute
   superset-worker-1  |     result = self._query(query)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in 
_query
   superset-worker-1  |     conn.query(q)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 575, in 
query
   superset-worker-1  |     self._affected_rows = 
self._read_query_result(unbuffered=unbuffered)
   superset-worker-1  |                           
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 826, in 
_read_query_result
   superset-worker-1  |     result.read()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in 
read
   superset-worker-1  |     first_packet = self.connection._read_packet()
   superset-worker-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 782, in 
_read_packet
   superset-worker-1  |     packet.raise_for_error()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in 
raise_for_error
   superset-worker-1  |     err.raise_mysql_exception(self._data)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/err.py", line 150, in 
raise_mysql_exception
   superset-worker-1  |     raise errorclass(errno, errval)
   superset-worker-1  | sqlalchemy.exc.ProgrammingError: 
(pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; 
check the manual that corresponds to your MariaDB server version for the right 
syntax to use near 'CYCLE' at line 1")
   superset-worker-1  | [SQL: CREATE SEQUENCE ab_permission_id_seq INCREMENT BY 
1 START WITH 1 MINVALUE 1 NO CYCLE]
   superset-worker-1  | (Background on this error at: 
https://sqlalche.me/e/14/f405)
   superset-worker-1  | 
   superset-worker-1  | The above exception was the direct cause of the 
following exception:
   superset-worker-1  | 
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File "/app/superset/app.py", line 73, in create_app
   superset-worker-1  |     app_initializer.init_app()
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
638, in init_app
   superset-worker-1  |     self.init_app_in_ctx()
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
507, in init_app_in_ctx
   superset-worker-1  |     self.configure_fab()
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 267, 
in wrapped
   superset-worker-1  |     return on_error(ex)
   superset-worker-1  |            ^^^^^^^^^^^^
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 230, 
in on_error
   superset-worker-1  |     raise reraise() from ex
   superset-worker-1  | sqlalchemy.exc.SQLAlchemyError: ()
   superset-worker-1  | Usage: celery [OPTIONS] COMMAND [ARGS]...
   superset-worker-1  | Try 'celery --help' for help.
   superset-worker-1  | 
   superset-worker-1  | Error: 
   superset-worker-1  | Unable to load celery application.
   superset-worker-1  | While trying to load the module 
superset.tasks.celery_app:app the following error occurred:
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, 
in _execute_context
   superset-worker-1  |     self.dialect.do_execute(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 
736, in do_execute
   superset-worker-1  |     cursor.execute(statement, parameters)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in 
execute
   superset-worker-1  |     result = self._query(query)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in 
_query
   superset-worker-1  |     conn.query(q)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 575, in 
query
   superset-worker-1  |     self._affected_rows = 
self._read_query_result(unbuffered=unbuffered)
   superset-worker-1  |                           
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 826, in 
_read_query_result
   superset-worker-1  |     result.read()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in 
read
   superset-worker-1  |     first_packet = self.connection._read_packet()
   superset-worker-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 782, in 
_read_packet
   superset-worker-1  |     packet.raise_for_error()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in 
raise_for_error
   superset-worker-1  |     err.raise_mysql_exception(self._data)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/err.py", line 150, in 
raise_mysql_exception
   superset-worker-1  |     raise errorclass(errno, errval)
   superset-worker-1  | pymysql.err.ProgrammingError: (1064, "You have an error 
in your SQL syntax; check the manual that corresponds to your MariaDB server 
version for the right syntax to use near 'CYCLE' at line 1")
   superset-worker-1  | 
   superset-worker-1  | The above exception was the direct cause of the 
following exception:
   superset-worker-1  | 
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 260, 
in wrapped
   superset-worker-1  |     result = func(*args, **kwargs)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
717, in configure_fab
   superset-worker-1  |     appbuilder.init_app(self.superset_app, db.session)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/base.py", line 201, 
in init_app
   superset-worker-1  |     self.sm = self.security_manager_class(self)
   superset-worker-1  |               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 100, in __init__
   superset-worker-1  |     self.create_db()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 126, in create_db
   superset-worker-1  |     self._create_db()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/security/sqla/manager.py",
 line 134, in _create_db
   superset-worker-1  |     Model.metadata.create_all(engine)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/schema.py", line 4930, 
in create_all
   superset-worker-1  |     bind._run_ddl_visitor(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 3238, 
in _run_ddl_visitor
   superset-worker-1  |     conn._run_ddl_visitor(visitorcallable, element, 
**kwargs)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2221, 
in _run_ddl_visitor
   superset-worker-1  |     visitorcallable(self.dialect, self, 
**kwargs).traverse_single(element)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 855, in 
visit_metadata
   superset-worker-1  |     self.traverse_single(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 893, in 
visit_table
   superset-worker-1  |     self.traverse_single(column.default)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/visitors.py", line 524, 
in traverse_single
   superset-worker-1  |     return meth(obj, **kw)
   superset-worker-1  |            ^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 937, in 
visit_sequence
   superset-worker-1  |     self.connection.execute(CreateSequence(sequence))
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1385, 
in execute
   superset-worker-1  |     return meth(self, multiparams, params, 
_EMPTY_EXECUTION_OPTS)
   superset-worker-1  |            
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/ddl.py", line 80, in 
_execute_on_connection
   superset-worker-1  |     return connection._execute_ddl(
   superset-worker-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1477, 
in _execute_ddl
   superset-worker-1  |     ret = self._execute_context(
   superset-worker-1  |           ^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1953, 
in _execute_context
   superset-worker-1  |     self._handle_dbapi_exception(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2134, 
in _handle_dbapi_exception
   superset-worker-1  |     util.raise_(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211, 
in raise_
   superset-worker-1  |     raise exception
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910, 
in _execute_context
   superset-worker-1  |     self.dialect.do_execute(
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 
736, in do_execute
   superset-worker-1  |     cursor.execute(statement, parameters)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in 
execute
   superset-worker-1  |     result = self._query(query)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in 
_query
   superset-worker-1  |     conn.query(q)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 575, in 
query
   superset-worker-1  |     self._affected_rows = 
self._read_query_result(unbuffered=unbuffered)
   superset-worker-1  |                           
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 826, in 
_read_query_result
   superset-worker-1  |     result.read()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in 
read
   superset-worker-1  |     first_packet = self.connection._read_packet()
   superset-worker-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/connections.py", line 782, in 
_read_packet
   superset-worker-1  |     packet.raise_for_error()
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in 
raise_for_error
   superset-worker-1  |     err.raise_mysql_exception(self._data)
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/pymysql/err.py", line 150, in 
raise_mysql_exception
   superset-worker-1  |     raise errorclass(errno, errval)
   superset-worker-1  | sqlalchemy.exc.ProgrammingError: 
(pymysql.err.ProgrammingError) (1064, "You have an error in your SQL syntax; 
check the manual that corresponds to your MariaDB server version for the right 
syntax to use near 'CYCLE' at line 1")
   superset-worker-1  | [SQL: CREATE SEQUENCE ab_permission_id_seq INCREMENT BY 
1 START WITH 1 MINVALUE 1 NO CYCLE]
   superset-worker-1  | (Background on this error at: 
https://sqlalche.me/e/14/f405)
   superset-worker-1  | 
   superset-worker-1  | The above exception was the direct cause of the 
following exception:
   superset-worker-1  | 
   superset-worker-1  | Traceback (most recent call last):
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/celery/bin/celery.py", line 141, in 
celery
   superset-worker-1  |     app = find_app(app)
   superset-worker-1  |           ^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/celery/app/utils.py", line 383, in 
find_app
   superset-worker-1  |     sym = symbol_by_name(app, imp=imp)
   superset-worker-1  |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/kombu/utils/imports.py", line 59, in 
symbol_by_name
   superset-worker-1  |     module = imp(module_name, package=package, **kwargs)
   superset-worker-1  |              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/app/.venv/lib/python3.11/site-packages/celery/utils/imports.py", line 109, in 
import_from_cwd
   superset-worker-1  |     return imp(module, package=package)
   superset-worker-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File 
"/usr/local/lib/python3.11/importlib/__init__.py", line 126, in import_module
   superset-worker-1  |     return _bootstrap._gcd_import(name[level:], 
package, level)
   superset-worker-1  |            
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
   superset-worker-1  |   File "<frozen importlib._bootstrap>", line 1204, in 
_gcd_import
   superset-worker-1  |   File "<frozen importlib._bootstrap>", line 1176, in 
_find_and_load
   superset-worker-1  |   File "<frozen importlib._bootstrap>", line 1147, in 
_find_and_load_unlocked
   superset-worker-1  |   File "<frozen importlib._bootstrap>", line 690, in 
_load_unlocked
   superset-worker-1  |   File "<frozen importlib._bootstrap_external>", line 
940, in exec_module
   superset-worker-1  |   File "<frozen importlib._bootstrap>", line 241, in 
_call_with_frames_removed
   superset-worker-1  |   File "/app/superset/tasks/celery_app.py", line 32, in 
<module>
   superset-worker-1  |     flask_app = create_app()
   superset-worker-1  |                 ^^^^^^^^^^^^
   superset-worker-1  |   File "/app/superset/app.py", line 73, in create_app
   superset-worker-1  |     app_initializer.init_app()
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
638, in init_app
   superset-worker-1  |     self.init_app_in_ctx()
   superset-worker-1  |   File "/app/superset/initialization/__init__.py", line 
507, in init_app_in_ctx
   superset-worker-1  |     self.configure_fab()
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 267, 
in wrapped
   superset-worker-1  |     return on_error(ex)
   superset-worker-1  |            ^^^^^^^^^^^^
   superset-worker-1  |   File "/app/superset/utils/decorators.py", line 230, 
in on_error
   superset-worker-1  |     raise reraise() from ex
   superset-worker-1  | sqlalchemy.exc.SQLAlchemyError: ()
   superset-worker-1  | 
   superset-worker-1 exited with code 2
   ```
   
   ### Checklist
   
   - [x] I have searched Superset docs and Slack and didn't find a solution to 
my problem.
   - [x] I have searched the GitHub issue tracker and didn't find a similar bug 
report.
   - [x] I have checked Superset's logs for errors and if I found a relevant 
Python stacktrace, I included it here as text in the "additional context" 
section.


-- 
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]

Reply via email to