search

swyp3-babpool / babpool-backend

🏆 스위프 3기 1위 수상
https://bab-pool.com
MIT License
1 stars 0 forks source link

Hotfix/pro hyundo #139

Closed proHyundo closed 7 months ago

proHyundo commented 7 months ago

Resolves #{이슈-번호}

Issue Define

image

2024-03-16T09:38:57.749+09:00  INFO 1 --- [nio-9090-exec-5] c.s.b.d.p.a.ProfileServiceImpl           : ProfileServiceImpl.updatePossibleDateTime, 가능한 날짜와 시간 삭제 중 오류 발생.
### Error updating database.  Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`babpool_dev_db`.`t_appointment_request_time`, CONSTRAINT `t_appointment_request_time_t_possible_time_possible_time_id_fk` FOREIGN KEY (`possible_time_id`) REFERENCES `t_possible_time` (`possi)
### The error may exist in class path resource [mapper/PossibleDateTimeMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: DELETE FROM t_possible_time         WHERE possible_date_id = ?           and possible_time_id = ?
### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`babpool_dev_db`.`t_appointment_request_time`, CONSTRAINT `t_appointment_request_time_t_possible_time_possible_time_id_fk` FOREIGN KEY (`possible_time_id`) REFERENCES `t_possible_time` (`possi)
; Cannot delete or update a parent row: a foreign key constraint fails (`babpool_dev_db`.`t_appointment_request_time`, CONSTRAINT `t_appointment_request_time_t_possible_time_possible_time_id_fk` FOREIGN KEY (`possible_time_id`) REFERENCES `t_possible_time` (`possi)
2024-03-16T09:38:57.749+09:00  INFO 1 --- [nio-9090-exec-5] c.s.b.d.p.a.ProfileServiceImpl           : 참조키 오류 발생 : PossibleDateAndTime(possibleDateId=165, possibleDate=2024-03-23, possibleTimeIdList=[296, 297, 298], possibleTimeList=[13, 14, 18])
2024-03-16T09:38:57.762+09:00 ERROR 1 --- [nio-9090-exec-5] c.s.b.d.p.e.h.ProfileExceptionHandler    : ProfileException getProfileErrorCode() >> PROFILE_POSSIBLE_DATE_ERROR
2024-03-16T09:38:57.762+09:00 ERROR 1 --- [nio-9090-exec-5] c.s.b.d.p.e.h.ProfileExceptionHandler    : ProfileException getMessage() >> 가능한 날짜와 시간 삭제 중 오류가 발생했습니다.

Summary of resolutions or improvements

Note

RCA Rule

r: 꼭 반영해 주세요. 적극적으로 고려해 주세요. (Request changes)
c: 웬만하면 반영해 주세요. (Comment)
a: 반영해도 좋고 넘어가도 좋습니다. 그냥 사소한 의견입니다. (Approve)