Transaction marked as rollback only How do I find the cause

Question

I am having issues with committing a transaction within my  Transactional method   methodA         methodB       Transactional methodB                 em persist                em flush        log  OK        When I call methodB   from methodA    the method passes successfuly and I can see  OK  in my logs  But then I get   Could not commit JPA transaction  nested exception is javax persistence RollbackException  Transaction marked as rollbackOnly org springframework transaction TransactionSystemException  Could not commit JPA transaction  nested exception is javax persistence RollbackException  Transaction marked as rollbackOnly     at org springframework orm jpa JpaTransactionManager doCommit JpaTransactionManager java 521      at org springframework transaction support AbstractPlatformTransactionManager processCommit AbstractPlatformTransactionManager java 754      at org springframework transaction support AbstractPlatformTransactionManager commit AbstractPlatformTransactionManager java 723      at org springframework transaction interceptor TransactionAspectSupport commitTransactionAfterReturning TransactionAspectSupport java 393      at org springframework transaction interceptor TransactionInterceptor invoke TransactionInterceptor java 120      at org springframework aop framework ReflectiveMethodInvocation proceed ReflectiveMethodInvocation java 172      at org springframework aop framework Cglib2AopProxy DynamicAdvisedInterceptor intercept Cglib2AopProxy java 622      at methodA         The context of methodB is completely missing in the exception - which is okay I suppose  Something within the methodB   marked the transaction as rollback only  How can I find it out  Is there for instance a way to check something like getCurrentTransaction   isRollbackOnly    - like this I could step through the method and find the cause

User · Answer

I struggled with this exception while running my application   Finally the problem was on the sql query  i mean that the query is wrong    please verify your query  This is my suggestion

User · Answer

Found a good explanation with solutions  https   vcfvct wordpress com 2016 12 15 spring-nested-transactional-rollback-only   1  remove the  Transacional from the nested method if it does not really require transaction control  So even it has exception  it just bubbles up and does not affect transactional stuff   OR   2  if nested method does need transaction control  make it as REQUIRE NEW for the propagation policy that way even if throws exception and marked as rollback only  the caller will not be affected

User · Answer

disable the transactionmanager in your Bean xml   lt tx annotation-driven proxy-target-class  true  transaction-manager  transactionManager   gt       lt bean id  transactionManager          class  org springframework jdbc datasource DataSourceTransactionManager  gt           lt property name  dataSource  ref  dataSource  gt  lt  property gt       lt  bean gt    comment out these lines  and you ll see the exception causing the rollback

User · Answer

When you mark your method as  Transactional  occurrence of any exception inside your method will mark the surrounding TX as roll-back only  even if you catch them   You can use other attributes of  Transactional annotation to prevent it of rolling back like    Transactional rollbackFor MyException class  noRollbackFor MyException2 class

User · Answer

There is always a reason why the nested method roll back  If you don t see the reason  you need to change your logger level to debug  where you will see the more details where transaction failed  I changed my logback xml by adding  lt logger name  quot org springframework transaction quot  level  quot debug quot   gt   lt logger name  quot org springframework orm jpa quot  level  quot debug quot   gt   then I got this line in the log  Participating transaction failed - marking existing transaction as rollback-only  So I just stepped through my code to see where this line is generated and found that there is a catch block which did not throw anything  private Student add Student s            try               Student retval   studentRepository save s               return retval            catch  Exception e                                   return null

User · Answer

Look for exceptions being thrown and caught in the     sections of your code  Runtime and rollbacking application exceptions cause rollback when thrown out of a business method even if caught on some other place   You can use context to find out whether the transaction is marked for rollback    Resource private SessionContext context   context getRollbackOnly

User · Answer

apply the below code in productRepository    Query  update Product set prodName  name where prodId  id          Transactional       Modifying      int  updateMyData  Param  name  String name   Param  id   Integer id    while in junit test apply below code    Test public void updateData       int i productRepository updateMyData  Iphone  102      System out println  successfully updated           assertTrue i  0        it is working fine for my code

User · Answer

I finally understood the problem   methodA         methodB       Transactional noRollbackFor   Exception class  methodB                 try           methodC         catch                 log  OK        Transactional methodC         throw new            What happens is that even though the methodB has the right annotation  the methodC does not  When the exception is thrown  the second  Transactional marks the first transaction as Rollback only anyway

User · Answer

To quickly fetch the causing exception without the need to re-code or rebuild  set a breakpoint on   org hibernate ejb TransactionImpl setRollbackOnly      Hibernate  lt  4 3  or org hibernate jpa internal TransactionImpl      as of Hibernate 4 3   and go up in the stack  usually to some Interceptor  There you can read the causing exception from some catch block

[java] Transaction marked as rollback only: How do I find the cause

Examples related to java

Examples related to spring

Examples related to hibernate

Examples related to jpa

Examples related to transactions