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:
[email protected]
