Recorder thread dies after exception from long query, after installing a theme. #31651

recklessnl · 2020-02-09T05:46:40Z

The problem

I installed a popular iOS dark theme from @basnijholt using HACS. It worked for a while, but suddenly now I'm getting 403 forbidden errors after rebooting Home Assistant Core (run through Docker). Turns out it's something to do with a base64 image producing incredibly long strings, that seems to overload my MariaDB database. It renders Home Assistant completely useless as I'm unable to even see the GUI. See log below. This is a continuation of #15984 per @balloob's request.

I'm not the only one with this issue: basnijholt/lovelace-ios-dark-mode-theme#6

Environment

Home Assistant release with the issue: 105.2
Last working Home Assistant release (if known): N/A
Operating environment (Hass.io/Docker/Windows/etc.): Docker running on Debian 10.2
Integration causing this issue: iOS dark theme
Link to integration documentation on our website: https://github.com/basnijholt/lovelace-ios-dark-mode-theme

Problem-relevant `configuration.yaml`

frontend:
  themes: !include_dir_merge_named themes

Traceback/Error logs

2020-02-08 23:15:26 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._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, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s)]
[parameters: ('themes_updated', '{"themes": {"Gray & Green": {"primary-color": "#24E081", "light-primary-color": "#6BEAAA", "primary-background-color": "#494B58", "secondary-backgrou ... (3165463 characters truncated) ... ground-color": "var(--light-primary-color)", "custom-bar-card-color": "var(--accent-color)"}}, "default_theme": "ios-dark-mode-blue-red-alternative"}', 'LOCAL', datetime.datetime(2020, 2, 9, 5, 15, 18, 963105, tzinfo=<UTC>), datetime.datetime(2020, 2, 9, 5, 15, 26, 921623), 'be6c5edfad144999b583488bbd06f802', None)]
(Background on this error at: http://sqlalche.me/e/9h9h)
2020-02-08 23:15:27 ERROR (Recorder) [homeassistant.components.recorder] Error saving event: <Event themes_updated[L]: themes=Gray & Green=primary-color=#24E081, light-primary-color=#6BEAAA, primary-background-color=#494B58, secondary-background-color=var(--primary-background-color), divider-color=#595B6B, primary-text-color=#FBFBFB, secondary-text-color=#24E081, text-primary-color=#FBFBFB, disabled-text-color=#7A7D90, sidebar-icon-color=#A2A4B2, sidebar-text-color=#FBFBFB, sidebar-selected-background-color=var(--primary-background-color), sidebar-selected-icon-color=#24E081, sidebar-selected-text-color=var(--sidebar-selected-icon-color), state-icon-color=#24E081, state-icon-active-color=#FBCD41, state-icon-unavailable-color=var(--disabled-text-color), paper-slider-knob-color=#24E081, paper-slider-knob-start-color=var(--paper-slider-knob-color), paper-slider-pin-color=var(--paper-slider-knob-color), paper-slider-active-color=var(--paper-slider-knob-color), paper-slider-secondary-color=var(--light-primary-color), paper-green-400=#FBCD41, label-badge-background-color=#9A9CAB, label-badge-text-color=#FBFBFB, label-badge-red=#555766, paper-card-background-color=#555766, paper-listbox-background-color=var(--primary-background-color), paper-toggle-button-checked-button-color=#24E081, paper-toggle-button-checked-bar-color=#6BEAAA, paper-toggle-button-unchecked-button-color=#A2A4B2, paper-toggle-button-unchecked-bar-color=#787B8F, table-row-background-color=var(--primary-background-color), table-row-alternative-background-color=var(--secondary-background-color), DarkGray=primary-color=#A3A3A3, light-primary-color=#C5C5C5, primary-background-color=#272727, secondary-background-color=var(--primary-background-color), divider-color=#343434, primary-text-color=#FFFFFD, secondary-text-color=#87BF50, text-primary-color=#FFFFFF, disabled-text-color=#A3A3A3, sidebar-icon-color=#A3A3A3, sidebar-text-color=#FFFFFD, sidebar-selected-background-color=var(--primary-background-color), sidebar-selected-icon-color=#87BF50, sidebar-selected-text-color=var(--sidebar-selected-icon-color), state-icon-color=#87BF50, state-icon-active-color=#F7AA1C, state-icon-unavailable-color=var(--disabled-text-color), paper-slider-knob-color=#87BF50, paper-slider-knob-start-color=var(--paper-slider-knob-color), paper-slider-pin-color=var(--paper-slider-knob-color), paper-slider-active-color=var(--paper-slider-knob-color), paper-slider-secondary-color=var(--light-primary-color), label-badge-background-color=#575757, label-badge-text-color=#FFFFFD, label-badge-red=#575757, paper-card-background-color=#2D2D2D, paper-listbox-background-color=var(--primary-background-color), paper-toggle-button-checked-button-color=#87BF50, paper-toggle-button-checked-bar-color=#598330, paper-toggle-button-unchecked-button-color=#A3A3A3, paper-toggle-button-unchecked-bar-color=#6F6F6F, table-row-background-color=var(--primary-background-color), table-row-alternative-background-color=var(--secondary-background-color), Dark - Blue=primary-color=#2F7EFD, light-primary-color=#6FA6FE, primary-background-color=#1F1F28, secondary-background-color=var(--primary-background-color), divider-color=#2F2F3D, primary-text-color=#FFFFFF, secondary-text-color=#6FA6FE, text-primary-color=#FFFFFF, disabled-text-color=#4E4E66, sidebar-icon-color=#B6B6C1, sidebar-text-color=#F1F1F1, sidebar-selected-background-color=var(--primary-background-color), sidebar-selected-icon-color=#6FA6FE, sidebar-selected-text-color=var(--sidebar-selected-icon-color), state-icon-color=#2F7EFD, state-icon-active-color=#FBCD41, state-icon-unavailable-color=var(--disabled-text-color), paper-slider-knob-color=#2F7EFD, paper-slider-knob-start-color=var(--paper-slider-knob-color), paper-slider-pin-color=var(--paper-slider-knob-color), paper-slider-active-color=var(--paper-slider-knob-color), paper-slider-secondary-color=var(--light-primary-color), label-badge-background-color=#23232E, label-badge-text-color=#F1F1F1, label-badge-red=#6FA6FE, paper-card-background-color=#23232E, paper-listbox-background-color=var(--primary-background-color), paper-toggle-button-checked-button-color=#2F7EFD, paper-toggle-button-checked-bar-color=#6FA6FE, paper-toggle-button-unchecked-button-color=var(--paper-toggle-button-checked-button-color), paper-toggle-button-unchecked-bar-color=#3E4756, table-row-background-color=var(--primary-background-color), table-row-alternative-background-color=var(--secondary-background-color), ios-dark-mode-blue-red-alternative=background-image=center / cover no-repeat fixed url('data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAASABIAAD/4QBYRXhpZgAATU0AKgAAAAgAAgESAAMAAAABAAEAAIdpAAQAAAABAAAAJgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAAHgKADAAQAAAABAAAHgAAAAAD/7QA4UGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAAA4QklNBCUAAAAAABDUHYzZjwCyBOmACZjs+EJ+//4ANE9wdGltaXplZCBieSBKUEVHbWluaSAzLjE0LjEyLjcxOTAxNzA2IDB4NjI3Mjg0NDgA/9sAQwAFAgICAgIDAgIDBAMDAwQLBAQEBAUHBQsFCw8PEREQDxAQEhQYFRITFxMICxcdFxgaGxwcHAwOHyEfHSEbHR0c/9sAQwEFBQUHAwcNBwcNHBMQExwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwcHBwc/8AAEQgHgAeAAwEiAAIRAQMRAf/EABwAAQEBAQEBAQEBAAAAAAAAAAABAgMFBAYHCP/EACQQAQEBAQEAAwEBAQEAAgMAAAABEgIRITFBYYFRcSJCscHw/8QAGwEBAQEBAQEBAQAAAAAAAAAAAAECAwUGBAf/xAAZEQEBAQEBAQAAAAAAAAAAAAAAEQExIQL/2gAM

Additional information

I removed the rest of the string as it was incomprehensible long... perhaps @basnijholt can help explain further what is going on since I don't know much about base64 images. I just want to make sure my database isn't corrupted by this.

The text was updated successfully, but these errors were encountered:

recklessnl · 2020-02-09T05:56:51Z

EDIT: the 403 error was due to an IP ban for some reason. So that is not related to the issue.

balloob · 2020-02-09T06:08:54Z

themes data should not be sent over the event bus 🤦‍♂

(we also shouldn't crash the recorder)

balloob · 2020-02-09T06:37:03Z

@basnijholt why do you have base64 encoded images in your theme? That is very inefficient. Just ask users to install an image in their /local dir.

balloob · 2020-02-09T07:03:59Z

What exception is thrown by the recorder? There should be a stacktrace to indicate the process has quit.

basnijholt · 2020-02-10T15:47:16Z

@basnijholt why do you have base64 encoded images in your theme? That is very inefficient. Just ask users to install an image in their /local dir.

It was recommended to do it this way by @ludeeus. I guess because it's easier to install with HACS.

balloob · 2020-02-10T16:27:30Z

By having the images inside the themes, it makes it slower to load the themes on initial load of the app. If it was a url, themes load faster, get applied faster and the url can be loaded from cache. We should see if HACS can fix that.

balloob · 2020-02-10T16:29:28Z

@recklessnl your issue claims that the recorder thread dies, however I cannot see that in the code. The fact that we log "Error saving event" means we caught the error. https://github.com/home-assistant/home-assistant/blob/dev/homeassistant/components/recorder/__init__.py#L390-L392

Are there 0 events recorded after the error? And if so, do you see other errors ?

recklessnl · 2020-02-11T00:30:45Z

I copied the title from the previous bug report. These are all the errors I see after the recorder error I posted earlier:

2020-02-10 18:15:13 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._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, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s)]
[parameters: ('themes_updated', '{"themes": {"Gray & Green": {"primary-color": "#24E081", "light-primary-color": "#6BEAAA", "primary-background-color": "#494B58", "secondary-backgrou ... (3168828 characters truncated) ... und-color": "var(--light-primary-color)", "custom-bar-card-color": "var(--accent-color)"}}, "default_theme": "ios-light-mode-dark-green-alternative"}', 'LOCAL', datetime.datetime(2020, 2, 11, 0, 15, 5, 183066, tzinfo=<UTC>), datetime.datetime(2020, 2, 11, 0, 15, 13, 113507), 'dea430d035ac4a55bade4cb261223cf2', None)]
(Background on this error at: http://sqlalche.me/e/9h9h)
2020-02-10 18:15:13 ERROR (Recorder) [homeassistant.components.recorder] Error saving event: <Event themes_updated[L]: themes=Gray & Green=primary-color=#24E081, light-primary-color=#6BEAAA, primary-background-color=#494B58, secondary-background-color=var(--primary-background-color), divider-color=#595B6B, primary-text-color=#FBFBFB, secondary-text-color=#24E081, text-primary-color=#FBFBFB, disabled-text-color=#7A7D90, sidebar-icon-color=#A2A4B2



Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.DataError: (1406, "Data too long for column 'event_data' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 364, in run
    session.flush()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2479, in flush
    self._flush(objects)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2617, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2577, in _flush
    flush_context.execute()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
    rec.execute(self)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
    uow,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
    insert,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1137, in _emit_insert_statements
    statement, params
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.DataError: (MySQLdb._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, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s)]
[parameters: ('themes_updated', '{"themes": {"Gray & Green": {"primary-color": "#24E081", "light-primary-color": "#6BEAAA", "primary-background-color": "#494B58", "secondary-backgrou ... (3168828 characters truncated) ... und-color": "var(--light-primary-color)", "custom-bar-card-color": "var(--accent-color)"}}, "default_theme": "ios-light-mode-dark-green-alternative"}', 'LOCAL', datetime.datetime(2020, 2, 11, 0, 15, 5, 183066, tzinfo=<UTC>), datetime.datetime(2020, 2, 11, 0, 15, 13, 113507), 'dea430d035ac4a55bade4cb261223cf2', None)]
(Background on this error at: http://sqlalche.me/e/9h9h)
2020-02-10 18:15:27 ERROR (SyncWorker_164) [pynanoleaf.pynanoleaf] Nanoleaf is not allowing new tokens,
                    please make sure to press and hold the on/off button
                    on your device for 5 seconds until the LED starts flashing
                    in a pattern.
2020-02-10 18:15:27 ERROR (MainThread) [homeassistant.components.light] Error while setting up nanoleaf platform for light
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/pynanoleaf/pynanoleaf.py", line 189, in _request
    response.raise_for_status()
  File "/usr/local/lib/python3.7/site-packages/requests/models.py", line 940, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 403 Client Error: Forbidden for url: http://192.168.1.158:16021/api/v1/new

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/helpers/entity_platform.py", line 179, in _async_setup_platform
    await asyncio.wait_for(asyncio.shield(task), SLOW_SETUP_MAX_WAIT)
  File "/usr/local/lib/python3.7/asyncio/tasks.py", line 442, in wait_for
    return fut.result()
  File "/usr/local/lib/python3.7/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/src/homeassistant/homeassistant/components/nanoleaf/light.py", line 81, in setup_platform
    token = nanoleaf_light.request_token()
  File "/usr/local/lib/python3.7/site-packages/pynanoleaf/pynanoleaf.py", line 60, in request_token
    response = self._request("new", 'POST', authenticated=False).json()
  File "/usr/local/lib/python3.7/site-packages/pynanoleaf/pynanoleaf.py", line 206, in _request
    in a pattern.""") from e
pynanoleaf.pynanoleaf.NotAuthorizingNewTokens: Nanoleaf is not allowing new tokens,
                    please make sure to press and hold the on/off button
                    on your device for 5 seconds until the LED starts flashing
                    in a pattern.
2020-02-10 18:15:32 ERROR (SyncWorker_27) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:15:32 WARNING (SyncWorker_27) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
2020-02-10 18:15:53 ERROR (SyncWorker_212) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:15:53 WARNING (SyncWorker_212) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
2020-02-10 18:16:14 ERROR (SyncWorker_37) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:16:14 WARNING (SyncWorker_37) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
2020-02-10 18:16:35 ERROR (SyncWorker_193) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:16:35 WARNING (SyncWorker_193) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
2020-02-10 18:16:56 ERROR (SyncWorker_33) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:16:56 WARNING (SyncWorker_33) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
2020-02-10 18:17:17 ERROR (SyncWorker_75) [miio.device] Unable to discover a device at address 192.168.1.196
2020-02-10 18:17:17 WARNING (SyncWorker_75) [homeassistant.components.xiaomi_miio.vacuum] Got exception while fetching the state: Unable to discover the device 192.168.1.196
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.DataError: (1406, "Data too long for column 'event_data' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 364, in run
    session.flush()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2479, in flush
    self._flush(objects)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2617, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2577, in _flush
    flush_context.execute()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
    rec.execute(self)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
    uow,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj
    insert,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1137, in _emit_insert_statements
    statement, params
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 293, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.DataError: (MySQLdb._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, context_id, context_user_id) VALUES (%s, %s, %s

balloob · 2020-02-11T00:38:36Z

My question has not been answered. How do you know the recorder has died ? Nothing in your log indicates that the recorder has died?

recklessnl · 2020-02-11T00:39:33Z

This is the answer: I copied the title from the previous bug report. You requested to make a new bug report, I just copied the title. Perhaps it didn't die.

balloob · 2020-02-11T00:44:35Z

Okay, then the themes related PRs have fixed this issue.

balloob added the integration: recorder label Feb 9, 2020

balloob mentioned this issue Feb 9, 2020

Theme update refetch themes home-assistant/frontend#4812

Merged

9 tasks

balloob mentioned this issue Feb 9, 2020

Clean up frontend services and events #31654

Merged

20 tasks

balloob closed this as completed Feb 11, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Recorder thread dies after exception from long query, after installing a theme. #31651

Recorder thread dies after exception from long query, after installing a theme. #31651

recklessnl commented Feb 9, 2020 •

edited

Loading

recklessnl commented Feb 9, 2020 •

edited

Loading

balloob commented Feb 9, 2020 •

edited

Loading

balloob commented Feb 9, 2020

balloob commented Feb 9, 2020

basnijholt commented Feb 10, 2020

balloob commented Feb 10, 2020

balloob commented Feb 10, 2020

recklessnl commented Feb 11, 2020

balloob commented Feb 11, 2020

recklessnl commented Feb 11, 2020

balloob commented Feb 11, 2020

Recorder thread dies after exception from long query, after installing a theme. #31651

Recorder thread dies after exception from long query, after installing a theme. #31651

Comments

recklessnl commented Feb 9, 2020 • edited Loading

The problem

Environment

Problem-relevant configuration.yaml

Traceback/Error logs

Additional information

recklessnl commented Feb 9, 2020 • edited Loading

balloob commented Feb 9, 2020 • edited Loading

balloob commented Feb 9, 2020

balloob commented Feb 9, 2020

basnijholt commented Feb 10, 2020

balloob commented Feb 10, 2020

balloob commented Feb 10, 2020

recklessnl commented Feb 11, 2020

balloob commented Feb 11, 2020

recklessnl commented Feb 11, 2020

balloob commented Feb 11, 2020

recklessnl commented Feb 9, 2020 •

edited

Loading

Problem-relevant `configuration.yaml`

recklessnl commented Feb 9, 2020 •

edited

Loading

balloob commented Feb 9, 2020 •

edited

Loading