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