jbat commented on issue #27140:
URL: https://github.com/apache/superset/issues/27140#issuecomment-1951633598
I have the same issue.
"There was an issue deleting TEST COPY - TO BE DELETED: Dashboard could not
be deleted."
Logs showing this
```
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py",
line 1207, in _run_crud
2024-02-19T03:29:32.878Z raise exc.StaleDataError(
2024-02-19T03:29:32.878Z sqlalchemy.orm.exc.StaleDataError: DELETE statement
on table 'tagged_object' expected to delete 3 row(s); Only 4 were matched.
```
Full stack trace
```2024-02-19T03:29:32.878Z DELETE statement on table 'tagged_object'
expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.878Z Traceback (most recent call last):
2024-02-19T03:29:32.878Z File "/app/superset/daos/base.py", line 222, in
delete
2024-02-19T03:29:32.878Z db.session.commit()
2024-02-19T03:29:32.878Z File "<string>", line 2, in commit
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435,
in commit
2024-02-19T03:29:32.878Z self._transaction.commit(_to_root=self.future)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829,
in commit
2024-02-19T03:29:32.878Z self._prepare_impl()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808,
in _prepare_impl
2024-02-19T03:29:32.878Z self.session.flush()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367,
in flush
2024-02-19T03:29:32.878Z self._flush(objects)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507,
in _flush
2024-02-19T03:29:32.878Z transaction.rollback(_capture_exception=True)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line
70, in __exit__
2024-02-19T03:29:32.878Z compat.raise_(
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207,
in raise_
2024-02-19T03:29:32.878Z raise exception
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467,
in _flush
2024-02-19T03:29:32.878Z flush_context.execute()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
456, in execute
2024-02-19T03:29:32.878Z rec.execute(self)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
577, in execute
2024-02-19T03:29:32.878Z self.dependency_processor.process_deletes(uow,
states)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1110, in process_deletes
2024-02-19T03:29:32.878Z self._run_crud(
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1207, in _run_crud
2024-02-19T03:29:32.878Z raise exc.StaleDataError(
2024-02-19T03:29:32.878Z sqlalchemy.orm.exc.StaleDataError: DELETE statement
on table 'tagged_object' expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.878Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.878Z Traceback (most recent call last):
2024-02-19T03:29:32.878Z File
"/app/superset/commands/dashboard/delete.py", line 49, in run
2024-02-19T03:29:32.878Z DashboardDAO.delete(self._models)
2024-02-19T03:29:32.878Z File "/app/superset/daos/base.py", line 225, in
delete
2024-02-19T03:29:32.878Z raise DAODeleteFailedError(exception=ex) from ex
2024-02-19T03:29:32.878Z superset.daos.exceptions.DAODeleteFailedError:
Delete failed
2024-02-19T03:29:32.878Z 2024-02-19
03:29:32,878:ERROR:superset.commands.dashboard.delete:DELETE statement on table
'tagged_object' expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.878Z Traceback (most recent call last):
2024-02-19T03:29:32.878Z File "/app/superset/daos/base.py", line 222, in
delete
2024-02-19T03:29:32.878Z db.session.commit()
2024-02-19T03:29:32.878Z File "<string>", line 2, in commit
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435,
in commit
2024-02-19T03:29:32.878Z self._transaction.commit(_to_root=self.future)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829,
in commit
2024-02-19T03:29:32.878Z self._prepare_impl()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808,
in _prepare_impl
2024-02-19T03:29:32.878Z self.session.flush()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367,
in flush
2024-02-19T03:29:32.878Z self._flush(objects)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507,
in _flush
2024-02-19T03:29:32.878Z transaction.rollback(_capture_exception=True)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line
70, in __exit__
2024-02-19T03:29:32.878Z compat.raise_(
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207,
in raise_
2024-02-19T03:29:32.878Z raise exception
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467,
in _flush
2024-02-19T03:29:32.878Z flush_context.execute()
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
456, in execute
2024-02-19T03:29:32.878Z rec.execute(self)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
577, in execute
2024-02-19T03:29:32.878Z self.dependency_processor.process_deletes(uow,
states)
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1110, in process_deletes
2024-02-19T03:29:32.878Z self._run_crud(
2024-02-19T03:29:32.878Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1207, in _run_crud
2024-02-19T03:29:32.878Z raise exc.StaleDataError(
2024-02-19T03:29:32.878Z sqlalchemy.orm.exc.StaleDataError: DELETE statement
on table 'tagged_object' expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.878Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.878Z Traceback (most recent call last):
2024-02-19T03:29:32.878Z File
"/app/superset/commands/dashboard/delete.py", line 49, in run
2024-02-19T03:29:32.878Z DashboardDAO.delete(self._models)
2024-02-19T03:29:32.878Z File "/app/superset/daos/base.py", line 225, in
delete
2024-02-19T03:29:32.878Z raise DAODeleteFailedError(exception=ex) from ex
2024-02-19T03:29:32.878Z superset.daos.exceptions.DAODeleteFailedError:
Delete failed
2024-02-19T03:29:32.879Z Error deleting model DashboardRestApi: Dashboard
could not be deleted.
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File "/app/superset/daos/base.py", line 222, in
delete
2024-02-19T03:29:32.879Z db.session.commit()
2024-02-19T03:29:32.879Z File "<string>", line 2, in commit
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435,
in commit
2024-02-19T03:29:32.879Z self._transaction.commit(_to_root=self.future)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829,
in commit
2024-02-19T03:29:32.879Z self._prepare_impl()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808,
in _prepare_impl
2024-02-19T03:29:32.879Z self.session.flush()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367,
in flush
2024-02-19T03:29:32.879Z self._flush(objects)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507,
in _flush
2024-02-19T03:29:32.879Z transaction.rollback(_capture_exception=True)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line
70, in __exit__
2024-02-19T03:29:32.879Z compat.raise_(
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207,
in raise_
2024-02-19T03:29:32.879Z raise exception
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467,
in _flush
2024-02-19T03:29:32.879Z flush_context.execute()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
456, in execute
2024-02-19T03:29:32.879Z rec.execute(self)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
577, in execute
2024-02-19T03:29:32.879Z self.dependency_processor.process_deletes(uow,
states)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1110, in process_deletes
2024-02-19T03:29:32.879Z self._run_crud(
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1207, in _run_crud
2024-02-19T03:29:32.879Z raise exc.StaleDataError(
2024-02-19T03:29:32.879Z sqlalchemy.orm.exc.StaleDataError: DELETE statement
on table 'tagged_object' expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.879Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File
"/app/superset/commands/dashboard/delete.py", line 49, in run
2024-02-19T03:29:32.879Z DashboardDAO.delete(self._models)
2024-02-19T03:29:32.879Z File "/app/superset/daos/base.py", line 225, in
delete
2024-02-19T03:29:32.879Z raise DAODeleteFailedError(exception=ex) from ex
2024-02-19T03:29:32.879Z superset.daos.exceptions.DAODeleteFailedError:
Delete failed
2024-02-19T03:29:32.879Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File "/app/superset/dashboards/api.py", line 672,
in delete
2024-02-19T03:29:32.879Z DeleteDashboardCommand([pk]).run()
2024-02-19T03:29:32.879Z File
"/app/superset/commands/dashboard/delete.py", line 52, in run
2024-02-19T03:29:32.879Z raise DashboardDeleteFailedError() from ex
2024-02-19T03:29:32.879Z
superset.commands.dashboard.exceptions.DashboardDeleteFailedError: Dashboard
could not be deleted.
2024-02-19T03:29:32.879Z 2024-02-19
03:29:32,878:ERROR:superset.dashboards.api:Error deleting model
DashboardRestApi: Dashboard could not be deleted.
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File "/app/superset/daos/base.py", line 222, in
delete
2024-02-19T03:29:32.879Z db.session.commit()
2024-02-19T03:29:32.879Z File "<string>", line 2, in commit
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1435,
in commit
2024-02-19T03:29:32.879Z self._transaction.commit(_to_root=self.future)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 829,
in commit
2024-02-19T03:29:32.879Z self._prepare_impl()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 808,
in _prepare_impl
2024-02-19T03:29:32.879Z self.session.flush()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3367,
in flush
2024-02-19T03:29:32.879Z self._flush(objects)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3507,
in _flush
2024-02-19T03:29:32.879Z transaction.rollback(_capture_exception=True)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line
70, in __exit__
2024-02-19T03:29:32.879Z compat.raise_(
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 207,
in raise_
2024-02-19T03:29:32.879Z raise exception
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 3467,
in _flush
2024-02-19T03:29:32.879Z flush_context.execute()
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
456, in execute
2024-02-19T03:29:32.879Z rec.execute(self)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line
577, in execute
2024-02-19T03:29:32.879Z self.dependency_processor.process_deletes(uow,
states)
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1110, in process_deletes
2024-02-19T03:29:32.879Z self._run_crud(
2024-02-19T03:29:32.879Z File
"/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/dependency.py", line
1207, in _run_crud
2024-02-19T03:29:32.879Z raise exc.StaleDataError(
2024-02-19T03:29:32.879Z sqlalchemy.orm.exc.StaleDataError: DELETE statement
on table 'tagged_object' expected to delete 3 row(s); Only 4 were matched.
2024-02-19T03:29:32.879Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File
"/app/superset/commands/dashboard/delete.py", line 49, in run
2024-02-19T03:29:32.879Z DashboardDAO.delete(self._models)
2024-02-19T03:29:32.879Z File "/app/superset/daos/base.py", line 225, in
delete
2024-02-19T03:29:32.879Z raise DAODeleteFailedError(exception=ex) from ex
2024-02-19T03:29:32.879Z superset.daos.exceptions.DAODeleteFailedError:
Delete failed
2024-02-19T03:29:32.879Z The above exception was the direct cause of the
following exception:
2024-02-19T03:29:32.879Z Traceback (most recent call last):
2024-02-19T03:29:32.879Z File "/app/superset/dashboards/api.py", line 672,
in delete
2024-02-19T03:29:32.879Z DeleteDashboardCommand([pk]).run()
2024-02-19T03:29:32.879Z File
"/app/superset/commands/dashboard/delete.py", line 52, in run
2024-02-19T03:29:32.879Z raise DashboardDeleteFailedError() from ex
2024-02-19T03:29:32.879Z
superset.commands.dashboard.exceptions.DashboardDeleteFailedError: Dashboard
could not be deleted.
2024-02-19T03:29:32.888Z 49.181.76.109 - - [19/Feb/2024:03:29:32 +0000]
"DELETE /api/v1/dashboard/93 HTTP/1.1" 422 46
"https://staging.ready-superset.jobready.io/dashboard/list/?pageIndex=0&sortColumn=changed_on_delta_humanized&sortOrder=desc&viewMode=table";
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/121.0.0.0 Safari/537.36"
```
--
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
