有个DMS的实例删不掉，怎么办呢？

有个DMS的实例删不掉，怎么办呢？报错信息：

Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

The error may exist in URL [jar:file:/home/admin/idb-ent-console/target/idb-ent-console.war/WEB-INF/lib/idbx-meta-1.0-20240508.085348-5364.jar!/mybatis/dms_ent/Meta-InstanceDAO.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: UPDATE meta_instance SET gmt_modified = now(), state = ?, state_detail = ? WHERE meta_instance.tenant_id = 2087 AND id = ?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction