0.116: Entities card row editor, restore snapshots and performance metrics

Yes, all Yeelights are down for me.

2020-10-09 07:49:29 ERROR (MainThread) [homeassistant.config_entries] Error setting up entry Downstairs for light
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/config_entries.py", line 231, in async_setup
    result = await component.async_setup_entry(hass, self)  # type: ignore
  File "/usr/src/homeassistant/homeassistant/components/light/__init__.py", line 287, in async_setup_entry
    return await hass.data[DOMAIN].async_setup_entry(entry)
  File "/usr/src/homeassistant/homeassistant/helpers/entity_component.py", line 140, in async_setup_entry
    platform = await async_prepare_setup_platform(
  File "/usr/src/homeassistant/homeassistant/setup.py", line 298, in async_prepare_setup_platform
    platform = integration.get_platform(domain)
  File "/usr/src/homeassistant/homeassistant/loader.py", line 401, in get_platform
    cache[full_name] = importlib.import_module(
  File "/usr/local/lib/python3.8/importlib/__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
  File "<frozen importlib._bootstrap>", line 991, in _find_and_load
  File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 783, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/usr/src/homeassistant/homeassistant/components/yeelight/light.py", line 140, in <module>
    EFFECT_RANDOM_LOOP: yee_transitions.randomloop,
AttributeError: module 'yeelight.transitions' has no attribute 'randomloop'

Anyone have results for the recorder fix with 0.116.1 yet? My instance experienced the UNIQUE constraint failed error and I have no logbook entries since ~4AM today.

Is the expected solution that updating to 0.116.1 will fix the issue and I’ll just have missing data from 4AM until 0.116.1 installation? Or is the database corrupted and in need of replacement? e.g. stop HA, blow away database, and replace with copy from 0.115.6 backup before corruption, and restart HA

Thanks for your help.

1 Like

Did you figure anything out with this?

Dropping out of order packet: 183510 <= 183510

My log is suddenly filled with this…

me too, works fine in 116.0, but down in 116.1.

Logger: homeassistant.config_entries
Source: components/yeelight/light.py:140
First occurred: 上午9:22:37 (2 occurrences)
Last logged: 上午9:22:37

Error setting up entry yeelight_stripe_0x000000000808140a for light
Error setting up entry yeelight_color6_0x0000000006696fd6 for light
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/config_entries.py", line 231, in async_setup
    result = await component.async_setup_entry(hass, self)  # type: ignore
  File "/usr/src/homeassistant/homeassistant/components/light/__init__.py", line 287, in async_setup_entry
    return await hass.data[DOMAIN].async_setup_entry(entry)
  File "/usr/src/homeassistant/homeassistant/helpers/entity_component.py", line 140, in async_setup_entry
    platform = await async_prepare_setup_platform(
  File "/usr/src/homeassistant/homeassistant/setup.py", line 298, in async_prepare_setup_platform
    platform = integration.get_platform(domain)
  File "/usr/src/homeassistant/homeassistant/loader.py", line 401, in get_platform
    cache[full_name] = importlib.import_module(
  File "/usr/local/lib/python3.8/importlib/__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
  File "<frozen importlib._bootstrap>", line 991, in _find_and_load
  File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 783, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/usr/src/homeassistant/homeassistant/components/yeelight/light.py", line 140, in <module>
    EFFECT_RANDOM_LOOP: yee_transitions.randomloop,
AttributeError: module 'yeelight.transitions' has no attribute 'randomloop'

i cant see the media folder in FTP, anyone else have this issue?

just updated to 0.116.1 and all of my yeelights are now showing as Unavailable

1 Like

@gambit2552 The same for me. All Yeelights are unavailable. I have tried to remove yeelight integration in configuration.yaml and install from UI and it does not work either. They appear in integrations but not in all entities of the developer tool. They cannot be used because they are not in home assistant. Please fix it asap in the next update

1 Like

@gambit2552 @janinho, The fix has literally been posted 3 replies above.

@janinho yeah i found it over here
" Problem with yeelight " also.

yeelight also down

Hmmm…yeah, sorting out my lovelace yaml seems to have solved the issue with vertical-stack
Big thanks!!

I see a similar problem after upgrade to 0.116

sqlalchemy.exc.IntegrityError: (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry '19744628' for key 'PRIMARY'")
[SQL: INSERT INTO events (event_id, event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: ((19744628, 'state_changed', '{}', 'LOCAL', datetime.datetime(2020, 10, 9, 2, 12, 28, 31937, tzinfo=<UTC>), datetime.datetime(2020, 10, 9, 2, 12, 28, 569438, tzinfo=<UTC>), 'e12aa7ba09d411eb9afed9eb6a285667', None, None), (19744599, 'state_changed', '{}', 'LOCAL', datetime.datetime(2020, 10, 9, 2, 12, 26, 569276, tzinfo=<UTC>), datetime.datetime(2020, 10, 9, 2, 12, 27, 197492, tzinfo=<UTC>), 'e04b79a609d411eb88ca951a8a542c20', None, None))]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

I guess I have to roll back to 0.115.6

You could delete the database (.db2), it will build a new one

I believe this isn’t because type isnt a valid option for views. It’s because it actually is now a valid option for views:

It allows developers to create custom view layouts but, because horizontal-stack is not a view layout (it’s a card), it is giving that error.

Actually for me it does not work in Safari… but indeed I checked with Chrome and it there! Waiting for update then :slight_smile:

cache problem with safari??

Hi
I have a question about updating in automations because some automations where I specified brightness with a certain value stopped working for me. This happened when I switched from 115.6 on 116.0
What is meant here?
“State conditions with attribute specified: When testing against a non-string attribute value, you now need to specify the value in your configuration in the same type as it is in the attribute (instead of as a string).”

I thought the problem would resolve itself if I upgraded from 116.0 to 116.1, but instead I got a new problem. My Yeelight devices are no longer detected. 1S Color Bulbe and Meteorit… Unfortunately, I can’t provide log entries, because I did a restore back to 115.6.

Hi @aceindy and thanks for your reply.
I moved on to 0.116.1 and the problem seemed to have disappeared.
However, as I use SQLite there is no .db2 to delete (am I right?)