Grails多线程下插入（修改）数据的问题

2018-03-26 04:27:07 326 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

深入探索 SEED-VII：情感脑电图研究的新利器 SEED-VII是上海交通大学最新发布的多模态情感脑电图数据集，在传统EEG数据基础上增加了眼动、生理信号等多维信息，支持更精细的情感识别研究。该数据集提供了丰富的情感维度标注（效价和唤醒度），可用于算法基准测试、跨模态情感融合及个性化模型开发等研究场景。在应用层面，SEED-VII可推动人机交互、心理健康监测、教育娱乐等领域的情感计算技术发展。文章还提供了PyTorch加载该数据集的代码示例，为研究者使用该数据集提供了技术参考。阅读详情

报错：Row was updated or deleted by another transaction

controller里面多线程这块代码
List<Integer> list = db.rows(communitySql).asList()
ExecutorService evaluatePool = Executors.newFixedThreadPool(10)
List<Future<List<Object>>> futures = new ArrayList<>(10);

for (int i = 0;i<10;i++){
try {
futures.add(evaluatePool.submit(new ComputeThreadService(list,this.computeDistanceService)))
}
catch(Exception e) {
e.printStackTrace()
}
}

try {
//处理
List<Object> result = new ArrayList<>();
int i = 0
for(Future<List<Object>> future : futures){
//合并操作
result.addAll(future.get())
}
println "result.size()=========="+result.size()
//批量插入
result.each{
it.save()
i++
if(i % 1000 == 0){
sessionFactory.currentSession.flush()
sessionFactory.currentSession.clear()
}
}
} catch (Exception e) {
e.printStackTrace()
}
ComputeThreadService中只调用这个：
@Override
List<Object> call() throws Exception {

def obj = null
List<Object> retList = new ArrayList<Object>();
for(int i=0;i<list.size();i++){
obj = list.get(i)?.community_id
//处理逻辑
def distance = computeDistanceService.communityDistance(obj.toString())
retList.addAll(distance)
}
//返回处理结果
return retList;
}
service中只有这一处会连接数据库插入：Community community = null
if(Community.findByCommunityId(communityId) == null){
community = new Community()
}else{
community = Community.findByCommunityId(communityId)
}

community.communityId = communityResult[0]?.community_id
community.name = communityResult[0]?.communityname
if(City.findByCityId(communityResult[0]?.city_id))
{
community.city = City.findByCityId(communityResult[0]?.city_id)
}
else
{
def city = new City()
city.cityId = communityResult[0]?.city_id
city.cityCode = communityResult[0]?.city_code
city.save()
community.city = city
}
if(community.validate())
{
community.save(flush:true)
}
else
{
println community.errors
}
找了很久，没有找到有效的解决方案，求大神提供一个解决办法

...全文