shyamalshivam opened a new issue, #33855:
URL: https://github.com/apache/superset/issues/33855
### Bug description
I am booting up official release tag (TAG=5.0.0rc3) with docker compose
with database metadata for Azure MYSQL Instance
I am overriding .env.local configuration as
DATABASE_PORT=3306
DATABASE_DIALECT=mysql+mysqlconnector
DATABASE_HOST=xxxx.mysql.database.azure.com
DATABASE_DB=superset
DATABASE_PASSWORD=yyyyy
DATABASE_USER=superset
superset_init container starts Applying DB migrations as below
superset_init |
######################################################################
superset_init | Init Step 1/4 [Starting] -- Applying DB migrations
superset_init |
######################################################################
superset_init | Loaded your LOCAL configuration at
[/app/docker/pythonpath_dev/superset_config.py]
superset_init | 2025-06-22
10:38:54,962:INFO:superset.initialization:Setting database isolation level to
READ COMMITTED
superset_init | 2025-06-22
10:38:55,393:INFO:mysql.connector:package: mysql.connector.plugins
superset_init | 2025-06-22
10:38:55,393:INFO:mysql.connector:plugin_name: mysql_native_password
superset_init | 2025-06-22
10:38:55,394:INFO:mysql.connector:AUTHENTICATION_PLUGIN_CLASS:
MySQLNativePasswordAuthPlugin
superset_init | 2025-06-22
10:38:59,275:INFO:superset.utils.screenshots:No PIL installation found
superset_init | 2025-06-22 10:38:59,895:INFO:superset.utils.pdf:No
PIL installation found
superset_init | INFO [alembic.env] Starting the migration scripts.
superset_init | INFO [alembic.runtime.migration] Context impl
MySQLImpl.
superset_init | INFO [alembic.runtime.migration] Will assume
transactional DDL.
superset_init | INFO [alembic.runtime.migration] Running upgrade
-> 4e6a06bad7a8, Init
but fails at the migration on below
mysql.connector.errors.ProgrammingError: Failed processing
pyformat-parameters; Python 'reportstate' cannot be converted to a MySQL type
superset_init | INFO [alembic.runtime.migration] Running upgrade
9d8a8d575284 -> cecc6bf46990, rm_time_range_endpoints_2
superset_init | INFO [alembic.runtime.migration] Running upgrade
cecc6bf46990 -> ad07e4fdbaba, rm_time_range_endpoints_from_qc_3
superset_init | slices updated with no time_range_endpoints: 0
superset_init | INFO [alembic.runtime.migration] Running upgrade
ad07e4fdbaba -> a9422eeaae74, new_dataset_models_take_2
superset_init | >> Assign new UUIDs to tables...
superset_init | >> Drop intermediate columns...
superset_init | INFO [alembic.runtime.migration] Running upgrade
a9422eeaae74 -> cbe71abde154, fix report schedule and execution log
superset_init | Traceback (most recent call last):
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/cursor.py", line 285,
in _process_params_dict
superset_init | conv = to_mysql(conv)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/conversion.py", line
245, in to_mysql
superset_init | raise TypeError(
superset_init | TypeError: Python 'reportstate' cannot be converted
to a MySQL type
superset_init |
superset_init | The above exception was the direct cause of the
following exception:
superset_init |
superset_init | Traceback (most recent call last):
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910,
in _execute_context
superset_init | self.dialect.do_execute(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/cursor.py", line 389,
in execute
superset_init | stmt = _bytestr_format_dict(stmt,
self._process_params_dict(params))
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/cursor.py", line 291,
in _process_params_dict
superset_init | raise ProgrammingError(
superset_init | mysql.connector.errors.ProgrammingError: Failed
processing pyformat-parameters; Python 'reportstate' cannot be converted to a
MySQL type
superset_init |
superset_init | The above exception was the direct cause of the
following exception:
superset_init |
superset_init | Traceback (most recent call last):
superset_init | File "/app/.venv/bin/superset", line 10, in
<module>
superset_init | sys.exit(superset())
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 1157, in __call__
superset_init | return self.main(*args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 1078, in main
superset_init | rv = self.invoke(ctx)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset_init | return
_process_result(sub_ctx.command.invoke(sub_ctx))
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 1688, in invoke
superset_init | return
_process_result(sub_ctx.command.invoke(sub_ctx))
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 1434, in invoke
superset_init | return ctx.invoke(self.callback, **ctx.params)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/decorators.py", line 33, in
new_func
superset_init | return f(get_current_context(), *args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/flask/cli.py", line 358, in decorator
superset_init | return __ctx.invoke(f, *args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/click/core.py", line 783, in invoke
superset_init | return __callback(*args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/flask_migrate/cli.py", line 149, in
upgrade
superset_init | _upgrade(directory, revision, sql, tag, x_arg)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/flask_migrate/__init__.py", line 98,
in wrapped
superset_init | f(*args, **kwargs)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/flask_migrate/__init__.py", line 185,
in upgrade
superset_init | command.upgrade(config, revision, sql=sql,
tag=tag)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/command.py", line 406, in
upgrade
superset_init | script.run_env()
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/script/base.py", line 586, in
run_env
superset_init | util.load_python_file(self.dir, "env.py")
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 95, in
load_python_file
superset_init | module = load_module_py(module_id, path)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/util/pyfiles.py", line 113, in
load_module_py
superset_init | spec.loader.exec_module(module) # type: ignore
superset_init | File "<frozen importlib._bootstrap_external>",
line 883, in exec_module
superset_init | File "<frozen importlib._bootstrap>", line 241, in
_call_with_frames_removed
superset_init | File
"/app/superset/extensions/../migrations/env.py", line 142, in <module>
superset_init | run_migrations_online()
superset_init | File
"/app/superset/extensions/../migrations/env.py", line 133, in
run_migrations_online
superset_init | context.run_migrations()
superset_init | File "<string>", line 8, in run_migrations
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/runtime/environment.py", line
946, in run_migrations
superset_init | self.get_context().run_migrations(**kw)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/alembic/runtime/migration.py", line
623, in run_migrations
superset_init | step.migration_fn(**kw)
superset_init | File
"/app/superset/migrations/versions/2022-05-03_19-39_cbe71abde154_fix_report_schedule_and_log.py",
line 64, in upgrade
superset_init | .all()
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773,
in all
superset_init | return self._iter().all()
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916,
in _iter
superset_init | result = self.session.execute(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717,
in execute
superset_init | result = conn._execute_20(statement, params or
{}, execution_options)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710,
in _execute_20
superset_init | return meth(self, args_10style, kwargs_10style,
execution_options)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334,
in _execute_on_connection
superset_init | return connection._execute_clauseelement(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577,
in _execute_clauseelement
superset_init | ret = self._execute_context(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953,
in _execute_context
superset_init | self._handle_dbapi_exception(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134,
in _handle_dbapi_exception
superset_init | util.raise_(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211,
in raise_
superset_init | raise exception
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910,
in _execute_context
superset_init | self.dialect.do_execute(
superset_init | File
"/app/.venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
superset_init | cursor.execute(statement, parameters)
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/cursor.py", line 389,
in execute
superset_init | stmt = _bytestr_format_dict(stmt,
self._process_params_dict(params))
superset_init | File
"/app/.venv/lib/python3.10/site-packages/mysql/connector/cursor.py", line 291,
in _process_params_dict
superset_init | raise ProgrammingError(
superset_init | sqlalchemy.exc.ProgrammingError:
(mysql.connector.errors.ProgrammingError) Failed processing
pyformat-parameters; Python 'reportstate' cannot be converted to a MySQL type
superset_init | [SQL: SELECT report_schedule.id AS
report_schedule_id, report_schedule.last_state AS report_schedule_last_state,
report_schedule.`last_value` AS report_schedule_last_value,
report_schedule.last_value_row_json AS report_schedule_last_value_row_json
superset_init | FROM report_schedule
superset_init | WHERE report_schedule.last_state = %(last_state_1)s]
superset_init | [parameters: {'last_state_1': <ReportState.WORKING:
'Working'>}]
superset_init | (Background on this error at:
https://sqlalche.me/e/14/f405)
what is the resolution for this?
### Screenshots/recordings
_No response_
### Superset version
master / latest-dev
### Python version
3.9
### Node version
16
### Browser
Chrome
### Additional context
_No response_
### Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to
my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug
report.
- [ ] 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]
