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/12/27 02:52:02 UTC
[GitHub] [shardingsphere] wsm12138 removed a comment on issue #13425: Add FAQ for DistSQL `ADD RESOURCE`
wsm12138 removed a comment on issue #13425:
URL: https://github.com/apache/shardingsphere/issues/13425#issuecomment-1000978462
Hi~ @RaigorJiang
### Which version of ShardingSphere did you use? & Which project did you use?
I used 5.0.1 snapshot ShardingSphere-Proxy reproduce the problem(commit id:ec75ec41dfc70db6696b02282471ef0934a6f98c)
### Actual behavior
When I use DistSQL to add RESOURCE for DATABASE,the following error occurred.

### Try to solve the problem
I'm sure i have `jdbc driver` because i can use `config-sharding.yaml` to startup Proxy successfuly
But i also can't find answer from [FAQ](https://github.com/apache/shardingsphere/blob/master/docs/document/content/reference/faq/_index.cn.md)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
```yaml
[root@localhost conf]# cat server.yaml | grep -v "#"
rules:
- !AUTHORITY
users:
- root@%:root
- sharding@:sharding
provider:
type: ALL_PRIVILEGES_PERMITTED
props:
```
Proxy
```shell
mysql -uroot -proot -h127.0.0.1 -P3307
mysql> create database sbtest_sharding;
Query OK, 0 rows affected (0.99 sec)
mysql> use sbtest_sharding;
Database changed
mysql> ADD RESOURCE ds_0 (
-> HOST=127.0.0.1,
-> PORT=3306,
-> DB=sbtest_sharding,
-> USER=root,
-> PASSWORD=passwd
-> ), ds_1 (
-> HOST=127.0.0.2,
-> PORT=3306,
-> DB=sbtest_sharding,
-> USER=root,
-> PASSWORD=passwd
-> );
ERROR 1104 (C1104): Can not process invalid resources, error messages are: [Invalid data source configuration name `ds_0`, error message is: Failed to initialize pool: Communications link failure, Invalid data source configuration name `ds_1`, error message is: Failed to initialize pool: Communications link failure].
mysql> ^DBye
```
--
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