【 使用环境 】生产环境
【问题描述】
org.springframework.dao.TransientDataAccessResourceException:
Error updating database. Cause: java.sql.SQLException
The error may exist in URL [jar:file:/tools/apps/target/portal-web.jar!/BOOT-INF/lib/portal-web-dao-1.31.5-SNAPSHOT.jar!/mapper/FlowRateMerchantMapper.xml]
The error may involve com.portal.web.dao.mapper.FlowRateMerchantMapper.insertSelective-Inline
The error occurred while setting parameters
SQL: insert into t_flow_rate_merchant ( CREATED_AT, UPDATED_AT, PRODUCT_NO, MERCHANT_CODE, STORE_NO, MERCHANT_NAME, STORE_NAME, FLOW_RATE_DATE, FLOW_RATE_CHANNEL, FLOW_RATE_TYPE, PAGE_URL, PROVINCE_CODE, CITY_CODE ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
【复现路径】从mysql迁移后,部分表有新增操作时可复现
【问题现象及影响】
新增数据失败,并且是部分成功部分失败,在新增较为频繁的表中出现,不能定位是什么问题;