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: [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]
