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 2022/04/14 10:26:07 UTC

[GitHub] [shardingsphere] novice-gamer opened a new issue, #16829: Database selection error during SQL execution

novice-gamer opened a new issue, #16829:
URL: https://github.com/apache/shardingsphere/issues/16829

   # Question
   - Shardingsphere proxy version 5.1.1
   - configuration file
   Zookeeper is used, and the configuration file is as follows
   
   customer_delivery_dev datasources:
   ```yaml
   ds_0:
     password: xxxxxxxxx
     dataSourceClassName: com.zaxxer.hikari.HikariDataSource
     url: jdbc:mysql://192.168.1.6:3306/customer_delivery_dev
     username: root
   ```
   
   crawler2021 datasources:
   ```yaml
   ds_0:
     password: xxxx
     dataSourceClassName: com.zaxxer.hikari.HikariDataSource
     url: jdbc:mysql://192.168.1.6:3306/crawler2021_0
     username: root
   ds_1:
     password: xxxx
     dataSourceClassName: com.zaxxer.hikari.HikariDataSource
     url: jdbc:mysql://192.168.1.7:3306/crawler2021_1
     username: root
   ds_2:
     password: xxxx
     dataSourceClassName: com.zaxxer.hikari.HikariDataSource
     url: jdbc:mysql://192.168.1.8:3306/crawler2021_2
     username: root
   ds_3:
     password: xxxx
     dataSourceClassName: com.zaxxer.hikari.HikariDataSource
     url: jdbc:mysql://192.168.1.9:3306/crawler2021_3
     username: root
   
   ```
   
   - error message
   
   ![error](https://raw.githubusercontent.com/novice-gamer/picture/master/9ef8013576763fdd87990356fe866e5.png)
   
   The database queried is customer_ Delivery_ Dev, why from crawler2021_ 0 database?
   There is no similar problem when using version 5.1.0. Why does this problem occur when updating to 5.1.1?
   


-- 
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.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [shardingsphere] terrymanu closed issue #16829: Database selection error during SQL execution

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #16829: Database selection error during SQL execution
URL: https://github.com/apache/shardingsphere/issues/16829


-- 
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] strongduanmu commented on issue #16829: Database selection error during SQL execution

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16829:
URL: https://github.com/apache/shardingsphere/issues/16829#issuecomment-1099045685

   @novice-gamer Can you provide your sharding configuration?


-- 
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] terrymanu commented on issue #16829: Database selection error during SQL execution

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #16829:
URL: https://github.com/apache/shardingsphere/issues/16829#issuecomment-1159484492

   Closed because of no feedback for long time.


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