2021.4: For our advanced users ❤️

Blog
551

I know lots of people have already done the 2021.4.X upgrade including the database migration, but I wanted to add my data point on the database migration in case people like me were waiting.

Synology DS1515+ (Intel C2538 2.4GHz Quad Core)
DSM 6.2.4-25556 / Docker 18.09.0-0519
HA Container 2021.4.3
MariaDB 10.5.1 (Official Container Image)
Database Size ~ 7.8Gb
Monitoring with phpMyAdmin (Official Container Image)

Started new HA Container and DB upgrade took just shy of 7 hours. Frontend came up and best of all the states of things like my manual alarm panel were properly restored.

552

Hi,
The upgrade breaks mysql connection with an old server (Server version: 5.1.73). It worked with the previous one, then HA cannot start normally.
Log is in Cannot connect to (old) mysql after April update · Issue #49096 · home-assistant/core · GitHub

553

I might not be an advanced enough user for this, but has anyone else seen these info loggings, (which I have never seen before):

2021-04-12 09:09:53 INFO (MainThread) [backoff] Backing off get_scenarios(...) for 0.8s (aiohttp.client_exceptions.ServerDisconnectedError: Server disconnected)

it’s there on each restart now.

554

Very nice to see stats of how most users uses HA.

Is there a way to see my own stats in my Configuration → Info page? For easy direct comparison against Analytics average page.

  • Number of integrations (with/without internal)
  • Number of entities
  • Number of automations
555

Try this in the template editor:

{%- for d in states | groupby('domain') %}
{{ d[0] }} - {{ states[d[0]] | count  }}
{%- endfor %}

More here:

2 Likes
558

That’s info, not an error

559

ok, edited in the message

other than correcting that, would you know what it refers to?

564

this is a known issues, mysql requires at least 5.7

565

Did you solve this?
I recently have had the same issue.
Removed the integration and readd did not help.
But after that, I had to reconfigure mode and language. After that, it was fixed by magic :smiley:
I love those self healing issue… not.

567

Same here. I raised the issue on Github and was told (rather rudely) to fix my template… :roll_eyes:

568

Can you provide a link to the github issue you raised?

569

don’t use the states object, just feed the entity_id to expand.

          {{ expand('group.echos') ...
570

Thanks for the tip. I just tried this in the Dev Tools-> Template
{{ expand(group.echos) }}
and it says UndefinedError: ‘group’ is undefined
However {{expand(states.group.echos}} works without errors.
And Dev Tools-> group.echos does list out all the entity_ids in its attributes.
Wonder what else to try?

571

I also have this problem and get the same error codes in the home-assistant.log file. Did you find a solution to this?

572

Yes, look at my example, then what you wrote. You’ll notice they don’t match. Hint: You’re missing characters.

573

Ah yes…thanks :slight_smile:

1 Like
574

I also replied on your github issue, if you don’t understand the fixes make a forum post and tag me.

575

Again, thanks for your help. I just tried the expand('group.echos') in my config ( then rebooted HA). The template works, but still get the same log entry warning…Template variable warning: No first item, sequence was empty. when rendering.

576

Then it’s coming from the | first filter. You can probably safely ignore that warning without any repercussion. Otherwise you’ll have to check if there’s items in the list before collecting them.

1 Like
577

I believe a fix is in the works, best to keep an eye on this thread -

1 Like