Homeassistant

- Fix NMBS AttributeError ([PatrickGlesner] - [90525]) ([nmbs docs])
- Bump websockets constraint to 11.0.1+ ([bdraco] - [90901]) ([ambient_station docs]) ([vallox docs])
- Raise an issue for legacy SQL queries that will cause full table scans ([bdraco] - [90971]) ([sql docs])
- Resume entity id post migration after a restart ([bdraco] - [90973]) ([recorder docs])
- Bump vallox-websocket-api to 3.2.1 ([bdraco] - [90980]) ([vallox docs])
- Bump `aioambient` to 2023.04.0 ([bachya] - [90991]) ([ambient_station docs])
- Bump roombapy to 1.6.8 ([joostlek] - [91012]) ([roomba docs])
- Delay utility_meter until HA has started ([dgomes] - [91017]) ([utility_meter docs])
- Make sure upnp-router is also initialized when first seen through an advertisement ([StevenLooman] - [91037]) ([upnp docs])
- Bump ZHA quirks lib ([dmulcahey] - [91054]) ([zha docs])
- Fix Smartthings acceleration sensor in ZHA ([dmulcahey] - [91056]) ([zha docs])
- Bump zeroconf to 0.55.0 ([bdraco] - [90987]) ([zeroconf docs])
- Bump zeroconf to 0.56.0 ([bdraco] - [91060]) ([zeroconf docs])
- Make location optional in google calendar create service ([allenporter] - [91061]) ([google docs])
- Bump gcal_sync to 4.1.4 ([allenporter] - [91062]) ([google docs])
- Bump subarulink to 0.7.6 ([G-Two] - [91064]) ([subaru docs])
- Bump env_canada to v0.5.31 ([michaeldavie] - [91094]) ([environment_canada docs])
- Fix context_user_id round trip when calling to_native ([bdraco] - [91098]) ([recorder docs])
- Bump flux_led to 0.28.37 ([bdraco] - [91099]) ([flux_led docs])
- Make the device_tracker more forgiving when passed an empty ip address string ([bdraco] - [91101]) ([device_tracker docs])

[90525]: https://github.com/home-assistant/core/pull/90525
[90855]: https://github.com/home-assistant/core/pull/90855
[90901]: https://github.com/home-assistant/core/pull/90901
[90956]: https://github.com/home-assistant/core/pull/90956
[90971]: https://github.com/home-assistant/core/pull/90971
[90973]: https://github.com/home-assistant/core/pull/90973
[90980]: https://github.com/home-assistant/core/pull/90980
[90987]: https://github.com/home-assistant/core/pull/90987
[90991]: https://github.com/home-assistant/core/pull/90991
[91012]: https://github.com/home-assistant/core/pull/91012
[91017]: https://github.com/home-assistant/core/pull/91017
[91037]: https://github.com/home-assistant/core/pull/91037
[91054]: https://github.com/home-assistant/core/pull/91054
[91056]: https://github.com/home-assistant/core/pull/91056
[91060]: https://github.com/home-assistant/core/pull/91060
[91061]: https://github.com/home-assistant/core/pull/91061
[91062]: https://github.com/home-assistant/core/pull/91062
[91064]: https://github.com/home-assistant/core/pull/91064
[91094]: https://github.com/home-assistant/core/pull/91094
[91098]: https://github.com/home-assistant/core/pull/91098
[91099]: https://github.com/home-assistant/core/pull/91099
[91101]: https://github.com/home-assistant/core/pull/91101
[G-Two]: https://github.com/G-Two
[PatrickGlesner]: https://github.com/PatrickGlesner
[StevenLooman]: https://github.com/StevenLooman
[allenporter]: https://github.com/allenporter
[bachya]: https://github.com/bachya
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[dgomes]: https://github.com/dgomes
[dmulcahey]: https://github.com/dmulcahey
[frenck]: https://github.com/frenck
[joostlek]: https://github.com/joostlek
[michaeldavie]: https://github.com/michaeldavie
[actiontec docs]: https://www.home-assistant.io/integrations/actiontec/
[advantage_air docs]: https://www.home-assistant.io/integrations/advantage_air/
[airly docs]: https://www.home-assistant.io/integrations/airly/
[ambient_station docs]: https://www.home-assistant.io/integrations/ambient_station/
[device_tracker docs]: https://www.home-assistant.io/integrations/device_tracker/
[environment_canada docs]: https://www.home-assistant.io/integrations/environment_canada/
[flux_led docs]: https://www.home-assistant.io/integrations/flux_led/
[google docs]: https://www.home-assistant.io/integrations/google/
[nmbs docs]: https://www.home-assistant.io/integrations/nmbs/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[roomba docs]: https://www.home-assistant.io/integrations/roomba/
[sql docs]: https://www.home-assistant.io/integrations/sql/
[subaru docs]: https://www.home-assistant.io/integrations/subaru/
[upnp docs]: https://www.home-assistant.io/integrations/upnp/
[utility_meter docs]: https://www.home-assistant.io/integrations/utility_meter/
[vallox docs]: https://www.home-assistant.io/integrations/vallox/
[zeroconf docs]: https://www.home-assistant.io/integrations/zeroconf/
[zha docs]: https://www.home-assistant.io/integrations/zha/

- Handle Uncaught exceptions in async_update Honeywell ([mkmer] - [90746]) ([honeywell docs])
- Bump fritzconnection to 1.12.0 ([saschaabraham] - [90799]) ([fritz docs]) ([fritzbox_callmonitor docs])
- Fix issue with Insteon All-Link Database loading ([teharris1] - [90858]) ([insteon docs])
- Generate a seperate log message per dumped object for profiler.dump_log_objects ([bdraco] - [90867]) ([profiler docs])
- Add constraint for websockets to <11.0 ([bdraco] - [90868])
- Add MariaDB deadlock retry wrapper to database timestamp column migrations ([bdraco] - [90880]) ([recorder docs])
- Migrate entity unique ids in PI-Hole ([mib1185] - [90883]) ([pi_hole docs])
- Fix missing bluetooth client wrapper in bleak_retry_connector ([bdraco] - [90885]) ([bluetooth docs])
- Bump ulid-transform 0.6.0 ([bdraco] - [90888])
- Guard against invalid ULIDs in contexts while recording events ([bdraco] - [90889]) ([recorder docs])
- Fix entity_id migration query failing with MySQL 8.0.30 ([bdraco] - [90895]) ([recorder docs])
- Bump `simplisafe-python` to 2023.04.0 ([bachya] - [90896]) ([simplisafe docs])
- Bump aiodiscover to 1.4.16 ([bdraco] - [90903]) ([dhcp docs])
- Return empty available programs list if an appliance is off during initial configuration ([stickpin] - [90905]) ([home_connect docs])
- Handle NoURLAvailableError in Nuki component ([pree] - [90927]) ([nuki docs])
- Update frontend to 20230406.1 ([bramkragten] - [90951]) ([frontend docs])
- Fix flaky test in vesync ([epenet] - [90921]) ([vesync docs])
- Bump `aioambient` to 2022.10.0 ([bachya] - [90940]) ([ambient_station docs])
- Bump reolink-aio to 0.5.10 ([starkillerOG] - [90963]) ([reolink docs])
- Avoid writing state to all esphome entities at shutdown ([bdraco] - [90555]) ([esphome docs])
- Fix state being cleared on disconnect with deep sleep esphome devices ([bdraco] - [90925]) ([esphome docs])
- Coerce previously persisted local calendars to have valid durations ([allenporter] - [90970]) ([local_calendar docs])
- Bump gcal_sync to 4.1.3 ([allenporter] - [90968]) ([google docs])
- Fix error after losing an imap connection ([jbouwh] - [90966]) ([imap docs])
- Fix command_template sensor value_template not being used if json_attributes set ([gadgetchnnel] - [90603]) ([command_line docs])
- Fix verisure autolock ([heiparta] - [90960]) ([verisure docs])

[90555]: https://github.com/home-assistant/core/pull/90555
[90603]: https://github.com/home-assistant/core/pull/90603
[90855]: https://github.com/home-assistant/core/pull/90855
[90925]: https://github.com/home-assistant/core/pull/90925
[90956]: https://github.com/home-assistant/core/pull/90956
[90960]: https://github.com/home-assistant/core/pull/90960
[90966]: https://github.com/home-assistant/core/pull/90966
[90968]: https://github.com/home-assistant/core/pull/90968
[90970]: https://github.com/home-assistant/core/pull/90970
[allenporter]: https://github.com/allenporter
[balloob]: https://github.com/balloob
[bdraco]: https://github.com/bdraco
[frenck]: https://github.com/frenck
[gadgetchnnel]: https://github.com/gadgetchnnel
[heiparta]: https://github.com/heiparta
[jbouwh]: https://github.com/jbouwh
[actiontec docs]: https://www.home-assistant.io/integrations/actiontec/
[advantage_air docs]: https://www.home-assistant.io/integrations/advantage_air/
[airly docs]: https://www.home-assistant.io/integrations/airly/
[command_line docs]: https://www.home-assistant.io/integrations/command_line/
[esphome docs]: https://www.home-assistant.io/integrations/esphome/
[google docs]: https://www.home-assistant.io/integrations/google/
[imap docs]: https://www.home-assistant.io/integrations/imap/
[local_calendar docs]: https://www.home-assistant.io/integrations/local_calendar/
[verisure docs]: https://www.home-assistant.io/integrations/verisure/
[90746]: https://github.com/home-assistant/core/pull/90746
[90799]: https://github.com/home-assistant/core/pull/90799
[90855]: https://github.com/home-assistant/core/pull/90855
[90858]: https://github.com/home-assistant/core/pull/90858
[90867]: https://github.com/home-assistant/core/pull/90867
[90868]: https://github.com/home-assistant/core/pull/90868
[90880]: https://github.com/home-assistant/core/pull/90880
[90883]: https://github.com/home-assistant/core/pull/90883
[90885]: https://github.com/home-assistant/core/pull/90885
[90888]: https://github.com/home-assistant/core/pull/90888
[90889]: https://github.com/home-assistant/core/pull/90889
[90895]: https://github.com/home-assistant/core/pull/90895
[90896]: https://github.com/home-assistant/core/pull/90896
[90903]: https://github.com/home-assistant/core/pull/90903
[90905]: https://github.com/home-assistant/core/pull/90905
[90921]: https://github.com/home-assistant/core/pull/90921
[90927]: https://github.com/home-assistant/core/pull/90927
[90940]: https://github.com/home-assistant/core/pull/90940
[90951]: https://github.com/home-assistant/core/pull/90951
[90963]: https://github.com/home-assistant/core/pull/90963
[bachya]: https://github.com/bachya
[bdraco]: https://github.com/bdraco
[bramkragten]: https://github.com/bramkragten
[epenet]: https://github.com/epenet
[frenck]: https://github.com/frenck
[mib1185]: https://github.com/mib1185
[mkmer]: https://github.com/mkmer
[pree]: https://github.com/pree
[saschaabraham]: https://github.com/saschaabraham
[starkillerOG]: https://github.com/starkillerOG
[stickpin]: https://github.com/stickpin
[teharris1]: https://github.com/teharris1
[actiontec docs]: https://www.home-assistant.io/integrations/actiontec/
[advantage_air docs]: https://www.home-assistant.io/integrations/advantage_air/
[airly docs]: https://www.home-assistant.io/integrations/airly/
[ambient_station docs]: https://www.home-assistant.io/integrations/ambient_station/
[bluetooth docs]: https://www.home-assistant.io/integrations/bluetooth/
[dhcp docs]: https://www.home-assistant.io/integrations/dhcp/
[fritz docs]: https://www.home-assistant.io/integrations/fritz/
[fritzbox_callmonitor docs]: https://www.home-assistant.io/integrations/fritzbox_callmonitor/
[frontend docs]: https://www.home-assistant.io/integrations/frontend/
[home_connect docs]: https://www.home-assistant.io/integrations/home_connect/
[honeywell docs]: https://www.home-assistant.io/integrations/honeywell/
[insteon docs]: https://www.home-assistant.io/integrations/insteon/
[nuki docs]: https://www.home-assistant.io/integrations/nuki/
[pi_hole docs]: https://www.home-assistant.io/integrations/pi_hole/
[profiler docs]: https://www.home-assistant.io/integrations/profiler/
[recorder docs]: https://www.home-assistant.io/integrations/recorder/
[reolink docs]: https://www.home-assistant.io/integrations/reolink/
[simplisafe docs]: https://www.home-assistant.io/integrations/simplisafe/
[vesync docs]: https://www.home-assistant.io/integrations/vesync/

https://www.home-assistant.io/blog/2023/04/05/release-20234/

- Fix bluetooth_le_tracker reporting devices Home when they leave (ProtoxiDe22 - 90641)
- Add entity name translations to SMS (mib1185 - 90727)
- Add entity name translations to Tractive (bieniu - 90738)
- SharkIQ Hotfix - Handle current installations by using default `REGION` (funkybunch - 90741)
- Add entity name translations to NextDNS (bieniu - 90743)
- Bump zeroconf to 0.54.0 (bdraco - 90744)
- Prevent overly large event data from being stored in the database (bdraco - 90747)
- Restore state for ZHA OnOff binary sensors (TheJulianJES - 90749)
- Bump aiohomekit to 2.6.3 (bdraco - 90752)
- Add render count to templates repr (bdraco - 90753)
- Fix frontend test again (balloob - 90754)
- Update template environment from the event loop (emontnemery - 90758)
- Fix recovering imap connection triggers re-auth (jbouwh - 90762)
- Add async_write_ha_state to Reolink select (starkillerOG - 90764)
- Address late review for NextDNS entity name translations (bieniu - 90771)
- Add Warning in the issue registry if a HTTPS webhook is used for Nuki (pree - 90718)
- Add translations for Nuki entity name and battery critical state attribute (Nardol - 90772)
- Add entity name translations to Broadlink sensors (Nardol - 90783)

- Remove Darksky integration (gjohansson-ST - 90322)
- Use entity name translations in Fronius (farmio - 90463)
- Raise repair issue if OTBR and ZHA are on different channels (emontnemery - 90494)
- Correct handling if WIFI combine suffix is "None" (N3rdix - 90528)
- Add entity name translations to Plugwise (frenck - 90537)
- Add entity name translations to Switchbot (Nardol - 90600)
- Bump env_canada to v0.5.30 (michaeldavie - 90644)
- Ensure system log does not raise while processing logger messages (bdraco - 90652)
- Add entity name translations to NAM (bieniu - 90681)
- Use the default entity names in Airly (bieniu - 90693)
- Use entity name translations in 1-wire (epenet - 90696)
- Use entity name translations in Renault (epenet - 90697)
- Use entity name translations in SFR Box (epenet - 90698)
- Fix ha version in EDL21 deprecation warning (StephanU - 90699)
- Use the default entity names in GIOS (bieniu - 90700)
- Add entity name translations to BraviaTV (bieniu - 90702)
- Add entity name translations to AVM Fritz!Tools (mib1185 - 90703)
- Add entity name translations to Synology DSM (mib1185 - 90706)
- Add entity name translations to AVM Fritz!SmartHome (mib1185 - 90707)
- Add entity name translations to NUT (mib1185 - 90709)
- Fix Livisi climate min/max temperature (planbnet - 90712)
- Add entity name translations to Pi-hole (mib1185 - 90713)
- Fix translation of status binary sensor in PI-Hole (mib1185 - 90719)
- Fix missing battery sensors for SimpliSafe locks (bachya - 90722)
- Bump pychromecast to 13.0.7 (emontnemery - 90724)
- Add entity name translations to Luftdaten (mib1185 - 90725)
- Add entity name translations to sun (mib1185 - 90732)
- Update frontend to 20230403.0 (bramkragten - 90735)

- Update goodwe library to v0.2.30 (mletenay - 90607)
- Add entity name translations to Brother (bieniu - 90634)
- Add object source logger to profiler (bdraco - 90650)
- Add entity name translations to GIOS (bieniu - 90655)
- Add entity name translations to Airly (bieniu - 90656)
- Bump zeroconf to 0.52.0 (bdraco - 90660)
- Add entity name translations for Nest sensors (Nardol - 90677)
- Fix frontend test (balloob - 90679)
- Bump zeroconf to 0.53.0 (bdraco - 90682)
- Fix default sensor entity name for PM1 (bieniu - 90684)
- Fix memory churn in state templates (bdraco - 90685)