spring boot test에서 repository test에서 롤백 안됨

Question

안녕하세요!!개발 공부중인 학생입니다스프링 부트로 개발 도중에 레포지토리 테스트를 작성했습니다해당 테스트의 테스트 메서드를 하나씩 실행하면 성공하는데전체 실행하면 테스트를 실패하더라고요테스트 독립성이 보장되지 않은 것이 문제로 추정되어 테스트 메서드 시작전에 db에 데이터가 있는지 출력을 해보니 테스트 메서드들이 종료된뒤 데이터가 롤백이 되지 않고 계속 쌓여서 테스트가 실패하게 되더라고요테스트 코드에서 @Transaction 을 사용하면 테스트 이후 롤백이 되는 것으로 알고있고 마지막에 롤백이 성공했다고 로그도 찍히지만 롤백이 되지 않았더라고요혹시 어떤 원인으로 롤백이 안되고 있는지 알려주시면 정말 감사드리겠습니다첫번째로 실행된 메서드는 데이터가 없는 상태에서 실행되어 성공하였지만그 다음 메서드는 데이터가 아래처럼 남아있는 상태로 실행되어 실패하였습니다...각 메서드 마지막에 아래처럼 롤백 관련 로그가 찍히지만 롤백이 되지 않고 있습니다.2022-10-04 11:05:48.650 INFO 30932 --- [ Test worker] o.s.t.c.transaction.TransactionContext : Rolled back transaction for test: [DefaultTestContext@15deb1dc testClass = ProblemRepositoryTest.FindUnsolvedProblemByTeamIdAndTier, testInstance = com.unsolvedwa.unsolvedwa.domain.problem.ProblemRepositoryTest$FindUnsolvedProblemByTeamIdAndTier@54d116d5, testMethod = success@ProblemRepositoryTest.FindUnsolvedProblemByTeamIdAndTier, testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@6e9c413e testClass = ProblemRepositoryTest.FindUnsolvedProblemByTeamIdAndTier, locations = '{}', classes = '{class com.unsolvedwa.unsolvedwa.UnsolvedWaApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.autoconfigure.actuate.metrics.MetricsExportContextCustomizerFactory$DisableMetricExportContextCustomizer@52045dbe, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@45efc20d, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@2a3c96e3, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@cb191ca, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.web.client.TestRestTemplateContextCustomizer@75d0911a, org.springframework.boot.test.context.SpringBootTestArgs@1, org.springframework.boot.test.context.SpringBootTestWebEnvironment@34129c78], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]], attributes = map['org.springframework.test.context.web.ServletTestExecutionListener.activateListener' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.populatedRequestContextHolder' -> true, 'org.springframework.test.context.web.ServletTestExecutionListener.resetRequestContextHolder' -> true, 'org.springframework.test.context.event.ApplicationEventsTestExecutionListener.recordApplicationEvents' -> false]] 아래는 테스트 코드입니다.package com.unsolvedwa.unsolvedwa.domain.problem; import com.unsolvedwa.unsolvedwa.domain.problem.dto.ProblemResponseDto; import com.unsolvedwa.unsolvedwa.domain.problemteam.ProblemTeam; import com.unsolvedwa.unsolvedwa.domain.problemteam.ProblemTeamRepository; import com.unsolvedwa.unsolvedwa.domain.team.Team; import com.unsolvedwa.unsolvedwa.domain.team.TeamRepository; import com.unsolvedwa.unsolvedwa.domain.user.User; import com.unsolvedwa.unsolvedwa.domain.user.UserRepository; import com.unsolvedwa.unsolvedwa.domain.userteam.UserTeam; import com.unsolvedwa.unsolvedwa.domain.userteam.UserTeamRepository; import java.util.List; import org.assertj.core.api.Assertions; import org.junit.jupiter.api.Nested; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.data.crossstore.ChangeSetPersister.NotFoundException; import org.springframework.test.annotation.Rollback; import org.springframework.transaction.annotation.Transactional; @SpringBootTest @Transactional @Rollback public class ProblemRepositoryTest { @Autowired ProblemRepository problemRepository; @Autowired TeamRepository teamRepository; @Autowired UserRepository userRepository; @Autowired UserTeamRepository userTeamRepository; @Autowired ProblemTeamRepository problemTeamRepository; @Autowired ProblemService problemService; @Nested @Transactional @Rollback class FindUnsolvedProblemByTeamIdAndTier{ List users; List teams; List problems; @Transactional @Rollback public void setTestData(Long numOfProblems, Long numOfTeams, Long numOfUsers, Long numOfSolvedProblemByEachUser, Long tier) { for (int i = 0; i < numOfUsers; i++) { User user = new User("user"+ (i + 1)); userRepository.save(user); } users = userRepository.findAll(); for (int i = 0; i < numOfTeams; i++) { Team team = new Team("team" + (i + 1)); teamRepository.save(team); } teams = teamRepository.findAll(); for (int i = 0; i < numOfTeams; i++) { for (int j = 0; j < numOfUsers - i; j++) { UserTeam userTeam = new UserTeam(teams.get(i), users.get(j)); userTeamRepository.save(userTeam); } } for (int i = 0; i < numOfProblems; i++) { Problem problem = new Problem(0L + i, "problem" + i, tier); problem = problemRepository.save(problem); } problems = problemRepository.findAll(); for (int i = 0; i < numOfProblems && numOfSolvedProblemByEachUser > 0; i++) { if (i/numOfSolvedProblemByEachUser.intValue() >= numOfUsers){ break; } Problem problem = problems.get(i); User solvingUser = users.get(i/numOfSolvedProblemByEachUser.intValue()); try { problemService.solveProblem(solvingUser.getId(), problem.getProblemNumber()); } catch (NotFoundException notFoundException) { } } } public void show_empty(){ users = userRepository.findAll(); teams = teamRepository.findAll(); List userTeams = userTeamRepository.findAll(); problems = problemRepository.findAll(); List problemTeams = problemTeamRepository.findAll(); System.out.println("users.size() = " + users.size()); System.out.println("teams.size() = " + teams.size()); System.out.println("userTeams.size() = " + userTeams.size()); System.out.println("problems.size() = " + problems.size()); System.out.println("problemTeams = " + problemTeams.size()); } //문제 10문제 //팀 5개 //유저 5명 // 팀 1 유저 5명, 팀 2 유저 4명, 팀 3 유저 3명, 팀 4 유저 2명, 팀 5 유저 1명 //유저들이 각 1문제씩 총 5문제 품 //기대 리턴 : 팀 1 안푼 문제 5, 팀 2 안푼 문제 6, 팀 3 안푼 문제 7, 팀 4 안푼 문제 8, 팀 5 안푼 문제 9 @Test @Transactional @Rollback public void success() throws Exception { show_empty(); //given Long numOfProblems = 10L; Long numOfTeams = 5L; Long numOfUsers = 5L; Long numOfSolvedProblemByEachUser = 1L; Long tier = 1L; setTestData(numOfProblems, numOfTeams, numOfUsers, numOfSolvedProblemByEachUser, tier); //when // then for (int i = 0; i < numOfTeams; i++) { List unsolvedProblemResponseDtoList = problemRepository.findUnsolvedProblemsByTeamAndTier(teams.get(i).getId(), tier); Long curNumOfUnsolvedProblem = numOfProblems - numOfTeams * numOfSolvedProblemByEachUser + i * numOfSolvedProblemByEachUser; for (int j = 0; j < unsolvedProblemResponseDtoList.size(); j++){ ProblemResponseDto temp = unsolvedProblemResponseDtoList.get(j); System.out.println("temp.getProblemId() = " + temp.getProblemId()); } Assertions.assertThat(unsolvedProblemResponseDtoList).hasSize(curNumOfUnsolvedProblem.intValue()); } } @Test @Transactional @Rollback public void zeroSolve() throws Exception { show_empty(); //given Long numOfProblems = 10L; Long numOfTeams = 5L; Long numOfUsers = 5L; Long numOfSolvedProblemByEachUser = 0L; Long tier = 1L; setTestData(numOfProblems, numOfTeams, numOfUsers, numOfSolvedProblemByEachUser, tier); //when // then for (int i = 0; i < numOfTeams; i++) { List unsolvedProblemResponseDtoList = problemRepository.findUnsolvedProblemsByTeamAndTier(teams.get(i).getId(), tier); Long curNumOfUnsolvedProblem = numOfProblems - numOfTeams * numOfSolvedProblemByEachUser + i * numOfSolvedProblemByEachUser; Assertions.assertThat(unsolvedProblemResponseDtoList).hasSize(curNumOfUnsolvedProblem.intValue()); } } @Test @Transactional @Rollback public void team1AllSolve() throws Exception { show_empty(); //given Long numOfProblems = 10L; Long numOfTeams = 5L; Long numOfUsers = 5L; Long numOfSolvedProblemByEachUser = 2L; Long tier = 1L; setTestData(numOfProblems, numOfTeams, numOfUsers, numOfSolvedProblemByEachUser, tier); //when // then for (int i = 0; i < numOfTeams; i++) { List unsolvedProblemResponseDtoList = problemRepository.findUnsolvedProblemsByTeamAndTier(teams.get(i).getId(), tier); Long curNumOfUnsolvedProblem = numOfProblems - numOfTeams * numOfSolvedProblemByEachUser + i * numOfSolvedProblemByEachUser; Assertions.assertThat(unsolvedProblemResponseDtoList).hasSize(curNumOfUnsolvedProblem.intValue()); } } @Test @Transactional @Rollback public void zeroUser() throws Exception { show_empty(); //given Long numOfProblems = 10L; Long numOfTeams = 5L; Long numOfUsers = 0L; Long numOfSolvedProblemByEachUser = 0L; Long tier = 1L; setTestData(numOfProblems, numOfTeams, numOfUsers, numOfSolvedProblemByEachUser, tier); //when // then for (int i = 0; i < numOfTeams; i++) { List unsolvedProblemResponseDtoList = problemRepository.findUnsolvedProblemsByTeamAndTier(teams.get(i).getId(), tier); Long curNumOfUnsolvedProblem = numOfProblems - numOfTeams * numOfSolvedProblemByEachUser + i * numOfSolvedProblemByEachUser; Assertions.assertThat(unsolvedProblemResponseDtoList).hasSize(curNumOfUnsolvedProblem.intValue()); } } @Test @Transactional @Rollback public void zeroProblem() throws Exception { show_empty(); //given Long numOfProblems = 0L; Long numOfTeams = 5L; Long numOfUsers = 5L; Long numOfSolvedProblemByEachUser = 0L; Long tier = 1L; setTestData(numOfProblems, numOfTeams, numOfUsers, numOfSolvedProblemByEachUser, tier); //when // then for (int i = 0; i < numOfTeams; i++) { List unsolvedProblemResponseDtoList = problemRepository.findUnsolvedProblemsByTeamAndTier(teams.get(i).getId(), tier); Long curNumOfUnsolvedProblem = numOfProblems - numOfTeams * numOfSolvedProblemByEachUser + i * numOfSolvedProblemByEachUser; Assertions.assertThat(unsolvedProblemResponseDtoList).hasSize(curNumOfUnsolvedProblem.intValue()); } } } }

Ruamin · Accepted Answer

&#64;AfterEach 를 사용해보시기바랍니다.https://velog.io/&#64;dbal9357/%ED%85%8C%EC%8A%A4%ED%8A%B8%EC%BC%80%EC%9D%B4%EC%8A%A4-%EC%9E%91%EC%84%B1%EC%8B%9C-AfterEach-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0

SeNalUk · Answer

좀 오래된 일이고 해결도 되신듯 하지만 비슷한 상황이셨던 것 같으니 https://senaluk.tistory.com/4 제가 정리한 글인데 한번 보시면 도움되실지도..

spring boot test에서 repository test에서 롤백 안됨

2개의 답변

#rollback 목록