Mam pytanie odno艣nie b艂臋d贸w recordera - gdzie szuka膰 przyczyny?
Szczeg贸艂y loga (ERROR)
Logger: aiohttp.server
Source: components/recorder/__init__.py:719
First occurred: 19:27:27 (2 occurrences)
Last logged: 19:27:28
Error handling request
Traceback (most recent call last):
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2285, in _wrap_pool_connect
return fn()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 363, in connect
return _ConnectionFairy._checkout(self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 773, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
rec = pool._do_get()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
return self._create_connection()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
return _ConnectionRecord(self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
self.__connect(first_connect_check=True)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 664, in __connect
pool.dispatch.connect(self.connection, self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/event/attr.py", line 261, in __call__
fn(*args, **kw)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/recorder/__init__.py", line 719, in set_sqlite_pragma
cursor.execute("PRAGMA journal_mode=WAL")
sqlite3.OperationalError: database is locked
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.7/site-packages/aiohttp/web_protocol.py", line 418, in start
resp = await task
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/aiohttp/web_app.py", line 458, in _handle
resp = await handler(request)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/aiohttp/web_middlewares.py", line 119, in impl
return await handler(request)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/http/real_ip.py", line 39, in real_ip_middleware
return await handler(request)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/http/ban.py", line 72, in ban_middleware
return await handler(request)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/http/auth.py", line 127, in auth_middleware
return await handler(request)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/http/view.py", line 123, in handle
result = await result
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/history/__init__.py", line 348, in get
significant_changes_only,
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/concurrent/futures/thread.py", line 57, in run
result = self.fn(*self.args, **self.kwargs)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/history/__init__.py", line 86, in get_significant_states
for state in execute(query)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/recorder/util.py", line 66, in execute
row for row in (row.to_native() for row in qry) if row is not None
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3403, in __iter__
return self._execute_and_instances(context)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3425, in _execute_and_instances
querycontext, self._connection_from_session, close_with_result=True
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3440, in _get_bind_args
mapper=self._bind_mapper(), clause=querycontext.statement, **kw
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3418, in _connection_from_session
conn = self.session.connection(**kw)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1133, in connection
execution_options=execution_options,
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1139, in _connection_for_bind
engine, execution_options
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 432, in _connection_for_bind
conn = bind._contextual_connect()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2251, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2289, in _wrap_pool_connect
e, dialect, self
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1555, in _handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2285, in _wrap_pool_connect
return fn()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 363, in connect
return _ConnectionFairy._checkout(self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 773, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
rec = pool._do_get()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/impl.py", line 238, in _do_get
return self._create_connection()
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
return _ConnectionRecord(self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
self.__connect(first_connect_check=True)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 664, in __connect
pool.dispatch.connect(self.connection, self)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/sqlalchemy/event/attr.py", line 261, in __call__
fn(*args, **kw)
File "/data/data/pl.sviete.dom/files/usr/lib/python3.7/site-packages/homeassistant/components/recorder/__init__.py", line 719, in set_sqlite_pragma
cursor.execute("PRAGMA journal_mode=WAL")
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
(Background on this error at: http://sqlalche.me/e/e3q8)