SQl error when running daemon for inserts into vm_event_history

[Mikesch-mp]

Expected Behavior

There should be no error messages regarding truncating messages

Task eventStream failed: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'full_message' at row 1, query was: INSERT INTO vm_event_history (vcenter_uuid, ts_event_ms, event_type, event_key, event_chain_id, full_message, is_template, user_name, datacenter_uuid, datastore_uuid, host_uuid, vm_uuid, compute_resource_uuid, config_spec, config_changes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Current Behavior

The daemon outputs a lot of errors regarding insert full_message into vm_event_history failed

Possible Solution

Change the the type of full_message in table vm_event_history from 'text' to 'longtext' solves the problem.

Your Environment

• VMware vCenter®/ESXi™-Version: 6.7 latest
• Version/GIT-Hash of this module: 1.1.0
• Icinga Web 2 version: 2.7.3
• Operating System and version: Centos 7
• Webserver, PHP versions: Apache/PHP-FPM

[Thomas-Gelf]

Thanks for reporting this!