icingadb crashes after ~1 minute due to "data too long for column "value"

[yoshi314]

When i enable icingadb in icinga 2.12, and data starts flowing in, the icingagn process crashes with the following message.

gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:19+01:00" level=info msg="Inserting 40 notification_usergroups on runtime update" action="runtime insert/update" type=notification_usergroup
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 318 notification_users on runtime update" action="runtime insert/update" type=notification_user
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 383 customvars on runtime update" action="runtime insert/update" type=customvar
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 383 customvar_flats on runtime update" action="runtime insert/update" type=customvar_flat
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 383 notification_customvars on runtime update" action="runtime insert/update" type=notification_customvar
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 195 notifications on runtime update" action="runtime insert/update" type=notification
gru 31 14:32:20 icinga2c icingadb[3720]: time="2020-12-31T14:32:20+01:00" level=info msg="Inserting 186 notification_usergroups on runtime update" action="runtime insert/update" type=notification_usergroup
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 58 notification_users on runtime update" action="runtime insert/update" type=notification_user
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 84 customvars on runtime update" action="runtime insert/update" type=customvar
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 92 customvar_flats on runtime update" action="runtime insert/update" type=customvar_flat
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 629 notification_recipients on runtime update" action="runtime insert/update" type=notification_recipient
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 92 notification_customvars on runtime update" action="runtime insert/update" type=notification_customvar
gru 31 14:32:21 icinga2c icingadb[3720]: time="2020-12-31T14:32:21+01:00" level=info msg="Inserting 33 notifications on runtime update" action="runtime insert/update" type=notification
gru 31 14:32:22 icinga2c icingadb[3720]: time="2020-12-31T14:32:22+01:00" level=info msg="Inserting 29 notification_usergroups on runtime update" action="runtime insert/update" type=notification_usergroup
gru 31 14:32:22 icinga2c icingadb[3720]: time="2020-12-31T14:32:22+01:00" level=fatal msg="Error 1406: Data too long for column 'value' at row 299"
gru 31 14:32:22 icinga2c systemd[1]: icingadb.service: Main process exited, code=exited, status=1/FAILURE
gru 31 14:32:22 icinga2c systemd[1]: icingadb.service: Failed with result 'exit-code'.

as far as i can tell, there is just one column named 'valule' in the mysql schema and it ought to be long enough. so this is a puzzling issue.

[N-o-X]

Hi @yoshi314,

which version of Icinga DB are you using?

Please try to set the log level in icingadb.ini to debug. That should provide more information on the query.

Greetings Noah

[yoshi314]

i tried latest snapshot and also current git. (i've dropped the db and recreated it from scratch, just to make sure)

[yoshi314]

I'll see about debug logs.

[yoshi314]

i've uploaded the logs to https://easyupload.io/gjszyr

[Al2Klimov]

Dup of #199.