Cannot connect to Shardingsphere-Proxy with MySQL Workbench #11762

sgc109 · 2021-08-11T09:06:23Z

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

When i click Test Connection button,

When i double-click the connection card view at home screen,

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

JDK version
9
MySQL Workbench version
8.0.26

config-sharding.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

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

stdout.log after the proxy successes to start

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/apache-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-shardingsphere-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-beta-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-shardingsphere-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-shardingsphere-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-shardingsphere-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-shardingsphere-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-shardingsphere-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/shardingsphere-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/shardingsphere-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-shardingsphere-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-shardingsphere-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-splitting-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-shardingsphere-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 windows capture.

It works when I try to access MySQL CLI client as follows , but doesn't work when I connect with MySQL Workbench.

Example codes for reproduce this issue (such as a github link).

https://github.com/sgc109/shardingsphere-proxy-bin

The text was updated successfully, but these errors were encountered:

sgc109 · 2021-08-11T11:08:08Z

Once i set Default Schema , i could connect to the proxy

But, some data still don't be fetched as follows.

cqiwencom · 2021-08-12T04:44:52Z

This question has been consulted. I also have this problem when testing the version of navicat12. You can log in normally by using navicat11.

sgc109 · 2021-08-12T07:15:53Z

@cqiwencom Hi, i'm currently using MySQL Workbench 8.0.26 and I can't use Navicat because I don't have a license.

tristaZero · 2021-08-15T09:25:29Z

@sgc109 Hi thanks for your detailed report. It is an important and complex issue to adapt different clients.
@RaigorJiang @TeslaCN Could you have a look here?

RaigorJiang · 2021-08-16T02:14:59Z

Hi @sgc109 @cqiwencom
These problems do exist, because different clients or even different versions will send different SQL statements when they connect. It is very complicated.
We have recorded these issues, and some adaptation plans will be required later.

tristaZero · 2021-08-18T06:44:55Z

@RaigorJiang Thanks, let firstly check out all the relevant issues and do some tests. Next, we can make a plan with some hints we got.

RaigorJiang · 2021-08-18T06:55:10Z

@RaigorJiang Thanks, let firstly check out all the relevant issues and do some tests. Next, we can make a plan with some hints we got.

Yes, it should be like this.

RaigorJiang · 2021-09-08T10:35:57Z

Hi guys, @sgc109 @cqiwencom
We have done some client adaptation work for Proxy, the purpose is to allow Navicat, MySQLWorkbench and other tools to connect normally and perform basic operations.
Up to now, both Navicat and Workbench can be easily connected to Proxy. Welcome everyone to experience.
For more information, please follow the issue:
#11994

As for the tables information in the Workbench, it needs to query the information_schema.columns and information_schema.tables tables, which are not yet supported. Please look forward to subsequent improvements.

P.S. I tested the following clients:

Navicat 15.0.20
MySQ Workbench 8.0.25
DataGrip 2021.1.3

tristaZero · 2021-09-12T11:47:57Z

Look forward to this feature. ;-)
Does Anyone want to test this feature? We are willing to provide any help. ;-)

RaigorJiang · 2021-09-26T13:55:46Z

The connection problem has been resolved, this issue will be closed.
Please refer to another issue for more support "#11994.

tristaZero added the in: proxy label Aug 15, 2021

tristaZero added the type: enhancement label Aug 18, 2021

tristaZero added this to the 5.0.0-RC1 milestone Aug 18, 2021

RaigorJiang mentioned this issue Sep 15, 2021

How to use Navicat in shardingsphere-proxy #12444

Closed

RaigorJiang closed this as completed Sep 26, 2021

menghaoranss modified the milestones: 5.0.0-RC1, 5.0.0 Oct 26, 2021

RaigorJiang mentioned this issue Oct 28, 2021

Improve MySQL DAL for MySQLWorkbench #13341

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Cannot connect to Shardingsphere-Proxy with MySQL Workbench #11762

Cannot connect to Shardingsphere-Proxy with MySQL Workbench #11762

sgc109 commented Aug 11, 2021 •

edited

Loading

sgc109 commented Aug 11, 2021 •

edited

Loading

cqiwencom commented Aug 12, 2021

sgc109 commented Aug 12, 2021 •

edited

Loading

tristaZero commented Aug 15, 2021

RaigorJiang commented Aug 16, 2021

tristaZero commented Aug 18, 2021

RaigorJiang commented Aug 18, 2021

RaigorJiang commented Sep 8, 2021

tristaZero commented Sep 12, 2021 •

edited

Loading

RaigorJiang commented Sep 26, 2021

Cannot connect to Shardingsphere-Proxy with MySQL Workbench #11762

Cannot connect to Shardingsphere-Proxy with MySQL Workbench #11762

Comments

sgc109 commented Aug 11, 2021 • edited Loading

Bug Report

Which version of ShardingSphere did you use?

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

Expected behavior

Actual behavior

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).

sgc109 commented Aug 11, 2021 • edited Loading

cqiwencom commented Aug 12, 2021

sgc109 commented Aug 12, 2021 • edited Loading

tristaZero commented Aug 15, 2021

RaigorJiang commented Aug 16, 2021

tristaZero commented Aug 18, 2021

RaigorJiang commented Aug 18, 2021

RaigorJiang commented Sep 8, 2021

tristaZero commented Sep 12, 2021 • edited Loading

RaigorJiang commented Sep 26, 2021

sgc109 commented Aug 11, 2021 •

edited

Loading

sgc109 commented Aug 11, 2021 •

edited

Loading

sgc109 commented Aug 12, 2021 •

edited

Loading

tristaZero commented Sep 12, 2021 •

edited

Loading