회원탈퇴 api 호출 시,
2024-05-23T16:30:29.451+09:00 WARN 20304 --- [nio-8080-exec-8] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.dao.DataIntegrityViolationException: could not execute statement [Cannot delete or update a parent row: a foreign key constraint fails (cloneoflaw.token, CONSTRAINT FKiiyr9nhulmfrvje08nvravy02 FOREIGN KEY (user_id) REFERENCES user (user_id))] [delete from AuthInfo where auth_info_id=?]; SQL [delete from AuthInfo where auth_info_id=?]; constraint [null]]
에러 발생
token이랑 user_id간의 제약조건으로 발생하는 문제라고 생각됨.
그런데 AuthInfo 엔티티 제거시에 해당 문제가 발생하고 있는데 좀더 살펴봐야할 것 같음.
1. 내용
회원탈퇴 api 호출 시, 2024-05-23T16:30:29.451+09:00 WARN 20304 --- [nio-8080-exec-8] .m.m.a.ExceptionHandlerExceptionResolver : Resolved [org.springframework.dao.DataIntegrityViolationException: could not execute statement [Cannot delete or update a parent row: a foreign key constraint fails (
cloneoflaw
.token
, CONSTRAINTFKiiyr9nhulmfrvje08nvravy02
FOREIGN KEY (user_id
) REFERENCESuser
(user_id
))] [delete from AuthInfo where auth_info_id=?]; SQL [delete from AuthInfo where auth_info_id=?]; constraint [null]] 에러 발생 token이랑 user_id간의 제약조건으로 발생하는 문제라고 생각됨. 그런데 AuthInfo 엔티티 제거시에 해당 문제가 발생하고 있는데 좀더 살펴봐야할 것 같음.