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/10/10 06:33:44 UTC
[GitHub] [shardingsphere] userhujiong opened a new issue, #19906: Invalid binding table configuration in ShardingRuleConfiguration
userhujiong opened a new issue, #19906:
URL: https://github.com/apache/shardingsphere/issues/19906
code:
![image](https://user-images.githubusercontent.com/42227273/183058350-1ed96a18-5f04-4170-8ee7-05e21f8dfa69.png)
![image](https://user-images.githubusercontent.com/42227273/183058460-0bb1a3fe-39ad-411d-b200-d11a83e2a0e8.png)
ocnfig:
![image](https://user-images.githubusercontent.com/42227273/183057928-23eef796-5358-48e5-9a0a-1642d6edb9a7.png)
result:
![image](https://user-images.githubusercontent.com/42227273/183058031-2d75c42d-a5f5-4b44-9d01-45d402f07a5b.png)
Why was the table name intercepted?
And the order of the table doesn't matter?
--
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] commented on issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1272349056
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
[GitHub] [shardingsphere] okami-chen commented on issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
okami-chen commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1214023980
2022 or 2021?
--
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] userhujiong commented on issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
userhujiong commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1207515101
> Hi @userhujiong, can you provide your sharding configuration in markdown? I will try to reproduce this exception.
config
```yaml
spring:
shardingsphere:
props:
sql-show: true
datasource:
common:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
initial-size: 6
min-idle: 3
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
#validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
filters: stat,wall,slf4j
connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
wall:
multi-statement-allow: true
names: master
master:
driverClassName: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
url: jdbc:mysql://localhost:3306/ga_app_attendance?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
password: root
username: root
rules:
sql_translator:
type: NATIVE
sharding:
binding-tables:
- ga_app_attendance,ga_app_attendance_department
tables:
ga_app_attendance:
actual-data-nodes: master.ga_app_attendance_2022_0$->{1..8},master.ga_app_attendance_2021_0$->{1..8}
table-strategy:
standard:
sharding-column: checkin_sharding
sharding-algorithm-name: attendance-table-inline
ga_app_attendance_department:
actual-data-nodes: master.ga_app_attendance_department_2022_0$->{1..8},master.ga_app_attendance_department_2021_0$->{1..8}
table-strategy:
standard:
sharding-column: checkin_sharding
sharding-algorithm-name: attendance_dept_table-inline
sharding-algorithms:
attendance-table-inline:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName: com.jrsoft.ga.business.attendance.config.MonthStandardAlgorithm
attendance_dept_table-inline:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName: com.jrsoft.ga.business.attendance.config.MonthStandardAlgorithm
```
This problem occurs when there are two expressions
master.ga_app_attendance_2022_0$->{1..8},master.ga_app_attendance_2021_0$->{1..8} `false`
master.ga_app_attendance_2022_0$->{1..8} `true`
--
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 #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1207177713
Hi @userhujiong, can you provide your sharding configuration in markdown? I will try to reproduce this exception.
--
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] userhujiong commented on issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
userhujiong commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1207150289
> What is your version?
5.1.2, But I found that 5.1.1 also has this problem
--
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
Re: [I] Invalid binding table configuration in ShardingRuleConfiguration [shardingsphere]
Posted by "vinsmoke-sanji59 (via GitHub)" <gi...@apache.org>.
vinsmoke-sanji59 commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1851255705
hello,is this problem solvend now? because I'm having the same problem right now。version 5.1.2
--
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 #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19906:
URL: https://github.com/apache/shardingsphere/issues/19906#issuecomment-1207148608
What is your version?
--
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] closed issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19906: Invalid binding table configuration in ShardingRuleConfiguration
URL: https://github.com/apache/shardingsphere/issues/19906
--
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