This repository has been archived by the owner on Jan 23, 2025. It is now read-only.
Error Message when MariaDB is used #4
Assignees
Labels
bug
Something isn't working
Comments
|
Thanks for the Feedback. I will have a look into it on how to handle such big data amounts. Could you tell me how many items your rewe catalog contains (it is the value of the rewe sensor, that hopefully should be working)? |
|
the Value would be 342 Items |
Sign up for free
to subscribe to this conversation on GitHub.
Already have an account?
Sign in.
The problem
When HACS Integration is used with MariaDB the following Error appear on the HASS Log
What version of Home Assistant Core has the issue?
core-2022.12.4
What version of Rewe Integration has the issue?
2022.09.2
What type of installation are you running?
Home Assistant OS
Example YAML snippet
No response
Anything in the logs that might be useful for us?
Logger: homeassistant.components.recorder.core Source: components/recorder/core.py:948 Integration: Recorder (documentation, issues) First occurred: 11:15:04 (1 occurrences) Last logged: 11:15:04 Unhandled database error while processing task CommitTask(): (MySQLdb.DataError) (1406, "Data too long for column 'shared_attrs' at row 1") [SQL: INSERT INTO state_attributes (hash, shared_attrs) VALUES (%s, %s)] [parameters: (160564991, '{"REWE Market ID":"865799","valid_until":"2022-12-17","discounts":[{"product":"Bauer Butterkäse","price":{"price":"0.79","regularPrice":"Aktion"},"pi ... (73209 characters truncated) ... /34078294-9_digital-image.png"],"category":"Freizeit & Mode"}],"unit_of_measurement":"items","icon":"mdi:cart-percent","friendly_name":"Rewe 865799"}')] (Background on this error at: https://sqlalche.me/e/14/9h9h) Traceback (most recent call last): File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/usr/local/lib/python3.10/site-packages/MySQLdb/connections.py", line 254, in query _mysql.connection.query(self, query) MySQLdb.DataError: (1406, "Data too long for column 'shared_attrs' 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/core.py", line 679, in _process_one_task_or_recover return task.run(self) File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 265, in run instance._commit_event_session_or_retry() File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 929, in _commit_event_session_or_retry self._commit_event_session() File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 948, in _commit_event_session self.event_session.commit() File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1451, in commit self._transaction.commit(_to_root=self.future) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 829, in commit self._prepare_impl() File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl self.session.flush() File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3444, in flush self._flush(objects) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3583, in _flush with util.safe_reraise(): File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__ compat.raise_( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_ raise exception File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 3544, in _flush flush_context.execute() File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute rec.execute(self) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/unitofwork.py", line 630, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/persistence.py", line 1238, in _emit_insert_statements result = connection._execute_20( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20 return meth(self, args_10style, kwargs_10style, execution_options) File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection return connection._execute_clauseelement( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement ret = self._execute_context( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context self._handle_dbapi_exception( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception util.raise_( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_ raise exception File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context self.dialect.do_execute( File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/usr/local/lib/python3.10/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/usr/local/lib/python3.10/site-packages/MySQLdb/connections.py", line 254, in query _mysql.connection.query(self, query) sqlalchemy.exc.DataError: (MySQLdb.DataError) (1406, "Data too long for column 'shared_attrs' at row 1") [SQL: INSERT INTO state_attributes (hash, shared_attrs) VALUES (%s, %s)] [parameters: (160564991, '{"REWE Market ID":"865799","valid_until":"2022-12-17","discounts":[{"product":"Bauer Butterkäse","price":{"price":"0.79","regularPrice":"Aktion"},"pi ... (73209 characters truncated) ... /34078294-9_digital-image.png"],"category":"Freizeit & Mode"}],"unit_of_measurement":"items","icon":"mdi:cart-percent","friendly_name":"Rewe 865799"}')] (Background on this error at: https://sqlalche.me/e/14/9h9h)Additional information
No response
The text was updated successfully, but these errors were encountered: