qlands commented on issue #33157:
URL: https://github.com/apache/superset/issues/33157#issuecomment-2814289128
Here is the stack trace:
```
Traceback (most recent call last):
File
"/opt/superset_env/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py",
line 111, in wraps
return f(self, *args, **kwargs)
File
"/opt/superset_env/lib/python3.10/site-packages/superset/views/base_api.py",
line 119, in wraps
duration, response = time_function(f, self, *args, **kwargs)
File
"/opt/superset_env/lib/python3.10/site-packages/superset/utils/core.py", line
1364, in time_function
response = func(*args, **kwargs)
File
"/opt/superset_env/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py",
line 183, in wraps
return f(self, *args, **kwargs)
File
"/opt/superset_env/lib/python3.10/site-packages/superset/utils/log.py", line
303, in wrapper
value = f(*args, **kwargs)
File
"/opt/superset_env/lib/python3.10/site-packages/superset/dashboards/api.py",
line 1188, in favorite_status
favorited_dashboard_ids = DashboardDAO.favorited_ids(dashboards)
File
"/opt/superset_env/lib/python3.10/site-packages/superset/daos/dashboard.py",
line 279, in favorited_ids
.all()
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line
2773, in all
return self._iter().all()
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line
2916, in _iter
result = self.session.execute(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/orm/session.py",
line 1717, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/sql/elements.py",
line 334, in _execute_on_connection
return connection._execute_clauseelement(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1577, in _execute_clauseelement
ret = self._execute_context(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1953, in _execute_context
self._handle_dbapi_exception(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 2134, in _handle_dbapi_exception
util.raise_(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/util/compat.py",
line 211, in raise_
raise exception
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/base.py",
line 1910, in _execute_context
self.dialect.do_execute(
File
"/opt/superset_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py",
line 736, in do_execute
cursor.execute(statement, parameters)
File
"/opt/superset_env/lib/python3.10/site-packages/mysql/connector/cursor.py",
line 389, in execute
stmt = _bytestr_format_dict(stmt, self._process_params_dict(params))
File
"/opt/superset_env/lib/python3.10/site-packages/mysql/connector/cursor.py",
line 291, in _process_params_dict
raise ProgrammingError(
sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError)
Failed processing pyformat-parameters; Python 'favstarclassname' cannot be
converted to a MySQL type
[SQL: SELECT favstar.obj_id AS favstar_obj_id
FROM favstar
WHERE favstar.class_name = %(class_name_1)s AND favstar.obj_id IN
(%(obj_id_1_1)s, %(obj_id_1_2)s, %(obj_id_1_3)s, %(obj_id_1_4)s,
%(obj_id_1_5)s, %(obj_id_1_6)s, %(obj_id_1_7)s, %(obj_id_1_8)s, %(obj_id_1_9)s,
%(obj_id_1_10)s, %(obj_id_1_11)s, %(obj_id_1_12)s, %(obj_id_1_13)s,
%(obj_id_1_14)s, %(obj_id_1_15)s, %(obj_id_1_16)s, %(obj_id_1_17)s,
%(obj_id_1_18)s, %(obj_id_1_19)s, %(obj_id_1_20)s, %(obj_id_1_21)s,
%(obj_id_1_22)s) AND favstar.user_id = %(user_id_1)s]
[parameters: {'class_name_1': <FavStarClassName.DASHBOARD: 'Dashboard'>,
'user_id_1': 1, 'obj_id_1_1': 4, 'obj_id_1_2': 6, 'obj_id_1_3': 7,
'obj_id_1_4': 8, 'obj_id_1_5': 13, 'obj_id_1_6': 14, 'obj_id_1_7': 17,
'obj_id_1_8': 18, 'obj_id_1_9': 21, 'obj_id_1_10': 23, 'obj_id_1_11': 24,
'obj_id_1_12': 25, 'obj_id_1_13': 26, 'obj_id_1_14': 27, 'obj_id_1_15': 28,
'obj_id_1_16': 29, 'obj_id_1_17': 30, 'obj_id_1_18': 32, 'obj_id_1_19': 33,
'obj_id_1_20': 34, 'obj_id_1_21': 35, 'obj_id_1_22': 36}]
(Background on this error at: https://sqlalche.me/e/14/f405)
INFO:sqlalchemy.engine.Engine:ROLLBACK
```
--
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]
