0.106: Light brightness stepping, better Safe Mode and person dialog

[Anwen]

I haven’t, I thought about it but was afraid I might lose my ability to get back in. I’ll try it…

[Anwen]

No dice. Tried rebooting, and then completely shutting down and restarting. I still don’t have a front end, or any errors in the log to figure out where to go next.

[DavidFW1960 (David)]

can you see if the homeassistant container is running?

[Anwen]

When I SSH into the host, docker ps shows me all the add-on containers, hassio_dns, hassio_audio, and hassio_supervisor running, but not home assistant. I tried to look at the supervisor log and its just a mass of errors of VSCode trying to connect to the API continuously scrolling:

20-03-04 22:32:38 ERROR (MainThread) [supervisor.api.proxy] Client error on WebSocket API Cannot connect to host 172.30.32.1:8123 ssl:False [Connection refused].
20-03-04 22:32:38 INFO (MainThread) [supervisor.api.proxy] Home Assistant WebSocket API request initialize
20-03-04 22:32:38 INFO (MainThread) [supervisor.api.proxy] WebSocket access from a0d7b954_vscode

How can I get the home assistant container up and running?

[DavidFW1960 (David)]

check you don’t have ip_bans.yaml blocking your ip address

[Anwen]

I don’t have an ip_bans.yaml. I really truly appreciate your help but we probably shouldn’t be doing all this in this thread. If you have any other ideas, feel free to PM me.

[nickrout]

@SkynetNexus

I saw there was another upgrade 106.5, so I upgraded and Samba started working again.

So how do you think upgrading HA core is going to make samba work?

[dgaust]

@Anwen

I don’t have an ip_bans.yaml. I really truly appreciate your help but we probably shouldn’t be doing all this in this thread. If you have any other ideas, feel free to PM me.

I don’t have a solution, but I have the exact same problem.

[Martso]

@ptdalen

Has anyone else noticed that the iOS app /presense is now reported much more often. I’ve been home all day, it reports that I’ve been home all day, but I have logbook entries every 5-10 minutes saying i’m home. I cannot see a state change

Yes, it looks like the Logbook spam was fixed in 0.106.5 by this pull:

Filter out duplicate logbook states

It seems like every update previously had a state record, just without updating last_changed. So hopefully no increase in db bloat? When I’m driving a lot OwnTracks can send a couple thousand updates in a day.

Wonder if this makes the Map location more accurate, or would trigger automations in more situations?

[Anwen]

There’s more people with the same problem here. I’m glad to know it’s not just me.

[Mariusthvdb (Marius)]

without changing anything in the recorder or plugwise settings (climate.kantoor), after updating to 106.5, my log is spammed with:

2020-03-05 16:27:18 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._exceptions.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: ('climate', 'climate.kantoor', 'auto', '{"hvac_modes": ["heat", "auto"], "min_temp": 4, "max_temp": 30, "preset_modes": ["away", "vacation", "no_frost", "asleep", "home"], "current_temperat ... (916 characters truncated) ... \',\\n            cooling:\'mdi:snowflake\',\\n            auto:\'mdi:autorenew\'}\\nreturn icon[action] ? icon[action] : \'mdi:pause-circle\';\\n"}}', 49994523, datetime.datetime(2020, 3, 5, 15, 19, 52, 318206, tzinfo=<UTC>), datetime.datetime(2020, 3, 5, 15, 19, 52, 318206, tzinfo=<UTC>), datetime.datetime(2020, 3, 5, 15, 26, 27, 871974), 'e7f0b3bd7redacted74', None)]
(Background on this error at: http://sqlalche.me/e/e3q8)

and it is the only recorder issue mentioned.
not its not, few other entities are mentioned also…

2020-03-05 16:42:21 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (MySQLdb._exceptions.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s)]
[parameters: ('state_changed', '{"entity_id": "input_number.alarmclock_wd_hour", "old_state": null, "new_state": {"entity_id": "input_number.alarmclock_wd_hour", "state": "7.0", "at ... (245 characters truncated) ... :00", "last_updated": "2020-03-05T15:19:53.217977+00:00", "context": {"id": "5b3a29e9a1834a4cbb7814d26c881807", "parent_id": null, "user_id": null}}}', 'LOCAL', datetime.datetime(2020, 3, 5, 15, 19, 53, 218038, tzinfo=<UTC>), datetime.datetime(2020, 3, 5, 15, 41, 28, 8334), '5b3aredactedd26c881807', None)]
(Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
2020-03-05 16:42:21 ERROR (Recorder) [homeassistant.components.recorder] Error in database update. Could not save after 11 tries. Giving up
2020-03-05 16:43:12 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._exceptions.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s)]
[parameters: ('state_changed', '{"entity_id": "variable.virtual_light_daylight", "old_state": null, "new_state": {"entity_id": "variable.virtual_light_daylight", "state": "off : 1 : ... (141 characters truncated) ... :00", "last_updated": "2020-03-05T15:19:53.224020+00:00", "context": {"id": "e00e923122b34aa88c5224bbd75a50d8", "parent_id": null, "user_id": null}}}', 'LOCAL', datetime.datetime(2020, 3, 5, 15, 19, 53, 224085, tzinfo=<UTC>), datetime.datetime(2020, 3, 5, 15, 42, 21, 907690), 'e00e92redacted4bbd75a50d8', None)]
(Background on this error at: http://sqlalche.me/e/e3q8)

anyone else seeing this?

@bouwew would you know what causes this?

[Mariusthvdb (Marius)]

also, in a separate post for visibility:

still seeing:

2020-03-05 16:47:58 ERROR (MainThread) [homeassistant.components.hue.light] Error fetching group data: 
2020-03-05 16:48:18 ERROR (MainThread) [homeassistant.components.hue.light] Error fetching group data: 
2020-03-05 16:48:23 ERROR (MainThread) [homeassistant.components.hue.sensor_base] Error fetching sensor data: 
2020-03-05 16:48:27 ERROR (MainThread) [homeassistant.components.hue.light] Error fetching light data: 
2020-03-05 16:48:42 ERROR (MainThread) [homeassistant.components.hue.light] Error fetching group data: 

in an undesirable quantity.
not fixed at all I am afraid, now how to ping Balloob without tagging him…

[dap35]

Try stopping HA and deleting the database. It will recreate on startup.

[Mariusthvdb (Marius)]

k, thanks, using mariadb though so no database in the /config to delete I am afraid.

[VDRainer]

Have you restarted the mariadb?

[Mariusthvdb (Marius)]

just did, restarting, let’s see what happens. thanks. I could witness a successful MariaDB restart fortunately.

[firstof9]

If it comes down to it you could drop the HA tables

[scfigg (Figg)]

Anyone know how frequently the coronavirus integration updates? Been 40 minutes for me now - not that it’s vital - just was comparing the numbers in the integration versus the actual site, and they are different.

[Anwen]

Just want to follow up that a solution has been found to the issue I posted yesterday about HA not starting…see https://github.com/home-assistant/core/issues/32514. It gets us back up and running, but something still needs to be fixed so it doesn’t happen to begin with…

[nickrout]

Looks like hourly. source