shubhshah01 commented on issue #27140:
URL: https://github.com/apache/superset/issues/27140#issuecomment-1951710147
Pasting my logs
```
LINE 2: FROM filter_sets
^
[SQL: SELECT filter_sets.created_on AS filter_sets_created_on,
filter_sets.changed_on AS filter_sets_changed_on, filter_sets.id AS
filter_sets_id, filter_sets.name AS filter_sets_name, filter_sets.description
AS filter_sets_description, filter_sets.json_metadata AS
filter_sets_json_metadata, filter_sets.dashboard_id AS
filter_sets_dashboard_id, filter_sets.owner_id AS filter_sets_owner_id,
filter_sets.owner_type AS filter_sets_owner_type, filter_sets.created_by_fk AS
filter_sets_created_by_fk, filter_sets.changed_by_fk AS
filter_sets_changed_by_fk
FROM filter_sets
WHERE %(param_1)s = filter_sets.dashboard_id]
[parameters: {'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/14/f405)
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line
732, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "filter_sets" does not exist
LINE 2: FROM filter_sets
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/app/superset/daos/base.py", line 219, in delete
db.session.delete(item)
File "<string>", line 2, in delete
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py",
line 2648, in delete
self._delete_impl(state, instance, head=True)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py",
line 2674, in _delete_impl
cascade_states = list(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/mapper.py",
line 3202, in cascade_iterator
queue = deque(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line
1989, in cascade_iterator
tuples = self._value_as_iterable(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/relationships.py", line
1963, in _value_as_iterable
x = impl.get(state, dict_, passive=passive)
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line
941, in get
value = self._fire_loader_callables(state, key, passive)
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line
977, in _fire_loader_callables
return self.callable_(state, passive)
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line
911, in _load_for_state
return self._emit_lazyload(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/strategies.py", line
1047, in _emit_lazyload
result = session.execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py",
line 1696, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1631, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py",
line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1498, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1862, in _execute_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 2043, in _handle_dbapi_exception
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py",
line 207, in raise_
raise exception
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py",
line 1819, in _execute_context
self.dialect.do_execute(
File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line
732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation
"filter_sets" does not exist
LINE 2: FROM filter_sets
^
[SQL: SELECT filter_sets.created_on AS filter_sets_created_on,
filter_sets.changed_on AS filter_sets_changed_on, filter_sets.id AS
filter_sets_id, filter_sets.name AS filter_sets_name, filter_sets.description
AS filter_sets_description, filter_sets.json_metadata AS
filter_sets_json_metadata, filter_sets.dashboard_id AS
filter_sets_dashboard_id, filter_sets.owner_id AS filter_sets_owner_id,
filter_sets.owner_type AS filter_sets_owner_type, filter_sets.created_by_fk AS
filter_sets_created_by_fk, filter_sets.changed_by_fk AS
filter_sets_changed_by_fk
FROM filter_sets
WHERE %(param_1)s = filter_sets.dashboard_id]
[parameters: {'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/14/f405)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/app/superset/commands/dashboard/delete.py", line 49, in run
DashboardDAO.delete(self._models)
File "/app/superset/daos/base.py", line 225, in delete
raise DAODeleteFailedError(exception=ex) from ex
superset.daos.exceptions.DAODeleteFailedError: Delete failed
2024-02-19
05:10:20,286:ERROR:superset.commands.dashboard.delete:(psycopg2.errors.UndefinedTable)
relation "filter_sets" does not exist
LINE 2: FROM filter_sets
^
```
--
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: notifications-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
