分表后重复保存报错

Blade 未结

关注举报

 1  183

whh 剑侠 2025-01-21 16:00

一、该问题的重现步骤是什么？

使用sharding分表后，因业务需求需要先保存获取id，再调整并保存，
这时调用saveOrUpdateBatch()或updateById()进行修改报错时会报错

二、你期待的结果是什么？实际看到的又是什么？

希望和没分表之前的效果一样能保存后再保存

三、你正在使用的是什么产品，什么版本？在什么操作系统上？

boot版 3.4.0 Win10

四、请提供详细的错误堆栈信息，这很重要。

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

### Error updating database. Cause: org.apache.shardingsphere.sharding.exception.syntax.UnsupportedUpdatingShardingValueException

### The error may exist in org/springblade/pointDevice/mapper/PointDeviceMapper.java (best guess)

### The error may involve org.springblade.pointDevice.mapper.PointDeviceMapper.updateById-Inline

### The error occurred while setting parameters

### SQL: UPDATE ht_point_device SET ex_id = ?, project_id = ?, project_step = ?, point_type = ?, latitude = ?, longitude = ?, altitude = ?, voltage_level = ?, point_name = ?, prev_point = ?, cons_prop = ?, pole_dis = ?, loop_count = ?, wire_cons_prop = ?, c_pole_code = ?, c_pole_code_name = ?, c_voltage_level = ?, c_type = ?, c_wire_spec = ?, c_pole_height = ?, c_pole_type = ?, c_pole_m_type = ?, c_pole_angle = ?, c_lay_type = ?, c_pole_deep = ?, ld_man = ?, ld_car = ?, ld_ship = ?, ld_tractor = ?, remark = ?, create_user = ?, create_dept = ?, create_time = ?, update_user = ?, update_time = ?, status = ? WHERE id = ? AND is_deleted = 0 AND tenant_id = '000000'

### Cause: org.apache.shardingsphere.sharding.exception.syntax.UnsupportedUpdatingShardingValueException

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)

at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:202)

at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.executeBatch(SqlHelper.java:233)

at com.baomidou.mybatisplus.extension.toolkit.SqlHelper.saveOrUpdateBatch(SqlHelper.java:282)

at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.saveOrUpdateBatch(ServiceImpl.java:218)

at org.springblade.core.mp.base.BaseServiceImpl.saveOrUpdateBatch(BaseServiceImpl.java:83)

at com.baomidou.mybatisplus.extension.service.IService.saveOrUpdateBatch(IService.java:88)

at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>)

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)

at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707)

at org.springblade.pointDevice.service.impl.PointDeviceServiceImpl$$EnhancerBySpringCGLIB$$6cd66510.saveOrUpdateBatch(<generated>)

at org.springblade.project.service.impl.ProjectServiceImpl.analysisJsonLinesData(ProjectServiceImpl.java:2141)

at org.springblade.project.service.impl.ProjectServiceImpl.analysisJson(ProjectServiceImpl.java:1762)

at org.springblade.project.service.impl.ProjectServiceImpl$$FastClassBySpringCGLIB$$fa622a6f.invoke(<generated>)