You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "chenqi14 (via GitHub)" <gi...@apache.org> on 2024/07/19 07:36:05 UTC

[I] executeBatch not support xa transaction [shardingsphere]

chenqi14 opened a new issue, #32187:
URL: https://github.com/apache/shardingsphere/issues/32187

   ## Bug Report
   
   sharding  version : 5.4.0
   
   scene : I opened  xa transaction and  executed executeBatch  sql, but xa failed。
   
   cause:  ShardingSpherePreparedStatement.executeBatch
   <img width="955" alt="image" src="https://github.com/user-attachments/assets/6734bee3-8d1b-4470-8f9d-65d0bdebe688">
   
   
   


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2241162157

   What is the exception or behavior?


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2257437061

   What is the frequency of this issue occurring, does it require high concurrency or does it happen frequently?
   What is the cause of the SQL execute failure, is there a detail of error message?


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2327969250

   @comecny Welcome, I just assign this issue to you.


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "chenqi14 (via GitHub)" <gi...@apache.org>.
chenqi14 commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2295892464

   必现的,如果是广播表插入数据,如果有一个实例uk冲突导致失败,那么只有这一个实例插入失败了,其他的实例插入成功。没有回滚。原因是executeBatch逻辑就是一个并行插入的逻辑,没有做事务控制


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "chenqi14 (via GitHub)" <gi...@apache.org>.
chenqi14 commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2270299456

   没有报错,是必现的,executebatch逻辑开xa和不开xa执行逻辑都是一样的


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "comecny (via GitHub)" <gi...@apache.org>.
comecny commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2327941318

   hi  @terrymanu ,  could you assign this issue to me ?


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "comecny (via GitHub)" <gi...@apache.org>.
comecny commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2329826702

    hi  @chenqi14 , Provide more information, configuration details, or code usage examples


-- 
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] executeBatch not support xa transaction [shardingsphere]

Posted by "chenqi14 (via GitHub)" <gi...@apache.org>.
chenqi14 commented on issue #32187:
URL: https://github.com/apache/shardingsphere/issues/32187#issuecomment-2257351633

   When some instances sql failed, all instances should be rolled back, but there is not, some insertions succeed and some 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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