hannespr commented on issue #38629:
URL: https://github.com/apache/superset/issues/38629#issuecomment-4932673568
I just experienced the same problem with a PostgreSQL DB & v6.1.0.
```
superset-1 | Traceback (most recent call last):
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/flask_appbuilder/models/sqla/interface.py",
line 831, in delete
superset-1 | self.session.commit()
superset-1 | File "<string>", line 2, in commit
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1454,
in commit
superset-1 | self._transaction.commit(_to_root=self.future)
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 832,
in commit
superset-1 | self._prepare_impl()
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 811,
in _prepare_impl
superset-1 | self.session.flush()
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 3449,
in flush
superset-1 | self._flush(objects)
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 3588,
in _flush
superset-1 | with util.safe_reraise():
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line
70, in __exit__
superset-1 | compat.raise_(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211,
in raise_
superset-1 | raise exception
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 3549,
in _flush
superset-1 | flush_context.execute()
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line
456, in execute
superset-1 | rec.execute(self)
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line
667, in execute
superset-1 | util.preloaded.orm_persistence.delete_obj(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line
343, in delete_obj
superset-1 | _emit_delete_statements(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line
1468, in _emit_delete_statements
superset-1 | c = connection._execute_20(
superset-1 | ^^^^^^^^^^^^^^^^^^^^^^^
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1710,
in _execute_20
superset-1 | return meth(self, args_10style, kwargs_10style,
execution_options)
superset-1 |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 334,
in _execute_on_connection
superset-1 | return connection._execute_clauseelement(
superset-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1577,
in _execute_clauseelement
superset-1 | ret = self._execute_context(
superset-1 | ^^^^^^^^^^^^^^^^^^^^^^
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1953,
in _execute_context
superset-1 | self._handle_dbapi_exception(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2134,
in _handle_dbapi_exception
superset-1 | util.raise_(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 211,
in raise_
superset-1 | raise exception
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1910,
in _execute_context
superset-1 | self.dialect.do_execute(
superset-1 | File
"/app/.venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line
736, in do_execute
superset-1 | cursor.execute(statement, parameters)
superset-1 | sqlalchemy.exc.IntegrityError:
(psycopg2.errors.ForeignKeyViolation) update or delete on table "ab_user"
violates foreign key constraint "key_value_created_by_fk_fkey" on table
"key_value"
superset-1 | DETAIL: Key (id)=(3) is still referenced from table
"key_value".
superset-1 |
superset-1 | [SQL: DELETE FROM ab_user WHERE ab_user.id = %(id)s]
superset-1 | [parameters: {'id': 3}]
```
--
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]
