java.lang.Exception:
### Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
解決辦法:
執行MySQL命令: show full PRocesslist;
      
     
然后找出查詢語句的系統id:kill掉被鎖住的線程id
    
查看事物表: select * from information_schema.innodb_trx;

參考文章:記一次處理MySql鎖等待(Lock wait timeout exceeded):http://my.oschina.net/quanzhong/blog/222091
新聞熱點
疑難解答