Related to:

Bulk edit of opsview hosts, templates, hashtags

Problem

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

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

Possible Solution

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

• Any existing FAQ / external website

If Issue Persists

• Please contact with our Client Services team via the chat service box available in any of our websites or via email to support@itrsgroup.com
  
  
  
• Make sure you provide to us:

- ANY LOG FILE OR DIAGNOSTIC

- ANY SCREENSHOT

- ANY VENDOR/VERSION OF WHAT THEY ARE TRYING TO CONNECT TO

-Any troubleshooting step already verified from the ones described in this article.