大家好，碰到这样的一个问题，怎么解决:
org.springframework.dao.CannotAcquireLockException:
Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
The error may involve com.weitoo.server.mapper.SequenceMapper.updateSequence-Inline
The error occurred while setting parameters
SQL: UPDATE sequence SET NEXTID = ? WHERE NAME = ?
Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction}