sgc109 opened a new issue #11762: URL: https://github.com/apache/shardingsphere/issues/11762
## Bug Report ### Which version of ShardingSphere did you use? 5.0.0-beta ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? Shardingsphere-Proxy ### Expected behavior Being able to connect to Sharindgsphere-Proxy. ### Actual behavior <img width="372" alt="Screen Shot 2021-08-11 at 5 49 54 PM" src="https://user-images.githubusercontent.com/7943694/128999386-42c2a331-a073-4181-9064-57115eab16a7.png";> ### Reason analyze (If you can) ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. * config-sharding.yaml ```yaml schemaName: test dataSources: test_db: url: jdbc:mysql://localhost:3306/test_db username: admin password: connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 rules: - !SHARDING tables: test_table: actualDataNodes: test_db.test_table databaseStrategy: none: tableStrategy: none: keyGenerateStrategy: column: test_column keyGeneratorName: snowflake keyGenerators: snowflake: type: SNOWFLAKE props: worker-id: 123 ``` * server.yaml ```yaml governance: name: governance_ds registryCenter: type: ZooKeeper serverLists: localhost:2181 props: timeToLiveSeconds: 60 retryIntervalMilliseconds: 500 maxRetries: 3 operationTimeoutMilliseconds: 500 overwrite: false scaling: blockQueueSize: 10000 workerThread: 40 rules: - !AUTHORITY users: - root@%:root - sharding@:sharding provider: type: NATIVE props: max-connections-size-per-query: 1 executor-size: 16 # Infinite by default. proxy-frontend-flush-threshold: 128 # The default value is 128. # LOCAL: Proxy will run with LOCAL transaction. # XA: Proxy will run with XA transaction. # BASE: Proxy will run with B.A.S.E transaction. proxy-transaction-type: LOCAL xa-transaction-manager-type: Atomikos proxy-opentracing-enabled: false proxy-hint-enabled: true sql-show: false check-table-metadata-enabled: false lock-wait-timeout-milliseconds: 50000 # The maximum time to wait for a lock ``` * command for starting proxy <img width="829" alt="Screen Shot 2021-08-11 at 6 03 29 PM" src="https://user-images.githubusercontent.com/7943694/129001461-ebf2486f-d68e-49fa-8998-c7e157a1e1d0.png";> * `stdout.log` after proxy successes to start ```txt OpenJDK 64-Bit Server VM warning: Option UseConcMarkSweepGC was deprecated in version 9.0 and will likely be removed in a future release. OpenJDK 64-Bit Server VM warning: Ignoring option UseFastAccessorMethods; support was removed in 9.0 [INFO ] 2021-08-11 18:03:26.997 [main] o.a.c.f.imps.CuratorFrameworkImpl - Starting [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.6.0--b4c89dc7f6083829e18fae6e446907ae0b1f22d7, built on 02/25/2020 14:38 GMT [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:host.name=localhost [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.version=9 [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.home=/Library/Java/JavaVirtualMachines/adoptopenjdk-9.jdk/Contents/Home [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=.:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/avatica-core-1.17.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-context-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-statement-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-governance-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-transaction-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/aggdesigner-algorithm-6.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-scaling-postgresql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta- shardingsphere-proxy-bin/lib/commons-io-2.8.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jta-1.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/gson-2.8.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/json-path-2.4.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/protobuf-java-3.11.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-common-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-common-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jcl-over-slf4j-1.7.7.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/perfmark-api-0.19.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/quartz-2.3.2.jar:/Users/sam/work/apach e-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-tracing-api-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-scaling-mysql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-sqlserver-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-distsql-parser-engine-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-authority-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/httpcore-4.4.11.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-grpclb-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-distsql-parser-statement-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphe re-proxy-bin/lib/transactions-4.0.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-postgresql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-protocol-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-frontend-mysql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-infra-common-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-api-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/antlr4-runtime-4.7.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/netty-all-4.1.45.Final.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/memory-0.9.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-b eta-shardingsphere-proxy-bin/lib/shardingsphere-governance-context-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jackson-core-2.10.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/calcite-core-1.26.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-governance-repository-etcd-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-logging-1.1.3.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/animal-sniffer-annotations-1.18.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-executor-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/HikariCP-3.4.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/curator-client-5.1.0.jar:/Users/sam/work/apache-shardingsphe re-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-error-handler-general-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/calcite-linq4j-1.26.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-stub-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-simple-executor-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-lite-core-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-api-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/log4j-1.2.17.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-parser-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-mysql-5.0.0-beta.jar:/Users/sam/work/apache-shardin gsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/slf4j-api-1.7.7.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/transactions-jdbc-4.0.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-netty-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-scaling-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-executor-kernel-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/postgresql-42.2.5.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-protocol-mysql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/protobuf-java-util-3.11.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-encrypt-api-5.0.0-beta.jar:/Users/sam/work/apache-shard ingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/failureaccess-1.0.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-governance-repository-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/checker-qual-2.11.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/esri-geometry-api-2.2.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-collections4-4.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-bootstrap-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-optimize-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-discovery-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sharding -core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/transactions-jta-4.0.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-frontend-postgresql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-transaction-xa-spi-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/json-smart-2.3.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-protocol-postgresql-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-engine-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/logback-classic-1.2.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-lite-lifecycle-3.0.0-beta.jar:/Users/sam/work/apache-shardingsp here-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-context-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/error_prone_annotations-2.3.4.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-dbcp-1.4.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-shadow-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/sketches-core-0.9.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-discovery-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/curator-framework-5.1.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/groovy-2.4.19-indy.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-readwrite-splitting-core-5.0.0-beta.jar:/Users/sam/work/apache-shardin gsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-encrypt-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/snakeyaml-1.16.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/guava-29.0-jre.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-registry-center-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jackson-dataformat-yaml-2.10.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-transaction-xa-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-script-executor-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphe re-infra-binder-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/zookeeper-3.6.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/asm-5.0.4.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/mysql-connector-java-5.1.47.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-codec-1.10.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/audience-annotations-0.5.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-governance-repository-zookeeper-curator-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/logback-core-1.2.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-jdbc-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/apiguardian -api-1.1.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-sql92-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-db-discovery-mgr-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/atomikos-util-4.0.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-oracle-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-exec-1.3.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/httpclient-4.5.9.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/janino-3.0.11.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-system-datetime-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/sharding sphere-infra-merge-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-frontend-spi-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-transaction-xa-atomikos-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/failsafe-2.3.3.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/transactions-api-4.0.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jetcd-resolver-0.5.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-compiler-3.0.11.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/mchange-commons-java-0.2.15.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-datetime-spi-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardin gsphere-proxy-bin/lib/accessors-smart-1.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-authority-common-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-frontend-core-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/avatica-metrics-1.17.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-protobuf-lite-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-lang-2.6.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sharding-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-protobuf-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-route-5.0.0-beta.jar:/Users/sam/work/apache-shardingspher e-5.0.0-beta-shardingsphere-proxy-bin/lib/HikariCP-java7-2.4.13.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-error-handler-spi-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-tracing-rdb-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/proto-google-common-protos-1.17.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-sql-parser-spi-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-proxy-backend-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jetcd-common-0.5.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-shadow-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-readwrite-splitti ng-api-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/grpc-core-1.27.1.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jsr305-3.0.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-http-executor-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/uzaygezen-core-0.2.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/zookeeper-jute-3.6.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/commons-lang3-3.4.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/elasticjob-dataflow-executor-3.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jetcd-core-0.5.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/curator-recipes-5.1.0.jar:/Users/sam/work/apache-shardingsph ere-5.0.0-beta-shardingsphere-proxy-bin/lib/jackson-annotations-2.10.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/shardingsphere-infra-rewrite-5.0.0-beta.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/jackson-databind-2.10.0.jar:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/ext-lib/* [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/Users/sam/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:. [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/var/folders/38/zs18s2t52yn2z3hhh3kxwbkr0000gn/T/ [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA> [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.name=Mac OS X [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.arch=x86_64 [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.version=10.16 [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:user.name=sam [INFO ] 2021-08-11 18:03:27.005 [main] org.apache.zookeeper.ZooKeeper - Client environment:user.home=/Users/sam [INFO ] 2021-08-11 18:03:27.006 [main] org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin [INFO ] 2021-08-11 18:03:27.006 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.memory.free=1781MB [INFO ] 2021-08-11 18:03:27.006 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.memory.max=1945MB [INFO ] 2021-08-11 18:03:27.006 [main] org.apache.zookeeper.ZooKeeper - Client environment:os.memory.total=1945MB [INFO ] 2021-08-11 18:03:27.007 [main] org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@27eedb64 [INFO ] 2021-08-11 18:03:27.010 [main] org.apache.zookeeper.common.X509Util - Setting -D jdk.tls.rejectClientInitiatedRenegotiation=true to disable client-initiated TLS renegotiation [INFO ] 2021-08-11 18:03:27.015 [main] o.apache.zookeeper.ClientCnxnSocket - jute.maxbuffer value is 1048575 Bytes [INFO ] 2021-08-11 18:03:27.018 [main] org.apache.zookeeper.ClientCnxn - zookeeper.request.timeout value is 0. feature enabled=false [INFO ] 2021-08-11 18:03:27.021 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost/127.0.0.1:2181. [INFO ] 2021-08-11 18:03:27.021 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - SASL config status: Will not attempt to authenticate using SASL (unknown error) [INFO ] 2021-08-11 18:03:27.023 [main] o.a.c.f.imps.CuratorFrameworkImpl - Default schema [INFO ] 2021-08-11 18:03:27.027 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Socket connection established, initiating session, client: /127.0.0.1:51592, server: localhost/127.0.0.1:2181 [INFO ] 2021-08-11 18:03:27.050 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost/127.0.0.1:2181, session id = 0x1000b267f280010, negotiated timeout = 40000 [INFO ] 2021-08-11 18:03:27.054 [main-EventThread] o.a.c.f.state.ConnectionStateManager - State change: CONNECTED [INFO ] 2021-08-11 18:03:27.065 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:27.065 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:27.262 [main] o.apache.curator.utils.Compatibility - Using org.apache.zookeeper.server.quorum.MultipleAddresses WARNING: An illegal reflective access operation has occurred WARNING: Illegal reflective access by org.codehaus.groovy.reflection.CachedClass (file:/Users/sam/work/apache-shardingsphere-5.0.0-beta-shardingsphere-proxy-bin/lib/groovy-2.4.19-indy.jar) to method java.lang.Object.finalize() WARNING: Please consider reporting this to the maintainers of org.codehaus.groovy.reflection.CachedClass WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations WARNING: All illegal access operations will be denied in a future release Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice [INFO ] 2021-08-11 18:03:30.887 [main] o.a.s.p.i.i.AbstractBootstrapInitializer - Database name is `MySQL`, version is `5.7.12` [INFO ] 2021-08-11 18:03:30.895 [main] o.a.s.s.c.e.j.FinishedCheckJobExecutor - Start finished check job executor. [INFO ] 2021-08-11 18:03:30.898 [main] o.a.c.f.imps.CuratorFrameworkImpl - Starting [INFO ] 2021-08-11 18:03:30.899 [main] org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@106cd9c8 [INFO ] 2021-08-11 18:03:30.899 [main] o.apache.zookeeper.ClientCnxnSocket - jute.maxbuffer value is 1048575 Bytes [INFO ] 2021-08-11 18:03:30.899 [main] org.apache.zookeeper.ClientCnxn - zookeeper.request.timeout value is 0. feature enabled=false [INFO ] 2021-08-11 18:03:30.900 [main] o.a.c.f.imps.CuratorFrameworkImpl - Default schema [INFO ] 2021-08-11 18:03:30.900 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost/127.0.0.1:2181. [INFO ] 2021-08-11 18:03:30.900 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - SASL config status: Will not attempt to authenticate using SASL (unknown error) [INFO ] 2021-08-11 18:03:30.900 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Socket connection established, initiating session, client: /127.0.0.1:51617, server: localhost/127.0.0.1:2181 [INFO ] 2021-08-11 18:03:30.921 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost/127.0.0.1:2181, session id = 0x1000b267f280011, negotiated timeout = 40000 [INFO ] 2021-08-11 18:03:30.922 [main-EventThread] o.a.c.f.state.ConnectionStateManager - State change: CONNECTED [INFO ] 2021-08-11 18:03:30.923 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:30.923 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:30.924 [main] o.a.c.f.imps.CuratorFrameworkImpl - Starting [INFO ] 2021-08-11 18:03:30.925 [main] org.apache.zookeeper.ZooKeeper - Initiating client connection, connectString=localhost:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@4300e240 [INFO ] 2021-08-11 18:03:30.925 [main] o.apache.zookeeper.ClientCnxnSocket - jute.maxbuffer value is 1048575 Bytes [INFO ] 2021-08-11 18:03:30.925 [main] org.apache.zookeeper.ClientCnxn - zookeeper.request.timeout value is 0. feature enabled=false [INFO ] 2021-08-11 18:03:30.925 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Opening socket connection to server localhost/127.0.0.1:2181. [INFO ] 2021-08-11 18:03:30.925 [main] o.a.c.f.imps.CuratorFrameworkImpl - Default schema [INFO ] 2021-08-11 18:03:30.925 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - SASL config status: Will not attempt to authenticate using SASL (unknown error) [INFO ] 2021-08-11 18:03:30.926 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Socket connection established, initiating session, client: /127.0.0.1:51618, server: localhost/127.0.0.1:2181 [INFO ] 2021-08-11 18:03:30.946 [main-SendThread(localhost:2181)] org.apache.zookeeper.ClientCnxn - Session establishment complete on server localhost/127.0.0.1:2181, session id = 0x1000b267f280012, negotiated timeout = 40000 [INFO ] 2021-08-11 18:03:30.946 [main-EventThread] o.a.c.f.state.ConnectionStateManager - State change: CONNECTED [INFO ] 2021-08-11 18:03:30.948 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:30.948 [main-EventThread] o.a.c.framework.imps.EnsembleTracker - New config event received: {} [INFO ] 2021-08-11 18:03:31.012 [main] org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor [INFO ] 2021-08-11 18:03:31.022 [main] o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl [INFO ] 2021-08-11 18:03:31.022 [main] org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. [INFO ] 2021-08-11 18:03:31.023 [main] o.a.s.e.l.i.s.JobShutdownHookPlugin - Registering Quartz shutdown hook. _finished_check [INFO ] 2021-08-11 18:03:31.023 [main] org.quartz.simpl.RAMJobStore - RAMJobStore initialized. [INFO ] 2021-08-11 18:03:31.023 [main] org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) '_finished_check' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 1 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. [INFO ] 2021-08-11 18:03:31.023 [main] org.quartz.impl.StdSchedulerFactory - Quartz scheduler '_finished_check' initialized from an externally provided properties instance. [INFO ] 2021-08-11 18:03:31.024 [main] org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 [INFO ] 2021-08-11 18:03:31.291 [main] org.quartz.core.QuartzScheduler - Scheduler _finished_check_$_NON_CLUSTERED started. [INFO ] 2021-08-11 18:03:31.302 [main] o.a.s.s.c.e.job.ScalingJobExecutor - Start scaling job executor. [INFO ] 2021-08-11 18:03:31.462 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy start success. ``` * MySQL Workbench window. <img width="912" alt="Screen Shot 2021-08-11 at 6 00 49 PM" src="https://user-images.githubusercontent.com/7943694/129001084-7efba7d5-d9bf-4610-9d8b-fae4ebc3ae59.png";> It works when I try to access MySQL CLI client as follows , but doesn't work when I connect with MySQL Workbench. <img width="829" alt="Screen Shot 2021-08-11 at 5 59 11 PM" src="https://user-images.githubusercontent.com/7943694/129000822-24feac42-1e98-431b-86da-002f5f5593ab.png";> ### Example codes for reproduce this issue (such as a github link). -- 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]
![https://user-images.githubusercontent.com/7943694/128999386-42c2a331-a073-4181-9064-57115eab16a7.png"](https://user-images.githubusercontent.com/7943694/128999386-42c2a331-a073-4181-9064-57115eab16a7.png"){kind=link}
![https://user-images.githubusercontent.com/7943694/129001461-ebf2486f-d68e-49fa-8998-c7e157a1e1d0.png"](https://user-images.githubusercontent.com/7943694/129001461-ebf2486f-d68e-49fa-8998-c7e157a1e1d0.png"){kind=link}
![https://user-images.githubusercontent.com/7943694/129001084-7efba7d5-d9bf-4610-9d8b-fae4ebc3ae59.png"](https://user-images.githubusercontent.com/7943694/129001084-7efba7d5-d9bf-4610-9d8b-fae4ebc3ae59.png"){kind=link}
![https://user-images.githubusercontent.com/7943694/129000822-24feac42-1e98-431b-86da-002f5f5593ab.png"](https://user-images.githubusercontent.com/7943694/129000822-24feac42-1e98-431b-86da-002f5f5593ab.png"){kind=link}