My Home Assistant will start slowing down and eventually be unresponsive after running for a few days straight. I noticed a bunch of rest sensor timeout errors after it’s been running for about a day… and, wont’ stop with those timeout errors until I either restart Home Assistant or it eventually becomes unresponsive (requiring a forced restart).
Configuration.yaml:
recorder:
purge_keep_days: 7
home-assistant_v2.db is 3,140,360Kb in size!
The below log errors start accumulating after Home Assistant has been running for 6-8 hours. I’m not sure why I’m seeing all those REST sensor timeouts since the respective API endpoints are accessible from any device on my LAN within just a 1-3 seconds response time.
Could someone please tell me if my database file size has something to with the stability issue and all the errors below? I’ve tried deleting the database… but then it just grows back to that size again. I’m not sure how to troubleshoot this issue.
2020-07-09 01:58:29 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 01:58:29 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 01:59:45 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 02:00:04 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 02:00:04 ERROR (SyncWorker_3) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 02:01:12 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 02:01:12 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 02:01:23 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.gpu is taking over 10 seconds
2020-07-09 02:01:23 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/gpu failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 02:01:23 WARNING (SyncWorker_4) [homeassistant.components.rest.sensor] Empty reply found when expecting JSON data
2020-07-09 02:01:23 ERROR (MainThread) [homeassistant.components.template.sensor] Could not render template horizon_gpu_memory: UndefinedError: 'mappingproxy object' has no attribute 'mem'
2020-07-09 02:01:23 WARNING (MainThread) [homeassistant.components.alexa.capabilities] Invalid temp value for sensor.horizon_gpu_temperature
2020-07-09 02:18:31 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 02:18:31 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 02:18:31 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 02:18:31 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 02:18:32 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 05:28:20 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 05:54:38 ERROR (SyncWorker_3) [homeassistant.components.openweathermap.weather] Exception when calling OWM web API to update data
2020-07-09 06:56:01 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 08:18:21 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 08:18:21 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:17:59 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:17:59 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:18:00 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 09:18:16 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:18:16 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:18:18 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 09:18:18 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:18:32 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:18:32 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:18:47 ERROR (bellows.thread_0) [bellows.uart] CRC error in frame b'00217aa1ad90fb7e' (b'90fb' != b'0537')
2020-07-09 09:18:54 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:18:54 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:18:54 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 09:19:15 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:19:15 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:19:36 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:19:36 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:19:58 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:19:58 ERROR (SyncWorker_3) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:20:18 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:20:18 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:20:31 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:20:31 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:20:44 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 09:20:44 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:21:04 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:21:04 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:21:19 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:21:19 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:21:37 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:21:37 ERROR (SyncWorker_3) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:21:59 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:21:59 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:22:20 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:22:20 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:22:32 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 09:22:32 ERROR (SyncWorker_0) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:22:32 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:22:49 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 09:22:49 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:23:03 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:23:03 WARNING (MainThread) [homeassistant.components.sensor] Updating rest sensor took longer than the scheduled update interval 0:00:10
2020-07-09 09:23:03 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:23:21 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:23:35 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:23:35 ERROR (SyncWorker_3) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:23:51 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 09:23:51 ERROR (SyncWorker_2) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:24:07 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:24:07 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:24:22 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_uptime is taking over 10 seconds
2020-07-09 09:24:22 ERROR (SyncWorker_1) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/uptime failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:24:40 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:24:40 ERROR (SyncWorker_3) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:24:54 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_pagefile is taking over 10 seconds
2020-07-09 09:24:54 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/memswap failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)
2020-07-09 09:25:13 WARNING (MainThread) [homeassistant.helpers.entity] Update of sensor.horizon_ram is taking over 10 seconds
2020-07-09 09:25:13 ERROR (SyncWorker_4) [homeassistant.components.rest.sensor] Error fetching data: http://192.168.1.2:61208/api/3/mem failed with HTTPConnectionPool(host='192.168.1.2', port=61208): Read timed out. (read timeout=10)