Constraint exception when deleting user with mTLS certificates
authy_1 | java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`authy`.`client_auth_cert`, CONSTRAINT `FK1vut44g6htwhhqayrpmiy8t1f` FOREIGN KEY (`identity_id`) REFERENCES `identity` (`id`))
authy_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) ~[mysql-connector-java-8.0.19.jar!/:8.0.19]
authy_1 | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar!/:8.0.19]
authy_1 | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.19.jar!/:8.0.19]
We cant delete users with mTLS certs.