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


--
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

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、

3、Transaction 4.0 is ok
4、class 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-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