2023.2: How can I Assist?

[ivdimitro (Ivan Dimitrov)]

Were there any power level tuning for bluetooth in this release?
I had zigbee and BT adapter connected to the same hub, very close to each other and I know - not ideal. Up to this release both radios were working OK, but after the upgrade the zigbee can’t create the network if the BT dongle is also plugged.

[Boppie1976]

Hi Xander1,

Indeed a great integration, and the possibility to add static price components would be a good improvement! I’'m new here, so what is te right way to aks for such a improvement?

Greetings, Bob.

[nickrout]

That would be the feature requests section of the forum.

[Boppie1976]

Thanks, I started a topic in that section.

Greetings, Bob.

[gianky69]

After database migration, the table “states” no longer have a date value available in columns last_changed or lastupdated, so my sql max/min serach no longer works:
SELECT MAX(cast(state as decimal)) AS value FROM states WHERE entity_id='sensor.temperatura_giardino' AND state!='unknown' AND datetime(last_updated) >= datetime(date('now'));
How to re-enable it?

[visstro]

Same issue with Zigbee stick not working for me. I fixed it by reverting to 9.4 from the command line:

ha host update --version 9.4

See my reply here:

ZHA stopped working after update

Just updated the base OS (9.4 to 9.5) and have the same issue: FileNotFoundError: [Errno 2] No such file or directory: '/dev/serial/by-id/usb-1a86_USB_Serial-if00-port0' While I can see /dev/serial/by-id/usb-1a86_USB_Serial-if00-port0 under ttyUSB0 in the hardware tab. I don’t have much time for debugging now, but I fixed it by downgrading from the terminal: ha host update --version 9.4

[tom_l]

How can last_updated be greater than or equal to now()?

That implies it updated in the future.

Also now you need to use last_updated_ts

[Protoncek (Pavel)]

I was asking the same thing, if you look a couple (hundred ) posts up you’ll see an answer from guys for my case, i think it’s similar for yours.

[Protoncek (Pavel)]

As strange it may seem, it worked. I guess that’s because date(now) without stating hour/minute was considering today at 00:00, so everything greater than that is today’s value…

[gianky69]

Thanks, I’ve changed it to
SELECT MAX(cast(state as decimal)) AS value FROM states WHERE entity_id='sensor.temperatura_giardino' AND state!='unknown' AND datetime(last_updated_ts,'unixepoch') >= datetime(date('now'));

[osre (Reinhard)]

Since updating to 2023.2.2 Home Assistant runs for a couple of hours and then stops responding.
I have to unplug the hardware to get it running again.
Any Ideas.
I did also update to the latest Zigbee2MQTT recently, but I think the instability started only after HA update.
Any ideas?

[boheme61]

Have you by any chance got inspired to look in your logfiles ?

[osre (Reinhard)]

Yes, I have looked in the logs, but they only start with the HA restart.
Haven’t looked at the file system if there are older log files yet.
There is a MQTT error that is logged every 80 milliseconds which I have posted in the integrations thread already.

[lameuser (nobody)]

What a wonderful release. Updating the MariaDB tables took forever, and there was no telling when it was done.
Even better was that the recorder just broke for the entire period, even after the updating was done, and it took a restart of HA to bring it back and start logging things.
Great stuff.

[teskanoo]

@osre

There is a MQTT error that is logged every 80 milliseconds

If you have something writing to the log file every 80ms, I would imagine it could very quickly either swamp the bus of fill your storage (especially if you use an SD Card)

Are you able to edit your configuration to reduce the logging level to ‘critical’ to prevent the log spam until the issue is resolved?

[parautenbach (Pieter Rautenbach)]

@osre

Haven’t looked at the file system if there are older log files yet.

Please do. It’s near impossible to help with the details provided.

[sickidolderivative (radical-squared)]

@Protoncek

New “last_updated_ts” time format is unknown to me… just a bunch of numbers…?

If you’re using PostgreSQL in your SQL sensor use SELECT TO_TIMESTAMP(last_updated_ts) AS last_updated to extract human readable date from last_updated_ts column.

[arganto]

@arganto

Is there anything I’m doing wrong or is assis: xyz on or xyz off really not working and I always have to (type/say) turn xyz on, turn xyz off? Or only a problem with German language? Example domain: light.

I’m really not used to use this longer version via Alexa and to be honest, it would be better to have it as short as possible as well in internal HA assist.

If I compare to definition

         - "(<licht> | <lichter>) <area> <an><machen>"

shouldn’t it be possible to do this already? Or do I misinterpret the syntax?

“Büro an” is fitting to it. light.buro has the friendly name “Büro” and should be switched on. But it doen’t.

Bug or problem or wrong understanding on my side?

[boheme61]

i don’t know if you encountered same issues as i, but few updates ago (well actually on beta) there i only had to say “turn on/off hallway” … Now i have to say " turn on/off hallway Light" , so it seems like they have added “domän/” as “required” in the request
Edit: which to some degree makes sense … i.e (turn on hallway. Light/ run hallway. Automation/Scene " or turn on hallway. vacuum/temperature/heating/xxx/yyy )

[blackie333]

My sensor template entities with device_class timestamp stopped working after upgrade to 2023.2.2.
Following entity has no value, but value_template shows correct datetime value when tested via Template editor. Not sure what is wrong with the definition now.

    baldr3_last_updated:
      friendly_name: "Baldr3 Last Updated"
      device_class: timestamp
      unit_of_measurement: "datetime"
      value_template: "{{ as_datetime(states('sensor.baldr3_update_time')) }}"