Ticket #217 (closed 用户报障: 已处理)

Opened 12 years ago

Last modified 12 years ago

摄影部落同步到论坛，偶尔会出现报错，同步不成功

Reported by: chenguohao Owned by: dingjianyong
Priority: 次高级（2） Milestone:
Component: 电脑网产品论坛 Version:
Keywords: Cc:
Due Date: 19/12/2013

Description

INSERT INTO bbs7_user_limit (uid,today,topicCount,replyCount,gradeAmount1,gradeAmount2,gradeAmount3,gradeAmount4,gradeAmount5,gradeAmount6,gradeAmount7,recommendCount)

VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Duplicate entry '8793884-2013-12-17'

摄影部落同步到论坛，偶尔会出现报错，同步不成功
from 丁健勇

Change History

comment:1 Changed 12 years ago by chenguohao

  • Owner changed from qinhongyuan to dingjianyong
  • Status changed from new to assigned

comment:2 Changed 12 years ago by dingjianyong

了解过摄影部落同步过来的机制，由于是在后台人工审核后同步的，所以有可能同时同步多条数据过来，如果多个作品都是同一作者的，就有可能在插入userlimit表的时候出现主键冲突的问题。
详情可以看UserLimitDao中的findFromDb方法。

由于此数据非重要数据，使用insert ignore into语句代替insert into语句，在sprint29中修复

comment:3 Changed 12 years ago by dingjianyong

  • Status changed from assigned to closed
  • Resolution set to 已处理
Note: See TracTickets for help on using tickets.