Connection error after updating to 0.80

Configuration
1

After updating to 0.80 I can’t connect to my hassio installation on raspberry pi 3b, I need to restart from ssh and then after some minutes I get this message from the front-end
Unable to connect to Home Assistant. RETRY
So I need to restart again.

Anyone has this problem?

2

Updating from? Anything in the log?

3

from 0.79.3

these are the errors from the log

Update for media_player.tv_cucina fails
15:43 components/media_player/samsungtv.py (ERROR)
Error in data transfer
15:41 /usr/local/lib/python3.6/site-packages/websockets/protocol.py (ERROR)
Exception in callback loop._exec_queued_writes handle: <Handle loop._exec_queued_writes>
15:41 /usr/local/lib/python3.6/site-packages/pylgtv/webos_client.py (ERROR)
Exception in callback loop._on_idle handle: <Handle loop._on_idle>
15:41 /usr/local/lib/python3.6/site-packages/pylgtv/webos_client.py (ERROR)
Update for media_player.tv_cucina fails
15:40 components/media_player/samsungtv.py (ERROR)
Update for media_player.tv_cucina fails
15:39 components/media_player/samsungtv.py (ERROR)
Update for media_player.tv_cucina fails
15:38 components/media_player/samsungtv.py (ERROR)
Update for media_player.tv_cucina fails
15:35 components/media_player/samsungtv.py (ERROR)
Error executing query: (sqlite3.OperationalError) database is locked (Background on this error at: http://sqlalche.me/e/e3q8)
15:32 components/recorder/util.py (ERROR)
Timer got out of sync. Resetting
15:32 core.py (ERROR)
Update for media_player.tv_cucina fails
15:31 components/media_player/samsungtv.py (ERROR)
Timer got out of sync. Resetting
15:31 core.py (ERROR)
Setup of xiaomi_aqara is taking over 10 seconds.
15:31 util/async_.py (WARNING)
Error setting up entry InternetGatewayDeviceV2 - FRITZ!Box 7490 for upnp
15:31 components/upnp/device.py (ERROR)
Could not add port mapping: 8123:192.168.1.48:8123
15:31 components/upnp/device.py (ERROR)
Monitored condition temperature_max is deprecated
15:31 components/sensor/darksky.py (WARNING)
Ended unfinished session (id=413 from 2018-10-14 13:27:06.428295)
15:30 components/recorder/__init__.py (WARNING)
4

I’m having a similar issue - updated from 0.79.3 this morning. The UI seems to hang if not timeout from the browser. I’ve noticed that my homeassistant docker container crashes periodically.

5

yes, it restarts itself after some minutes, or I have to restart it from ssh

6

everytime it restarts itself i loose recorded entity values.

in the log there is always lines like this

2018-10-16 13:39:08 WARNING (Recorder) [homeassistant.components.recorder] Ended unfinished session (id=453 from 2018-10-16 11:19:40.481785)
2018-10-16 13:39:15 ERROR (MainThread) [homeassistant.components.upnp] Could not add port mapping: 8123:192.168.1.48:8123
2018-10-16 13:39:17 ERROR (MainThread) [homeassistant.config_entries] Error setting up entry InternetGatewayDeviceV2 - FRITZ!Box 7490 for upnp
Traceback (most recent call last):
File “/usr/local/lib/python3.6/site-packages/homeassistant/config_entries.py”, line 236, in async_setup
result = await component.async_setup_entry(hass, self)
File “/usr/local/lib/python3.6/site-packages/homeassistant/components/upnp/init.py”, line 128, in async_setup_entry
await device.async_add_port_mappings(ports, local_ip=local_ip)
File “/usr/local/lib/python3.6/site-packages/homeassistant/components/upnp/device.py”, line 69, in async_add_port_mappings
internal_port)
File “/usr/local/lib/python3.6/site-packages/homeassistant/components/upnp/device.py”, line 90, in _async_add_port_mapping
lease_duration=None)
File “/usr/local/lib/python3.6/site-packages/async_upnp_client/igd.py”, line 83, in async_add_port_mapping
await action.async_call(
AttributeError: ‘NoneType’ object has no attribute ‘async_call’
2018-10-16 13:39:28 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, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’] [parameters: (‘state_changed’, ‘{“entity_id”: “zone.home”, “old_state”: null, “new_state”: {“entity_id”: “zone.home”, “state”: “zoning”, “attributes”: {“hidden”: true, “latitude”: 4 … (132 characters truncated) … T11:39:13.391961+00:00", “last_updated”: “2018-10-16T11:39:13.391961+00:00”, “context”: {“id”: “16bfb23584014130809522c9ad3e4e01”, “user_id”: null}}}’, ‘LOCAL’, ‘2018-10-16 11:39:13.392127’, ‘2018-10-16 11:39:28.435020’, ‘16bfb23584014130809522c9ad3e4e01’, None)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)

7

I’ve discovered that my arlo camera component has been the cause since 0.80. Disabling it has got rid of the issue. https://github.com/home-assistant/home-assistant/issues/17427

8

I think that my problem is related to the new upnp and my fritzbox… after I configured it hassio started to reboot.

How can I disable it?

9

finally i downgraded to 0.79.3

10

I have a fritzbox and one as a mesh repeater and I only set it to show status and it’s not locking me up here. You seem to have some dB issues as well?

11

The fritzbox wasn’t the problem.

I stil have this error

2018-10-21 10:32:42 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, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)'] [parameters: ('state_changed', '{"entity_id": "zone.home", "old_state": null, "new_state": {"entity_id": "zone.home", "state": "zoning", "attributes": {"hidden": true, "latitude": 4 ... (132 characters truncated) ... T08:32:19.471267+00:00", "last_updated": "2018-10-21T08:32:19.471267+00:00", "context": {"id": "165886bc0cd34b38b3a387b80990e574", "user_id": null}}}', 'LOCAL', '2018-10-21 08:32:19.471384', '2018-10-21 08:32:42.382813', '165886bc0cd34b38b3a387b80990e574', None)] (Background on this error at: http://sqlalche.me/e/4xp6)

And I have no more history…

12

I’m currently running 80.3 and started to get the same errors:
Error executing query: (sqlite3.OperationalError) database is locked

(I’m also running a new influx 1.6.4, not sure if it’s related as the mentioned error is for the internal db containing state and history)

To me it seems related to the history and logbook view.
It still doesn’t work (after it should have been fixed in 80.3) and every time I try to access those views my pie starts to slow down and eventually die without being able to restart it properly. I can’t ssh into the pi at some point and have to unplug the power to get homeassistant back up.
The ‘free’ command shows me that there is a memory issue. When the pi is slowing down I see that my memory only has 30 or less MB free and my 100MB swapfile is completely full.
To compare, I’m running homeassistant now for 12+ hours without accessing the history/logbook views and have 471MB free memory and swap is used for 11MB.