wsm12138 opened a new issue, #22081: URL: https://github.com/apache/shardingsphere/issues/22081
## Bug Report **For English only**, other languages will not accept. Before report a bug, make sure you have: - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues). - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview). Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot reproduce it on current information, we will **close it**. Please answer these questions before submitting your issue. Thanks! ### Which version of ShardingSphere did you use? ShardingSphere-5.2.2-SNAPSHOT Commit ID: 1fb8766851700ec17f2d4b2967a63bc42985288c Commit Message: Data consistency check job support breakpoint resume transmission (#22048) Branch: master Build time: 2022-11-11T14:05:03+0800 ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Expected behavior `export database configuration;` contents equal a.yml ### Actual behavior ``` [root@localhost apache-shardingsphere-5.2.2-SNAPSHOT-shardingsphere-proxy-bin]# mysql -uroot -proot -P7777 -hip mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.22-ShardingSphere-Proxy 5.2.2-SNAPSHOT-1fb8766 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> import database CONFIGURATION FROM FILE '/tmp/apache-shardingsphere-5.2.2-SNAPSHOT-shardingsphere-proxy-bin/a.yml'; Query OK, 0 rows affected (0.44 sec) mysql> show databases; +------------------------+ | schema_name | +------------------------+ | information_schema | | performance_schema | | sys | | shardingsphere | | readwrite_splliting_db | | mysql | +------------------------+ 6 rows in set (0.03 sec) mysql> use readwrite_splliting_db Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show databases; +------------------------+ | schema_name | +------------------------+ | information_schema | | performance_schema | | sys | | shardingsphere | | readwrite_splliting_db | | mysql | +------------------------+ 6 rows in set (0.00 sec) mysql> export database configuration; +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | result | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | databaseName: readwrite_splliting_db dataSources: ds_1: password: test@2021 url: jdbc:mysql://192.168.10.20:13306/test?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000 username: root minPoolSize: 1 connectionTimeoutMilliseconds: 30000 maxLifetimeMilliseconds: 1800000 readOnly: false idleTimeoutMilliseconds: 60000 maxPoolSize: 500 ds_0: password: test@2021 url: jdbc:mysql://192.168.10.20:13306/test?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000 username: test minPoolSize: 1 connectionTimeoutMilliseconds: 10000 maxLifetimeMilliseconds: 1800000 readOnly: false idleTimeoutMilliseconds: 60000 maxPoolSize: 500 rules: | +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) ``` ### Reason analyze (If you can) ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. ### Example codes for reproduce this issue (such as a github link). #### a.yml ``` databaseName: readwrite_splliting_db dataSources: ds_0: url: jdbc:mysql://192.168.10.20:13306/test?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000 username: test password: test@2021 connectionTimeoutMilliseconds: 10000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 500 minPoolSize: 1 ds_1: url: jdbc:mysql://192.168.10.20:13306/test?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000 username: root password: test@2021 connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 500 minPoolSize: 1 rules: - !READWRITE_SPLITTING dataSources: readwrite_ds: staticStrategy: writeDataSourceName: ds_0 readDataSourceNames: - ds_1 loadBalancerName: random loadBalancers: random: type: RANDOM ``` -- 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]
