Slow query when upgrading from 5.0.14 to 6.0.7

[nca]

Hello,

I'm not a DB expert at all and I don't know how to solve this issue.
My server is on Centos 8 stream and MariaDB 10.5.16 clustered with galera 25.3.32

The first part is working well but at one point, there are queries taking 14 000 seconds each.

select distinct i2.key_ from items i join item_discovery id on id.itemid=i.itemid join items i2 on id.parent_itemid=i2.itemid join functions f on i.itemid=f.itemid and f.triggerid=13272 where i.flags=2

After 2 days, the queries are not done.



I attach the describe, explain and analyze queries

Let me know if you need more information
Thanks in advance for your help.
Nathan

[nca]

Hello we found the problem and could resolve it.
The upgrade takes 5 min instead of never ending. The solution is posted in zabbix support here : [ZBX-21448] Slow query when upgrading from 5.0.14 to 6.0.7 - ZABBIX SUPPORT