LeeGuoPing commented on pull request #11540:
URL: https://github.com/apache/shardingsphere/pull/11540#issuecomment-893310528
@strongduanmu When I use unit test` GeneralDQLIT assertExecute`. Sometimes,
it has a exception` Connection is not available, request timed out after
30006ms.` Sometimes it run right. I debug the connection pool of H2 , find
H2's max connections is two. Then one connection wait time out, Do you met this
problems before?
```
<test-case sql="SELECT o.*, i.* FROM t_order_federate o,
t_order_item_federate i WHERE o.order_id = ? AND i.item_id = ?"
scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion parameters="1000:int, 100000:int"
expected-data-file="select_across_single_tables_with_federate.xml" />
</test-case>
<test-case sql="select t_order_federate.*,
t_order_item_federate_sharding.* from
t_order_federate,t_order_item_federate_sharding where t_order_federate.order_id
= t_order_item_federate_sharding.item_id"
scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion
expected-data-file="select_sql_by_id_across_single_and_sharding_tables.xml" />
</test-case>
<test-case sql="select t_order_federate.*,
t_order_item_federate_sharding.* from t_order_federate,
t_order_item_federate_sharding where t_order_federate.order_id =
t_order_item_federate_sharding.item_id AND
t_order_item_federate_sharding.order_id = ?"
scenario-types="db,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion parameters="10001:int"
expected-data-file="select_sql_by_id_across_single_and_sharding_tables_order_id.xml"
/>
</test-case>
```
--
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]
