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/01/17 11:52:51 UTC
[GitHub] [shardingsphere] soulasuna opened a new issue #14840: PostgreSQL integration test error case tbl and empty_rules
soulasuna opened a new issue #14840:
URL: https://github.com/apache/shardingsphere/issues/14840
## 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?
master
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
- PostgreSQL tbl
```bash
./mvnw -B install -f shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml -Dit.adapters=proxy -Dit.databases=PostgreSQL -Dit.scenarios=tbl -Dit.env.type=DOCKER
```
- PostgreSQL empty_rules
```bash
./mvnw -B install -f shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml -Dit.adapters=proxy -Dit.databases=PostgreSQL -Dit.scenarios=empty_rules -Dit.env.type=DOCKER
```
### Actual behavior
- PostgreSQL tbl
```bash
[ERROR] Failures:
[ERROR] GeneralDQLIT.assertExecuteQuery:66->assertExecuteQueryForStatement:77->BaseDQLIT.assertResultSet:67->BaseDQLIT.assertRows:95->BaseDQLIT.assertRow:108->BaseDQLIT.assertObjectValue:124
Expected: is "100000"
but: was "100001"
[ERROR] GeneralDQLIT.assertExecuteQuery:68->assertExecuteQueryForPreparedStatement:87->BaseDQLIT.assertResultSet:67->BaseDQLIT.assertRows:95->BaseDQLIT.assertRow:108->BaseDQLIT.assertObjectValue:124
Expected: is "100000"
but: was "100001"
[ERROR] GeneralDQLIT.assertExecute:96->assertExecuteForStatement:107->BaseDQLIT.assertResultSet:67->BaseDQLIT.assertRows:95->BaseDQLIT.assertRow:108->BaseDQLIT.assertObjectValue:124
Expected: is "100000"
but: was "100001"
[ERROR] GeneralDQLIT.assertExecute:98->assertExecuteForPreparedStatement:119->BaseDQLIT.assertResultSet:67->BaseDQLIT.assertRows:95->BaseDQLIT.assertRow:108->BaseDQLIT.assertObjectValue:124
Expected: is "100000"
but: was "100001"
[ERROR] Errors:
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRQLIT.<init>:47->BaseRQLIT.<init>:40->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] Tests run: 528, Failures: 4, Errors: 6, Skipped: 0
```
- PostgreSQL empty_rules
```bash
[ERROR] Errors:
[ERROR] GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT.assertExecute[proxy: empty_rules -> PostgreSQL -> Literal -> SHOW ENCRYPT TABLE RULE t_user](org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT)
[ERROR] Run 1: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 2: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT.assertExecute[proxy: empty_rules -> PostgreSQL -> Literal -> SHOW READWRITE_SPLITTING RULES](org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT)
[ERROR] Run 1: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 2: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 3: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT.assertExecute[proxy: empty_rules -> PostgreSQL -> Literal -> SHOW SCHEMA RESOURCES](org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT)
[ERROR] Run 1: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 2: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 3: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT.assertExecute[proxy: empty_rules -> PostgreSQL -> Literal -> SHOW SHARDING BINDING TABLE RULES](org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT)
[ERROR] Run 1: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 2: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 3: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT.assertExecute[proxy: empty_rules -> PostgreSQL -> Literal -> SHOW SHARDING BROADCAST TABLE RULES](org.apache.shardingsphere.test.integration.engine.it.rdl.GeneralRDLIT)
[ERROR] Run 1: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] Run 2: GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[INFO]
[ERROR] GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
[ERROR] GeneralRDLIT.<init>:49->BaseRDLIT.<init>:43->SingleITCase.<init>:52 » IllegalArgument
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
- set environment
```bash
./mvnw -B clean install -am -pl shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite -Pit.env.docker -DskipTests
```
- PostgreSQL tbl
```bash
./mvnw -B install -f shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml -Dit.adapters=proxy -Dit.databases=PostgreSQL -Dit.scenarios=tbl -Dit.env.type=DOCKER
```
- PostgreSQL empty_rules
```bash
./mvnw -B install -f shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml -Dit.adapters=proxy -Dit.databases=PostgreSQL -Dit.scenarios=empty_rules -Dit.env.type=DOCKER
```
--
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 commented on issue #14840: PostgreSQL integration test error case tbl and empty_rules
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #14840:
URL: https://github.com/apache/shardingsphere/issues/14840#issuecomment-1014632841
The test named `empty_rules`, but rules existed in `shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/config-empty-rules.yaml`. Maybe the scenario `empty_rules` should be renamed.
https://github.com/apache/shardingsphere/blob/f7b0bf90b7af2ac8ac0084561ff0e54971540d10/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/config-empty-rules.yaml?_pjax=%23js-repo-pjax-container%2C%20div%5Bitemtype%3D%22http%3A%2F%2Fschema.org%2FSoftwareSourceCode%22%5D%20main%2C%20%5Bdata-pjax-container%5D#L211-L244
--
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 closed issue #14840: PostgreSQL integration test error case tbl and empty_rules
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #14840:
URL: https://github.com/apache/shardingsphere/issues/14840
--
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 #14840: PostgreSQL integration test error case tbl and empty_rules
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #14840:
URL: https://github.com/apache/shardingsphere/issues/14840#issuecomment-1014971757
> The test named `empty_rules`, but rules existed in `shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/config-empty-rules.yaml`. Maybe the scenario `empty_rules` should be renamed.
>
> https://github.com/apache/shardingsphere/blob/f7b0bf90b7af2ac8ac0084561ff0e54971540d10/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/docker/empty_rules/mysql/proxy/conf/config-empty-rules.yaml?_pjax=%23js-repo-pjax-container%2C%20div%5Bitemtype%3D%22http%3A%2F%2Fschema.org%2FSoftwareSourceCode%22%5D%20main%2C%20%5Bdata-pjax-container%5D#L211-L244
Yes, I think so too, in fact it is still data sharding scenarios.
--
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