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:04 UTC
[GitHub] [shardingsphere] peilinqian opened a new issue, #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
peilinqian opened a new issue, #20063:
URL: https://github.com/apache/shardingsphere/issues/20063
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
we find java version: java8, full_version=1.8.0_282
ShardingSphere-5.1.3-SNAPSHOT
Commit ID: dirty-9dd0d3990c849d50c17c6dc7c92ec2d4ce0ad7e5
Commit Message: Implements openGauss version function by calcite (#19327)
Branch: 9dd0d3990c849d50c17c6dc7c92ec2d4ce0ad7e5
Build time: 2022-08-04T19:57:18+0800
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
opengauss manual scaling, “CHECK SCALING” syntax supported
### Actual behavior
opengauss manual scaling, “CHECK SCALING” syntax not supported
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
```
order_db=> show scaling status 0130317c30317c3054317c6f726465725f6462;
item | data_source | status | active | inventory_finished_percentage | incremental_idle_seconds
------+-------------+--------------------------+--------+-------------------------------+--------------------------
0 | ds_0 | EXECUTE_INCREMENTAL_TASK | true | 100 | 145
1 | ds_1 | EXECUTE_INCREMENTAL_TASK | true | 100 | 147
(2 rows)
order_db=> STOP SCALING SOURCE WRITING 0130317c30317c3054317c6f726465725f6462;
SUCCESS
order_db=> CHECK SCALING 0130317c30317c3054317c6f726465725f6462 BY TYPE (NAME=CRC32_MATCH);
ERROR: Database type openGauss is not supported in [MySQL]
order_db=> APPLY SCALING 0130317c30317c3054317c6f726465725f6462;
ERROR: Data consistency check is not finished or failed.
order_db=>
```
### Example codes for reproduce this issue (such as a github link).
--
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 #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20063:
URL: https://github.com/apache/shardingsphere/issues/20063#issuecomment-1272348941
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] github-actions[bot] closed issue #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
URL: https://github.com/apache/shardingsphere/issues/20063
--
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] TeslaCN closed issue #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
Posted by GitBox <gi...@apache.org>.
TeslaCN closed issue #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
URL: https://github.com/apache/shardingsphere/issues/20063
--
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 #20063: opengauss manual scaling, “CHECK SCALING” syntax not supported
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #20063:
URL: https://github.com/apache/shardingsphere/issues/20063#issuecomment-1216599012
Hi @peilinqian , the error of
```
order_db=> CHECK SCALING 0130317c30317c3054317c6f726465725f6462 BY TYPE (NAME=CRC32_MATCH);
ERROR: Database type openGauss is not supported in [MySQL]
```
means `CRC32_MATCH` just support `MySQL` for now, openGauss is not suportted.
You could use `DATA_MATCH` algorothem, e.g.
```
CHECK SCALING 0130317c30317c3054317c6f726465725f6462 BY TYPE (NAME=DATA_MATCH);
```
--
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