[GitHub] [shardingsphere] luoyexiaoran opened a new issue #12029: 5.0.0-beta The same error occurs : Batch update returned unexpected row count from update [0]; actual row count: 24; expected: 1

Thu, 26 Aug 2021 03:17:33 -0700 


luoyexiaoran opened a new issue #12029:
URL: https://github.com/apache/shardingsphere/issues/12029


   version :    shardingsphere-jdbc-core  5.0.0-beta
   project:   springboot+hibernate+ shardingsphere-jdbc-core 
   Here is my configuration:
   
   > #sharding-jdbc分表配置
   rules:
   - !SHARDING
     # 配置分片规则
     tables:
       # 配置商户汇总表cc_restaurant_collect_data规则
       cc_restaurant_collect_data:
         actualDataNodes: 
ds0.cc_restaurant_collect_data$->{2020..2021}0$->{1..9},ds0.cc_restaurant_collect_data$->{2020..2021}1$->{0..2}
         # 配置分表策略
         tableStrategy:
           complex:
             shardingColumns: collectDate
             shardingAlgorithmName: cc_restaurant_collect_data
       # 配置商户汇总表cc_sypoint_collect_data规则
       cc_sypoint_collect_data:
         actualDataNodes: 
ds0.cc_sypoint_collect_data$->{2020..2021}0$->{1..9},ds0.cc_sypoint_collect_data$->{2020..2021}1$->{0..2}
         # 配置分表策略
         tableStrategy:
           complex:
             shardingColumns: collectDate
             shardingAlgorithmName: cc_sypoint_collect_data
       # 配置商户汇总表cc_rfid规则
       cc_rfid:
         actualDataNodes: 
ds0.cc_rfid$->{2020..2021}0$->{1..9},ds0.cc_rfid$->{2020..2021}1$->{0..2}
         # 配置分表策略
         tableStrategy:
           complex:
             shardingColumns: time
             shardingAlgorithmName: cc_rfid
       # 配置商户汇总表cc_weighbridge规则
       cc_weighbridge:
         actualDataNodes: 
ds0.cc_weighbridge$->{2020..2021}0$->{1..9},ds0.cc_weighbridge$->{2020..2021}1$->{0..2}
         # 配置分表策略
         tableStrategy:
           complex:
             shardingColumns: grossDateTime
             shardingAlgorithmName: cc_weighbridge
     shardingAlgorithms:
       cc_restaurant_collect_data:
         type: CLASS_BASED
         props:
           strategy: COMPLEX
           algorithmClassName: 
com.vortex.cloud.envcloud.cc.config.sharding.RestaurantCollectDataShardingAlgorithm
       cc_sypoint_collect_data:
         type: CLASS_BASED
         props:
           strategy: COMPLEX
           algorithmClassName: 
com.vortex.cloud.envcloud.cc.config.sharding.SypointCollectDataShardingAlgorithm
       cc_rfid:
         type: CLASS_BASED
         props:
           strategy: COMPLEX
           algorithmClassName: 
com.vortex.cloud.envcloud.cc.config.sharding.RfidDataShardingAlgorithm
       cc_weighbridge:
         type: CLASS_BASED
         props:
           strategy: COMPLEX
           algorithmClassName: 
com.vortex.cloud.envcloud.cc.config.sharding.WeighbridgeShardingAlgorithm
   
     bindingTables:  #绑定表规则列表
       - cc_restaurant_collect_data
       - cc_sypoint_collect_data
       - cc_rfid
       - cc_weighbridge
   
   
   props: #属性配置
     #是否开启SQL显示，默认值: false
     sql-show: true
   
   
![image](https://user-images.githubusercontent.com/48896854/130945492-c0e93775-cd5f-4b4c-a0ac-f6deb8e20f22.png)
   it was there and it was fixed,But now it's back
   
   
   


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

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to