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