2023.2.0b8

• Bump env_canada to 0.5.27 (@michaeldavie - #86996)
• Bump ESPHome Dashboard API 1.2.3 (@balloob - #86997)
• Bump plugwise to v0.27.5 (@bouwew - #87001)
• Only report invalid numeric value for sensors once (@frenck - #87010)
• Honeywell Correct key name (@mkmer - #87018)
• Bump home-assistant-intents to 2023.1.31 (@synesthesiam - #87034)
• Add a repair issue when using MariaDB is affected by MDEV-25020 (@bdraco - #87040)
• Fix Yamaha MusicCast zone sleep select entity (@frenck - #87041)
• Improve JSON errors from HTTP view (@balloob - #87042)