Niestety, kolejne drzwi, za którymi kolejny mur do rozwalenia
Logger: homeassistant.components.recorder
Source: components/recorder/init.py:728
Integration: Recorder (documentation, issues)
First occurred: 10:49:04 (10 occurrences)
Last logged: 10:49:33
Error during connection setup to mysql://ais:******@172.16.144.2:23306/ais?charset=utf8mb4: (MySQLdb._exceptions.ProgrammingError) (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(6), \n\tcreated DATETIME(6), \n\tcontext_id VARCHAR(36), \n\tcontext_user_id VARCHAR(’ at line 6”) [SQL: CREATE TABLE events ( event_id INTEGER NOT NULL AUTO_INCREMENT, event_type VARCHAR(32), event_data LONGTEXT, origin VARCHAR(32), time_fired DATETIME(6), created DATETIME(6), context_id VARCHAR(36), context_user_id VARCHAR(36), context_parent_id VARCHAR(36), PRIMARY KEY (event_id) ) ] (Background on this error at: http://sqlalche.me/e/13/f405) (retrying in 3 seconds)
Traceback (most recent call last):
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context
self.dialect.do_execute(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py”, line 608, in do_execute
cursor.execute(statement, parameters)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/connections.py”, line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(6), \n\tcreated DATETIME(6), \n\tcontext_id VARCHAR(36), \n\tcontext_user_id VARCHAR(’ at line 6”)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/homeassistant/components/recorder/init.py”, line 440, in _setup_recorder
self._setup_connection()
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/homeassistant/components/recorder/init.py”, line 728, in _setup_connection
Base.metadata.create_all(self.engine)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/schema.py”, line 4663, in create_all
bind._run_visitor(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 2095, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1656, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/visitors.py”, line 145, in traverse_single
return meth(obj, **kw)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/ddl.py”, line 783, in visit_metadata
self.traverse_single(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/visitors.py”, line 145, in traverse_single
return meth(obj, **kw)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/ddl.py”, line 827, in visit_table
self.connection.execute(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1011, in execute
return meth(self, multiparams, params)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/sql/ddl.py”, line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1068, in _execute_ddl
ret = self._execute_context(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1316, in _execute_context
self.handle_dbapi_exception(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1510, in handle_dbapi_exception
util.raise(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/util/compat.py”, line 182, in raise
raise exception
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py”, line 1276, in _execute_context
self.dialect.do_execute(
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py”, line 608, in do_execute
cursor.execute(statement, parameters)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/cursors.py”, line 206, in execute
res = self._query(query)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/cursors.py”, line 319, in _query
db.query(q)
File “/data/data/pl.sviete.dom/files/usr/lib/python3.9/site-packages/MySQLdb/connections.py”, line 259, in query
_mysql.connection.query(self, query)
sqlalchemy.exc.ProgrammingError: (MySQLdb._exceptions.ProgrammingError) (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(6), \n\tcreated DATETIME(6), \n\tcontext_id VARCHAR(36), \n\tcontext_user_id VARCHAR(’ at line 6”)
[SQL:
CREATE TABLE events (
event_id INTEGER NOT NULL AUTO_INCREMENT,
event_type VARCHAR(32),
event_data LONGTEXT,
origin VARCHAR(32),
time_fired DATETIME(6),
created DATETIME(6),
context_id VARCHAR(36),
context_user_id VARCHAR(36),
context_parent_id VARCHAR(36),
PRIMARY KEY (event_id)
)
]
(Background on this error at: http://sqlalche.me/e/13/f405)