Another MariaDB/Galera hint

[RincewindsHat]

Describe the bug

When the max_allowed_packet parameter of mariadb is too low (16M in this case) some queries of IcingaDB exceed that limit and the query fails.
In the end this causes IcingaDB to fail.

To Reproduce

no idea, a very long check output maybe?

Expected behavior

Ideally IcingaDB should adapt it's behaviour to work within that limit or
at least die gracefully with a helpful message.

Additional context

Maybe a config option for setting this on the client side might be helpful

[oxzi]

Thanks for the report. The issue reminds me of Icinga/icinga-go-library#108.

[RincewindsHat]

That looks indeed quite similar. I did a little bit of research on this and, at least for MariaDB, the default for max_allowed_packet on the server is 16MiB, whereas for the [go-sql library)(https://github.com/go-sql-driver/mysql/blob/1fbafa8082dab81e2c2e8caeb55d569dfeafcf94/const.go#L17) it is 64MiB which led to this problem here.

[oxzi]

Thanks again. This was added to the newly introduced Operations section in #950, which you can view here on GitHub.

I would close this issue. However, feel free to reopen it if you have more to add in this regard.