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.
   ![image](https://user-images.githubusercontent.com/86462784/147378121-2742b932-12e5-45b2-9a71-662c977d354a.png)
   ### 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