Closed hyunmin0317 closed 14 hours ago
400
Oct 9 03:53:48 ip-172-31-14-225 web: 2024-10-09T03:53:48.886Z WARN 31512 --- [nio-5000-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1451, SQLState: 23000 Oct 9 03:53:48 ip-172-31-14-225 web: 2024-10-09T03:53:48.886Z ERROR 31512 --- [nio-5000-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : Cannot delete or update a parent row: a foreign key constraint fails (`smunity`.`core_course`, CONSTRAINT `FKpmb6uj4m3s9o701125v933itu` FOREIGN KEY (`member_id`) REFERENCES `common_member` (`member_id`)) Oct 9 03:53:48 ip-172-31-14-225 web: 2024-10-09T03:53:48.891Z WARN 31512 --- [nio-5000-exec-2] c.s.s.g.e.h.GeneralExceptionHandler : [WARNING] class org.springframework.dao.DataIntegrityViolationException : could not execute statement [Cannot delete or update a parent row: a foreign key constraint fails (`smunity`.`core_course`, CONSTRAINT `FKpmb6uj4m3s9o701125v933itu` FOREIGN KEY (`member_id`) REFERENCES `common_member` (`member_id`))] [delete from common_member where member_id=?]; SQL [delete from common_member where member_id=?]; constraint [null]
cascade = CascadeType.ALL
ON DELETE CASCADE
문제 상황
400
오류서버 로그
문제 원인 및 해결과정
cascade = CascadeType.ALL
)ON DELETE CASCADE
)