在kafka发送消息到另一个service,service执行sql, 首次或前2次执行正常C操作,但后续2次或以后的操作必然发生以下错误:

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '93' for key 'PRIMARY'
### The error may exist in com/crossoverjie/kafka/orderconsumer/mapper/StockOrderMapper.java (best guess)
### The error may involve com.crossoverjie.kafka.orderconsumer.mapper.StockOrderMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO stock_order  ( id,sid,name ) VALUES( ?,?,? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '93' for key 'PRIMARY'
; SQL []; Duplicate entry '93' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '93' for key 'PRIMARY'

2018-05-21 16:38:31.273 [consumer-pool-0] TRACE o.s.t.i.TransactionInterceptor - Completing transaction for [com.crossoverjie.kafka.orderconsumer.service.impl.OrderServiceImpl.createOptimisticOrderUseRedisAndKafka] after exception: java.lang.RuntimeException: 

根据错误提示,说已存在主键id=93这条数据,不能再插入了,正常理解是93是已存在了,为啥新插入id自增的怎么没自动累加呢?





我们的pojo设置了主键id注解



去掉就好了





Logo

「智能机器人开发者大赛」官方平台,致力于为开发者和参赛选手提供赛事技术指导、行业标准解读及团队实战案例解析;聚焦智能机器人开发全栈技术闭环,助力开发者攻克技术瓶颈,促进软硬件集成、场景应用及商业化落地的深度研讨。 加入智能机器人开发者社区iRobot Developer,与全球极客并肩突破技术边界,定义机器人开发的未来范式!

更多推荐