如何解决以下死锁问题?

mcdcgff0  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(255)

正在获取死锁错误 INSERT 声明:
密钥:

insert into status (userid,lastactivity,lastseen) 
                 values ('10691250','1536136821','1536136821') 
      on duplicate key update lastactivity = '1536136821',
                              lastseen = '1536136821'

sql语句:

`insert into status (userid,lastactivity,lastseen) 
                  values ('10691250','1536136821','1536136821') 
      on duplicate key 
      update lastactivity = '1536136821',
             lastseen = '1536136821'`

错误:
尝试获取锁时发现死锁;尝试重新启动事务

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题