Core: Recorder thread dies after exception from long query

[packetinspector]

Home Assistant release with the issue:

.75.3

Last working Home Assistant release (if known):

Operating environment (Hass.io/Docker/Windows/etc.):

rasbian, python virtual env
external MariaDB

Component/platform:

https://www.home-assistant.io/components/recorder/

Description of problem:
A service call returned a very large payload, exceeding the TEXT length in mariadb. Upon insert it throws an exception and the recorder functionality stops.

The recorder component exclude feature doesn't appear granular enough to block logging of this specific event.

Ultimately I altered the column to LONGTEXT to fix the issue.

Problem-relevant configuration.yaml entries and (fill out even if it seems unimportant):

Traceback (if applicable):

Additional information:
Logs
Aug 12 19:45:03 hass hass[30657]: #033[31m2018-08-12 19:45:03 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.DataError) (1406, "Data too long for column 'event_data' at row 1") [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (%s, %s, %s, %s, %s)'] [parameters: ('kodi_call_method_result', '{"result_ok": true, "entity_id": "media_player.kodi", "input": {"method": "PVR.GetRecordings", "params": {"properties": ["file", "playcount", "star ... (111460 characters truncated) ... 0Dog%20Day%20Afternoon, TV%20(99.1%20DFDF-DT), 20180306_030000, 999877844.pvr", "playcount": 0}], "limits": {"start": 0, "end": 425, "total": 425}}}', 'LOCAL', datetime.datetime(2018, 8, 12, 23, 45, 3, 289274, tzinfo=), datetime.datetime(2018, 8, 12, 23, 45, 3, 349243))] (Background on this error at: http://sqlalche.me/e/9h9h)#033[0m
Aug 12 19:45:03 ultrahouse hass[30657]: Exception in thread Recorder:

[sagilo]

see https://github.com/home-assistant/home-assistant/issues/16074

[balloobbot]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates.

Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment :+1:

[balloobbot]

This issue will be auto-closed because there hasn't been any activity for a few months. Feel free to open a new one if you still experience this problem 👍

[basnijholt]

This is still a problem with v0.102.0.

People are experiencing this problem when using the iOS Dark Mode theme in combination with an SQL db and recorder.

See https://github.com/basnijholt/lovelace-ios-dark-mode-theme/issues/6.

@balloob, can you please reopen this issue?

[recklessnl]

Can confirm I'm having this issue as well...

[balloob]

Please open a new issue.