[AMBARI-24547] A foreign key constraint fails when deleting a cluster from ambari

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Won't Do
• Affects Version/s: 2.5.0
• Component/s: ambari-server
• Labels: ambari-server pull-request-available
• Assignee: Dmytro Grinenko
• Reporter: yangqk
• Created: 28/Aug/18 03:03
• Updated: 27/Feb/20 06:50
• Resolved: 27/Feb/20 06:50

Description

when deleting a cluster which has been called some schedule requests, ambari server will reponse 500 , ambari-server.log has a exception like this:

org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign ke
y constraint fails (`aquila`.`request`, CONSTRAINT `FK_request_schedule_id` FOREIGN KEY (`request_schedule_id`) REFERENCES `requestschedule` (`schedule_id`))
Error Code: 1451
Call: DELETE FROM requestschedule WHERE (schedule_id = ?)
bind => [1 parameter bound]

Issue Links

• links to: GitHub Pull Request #2238