Icinga for Kubernetes 0.2.0, Error 1406: Data too long for column 'name'

Hello everyone,

I’m trying to install Icinga for Kubernetes (0.2.0) and have taken two different approaches.

The first approach follows the description in ‘Running out of Cluster’ , the second as described under ‘Using Helm’.
Unfortunately, both approaches result in the same error at an early stage.

Directly after systemctl enable --now icinga-kubernetes syslog shows:

2025-03-19T14:16:28.792875+00:00 icinga-srv-1 icinga-kubernetes[27891]: I0319 14:16:28.792607   27891 main.go:69] Starting Icinga for Kubernetes (v0.2.0)
2025-03-19T14:16:28.800794+00:00 icinga-srv-1 icinga-kubernetes[27891]: I0319 14:16:28.800739   27891 database.go:286] "Connecting to database" logger="database"
2025-03-19T14:16:28.802562+00:00 icinga-srv-1 icinga-kubernetes[27891]: I0319 14:16:28.802534   27891 main.go:178] "Importing schema" logger="database"
2025-03-19T14:16:29.382076+00:00 icinga-srv-1 icingadb[1066]: runtime-updates: Upserted 2 ServiceState items
2025-03-19T14:16:30.503633+00:00 icinga-srv-1 icinga-kubernetes[27891]: F0319 14:16:30.503253   27891 main.go:385] can't retry: can't perform "INSERT INTO `annotation` (`value`, `uuid`, `name`) VALUES (:value, :uuid, :name) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `uuid` = VALUES(`uuid`), `name` = VALUES(`name`)": Error 1406 (22001): Data too long for column 'name' at row 26
2025-03-19T14:16:30.506539+00:00 icinga-srv-1 mariadbd[971]: 2025-03-19 14:16:30 2931 [Warning] Aborted connection 2931 to db: 'kubernetes' user: 'kubernetes' host: 'localhost' (Got an error reading communication packets)

Installing the Helm Charts works without any problems.
But after a few seconds the corresponding pod runs into an error and ends in CrashLoopBackOff.

I0319 14:13:15.765466       1 main.go:69] Starting Icinga for Kubernetes (0.2.0)
I0319 14:13:15.765883       1 database.go:286] "Connecting to database" logger="database"
F0319 14:13:16.160949       1 main.go:385] can't retry: can't perform "INSERT INTO `annotation` (`value`, `uuid`, `name`) VALUES (:value, :uuid, :name) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `uuid` = VALUES(`uuid`), `name` = VALUES(`name`)": Error 1406 (22001): Data too long for column 'name' at row 52

Does anyone have any idea what is causing this problem?

Some information about the test environment…
It is distributed monitoring with two Master but with local databases.

Both Master running the same version.

root@icinga-srv-1:~# icinga2 --version
icinga2 - The Icinga 2 network monitoring daemon (version: r2.14.5-1)

System information:
  Platform: Ubuntu
  Platform version: 24.04.2 LTS (Noble Numbat)
  Kernel: Linux
  Kernel version: 6.8.0-55-generic
  Architecture: x86_64

Build information:
  Compiler: GNU 13.3.0
  Build host: runner-hh8q3bz2-project-575-concurrent-0
  OpenSSL version: OpenSSL 3.0.13 30 Jan 2024

The Kubernetes cluster runs version 1.24.17, all nodes run on Ubuntu 20.04.6 or 24.04.2.

Any help would be great.
best regards,
Dietmar

Hi @dietmar ,
any chance that there is some name of something longer than 253 characters in your setup?