Resolution: Cannot Reproduce
CentOS 8, MariaDB 10.3, Zabbix 5.0.14
I am using zabbix-server 5.0.14 on CentOS 8 with MariaDB.
In my environment, zabbix-server works with other systems and I made some tools to close problems or to change the severity.
I sometimes find that some problems are closing state for more than 1day. Please see attached image.
And the following logs are written in zabbix_server.log.
It seems that DB deadlock occurs and it causes problem close failure.
I attached the result of "show engine innodb status" in innodb.log. Please see "LATEST DETECTED DEADLOCK" section.
Steps to reproduce:
This is how I checked to reproduce the issue.
1. create many problems (~30k problems)
2. close all problems by API
3. change problem severity by API repeatedly
I used a python script for 2. and 3. Please see attached file close_problem.py.
Repeating this procedure several times caused the problem reproduction.
DB deadlock occurs and some problems remains in closing state.
All problems are closed.