Large Bulk Edit Failing to Complete

Related to Copied

Bulk edit of opsview hosts, templates, hashtags

Problem Copied

When carrying out bulk edit within Opsview against many hundred/thousand hosts the process doesnt complete.

In the opsview logs on the master you should see any entry saying ‘caught deadlock’.

Possible Cause Copied

The deadlock will be coming from the mysql/mariadb database. Increasing the parameter ‘innodb_lock_wait_timeout’ could resolve the issue.

Possible Solution Copied

Log into mysql/mariadb and run the following to capture the current setting.

MySQL [(none)]> show global variables like '%innodb_lock_wait_timeout%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| innodb_lock_wait_timeout | 50 |
+--------------------------+-------+

Increasing this value should resolve the problem

‘120’ seconds (2 mins).

MySQL [(none)]> SET GLOBAL innodb_lock_wait_timeout = 120;

Related Articles Copied

• Any existing FAQ / external website