douyi8408 2016-09-25 05:48 采纳率: 0%
浏览 44

Mysql错误:尝试获取锁定时发现死锁

I keep getting the deadlock error - Mysql error: Deadlock found when trying to get lock when updating products.

I did not write the sql statement and to me it's a mess. Writing a new app but need to fix this until then. I added - INTERVAL 900 SECOND order by id. The deadlock doesn't appear but now it doesn't update the products. Can someone show a better solution or show me why it's not updating?

$sql = "UPDATE  `" 
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)