lmhmhl commented on pull request #9557:
URL: https://github.com/apache/shardingsphere/pull/9557#issuecomment-794861242


   @tristaZero ,I am so sorry that I reply u late, recently, I am a little bit 
overwhelmed by all kinds of stuff, I hope u can understand me. As the same, It 
still doesn't work when I ran all the test method together, but if I run test 
method one by one, It's PERFECT. 
   ```
   java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Unique index or 
primary key violation: "PRIMARY KEY ON 
PUBLIC.""t_order_calcite_sharding_0""(""order_id_sharding"")"; SQL statement:
   
   
   INSERT INTO t_order_calcite_sharding_0 VALUES(1010, 10, 'init') [23505-196]
   
        at 
org.apache.shardingsphere.driver.jdbc.base.AbstractShardingSphereDataSourceForCalciteTest.initTable(AbstractShardingSphereDataSourceForCalciteTest.java:74)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
        at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
        at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
        at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
        at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
        at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
        at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
        at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
        at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
        at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
        at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
        at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
        at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
        at 
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
        at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
        at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
        at 
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
        at 
com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
        at 
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
        at 
com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
   Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key 
violation: "PRIMARY KEY ON 
PUBLIC.""t_order_calcite_sharding_0""(""order_id_sharding"")"; SQL statement:
   
   
   INSERT INTO t_order_calcite_sharding_0 VALUES(1010, 10, 'init') [23505-196]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.get(DbException.java:179)
        at org.h2.message.DbException.get(DbException.java:155)
        at org.h2.mvstore.db.MVPrimaryIndex.add(MVPrimaryIndex.java:139)
        at org.h2.mvstore.db.MVTable.addRow(MVTable.java:705)
        at org.h2.command.dml.Insert.insertRows(Insert.java:156)
        at org.h2.command.dml.Insert.update(Insert.java:114)
        at org.h2.command.CommandContainer.update(CommandContainer.java:101)
        at org.h2.command.Command.executeUpdate(Command.java:260)
        at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:192)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
        at 
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290)
        at 
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290)
        at org.h2.tools.RunScript.execute(RunScript.java:171)
        at 
org.apache.shardingsphere.driver.jdbc.base.AbstractShardingSphereDataSourceForCalciteTest.initTable(AbstractShardingSphereDataSourceForCalciteTest.java:69)
        ... 24 more
   
   ```


----------------------------------------------------------------
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]


Reply via email to