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/03/19 07:54:41 UTC
[GitHub] [shardingsphere] cowcomic commented on issue #9733: Throw Execption when adding a scaling Job
cowcomic commented on issue #9733:
URL: https://github.com/apache/shardingsphere/issues/9733#issuecomment-802629248
i make a new request like this
```
curl -X POST \
http://localhost:8888/scaling/job/start \
-H 'content-type: application/json' \
-d '{
"ruleConfig": {
"source": {
"type": "shardingSphereJdbc",
"parameter": "
dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
jdbcUrl: jdbc:mysql://192.168.0.142:3306/aaaa?serverTimezone=UTC&useSSL=false
username: root
password: xxx
ds_1:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
jdbcUrl: jdbc:mysql://192.168.0.88:3306/aaaa?serverTimezone=UTC&useSSL=false
username: root
password: xxx
rules:
- !SHARDING
tables:
t_calabash_label:
actualDataNodes: ds_${0..1}.t_calabash_label_${0..7}
databaseStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_db_algorith
tableStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_label_algorith
t_calabash_label_user:
actualDataNodes: ds_${0..1}.t_calabash_label_user_${0..7}
databaseStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_db_algorith
tableStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_label_user_algorith
t_calabash_label_story:
actualDataNodes: ds_${0..1}.t_calabash_label_story_${0..7}
databaseStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_db_algorith
tableStrategy:
standard:
shardingColumn: USERID
shardingAlgorithmName: t_calabash_label_story_algorith
shardingAlgorithms:
t_calabash_db_algorith:
type: INLINE
props:
algorithm-expression: ds_${USERID % 2}
t_calabash_label_algorith:
type: INLINE
props:
algorithm-expression: t_calabash_label_${USERID % 8}
t_calabash_label_user_algorith:
type: INLINE
props:
algorithm-expression: t_calabash_label_user_${USERID % 8}
t_calabash_label_story_algorith:
type: INLINE
props:
algorithm-expression: t_calabash_label_story_${USERID % 8}
"
},
"target": {
"type": "jdbc",
"parameter": "
username: root,
password: xxx,
jdbcUrl: jdbc:mysql://192.168.0.227:3307/aaaa?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
"
}
},
"jobConfiguration":{
"concurrency":"3"
}
}'
```
this time no error in back server
![image](https://user-images.githubusercontent.com/4745969/111747901-d4ce6700-88ca-11eb-8e5b-57e1c7465b08.png)
![image](https://user-images.githubusercontent.com/4745969/111747952-e44db000-88ca-11eb-8d10-a9c9a87bddc6.png)
![image](https://user-images.githubusercontent.com/4745969/111748000-f0397200-88ca-11eb-8ba4-1dc9102a79b7.png)
but job state seems not right
![image](https://user-images.githubusercontent.com/4745969/111748355-62aa5200-88cb-11eb-965f-ea4fc98f0397.png)
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org