Cannot add field poc_2_phone_b in table host_inventory - on DB startup

[amirowski]

Hi,

Did anyone encounter such error:

Cannot add field `poc_2_phone_b` in table `zabbix`.`host_inventory` because after adding it, the row size is 8246 which is greater than maximum allowed size (8126) for a record on index leaf page.

on MariaDB side, after update to MariaDB-server-10.4.7-1?

Field poc_2_phone_b is visible in host_inventory table schema.

Day before, there was also an update zabbix-server-mysql-4.2.5-1 on that machine, but it did not put any warnings in DB log (at that time MariaDB-server was still in version 10.4.6)

[DaneTorson]

Hello amirowski
I confirm that, same thing - seems to be MariaDB-server-10.4.7 related.

[nerijus]

Same here after upgrade to MariaDB 10.3.17.

[regex]

I have the same issue with 10.3.17-MariaDB. Is there an opened bug?

[andris]

See https://support.zabbix.com/browse/ZBX-16465
and https://jira.mariadb.org/browse/MDEV-19292

[loganv]

This appears to be a bug in Zabbix: https://jira.mariadb.org/browse/MDEV...comment-132239