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 2020/08/16 03:43:31 UTC
[GitHub] [shardingsphere] sandynz opened a new issue #6872: Failure test cases of BaseIT for PostgreSQL
sandynz opened a new issue #6872:
URL: https://github.com/apache/shardingsphere/issues/6872
TODO:
- [ ] Fix BaseIT.createTables:131 exception, support keyword table name for different databases
- [ ] Fix BaseIT.createDatabases:121 exception, databases not cleaned by previous BaseIT
## Bug Report
### Which version of ShardingSphere did you use?
master branch, 5.0.0-RC1-SNAPSHOT
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
Integration test using PostgreSQL instead of H2. Expect real test cases could run.
### Actual behavior
BaseXyzIT @BeforeClass and @AfterClass method thrown exception.
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
1, env.properties:
databases=PostgreSQL
postgresql.host=127.0.0.1 (suppose your PostgreSQL is on localhost)
postgresql.password=test
2, go to shardingsphere-test-suite module
3, mvn clean install
### Example codes for reproduce this issue (such as a github link).
```
[INFO] Running org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT
[INFO ] 15:57:37.967 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:57:37.979 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 3760, Active: PostgreSQL(1664), Disabled: MySQL(416), Oracle(832), SQLServer(848)
[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 39.665 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dcl.GeneralDC
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dcl.GeneralDCLIT Time elapsed: 39.664 s <<< ERROR!
java.lang.RuntimeException:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "`"
位置：15
Caused by: org.postgresql.util.PSQLException:
ERROR: syntax error at or near "`"
位置：15
[INFO] Running org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.790 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] Total: 0, Active: 0, Disabled: 0
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 s - in org.apache.shardingsphere.dbtest.engine.ddl.GeneralDDLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 s - in org.apache.shardingsphere.dbtest.engine.dml.AdditionalDMLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:16.816 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 832, Active: PostgreSQL(144), Disabled: H2(152), MySQL(240), Oracle(160)
, SQLServer(136)
[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.144 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.BatchDMLI
T
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.BatchDMLIT Time elapsed: 40.144 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
[INFO] Running org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:58:57.066 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 1936, Active: PostgreSQL(336), Disabled: H2(352), MySQL(560), Oracle(368
), SQLServer(320)
[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 40.279 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dml.GeneralDM
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dml.GeneralDMLIT Time elapsed: 40.279 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Tests run: 0, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 s - in org.apache.shardingsphere.dbtest.engine.dql.AdditionalDQLIT
[INFO] Running org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [INFO] ======= Test Plan =======
[INFO ] 15:59:37.378 [main] o.a.s.d.e.u.IntegrateTestParameters - [WARN] Total: 6752, Active: PostgreSQL(1328), Disabled: H2(1312), MySQL(1664), Oracle(
1232), SQLServer(1216)
[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 42.819 s <<< FAILURE! - in org.apache.shardingsphere.dbtest.engine.dql.GeneralDQ
LIT
[ERROR] org.apache.shardingsphere.dbtest.engine.dql.GeneralDQLIT Time elapsed: 42.819 s <<< ERROR!
java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
Caused by: org.postgresql.util.PSQLException: ERROR: database "db_0" already exists
[INFO]
[INFO] Results:
[INFO]
[ERROR] Errors:
[ERROR] GeneralDCLIT>BaseDCLIT.initDatabasesAndTables:100->BaseIT.createDatabasesAndTables:109->BaseIT.createTables:131 ? Runtime
[ERROR] BatchDMLIT>BatchIT.initDatabasesAndTables:85->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[ERROR] GeneralDMLIT>BaseDMLIT.initDatabasesAndTables:68->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[ERROR] GeneralDQLIT>BaseDQLIT.insertData:68->BaseIT.createDatabasesAndTables:107->BaseIT.createDatabases:121 ? Runtime
[INFO]
[ERROR] Tests run: 4, Failures: 0, Errors: 4, Skipped: 0
```
----------------------------------------------------------------
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] tuohai666 commented on issue #6872: Failure test cases of BaseIT for PostgreSQL
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #6872:
URL: https://github.com/apache/shardingsphere/issues/6872#issuecomment-675378358
@sandynz The existing two problems have been fixed. You can go ahead now.
----------------------------------------------------------------
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] tuohai666 closed issue #6872: Failure test cases of BaseIT for PostgreSQL
Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #6872:
URL: https://github.com/apache/shardingsphere/issues/6872
----------------------------------------------------------------
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] sandynz commented on issue #6872: Failure test cases of BaseIT for PostgreSQL
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #6872:
URL: https://github.com/apache/shardingsphere/issues/6872#issuecomment-675389544
>
>
> @sandynz The existing two problems have been fixed. You can go ahead now.
Ok, thanks.
----------------------------------------------------------------
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