SQL Sensor stopped working

Configuration
1

I’ve had a SQL sensor for a while now to determine a historical value of another sensor. Worked fine, until… it didn’t. Suddenly it stopped updating/working and I’m at a complete loss on why.

/config/sensors/Weather.yaml:

# Buienradar weather data
# https://www.home-assistant.io/integrations/sensor.buienradar/
- platform: buienradar
  monitored_conditions:
    - stationname
    - conditioncode
    - conditioncode_1d
    - condition
    - condition_1d
    - conditiondetailed
    - conditiondetailed_1d
    - conditionexact
    - temperature
    - temperature_1d
    - mintemp_1d
    - mintemp_3d
    - feeltemperature
    - humidity
    - precipitation_forecast_average
    - rainchance_1d
    - rain_1d
    - windspeed
    - irradiance

# Determine max forecasted temperature for 'today'
- platform: sql
  db_url: !secret mariadb_url
  queries:
    - name: max_temp_fcst_today
      query: >
        SELECT date(date_add(last_updated, INTERVAL 1 DAY)) AS date, MAX(state) AS max_temp
        FROM home_assistant.states
        WHERE entity_id = 'sensor.br_temperature_1d'
        AND last_updated BETWEEN DATE_ADD(CURDATE(), INTERVAL -1 DAY) AND CURDATE();
      column: max_temp
      unit_of_measurement: °C

Where

!secret mariadb_url = mariadb_url: ‘mysql://usr:[email protected]:3307/home_assistant?charset=utf8’`

And Weather.yaml is included in configuration.yaml through:

sensor: !include_dir_merge_list sensors/

The SQL works fine on its own, when used directly at DB level.

2

Same here with my SQL sensor that track’s DB size, it’s not updating anymore and query run directly on db is fine too.

MariaDB [homeassistant]> SELECT table_schema "database", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema;
+---------------+--------+
| database      | value  |
+---------------+--------+
| homeassistant | 1908.9 |
+---------------+--------+
3

Only thing I can see is the charset which should be utf8mb4