You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "asdf112255 (via GitHub)" <gi...@apache.org> on 2023/10/11 12:04:44 UTC
[I] Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed [shardingsphere]
asdf112255 opened a new issue, #28721:
URL: https://github.com/apache/shardingsphere/issues/28721
## Question
i use shading-proxy +seate with springboot app,
query data is right,
when i update database (insert/update/delete) i got exception below:
### Error updating database. Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454713603026944, errMsg: TransactionException[branch register request failed. xid=172.28.201.95:30095:455454713603026944, msg=Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454714349613056, errMsg: TransactionException[Could not found global transaction xid = 172.28.201.95:30095:455454714349613056, may be has finished.] ] ### The error may exist in jnpf/engine/mapper/FlowTaskMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM flow_task WHERE (F_ID IN (?)) ### Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454713603026944, errMsg: TransactionException[branch
register request failed. xid=172.28.201.95:30095:455454713603026944, msg=Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454714349613056, errMsg: TransactionException[Could not found global transaction xid = 172.28.201.95:30095:455454714349613056, may be has finished.] ] ; uncategorized SQLException; SQL state [HY000]; error code [1815]; Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454713603026944, errMsg: TransactionException[branch register request failed. xid=172.28.201.95:30095:455454713603026944, msg=Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454714349613056, errMsg: TransactionException[Could not found global transaction xid = 172.28.201.95:30095:455454714349613056, may be has finished.] ] ; nested exception is java.sql.SQLException: Internal error: io.seata.core.excep
tion.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454713603026944, errMsg: TransactionException[branch register request failed. xid=172.28.201.95:30095:455454713603026944, msg=Internal error: io.seata.core.exception.RmTransactionException: branch register failed, xid: 172.28.201.95:30095:455454714349613056, errMsg: TransactionException[Could not found global transaction xid = 172.28.201.95:30095:455454714349613056, may be has finished.] ]
do i need any another configuration?
shardingsphere server.conf:
transaction:
defaultType: BASE
providerType: Seata
seata.conf:
client {
application.id = risk
transaction.service.group = my_test_tx_group
}
any suggestion is appreciate!:)
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian commented on issue #28721:
URL: https://github.com/apache/shardingsphere/issues/28721#issuecomment-2010022843
- Closing this issue because it cannot be reproduced.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #28721:
URL: https://github.com/apache/shardingsphere/issues/28721#issuecomment-1806366732
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #28721:
URL: https://github.com/apache/shardingsphere/issues/28721#issuecomment-2008026049
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed [shardingsphere]
Posted by "linghengqian (via GitHub)" <gi...@apache.org>.
linghengqian closed issue #28721: Shardingsphere-proxy + seate update database exception Cause: java.sql.SQLException: Internal error: io.seata.core.exception.RmTransactionException: branch register failed
URL: https://github.com/apache/shardingsphere/issues/28721
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org