Lock wait timeout exceeded; try restarting transaction

(去掉事务也是一样的问题)

数据操作出错,出错的消息:; uncategorized SQLException for SQL [insert into account (available, create_time, email, id, is_enterprise_user, mobile, name, password, update_time, username, user_type) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [41000]; error code [1205]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

show full processlist;
SELECT * FROM information_schema.INNODB_TRX;

select current_user();
show processlist;
show grants for 'cbis'@'%';

posted @ 2017-12-21 19:50  雨花梦  阅读(322)  评论(0编辑  收藏  举报