chengw315 opened a new issue #7115:
URL: https://github.com/apache/shardingsphere/issues/7115
> sharding-scalingăsharding-proxy 4.1.1 ; mysql 5.7.30
there are 2 sharding-proxies(named s,t), I use sharding-scaling to migrate
data from s to t, but I meet NoSuchElementException
### the response
```json
{
"success": false,
"errorCode": 500,
"errorMsg": "java.util.NoSuchElementException",
"model": null
}
```
### stdout.log of sharding-scaling:
```java
[WARN ] 03:00:21.562 [nioEventLoopGroup-3-11] o.a.s.s.web.HttpServerHandler
- Http request handle occur error:
java.util.NoSuchElementException: null
at java.util.LinkedList$ListItr.next(LinkedList.java:890)
at
org.apache.shardingsphere.shardingscaling.core.datasource.DataSourceManager.createDatasources(DataSourceManager.java:50)
at
org.apache.shardingsphere.shardingscaling.core.datasource.DataSourceManager.<init>(DataSourceManager.java:45)
at
org.apache.shardingsphere.shardingscaling.web.HttpServerHandler.startJob(HttpServerHandler.java:99)
at
org.apache.shardingsphere.shardingscaling.web.HttpServerHandler.channelRead0(HttpServerHandler.java:76)
at
org.apache.shardingsphere.shardingscaling.web.HttpServerHandler.channelRead0(HttpServerHandler.java:56)
at
io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
.
.
.
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:514)
at
io.netty.util.concurrent.SingleThreadEventExecutor$6.run(SingleThreadEventExecutor.java:1044)
at
io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
at
io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
at java.lang.Thread.run(Thread.java:745)
```
### this is the request:
```json
curl -X POST \
http://localhost:13388/shardingscaling/job/start \
-H 'content-type: application/json' \
-d '{
"ruleConfiguration": {
"sourceDatasource": "db_source:\n url:
jdbc:mysql://10.16.10.42:33307/columbia_limadw?serverTimezone=UTC&useSSL=false\n
username: root\n password: 123456\n connectionTimeoutMilliseconds: 30000\n
idleTimeoutMilliseconds: 60000\n maxLifetimeMilliseconds: 1800000\n
maxPoolSize: 50",
"sourceRule": "defaultTableStrategy:\n none:",
"destinationDataSources": {
"name": "dt_0",
"password": "123456",
"url":
"jdbc:mysql://10.16.10.42:13308/bump_dvc_history?serverTimezone=UTC&useSSL=false",
"username": "root"
}
},
"jobConfiguration": {
"concurrency": 3
}
}'
```
"**sourceDatasource**" and "**sourceRule**" of the request is copy from
**config-sharding.yaml** of source sharding-proxy
### config-sharding.yaml
```yaml
schemaName: columbia_limadw
dataSources:
db_source:
url:
jdbc:mysql://10.16.10.42:33307/columbia_limadw?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
defaultTableStrategy:
none:
```
I do this obey the document, help me please
https://shardingsphere.apache.org/document/legacy/4.x/document/cn/manual/sharding-scaling/usage/
----------------------------------------------------------------
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:
[email protected]
