mysql尝试重新启动事务_SqlAlchemy+MySql 1205，“超过锁等待超时；尝试重新启动事务”...

用户正在尝试从一个用户角色映射中删除两个表。在UserRoleMapping is referenced to User table using User.id => UserRoleMapping.user_id.

我需要使用用户特定的id从两个表中删除一行

我的代码session_delete_mapping = Session()

session_delete_user= Session()

if request.method == "POST":

user_id = request.form['user_list']

try :

num_rows_deleted_map = session_delete_mapping.query(UserRoleMapping).filter(UserRoleMapping.user_id == user_id).delete()

num_rows_deleted_user = session_delete_user.query(UserRoleMapping).filter(User.id == user_id).delete()

session_delete_mapping.commit()

session_delete_user.commit()

User.query.filter(User.id == user_id).delete()

flash("Successfully deleted !!")

except Exception as e:

flash("Oops something went wrong : "+ str(e))

session_delete_mapping.rollback()

session_delete_user.rollback()

return render_template('index.html')

但是我的代码抛出了一个异常(InternalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'DELETE FROM user_role_mapping WHERE user_role_mapping.user_id = %s' ('3',)