You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/20 08:03:35 UTC

[GitHub] [shardingsphere] zhoubonet opened a new issue #10138: Transaction not rolled back

zhoubonet opened a new issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138


   Transaction not rolled back
   
   ### Which version of ShardingSphere did you use?
   5.0
   ![image](https://user-images.githubusercontent.com/4209701/115360087-dfde2500-a1f1-11eb-8de5-409647869318.png)
   ![image](https://user-images.githubusercontent.com/4209701/115360131-ec627d80-a1f1-11eb-8467-dac1155381d3.png)
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823737269


   http-> controller->service


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-855162965


   1 、database script  src/main/resources/data.sql
   2、database connect  src/main/resources/application.properties
   3、connect object initialize src/main/java/com/dudu/config/ShardingConfiguration.java
   4、Interface test  http://localhost:8090/learn/test
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823726506


   OK, where  is the `add` method invoked?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-824625175


   <dependency>
       <groupId>org.apache.shardingsphere</groupId>
       <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
       <version>${shardingsphere.version}</version>
   </dependency>
   
   I don't rely on this library
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823138532


   Hi @zhoubonet 
   Could you provide your sharding configuration and transaction code?  Because there are so many ways to make transaction fail


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823736989


    controller invoked
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823706243


   java configuration
   ![image](https://user-images.githubusercontent.com/4209701/115483087-b0c3c400-a282-11eb-9a1f-1069555e5837.png)
   shardingRuleConfig not  configuration
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823750691


   Hi @zhoubonet 
   I did not see your transaction configuration, are you using sping boot starter? 
   We should config  the  `TransactionManager`  and use  `@ShardingTransactionType` annotation.
   
   please see https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/transaction/spring-boot-starter/


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet closed issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet closed issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-861997406


   @RaigorJiang Will you have time to look at this problem


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-833157578


   existence


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-826234958


   Hi @zhoubonet , is this problem still exists?
   By default, ShardingSphere will affect local transactions, I can't tell more based on the information, sorry.
   Could you please provide a demo project on github?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-862005200


   @zhoubonet  Yes!  I reproduced this exception yesterday, and I am looking for the cause. 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-824624446


   I use Druid datasource transaction is OK


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823704760


   1、The configuration uses Java code
   2、
   ![image](https://user-images.githubusercontent.com/4209701/115482740-ef0cb380-a281-11eb-9825-9c2c40569cfe.png)
   3、Transaction 4.0 is ok
   4、class configuration
   ![image](https://user-images.githubusercontent.com/4209701/115482819-1cf1f800-a282-11eb-864b-8137fb2af750.png)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-839384814


   > existence
   
   Sorry to hear that. But the information is not enough, I can't reproduce it. 
   Maybe somebody else can help.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-863664398


   ok


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-824655931


   Data write exception, not thrown


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang edited a comment on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang edited a comment on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-823750691


   Hi @zhoubonet 
   I did not see your transaction configuration, are you using spring boot starter? 
   We should config  the  `TransactionManager`  and use  `@ShardingTransactionType` annotation.
   
   please see https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/transaction/spring-boot-starter/


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-856527882


   What's the result of the example test


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zhoubonet commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
zhoubonet commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-855159369


   test demo 
   https://gitee.com/lhur/sharding-demo.git


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] RaigorJiang commented on issue #10138: Transaction not rolled back

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #10138:
URL: https://github.com/apache/shardingsphere/issues/10138#issuecomment-826234958


   Hi @zhoubonet , is this problem still exists?
   By default, ShardingSphere will affect local transactions, I can't tell more based on the information, sorry.
   Could you please provide a demo project on github?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org