search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.75k stars 6.69k forks source link

There is a deadlock problem in acquiring the connection #21202

Open natehuangting opened 1 year ago

natehuangting commented 1 year ago

Bug Report

Assume that the logical table torder corresponds to ds${0..1}.t_order. The maximum number of connections for both ds_0 and ds_1 is 1. Request 1 has obtained the connection of ds_0, and is ready to request the connection of ds_1. Request 2 has obtained the connection of ds_1, and prepare to acquire the connection of ds_0. This is deadlock

Which version of ShardingSphere did you use?

master

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

TeslaCN commented 1 year ago

@tuichenchuxin I don't think this is a bug. It could be an enhancement.