You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "gdudau (via GitHub)" <gi...@apache.org> on 2026/05/12 05:43:37 UTC
Re: [I] 6.0.0 - Deleting a user via the GUI fails with IntegrityError on MariaDB [superset]
gdudau commented on issue #38629:
URL: https://github.com/apache/superset/issues/38629#issuecomment-4427662993
I have same error on PostgreSQL when I try to delete an user.
`2026-05-12 08:28:30,693:ERROR:flask_appbuilder.models.sqla.interface:Delete item database error
Traceback (most recent call last):
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.ForeignKeyViolation: update or delete on table "ab_user" violates foreign key constraint "key_value_created_by_fk_fkey" on table "key_value"
DETAIL: Key (id)=(2) is still referenced from table "key_value".
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "superset/.venv/lib64/python3.10/site-packages/flask_appbuilder/models/sqla/interface.py", line 831, in delete
self.session.commit()
File "<string>", line 2, in commit
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 1454, in commit
self._transaction.commit(_to_root=self.future)
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 832, in commit
self._prepare_impl()
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 811, in _prepare_impl
self.session.flush()
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 3449, in flush
self._flush(objects)
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 3588, in _flush
with util.safe_reraise():
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
compat.raise_(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/session.py", line 3549, in _flush
flush_context.execute()
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 453, in execute
n.execute_aggregate(self, set_)
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 776, in execute_aggregate
persistence.delete_obj(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 343, in delete_obj
_emit_delete_statements(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1468, in _emit_delete_statements
c = connection._execute_20(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
return connection._execute_clauseelement(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement
ret = self._execute_context(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context
self._handle_dbapi_exception(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception
util.raise_(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context
self.dialect.do_execute(
File "superset/.venv/lib64/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
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"
DETAIL: Key (id)=(2) is still referenced from table "key_value".
[SQL: DELETE FROM ab_user WHERE ab_user.id = %(id)s]
[parameters: {'id': 2}]
(Background on this error at: https://sqlalche.me/e/14/gkpj)`
I don't have charts or dashboards.
PostgreSQL is not in supported versions: 18.3
Apache Superset version 6.0.0
--
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-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org