john1337 commented on issue #37128:
URL: 
https://github.com/apache/shardingsphere/issues/37128#issuecomment-3546140110

   this problem can trace to DriverDatabaseConnectionManager's commit method,
       public void commit() throws SQLException {
           try {
               if (connectionTransaction.isLocalTransaction() && 
connectionTransaction.isRollbackOnly()) {
                   forceExecuteTemplate.execute(cachedConnections.values(), 
Connection::rollback);
               } else if (connectionTransaction.isLocalTransaction()) {
                   forceExecuteTemplate.execute(cachedConnections.values(), 
Connection::commit);
               } else {
                // this will call seata's method,only send seata's commit 
request to seata server,but didn't commit local transactions 
               // like forceExecuteTemplate.execute(cachedConnections.values(), 
Connection::commit);
             // that's where the problem lies
                   connectionTransaction.commit();
               }
           } finally {
               for (Connection each : cachedConnections.values()) {
                   
ConnectionSavepointManager.getInstance().transactionFinished(each);
               }
           }
       }
       


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to