0.92: HEOS, Somfy MyLink, Genius Hub

aidbish · April 25, 2019, 2:53pm

a couple of releases back custom components were under custom componentes foder inthe follwoing format
for example for sensors

custom_components/sensor/customcomponentname.py
now
custom_components/customcomponentname/sensor.py

knobunc · April 25, 2019, 2:55pm

I had to create empty __init__.py files in a couple of custom component directories, and that did the trick.

bachoo786 · April 25, 2019, 2:56pm

thats correct I didnt know but I already have that however my google_geocode sensor has stopped working since 0.92

aidbish · April 25, 2019, 2:59pm

It does seem the documentation contradicts each other.

troy · April 25, 2019, 3:02pm

So I upgraded from 91.3 and now I can no longer connect to Home Assistant.

The web page says “refused to connect”

I don’t have any errors in my log so I’m not sure what to troubleshoot but it seems like startup is just hanging up. I’m just running HA in virtualenv.

Any ideas? Not sure where to start since I see no errors. Thanks!

ramonvanbiljouw · April 25, 2019, 3:06pm

You can make google_geocode work!
Rename the folder to: google_geocode
Rename the file: from google_geocode.py to sensor.py
In the folder create a file called: manifest.json with the following content:
{
“domain”: “google_geocode”,
“name”: “Google Geocode”,
“documentation”: “https://github.com/michaelmcarthur/GoogleGeocode-HASS”,
“requirements”: [],
“dependencies”: [],
“codeowners”: []
}

Restart home assistant two times!

walt · April 25, 2019, 3:17pm

Your frontend hasn’t loaded – Give it 10 minutes max and then restart it. If it still doesn’t work, you’ll need to go through the log and see what is happening. Usual case is a pypi module that is taking a long time to install.

ronschaeffer · April 25, 2019, 3:36pm

Getting lots of sql errors since upgrading to 0.92. Assuming that home-assistant_v2.db was corrupted, I deleted it and restarted several times. The home-assistant_v2.db file was recreated each time, but the errors persist.

Example errors from the log:

Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:12.024002', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:12.024002', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:09.012289', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:09.012289', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:06.000906', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:06.000906', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:02.992789', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "switch.dryer", "old_state": {"entity_id": "switch.dryer", "state": "on", "attributes": {"current_power_w": "0.55", "total_energy_kwh": ... (633 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:38.165595+00:00", "context": {"id": "ff4501c4b08f4cbfa2b23f073e0b3a67", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:38.165685', '2019-04-25 15:23:02.992789', 'ff4501c4b08f4cbfa2b23f073e0b3a67', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database update. Could not save after 11 tries. Giving up
4:23 PM components/recorder/__init__.py (ERROR)
Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:23:02.989722', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:23 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:23:02.989722', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:23 PM components/recorder/util.py (ERROR)
Error in database connectivity: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:22:59.981485', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)
4:22 PM components/recorder/__init__.py (ERROR)
Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.json_time", "old_state": {"entity_id": "sensor.json_time", "state": "03:11:03 PM", "attributes": {"date": "04-25-2019", "millis ... (491 characters truncated) ... :00", "last_updated": "2019-04-25T15:11:34.195455+00:00", "context": {"id": "a44f4a77ee5741d49225c2af03215ab7", "parent_id": null, "user_id": null}}}', 'LOCAL', '2019-04-25 15:11:34.195617', '2019-04-25 15:22:59.981485', 'a44f4a77ee5741d49225c2af03215ab7', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
4:22 PM components/recorder/util.py (ERROR)

GaryK · April 25, 2019, 3:48pm

I’m getting this error also.

awarecan · April 25, 2019, 3:59pm

That is not correct. manifest.json IS OPTIONAL for custom component.

matisaul · April 25, 2019, 4:08pm

After update, I had problems With Xiaomi Gateway:

No gateway discovered
12:04 components/xiaomi_aqara/__init__.py (ERROR)

Nothing changes in this platform??

bachoo786 · April 25, 2019, 4:25pm

@ramonvanbiljouw @aidbish thanks that done the trick

frenck · April 25, 2019, 4:27pm

All community add-ons have been updated this morning to add all the icons.

Petrica · April 25, 2019, 4:57pm

Same effect here (not sure if the same cause): no error/warning on 0.91.4 but frontend fails to load on 0.92 even after 1 hour (virtualenv on NUC so not an under powered device). Hass process started but it hangs on the same memory load.

What does the log show (sudo systemctl status [email protected] -l)?

Found this in mine [homeassistant.components.recorder] Ended unfinished session which is quite generic.

Funny fact is that custom potential breaking changes sensor does show 5 entries (although I don’t have set either Insteon or MQTT Discovery and I already changed tts entry to google_translate) so I’ll start disabling components one by one to find the culprit

22710 { "component": "homeassistant", "prlink": "https://github.com/home-assistant/home-assistant/pull/22710", "doclink": "https://www.home-assistant.io/components/None", "description": "Remove deprecated Insteon components " }
22717 { "component": "homeassistant", "prlink": "https://github.com/home-assistant/home-assistant/pull/22717", "doclink": "https://www.home-assistant.io/components/None", "description": "Load requirements and dependencies from manifests. Fallback to current &lt;code&gt;REQUIREMENTS and &lt;code&gt;DEPENDENCIES " }
22878 { "component": "media_player", "prlink": "https://github.com/home-assistant/home-assistant/pull/22878", "doclink": "https://www.home-assistant.io/components/media_player", "description": "Check for supported features in media_player services " }
22998 { "component": "mqtt", "prlink": "https://github.com/home-assistant/home-assistant/pull/22998", "doclink": "https://www.home-assistant.io/components/mqtt", "description": "Deprecate implicit state_topic for MQTT discovery " }
23090 { "component": "google", "prlink": "https://github.com/home-assistant/home-assistant/pull/23090", "doclink": "https://www.home-assistant.io/components/google", "description": "Rename google/tts.py to google_translate/tts.py " }

m0wlheld · April 25, 2019, 5:19pm

Do you have the Flux component configured? I have and it prevents HA from starting since 0.92.0.

The appropriate bug has already been reported at Github.

ajoyce · April 25, 2019, 5:25pm

0.92 appears to break Google Maps device tracking once again:

Error setting up platform google_maps
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/homeassistant/components/device_tracker/__init__.py", line 177, in async_setup_platform
    disc_info)
  File "/usr/local/lib/python3.7/concurrent/futures/thread.py", line 57, in run
    result = self.fn(*self.args, **self.kwargs)
  File "/usr/local/lib/python3.7/site-packages/homeassistant/components/google_maps/device_tracker.py", line 39, in setup_scanner
    scanner = GoogleMapsScanner(hass, config, see)
  File "/usr/local/lib/python3.7/site-packages/homeassistant/components/google_maps/device_tracker.py", line 60, in __init__
    self._update_info()
  File "/usr/local/lib/python3.7/site-packages/homeassistant/components/google_maps/device_tracker.py", line 72, in _update_info
    for person in self.service.get_all_people():
  File "/usr/local/lib/python3.7/site-packages/locationsharinglib/locationsharinglib.py", line 439, in get_all_people
    people = self.get_shared_people() + [self.get_authenticated_person()]
  File "/usr/local/lib/python3.7/site-packages/locationsharinglib/locationsharinglib.py", line 400, in get_shared_people
    for info in output[0]:
TypeError: 'NoneType' object is not iterable

Usual fixes like deleting the cookie file and restarting twice do not seem to working unfortunately.

However - everything else is fantastic! Native Hue sensor integration is working perfectly for me and really enjoying having live streams from my cameras in Lovelace

fernandex00 · April 25, 2019, 5:27pm

thank you, all the components now work except for places https://github.com/tenly2000/HomeAssistant-Places
is the only component that dont work after the update

sunglass_guy · April 25, 2019, 6:23pm

still no success updating, just restarts in 0.91.4, any help on how i can debug this is much appreciated

Petrica · April 25, 2019, 6:25pm

That did the trick. It is strange that the component simply drags and doesn’t throw any error message.

Thanks @m0wlheld!

Schneider · April 25, 2019, 6:29pm

Hello guys!

I believe there are missing documentation as broadlink component has a breaking change. Here, it did not work anymore since the service call has changed. Now all services must be like this:

script:

  persiana_quarto_abrir:
    sequence:
    - service: broadlink.send
      data:
        host: 192.168.1.32
        packet: sgGEAwwUDBQXCgwUDBUMFAwVDBQMFAwUDBUWCgwVFgoWChcKDBQMFBcMoVA2CgwVFgoMFAwUFwoWCgwVFgodghjRcKDBQMFQwUDBQMFQwUFgoNFAwUDBQXCgwUDBUMFBYKDBUMFAwUDBUMFAwUDBUMFBYLCxUWChcKFgoMFAwVFgyhUDcKCxUWCgwVDBQWChcKDBQWChcKFgoMFAwVDBQMFAwVDBQXCgwUDBQMFRYKDBUMFAwdghjoMFQwUDBQMFQwUDBUMFAwUFwoMFBcKFgoWCgwVDBQWDKFRNgoMFBcKDBQMFBcJFwoMFBcKFgoWCgwUDBUMFAwVDBQMFBcKDBQMFQwUFgoMFQwUDBQXCgwUDBUMFAwUtryFAwUDBUWCgwVFgoWChcJDRQMFBcMoVA2CgwVFgoMFAwVFgoWCgwVFgoWChcKDBQMFAwVDBQMFAwVFgoMFQwUDBQXCQ0UDBQMFRYKDBUMFAwUDBUMFAwVDBQMFBcJDBUWChcJFwoMFAwUFwyhUDcJDBQXCgwUDBUWChcJDBUWChcKFgoMFA0UDBQMFQwUDBQWCgwVDBQMFRYKDBQMFQwUFwkMFQwUDBUMFAwUDBUMFAwUFwoMFBcJFwoWCgwUDRQWDKFRNgoMFBYKDBULFRcKFgoMFBYKFwoWCgwVDBQMFAwUDBUMFBcKDBQMFA0UFgoMFQwghfQXCgwUDBQMFQwUDBUMFAwUDBUWCgwUFwoWChcJDBUMFBcMoVAgfdUFwoMFAwUFwoWCgwUFwoWChcKDBQMFAwVDBQMFAwVFgoMFQwUDBQXCgwUDBQMFRYKDBQMFQwUDBQMFQwUDBUMFBYKDBQXChcJFwoMFAwUFwyhUDcJDBQXCgwUDBQXChYKDBUWChcJFwoMFAwVDBQMFAwVDBQWCgwVCxUMFRYKDBQMFQwUFgoMFQwUDBUMFAwUDBUMFAwUFwoMFBYKFwkXCgwVDBMXDKFQNwkMFRYKDBUMFBYKFwoMFBcJFwkXCgwUDBUMFAwVDBQMFBcKDBQMFQwUFgoMFQdghjBQXCgwUDBQMFQwUDBQMFQwUDBQXCgwUFwoWChYKDBUMFBcMoVA2CgwUFgoMFQwUFwoWCgwUFwkXChYKDRQMFAwUDBUMFAwVFgoMFQwUDBrtygwVDBQMFRYKDBQNFAwUDBQMFQwUDBQMFRYKDBUWChYKFwoMFAwUFwAF3AAAAAA==

Thanks.