[GitHub] [shardingsphere] peilinqian commented on issue #22412: Execute tpcc，returning ERROR: insert or update on table "bmsql_stock" violates foreign key constraint "s_item_fkey_bmsql_stock"

[GitBox <gi...@apache.org>]

peilinqian commented on issue #22412:
URL: https://github.com/apache/shardingsphere/issues/22412#issuecomment-1366577689

   ```
   Starting BenchmarkSQL LoadData
   
   driver=org.postgresql.Driver
   conn=jdbc:postgresql://7.212.123.28:11000/tpcc_db?loggerLevel=OFF
   user=sharding
   password=***********
   warehouses=5
   loadWorkers=10
   fileLocation (not defined)
   csvNullValue (not defined - using default 'NULL')
   
   Worker 000: Loading ITEM
   Worker 000: ERROR: [7.212.123.28:45428/7.212.123.28:11000] ERROR: Insert statement does not support sharding table routing to multiple data nodes.
   Worker 001: Loading Warehouse      1
   Worker 002: Loading Warehouse      2
   Worker 003: Loading Warehouse      3
   Worker 004: Loading Warehouse      4
   Worker 005: Loading Warehouse      5
   Worker 002: Loading Warehouse      2 done
   Worker 004: Loading Warehouse      4 done
   Worker 001: Loading Warehouse      1 done
   Worker 003: Loading Warehouse      3 done
   Worker 005: Loading Warehouse      5 done
   
   ```
   ```
   
   [ERROR] 2022-12-28 19:17:35.402 [Connection-19-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
   java.lang.IllegalStateException: Insert statement does not support sharding table routing to multiple data nodes.
           at com.google.common.base.Preconditions.checkState(Preconditions.java:508)
           at org.apache.shardingsphere.sharding.route.engine.validator.dml.impl.ShardingInsertStatementValidator.postValidate(ShardingInsertStatementValidator.java:106)
           at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.lambda$createRouteContext$1(ShardingSQLRouter.java:60)
           at java.util.Optional.ifPresent(Optional.java:159)
           at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:60)
           at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:46)
           at org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:69)
           at org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:55)
           at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.route(KernelProcessor.java:59)
           at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:51)
           at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:125)
           at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.extended.JDBCPortal.bind(JDBCPortal.java:101)
           at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.extended.bind.PostgreSQLComBindExecutor.execute(PostgreSQLComBindExecutor.java:53)
           at org.apache.shardingsphere.proxy.frontend.postgresql.command.query.extended.PostgreSQLAggregatedCommandExecutor.execute(PostgreSQLAggregatedCommandExecutor.java:41)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:111)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
           at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
           at java.lang.Thread.run(Thread.java:748)
   ```
   


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