This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new b7449a23bdb Remove Fix me (#33314)
b7449a23bdb is described below
commit b7449a23bdb2ae7ff9b0f46fcc0fb8548b916ce3
Author: zhaojinchao <[email protected]>
AuthorDate: Sun Oct 27 18:47:17 2024 +0800
Remove Fix me (#33314)
* Remove Fix me
* Adjustment maxPoolSize and minPoolSize
* Fix ci
* Fix ci
* Fix ci
---
.github/workflows/e2e-sql.yml | 4 +-
.github/workflows/nightly-e2e-sql-dynamic.yml | 2 -
.github/workflows/nightly-e2e-sql.yml | 4 +-
.../mysql/show_storage_units.xml | 40 +++++------
.../opengauss/show_storage_units.xml | 40 +++++------
.../postgresql/show_storage_units.xml | 40 +++++------
.../database-dbtbl-with-readwrite-splitting.yaml | 80 +++++++++++-----------
.../database-dbtbl-with-readwrite-splitting.yaml | 80 +++++++++++-----------
.../database-dbtbl-with-readwrite-splitting.yaml | 80 +++++++++++-----------
9 files changed, 182 insertions(+), 188 deletions(-)
diff --git a/.github/workflows/e2e-sql.yml b/.github/workflows/e2e-sql.yml
index 0c9660207e9..1a1c96daf59 100644
--- a/.github/workflows/e2e-sql.yml
+++ b/.github/workflows/e2e-sql.yml
@@ -92,9 +92,7 @@ jobs:
adapter: [ proxy, jdbc ]
mode: [ Standalone, Cluster ]
database: [ MySQL, PostgreSQL ]
- # Fix me #25051
- #scenario: [ dbtbl_with_readwrite_splitting,
dbtbl_with_readwrite_splitting_and_encrypt, sharding_and_encrypt,
encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding ]
- scenario: [ empty_rules, distsql_rdl, passthrough, db, tbl, encrypt,
readwrite_splitting, shadow, mask, dbtbl_with_readwrite_splitting_and_encrypt,
sharding_and_encrypt, encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding, db_tbl_sql_federation,
empty_storage_units ]
+ scenario: [ empty_rules, distsql_rdl, passthrough, db, tbl, encrypt,
readwrite_splitting, shadow, mask, dbtbl_with_readwrite_splitting,
dbtbl_with_readwrite_splitting_and_encrypt, sharding_and_encrypt,
encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding, db_tbl_sql_federation,
empty_storage_units ]
additional-options: [ '' ]
include:
- adapter: proxy
diff --git a/.github/workflows/nightly-e2e-sql-dynamic.yml
b/.github/workflows/nightly-e2e-sql-dynamic.yml
index 9c65efd381b..65d78b3f0f6 100644
--- a/.github/workflows/nightly-e2e-sql-dynamic.yml
+++ b/.github/workflows/nightly-e2e-sql-dynamic.yml
@@ -95,8 +95,6 @@ jobs:
adapter: ${{ fromJson(github.event.inputs.adapter) }}
mode: ${{ fromJson(github.event.inputs.mode) }}
database: ${{ fromJson(github.event.inputs.database) }}
- # Fix me #25051
- #scenario: [ dbtbl_with_readwrite_splitting,
dbtbl_with_readwrite_splitting_and_encrypt, sharding_and_encrypt,
encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding ]
scenario: ${{ fromJson(github.event.inputs.scenario) }}
additional-options: ${{
fromJson(github.event.inputs.additional-options) }}
include:
diff --git a/.github/workflows/nightly-e2e-sql.yml
b/.github/workflows/nightly-e2e-sql.yml
index 144294a7e3d..36463a1d0b8 100644
--- a/.github/workflows/nightly-e2e-sql.yml
+++ b/.github/workflows/nightly-e2e-sql.yml
@@ -76,9 +76,7 @@ jobs:
adapter: [ proxy, jdbc ]
mode: [ Standalone, Cluster ]
database: [ MySQL, PostgreSQL, openGauss ]
- # Fix me #25051
- #scenario: [ dbtbl_with_readwrite_splitting,
dbtbl_with_readwrite_splitting_and_encrypt, sharding_and_encrypt,
encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding ]
- scenario: [ empty_rules, distsql_rdl, passthrough, db, tbl, encrypt,
readwrite_splitting, shadow, mask, dbtbl_with_readwrite_splitting_and_encrypt,
sharding_and_encrypt, encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding, db_tbl_sql_federation,
empty_storage_units ]
+ scenario: [ empty_rules, distsql_rdl, passthrough, db, tbl, encrypt,
readwrite_splitting, shadow, mask, dbtbl_with_readwrite_splitting,
dbtbl_with_readwrite_splitting_and_encrypt, sharding_and_encrypt,
encrypt_and_readwrite_splitting, encrypt_shadow,
readwrite_splitting_and_shadow, sharding_and_shadow, sharding_encrypt_shadow,
mask_encrypt, mask_sharding, mask_encrypt_sharding, db_tbl_sql_federation,
empty_storage_units ]
additional-options: [ '' ]
include:
- adapter: proxy
diff --git
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_storage_units.xml
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_storage_units.xml
index d7565347670..bd8350b1c11 100644
---
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_storage_units.xml
+++
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/mysql/show_storage_units.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_0| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_1| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_2| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_3| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_4| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_5| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_6| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_7| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_8| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_9| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
- <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_0| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_1| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_2| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_3| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_4| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_5| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_6| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_7| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_8| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
- <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_9| 30000| 60000| 1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"
[...]
+ <row values="write_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_0| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_1| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_2| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_3| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_4| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_5| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_6| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_7| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_8| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="write_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| write_ds_9| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&
[...]
+ <row values="read_ds_0| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_0| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_1| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_1| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_2| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_2| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_3| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_3| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_4| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_4| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_5| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_5| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_6| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_6| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_7| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_7| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_8| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_8| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
+ <row values="read_ds_9| MySQL| mysql.dbtbl_with_readwrite_splitting.host|
3306| read_ds_9| 30000| 60000| 1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,&qu
[...]
</dataset>
diff --git
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/opengauss/show_storage_units.xml
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/opengauss/show_storage_units.xml
index f737a5ffb28..0c869370247 100644
---
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/opengauss/show_storage_units.xml
+++
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/opengauss/show_storage_units.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds_0| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_1| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_2| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_3| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_4| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_5| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_6| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_7| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_8| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="write_ds_9| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_0| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_1| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_2| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_3| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_4| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_5| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_6| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_7| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_8| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
- <row values="read_ds_9| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true&#
[...]
+ <row values="write_ds_0| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_1| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_2| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_3| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_4| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_5| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_6| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_7| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_8| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="write_ds_9| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
+ <row values="read_ds_0| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_1| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_2| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_3| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_4| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_5| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_6| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_7| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_8| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="read_ds_9| openGauss|
opengauss.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000|
1800000| 20| 10| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
</dataset>
diff --git
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_storage_units.xml
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_storage_units.xml
index a136509dc4a..6c4917659ba 100644
---
a/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_storage_units.xml
+++
b/test/e2e/sql/src/test/resources/cases/rql/dataset/dbtbl_with_readwrite_splitting/postgresql/show_storage_units.xml
@@ -30,24 +30,24 @@
<column name="read_only" />
<column name="other_attributes" />
</metadata>
- <row values="write_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="write_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tr
[...]
- <row values="read_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
- <row values="read_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000|
1800000| 2| 2| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true
[...]
+ <row values="write_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_0| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_1| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_2| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_3| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_4| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_5| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_6| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_7| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_8| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="write_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| write_ds_9| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":t
[...]
+ <row values="read_ds_0| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_0| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_1| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_1| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_2| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_2| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_3| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_3| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_4| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_4| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_5| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_5| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_6| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_6| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_7| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_7| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_8| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_8| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
+ <row values="read_ds_9| PostgreSQL|
postgresql.dbtbl_with_readwrite_splitting.host| 5432| read_ds_9| 30000| 60000|
1800000| 10| 5| false|
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":tru
[...]
</dataset>
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/database-dbtbl-with-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/database-dbtbl-with-readwrite-splitting.yaml
index d0aedfb5858..cd3709530b7 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/database-dbtbl-with-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/mysql/database-dbtbl-with-readwrite-splitting.yaml
@@ -25,8 +25,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -34,8 +34,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -43,8 +43,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -52,8 +52,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -61,8 +61,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -70,8 +70,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -79,8 +79,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -88,8 +88,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -97,8 +97,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/write_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -106,8 +106,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_0:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_0?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -115,8 +115,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_1:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_1?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -124,8 +124,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_2:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_2?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -133,8 +133,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_3:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_3?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -142,8 +142,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_4:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_4?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -151,8 +151,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_5:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_5?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -160,8 +160,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_6:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_6?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -169,8 +169,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_7:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_7?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -178,8 +178,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_8:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_8?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -187,8 +187,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_9:
url:
jdbc:mysql://mysql.dbtbl_with_readwrite_splitting.host:3306/read_ds_9?useSSL=false&characterEncoding=utf-8
username: test_user
@@ -196,8 +196,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
rules:
- !SINGLE
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/opengauss/database-dbtbl-with-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/opengauss/database-dbtbl-with-readwrite-splitting.yaml
index 6c47f328930..4b4f1417fa4 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/opengauss/database-dbtbl-with-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/opengauss/database-dbtbl-with-readwrite-splitting.yaml
@@ -25,8 +25,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_1:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_1
username: test_user
@@ -34,8 +34,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_2:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_2
username: test_user
@@ -43,8 +43,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_3:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_3
username: test_user
@@ -52,8 +52,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_4:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_4
username: test_user
@@ -61,8 +61,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_5:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_5
username: test_user
@@ -70,8 +70,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_6:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_6
username: test_user
@@ -79,8 +79,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_7:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_7
username: test_user
@@ -88,8 +88,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_8:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_8
username: test_user
@@ -97,8 +97,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
write_ds_9:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/write_ds_9
username: test_user
@@ -106,8 +106,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_0:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_0
username: test_user
@@ -115,8 +115,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_1:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_1
username: test_user
@@ -124,8 +124,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_2:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_2
username: test_user
@@ -133,8 +133,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_3:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_3
username: test_user
@@ -142,8 +142,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_4:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_4
username: test_user
@@ -151,8 +151,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_5:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_5
username: test_user
@@ -160,8 +160,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_6:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_6
username: test_user
@@ -169,8 +169,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_7:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_7
username: test_user
@@ -178,8 +178,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_8:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_8
username: test_user
@@ -187,8 +187,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
read_ds_9:
url:
jdbc:opengauss://opengauss.dbtbl_with_readwrite_splitting.host:5432/read_ds_9
username: test_user
@@ -196,8 +196,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 20
+ minPoolSize: 10
rules:
- !SINGLE
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/database-dbtbl-with-readwrite-splitting.yaml
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/database-dbtbl-with-readwrite-splitting.yaml
index c53e0bc01b8..5e2ae3c082b 100644
---
a/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/database-dbtbl-with-readwrite-splitting.yaml
+++
b/test/e2e/sql/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/proxy/conf/postgresql/database-dbtbl-with-readwrite-splitting.yaml
@@ -25,8 +25,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_1
username: test_user
@@ -34,8 +34,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_2
username: test_user
@@ -43,8 +43,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_3
username: test_user
@@ -52,8 +52,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_4
username: test_user
@@ -61,8 +61,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_5
username: test_user
@@ -70,8 +70,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_6
username: test_user
@@ -79,8 +79,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_7
username: test_user
@@ -88,8 +88,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_8
username: test_user
@@ -97,8 +97,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
write_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/write_ds_9
username: test_user
@@ -106,8 +106,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_0:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_0
username: test_user
@@ -115,8 +115,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_1:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_1
username: test_user
@@ -124,8 +124,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_2:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_2
username: test_user
@@ -133,8 +133,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_3:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_3
username: test_user
@@ -142,8 +142,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_4:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_4
username: test_user
@@ -151,8 +151,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_5:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_5
username: test_user
@@ -160,8 +160,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_6:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_6
username: test_user
@@ -169,8 +169,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_7:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_7
username: test_user
@@ -178,8 +178,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_8:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_8
username: test_user
@@ -187,8 +187,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
read_ds_9:
url:
jdbc:postgresql://postgresql.dbtbl_with_readwrite_splitting.host:5432/read_ds_9
username: test_user
@@ -196,8 +196,8 @@ dataSources:
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
- maxPoolSize: 2
- minPoolSize: 2
+ maxPoolSize: 10
+ minPoolSize: 5
rules:
- !SINGLE
