I have just rebuilt again due to sql errors and system becoming unstable. Running a Pi2 with a brand new card, no Etcher errors and latest snapshot restore. If I need to open an issue, do I open this on hassio or home assistant?
On a fresh boot I also got a database error, before restoring snapshot fresh from a new build.
2018-03-14 22:25:00 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=17 from 2018-03-13 14:14:02.680870)
2018-03-14 22:25:18 WARNING (SyncWorker_8) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-14 22:25:44 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-14 22:25:53 WARNING (SyncWorker_16) [homeassistant.components.wemo] Unable to probe wemo at 192.168.1.102
2018-03-14 22:25:56 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-14 22:26:25 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (?, ?, ?, ?, ?)'] [parameters: ('service_registered', '{"domain": "recorder", "service": "purge"}', 'LOCAL', '2018-03-14 22:24:56.760438', '2018-03-14 22:26:25.018690')] (Background on this error at: http://sqlalche.me/e/4xp6)
Really getting tired of this stuff.
Here is the entire log just a few moments in.
2018-03-14 22:25:00 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=17 from 2018-03-13 14:14:02.680870)
2018-03-14 22:25:18 WARNING (SyncWorker_8) [homeassistant.components.emulated_hue] When targeting Google Home, listening port has to be port 80
2018-03-14 22:25:44 WARNING (MainThread) [homeassistant.setup] Setup of wemo is taking over 10 seconds.
2018-03-14 22:25:53 WARNING (SyncWorker_16) [homeassistant.components.wemo] Unable to probe wemo at 192.168.1.102
2018-03-14 22:25:56 WARNING (MainThread) [homeassistant.components.sensor] Setup of platform snmp is taking over 10 seconds.
2018-03-14 22:26:25 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'INSERT INTO events (event_type, event_data, origin, time_fired, created) VALUES (?, ?, ?, ?, ?)'] [parameters: ('service_registered', '{"domain": "recorder", "service": "purge"}', 'LOCAL', '2018-03-14 22:24:56.760438', '2018-03-14 22:26:25.018690')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-03-14 22:34:03 ERROR (SyncWorker_5) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed OR states.state_id IS NULL) ORDER BY events.time_fired'] [parameters: ('state_changed', 'logbook_entry', 'homeassistant_start', 'homeassistant_stop', '2018-03-14 05:00:00.000000', '2018-03-15 05:00:00.000000')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-03-14 22:34:03 ERROR (SyncWorker_5) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed OR states.state_id IS NULL) ORDER BY events.time_fired'] [parameters: ('state_changed', 'logbook_entry', 'homeassistant_start', 'homeassistant_stop', '2018-03-14 05:00:00.000000', '2018-03-15 05:00:00.000000')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-03-14 22:34:04 ERROR (SyncWorker_5) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed OR states.state_id IS NULL) ORDER BY events.time_fired'] [parameters: ('state_changed', 'logbook_entry', 'homeassistant_start', 'homeassistant_stop', '2018-03-14 05:00:00.000000', '2018-03-15 05:00:00.000000')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-03-14 22:34:04 ERROR (SyncWorker_5) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed OR states.state_id IS NULL) ORDER BY events.time_fired'] [parameters: ('state_changed', 'logbook_entry', 'homeassistant_start', 'homeassistant_stop', '2018-03-14 05:00:00.000000', '2018-03-15 05:00:00.000000')] (Background on this error at: http://sqlalche.me/e/4xp6)
2018-03-14 22:34:04 ERROR (MainThread) [aiohttp.server] Error handling request
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.DatabaseError: database disk image is malformed
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/aiohttp/web_protocol.py", line 381, in start
resp = await self._request_handler(request)
File "/usr/lib/python3.6/site-packages/aiohttp/web_app.py", line 310, in _handle
resp = await handler(request)
File "/usr/lib/python3.6/site-packages/aiohttp/web_middlewares.py", line 88, in impl
return await handler(request)
File "/usr/lib/python3.6/site-packages/homeassistant/components/http/static.py", line 68, in staticresource_middleware
return await handler(request)
File "/usr/lib/python3.6/site-packages/homeassistant/components/http/real_ip.py", line 27, in real_ip_middleware
return await handler(request)
File "/usr/lib/python3.6/site-packages/homeassistant/components/http/ban.py", line 68, in ban_middleware
return await handler(request)
File "/usr/lib/python3.6/site-packages/homeassistant/components/http/auth.py", line 52, in auth_middleware
return await handler(request)
File "/usr/lib/python3.6/site-packages/homeassistant/components/http/view.py", line 100, in handle
result = await result
File "/usr/lib/python3.6/site-packages/homeassistant/components/logbook.py", line 143, in get
_get_events, hass, self.config, start_day, end_day)
File "/usr/lib/python3.6/asyncio/futures.py", line 332, in __iter__
yield self # This tells Task to wait for completion.
File "/usr/lib/python3.6/asyncio/tasks.py", line 250, in _wakeup
future.result()
File "/usr/lib/python3.6/asyncio/futures.py", line 245, in result
raise self._exception
File "/usr/lib/python3.6/concurrent/futures/thread.py", line 56, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/lib/python3.6/site-packages/homeassistant/components/logbook.py", line 286, in _get_events
events = execute(query)
File "/usr/lib/python3.6/site-packages/homeassistant/components/recorder/util.py", line 64, in execute
(row.to_native() for row in qry)
File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
return self._execute_and_instances(context)
File "/usr/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_created \nFROM events LEFT OUTER JOIN states ON events.event_id = states.event_id \nWHERE events.event_type IN (?, ?, ?, ?) AND events.time_fired > ? AND events.time_fired < ? AND (states.last_updated = states.last_changed OR states.state_id IS NULL) ORDER BY events.time_fired'] [parameters: ('state_changed', 'logbook_entry', 'homeassistant_start', 'homeassistant_stop', '2018-03-14 05:00:00.000000', '2018-03-15 05:00:00.000000')] (Background on this error at: http://sqlalche.me/e/4xp6)