You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/11 09:06:38 UTC
[GitHub] [shardingsphere] sgc109 opened a new issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-900862257
@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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sgc109 commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
sgc109 commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-896735598
Once i set `Default schema`, i could connect to the proxy
<img width="1012" alt="Screen Shot 2021-08-11 at 7 55 40 PM" src="https://user-images.githubusercontent.com/7943694/129017450-1b427e3b-f92e-4c89-ac83-86ba7f80c135.png">
But, some data still don't be fetched as follows.
<img width="1136" alt="Screen Shot 2021-08-11 at 8 01 32 PM" src="https://user-images.githubusercontent.com/7943694/129018138-b2f9ed61-e9c5-492c-8882-235e3a4fe9f6.png">
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-900867267
> @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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-927310635
The connection problem has been resolved, this issue will be closed.
Please refer to another issue for more support "https://github.com/apache/shardingsphere/issues/11994.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-899167504
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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-915120871
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:
https://github.com/apache/shardingsphere/issues/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
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] cqiwencom commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
cqiwencom commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-897344874
This question has been consulted. I also have this problem when testing the version of navicat12. You can log in normally by using navicat11.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sgc109 edited a comment on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
sgc109 edited a comment on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-897405836
@cqiwencom Hi, i'm currently using MySQL Workbench 8.0.26 and I can't use Navicat because I don't have a license.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sgc109 commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
sgc109 commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-897405836
@cqiwencom Hi, i'm currently using MySQL Workbench 8.0.26.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-900867267
> @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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-900862257
@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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-899022108
@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?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero edited a comment on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-917620246
Look forward to this feature. ;-)
Does Anyone want to test this feature? We are willing to provide any help. ;-)
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-917620246
Look forward to this feature. ;-)
Does Anyone want to test this feature? @RaigorJiang is willing to provide any help. ;-)
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sgc109 edited a comment on issue #11762: Cannot connect to Shardingsphere-Proxy with MySQL Workbench
Posted by GitBox <gi...@apache.org>.
sgc109 edited a comment on issue #11762:
URL: https://github.com/apache/shardingsphere/issues/11762#issuecomment-896735598
Once i set `Default Schema` , i could connect to the proxy
<img width="1012" alt="Screen Shot 2021-08-11 at 7 55 40 PM" src="https://user-images.githubusercontent.com/7943694/129017450-1b427e3b-f92e-4c89-ac83-86ba7f80c135.png">
But, some data still don't be fetched as follows.
<img width="1136" alt="Screen Shot 2021-08-11 at 8 01 32 PM" src="https://user-images.githubusercontent.com/7943694/129018138-b2f9ed61-e9c5-492c-8882-235e3a4fe9f6.png">
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org