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 2022/06/29 06:38:50 UTC

[GitHub] [shardingsphere] git-chenhao opened a new issue, #18684: JDBCBackendConnection:proxy-db connection no rollback when application-proxy connection is closed

git-chenhao opened a new issue, #18684:
URL: https://github.com/apache/shardingsphere/issues/18684

   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
    5.1.0
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   transaction rollback(proxy-db) when connection ( application-proxy) is closed
    
   ### Actual behavior
   transaction no rollback(proxy-db) when connection ( application-proxy) is closed
   
   ### Reason analyze (If you can)
   
   ![image](https://user-images.githubusercontent.com/20919316/176368125-9b7c3595-f0f1-4534-bdcb-ff44acbcc4de.png)
   
   When the above figure is executed to step 4-6, the disconnection of the upstream connection triggers the channelInactive method of Netty. At this time, the resources in the JDBCBackendConnection are still empty. Because step 7 has not been started, the subsequent step 7 is executed after the resources are cleaned up, and the subsequent connection will remain there.
   
   


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


[GitHub] [shardingsphere] TeslaCN commented on issue #18684: JDBCBackendConnection:proxy-db connection no rollback when application-proxy connection is closed

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

   Is it duplicated with https://github.com/apache/shardingsphere/issues/18634?
   Step 7 is finished after channel inactive.


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


[GitHub] [shardingsphere] git-chenhao commented on issue #18684: JDBCBackendConnection:proxy-db connection no rollback when application-proxy connection is closed

Posted by GitBox <gi...@apache.org>.
git-chenhao commented on issue #18684:
URL: https://github.com/apache/shardingsphere/issues/18684#issuecomment-1169613086

   > Is it duplicated with [https://github.com/apache/shardingsphere/issues/18634?](https://github.com/apache/shardingsphere/issues/18634%EF%BC%9F) Step 7 is finished after channel inactive, which may cause this issue.
   
   thanks,same question~


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


[GitHub] [shardingsphere] TeslaCN closed issue #18684: JDBCBackendConnection:proxy-db connection no rollback when application-proxy connection is closed

Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #18684: JDBCBackendConnection:proxy-db connection no rollback when application-proxy connection  is closed
URL: https://github.com/apache/shardingsphere/issues/18684


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