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/08/01 06:53:57 UTC
[GitHub] [shardingsphere] Luckyangle opened a new issue, #19741: Can't read data from read datasource, always from write datasource
Luckyangle opened a new issue, #19741:
URL: https://github.com/apache/shardingsphere/issues/19741
## Bug Report
Environment: springboot + mysql + mybatis-plus
Question: can't read data from read datasource, please help me out, thank you.
```
shardingsphere:
datasource:
write-ds-0:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.zaxxer.hikari.HikariDataSource
username: root
password: root
jdbc-url: jdbc:mysql://127.0.0.1:3306/write-ds-0?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
write-ds-0-read-0:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.zaxxer.hikari.HikariDataSource
username: root
password: root
jdbc-url: jdbc:mysql://127.0.0.1:3306/write-ds-0-read-0?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
write-ds-0-read-1:
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.zaxxer.hikari.HikariDataSource
username: root
password: root
jdbc-url: jdbc:mysql://127.0.0.1:3306/write-ds-0-read-1?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
names: write-ds-0,write-ds-0-read-0,write-ds-0-read-1
props:
sql-show: true
rules:
dataSources:
readwrite_ds_0:
staticStrategy:
writeDataSourceName: write-ds-0
readDataSourceNames: write-ds-0-read-0,write-ds-0-read-1
loadBalancerName: round_robin
loadBalancers:
round_robin:
type: ROUND_ROBIN
```
SQL log:
```
2022-08-01 14:38:20.604 INFO 30024 --- [ main] ShardingSphere-SQL : Logic SQL: SELECT order_id,price,user_id,create_time FROM t_order
2022-08-01 14:38:20.604 INFO 30024 --- [ main] ShardingSphere-SQL : SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty)
2022-08-01 14:38:20.604 INFO 30024 --- [ main] ShardingSphere-SQL : Actual SQL: write-ds-0 ::: SELECT order_id,price,user_id,create_time FROM t_order
```
### Which version of ShardingSphere did you use?
5.1.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
write data to write datasource, read data from read datasource
### Actual behavior
always read from write datasource
### Reason analyze (If you can)
I can't fix it.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
1. Download the code.
2. Create database follow the YML configuration file.
3. Execute sql file to create all tables.
4. Run Tests.
### Example codes for reproduce this issue (such as a github link).
github repository link: https://github.com/Luckyangle/shardingshpere-demo
--
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] github-actions[bot] closed issue #19741: Can't read data from read datasource, always from write datasource
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19741: Can't read data from read datasource, always from write datasource
URL: https://github.com/apache/shardingsphere/issues/19741
--
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] github-actions[bot] commented on issue #19741: Can't read data from read datasource, always from write datasource
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19741:
URL: https://github.com/apache/shardingsphere/issues/19741#issuecomment-1272349129
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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