[Spring] Transaction 0.0.0.0.tm169085777393700001 has timed out and will rollback.

Transaction 0.0.0.0.tm169085777393700001 has timed out and will rollback.

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.transaction.UnexpectedRollbackException: JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is javax.transaction.RollbackException: One or more resources refused to commit (possibly because of a timeout in the resource - see the log for details). This transaction has been rolled back instead.] with root cause
com.atomikos.icatch.RollbackException: One or more resources refused to commit (possibly because of a timeout in the resource - see the log for details). This transaction has been rolled back instead.
	at com.atomikos.icatch.imp.ActiveStateHandler.prepare(ActiveStateHandler.java:202)
	at com.atomikos.icatch.imp.CoordinatorImp.prepare(CoordinatorImp.java:523)
	at com.atomikos.icatch.imp.CoordinatorImp.terminate(CoordinatorImp.java:687)
	at com.atomikos.icatch.imp.CompositeTransactionImp.commit(CompositeTransactionImp.java:282)
	at com.atomikos.icatch.jta.TransactionImp.commit(TransactionImp.java:172)
	at com.atomikos.icatch.jta.TransactionManagerImp.commit(TransactionManagerImp.java:414)
	at com.atomikos.icatch.jta.UserTransactionImp.commit(UserTransactionImp.java:86)
	at org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransactionManager.java:1035)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:654)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:407)

atomikos 대량 ROW insert시 에러 발생

 

com.atomikos.icatch.default_jta_timeout=1000000

jta.properties 파일에 위 내용 추가

 

값은 적당히 바꿔서 사용