kitodo / kitodo-production

Kitodo.Production is a workflow management tool for mass digitization and is part of the Kitodo Digital Library Suite.
http://www.kitodo.org/software/kitodoproduction/
GNU General Public License v3.0
63 stars 63 forks source link

3.0.0 (commit f0d378a): UI stalls when deleting role or client #3054

Closed mnscholz closed 4 years ago

mnscholz commented 4 years ago

The system doesn't seem to check whether there are dependencies on a role or client when deleting it:

In the UI, if I want to delete a role or client that still has other things depending on it, the UI stalls showing the throbber. In the UI no error message or hint is shown. In the tomcat logs an exception like that one is logged: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (kitodo.project, CONSTRAINT FK_project_client_id FOREIGN KEY (client_id) REFERENCES client (id))

After reloading the user page, if I first delete all the dependencies, then the role/client deletion works correctly.

mnscholz commented 4 years ago

Obsolete. This seems to have been due to an insufficiently updated db. After a complete rebuild it does not appear anymore.