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/04/06 09:29:21 UTC
[GitHub] [shardingsphere] SpriderMan opened a new issue #9951: how can i deal with it ?
SpriderMan opened a new issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951
**version**: apache-shardingsphere-4.1.0-sharding-scaling-bin
**request**:
curl -X POST \
http://localhost:8888/shardingscaling/job/start \
-H 'content-type: application/json' \
-d '{
"ruleConfiguration": {
"sourceDatasource": "ds_0: !!org.apache.shardingsphere.orchestration.core.configuration.YamlDataSourceConfiguration\n dataSourceClassName: com.zaxxer.hikari.HikariDataSource\n properties:\n jdbcUrl: jdbc:mysql://127.0.0.1:3308/scaling?serverTimezone=UTC&useSSL=false\n username: sharding_slave\n password: '\''123456'\''\n connectionTimeout: 30000\n idleTimeout: 60000\n maxLifetime: 1800000\n maxPoolSize: 50\n minPoolSize: 1\n maintenanceIntervalMilliseconds: 30000\n readOnly: false\n",
"sourceRule": "tables:\n t_order:\n actualDataNodes: ds_0.t_order\n keyGenerator:\n column: order_id\n type: SNOWFLAKE",
"destinationDataSources": {
"name": "dt_0",
"password": "123456",
"url": "jdbc:mysql://127.0.0.1:3307/sharding_db?serverTimezone=UTC&useSSL=false",
"username": "root"
}
},
"jobConfiguration": {
"concurrency": 1
}
}'
**error**:
[nioEventLoopGroup-3-2] o.a.s.s.web.HttpServerHandler - Datasources check failed!
org.apache.shardingsphere.shardingscaling.core.exception.DatasourceCheckFailedException: Datasources check failed!
at org.apache.shardingsphere.shardingscaling.core.execute.executor.checker.AbstractDataSourceChecker.checkConnection(AbstractDataSourceChecker.java:38)
at org.apache.shardingsphere.shardingscaling.web.HttpServerHandler.checkDatasources(HttpServerHandler.java:116)
at org.apache.shardingsphere.shardingscaling.web.HttpServerHandler.startJob(HttpServerHandler.java:101)
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.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352)
at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352)
at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:438)
at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:328)
--
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
[GitHub] [shardingsphere] Lucas-307 commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
Lucas-307 commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-815545387
Datasource Check:
1. checkPrivilege
- ALL PRIVILEGES
or
- REPLICATION SLAVE + REPLICATION CLIENT
2. checkVariable
- LOG_BIN = ON
- BINLOG_FORMAT = ROW
- BINLOG_ROW_IMAGE = FULL
@SpriderMan Please make sure privilege and variable is valid.
--
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
[GitHub] [shardingsphere] terrymanu closed issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951
--
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] SpriderMan commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
SpriderMan commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-818475085
> Datasource Check:
>
> 1. checkPrivilege (sql: `SHOW GRANTS`)
>
> * ALL PRIVILEGES
> or
> * REPLICATION SLAVE + REPLICATION CLIENT
>
> 1. checkVariable (sql: `SHOW VARIABLES`)
>
> * LOG_BIN = ON
> * BINLOG_FORMAT = ROW
> * BINLOG_ROW_IMAGE = FULL
>
> @SpriderMan Please make sure privilege and variable is valid.
but it also gets wrong like that
--
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
[GitHub] [shardingsphere] SpriderMan commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
SpriderMan commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-818463969
> Datasource Check:
>
> 1. checkPrivilege (sql: `SHOW GRANTS`)
>
> * ALL PRIVILEGES
> or
> * REPLICATION SLAVE + REPLICATION CLIENT
>
> 1. checkVariable (sql: `SHOW VARIABLES`)
>
> * LOG_BIN = ON
> * BINLOG_FORMAT = ROW
> * BINLOG_ROW_IMAGE = FULL
>
> @SpriderMan Please make sure privilege and variable is valid.
GRANT ALL PRIVILEGES ON *.* TO 'sharding_slave'@'%' WITH GRANT OPTION
--
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
[GitHub] [shardingsphere] tristaZero commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-814660557
Hi @Lucas-307 Here.
--
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
[GitHub] [shardingsphere] Lucas-307 edited a comment on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
Lucas-307 edited a comment on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-815545387
Datasource Check:
1. checkPrivilege (sql: `SHOW GRANTS`)
- ALL PRIVILEGES
or
- REPLICATION SLAVE + REPLICATION CLIENT
2. checkVariable (sql: `SHOW VARIABLES`)
- LOG_BIN = ON
- BINLOG_FORMAT = ROW
- BINLOG_ROW_IMAGE = FULL
@SpriderMan Please make sure privilege and variable is valid.
--
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
[GitHub] [shardingsphere] terrymanu closed issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951
--
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] sandynz commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-928674590
Hi @SpriderMan , thanks for your feedback. We'll output detailed logs for better troubleshooting.
--
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] sandynz commented on issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951#issuecomment-928674590
Hi @SpriderMan , thanks for your feedback. We'll output detailed logs for better troubleshooting.
--
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 closed issue #9951: how can i deal with it ?
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9951:
URL: https://github.com/apache/shardingsphere/issues/9951
--
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