-
Incident report
-
Resolution: Unresolved
-
Trivial
-
None
-
4.4.9
-
None
-
None
-
Centos 7, MariaDB 10.3.16
Something as in https://support.zabbix.com/browse/ZBX-17851 I faced yesterday
Steps to reproduce:
Dont know because faced in first time.
Only logs:
[Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update trends set num=xx,value_min=xxxx.xxxxxx,value_avg=xxxx.xxxxxx,value_max=xxxx.xxxxxx where itemid=xxxxx and clock=1593475200;
[...]~80 of them
Unde xxxxx values are different only time was the same.
And after that [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update trends_uint set num=xx,value_min=xx,value_avg=xx,value_max=xx where itemid=xxxxx and clock=1593475200;
[...]~80 of them