core: Sensors on platform sql stopped working with 0.114 version

The problem

Since upgrading core to 0.114 all sensors have stopped working. I made sure the sql files were up to date with your latest from git. Data is flowing into the database as I can retrieve it using mysql workbench, also the graphs from grafana are working. Connected to mariadb.

configuration.yaml sensor: !include sensors.yaml

sensors.yaml - platform: sql db_url: mysql://homeassistant:password@core-mariadb/homeassistant?charset=utf8 queries: - name: Heating Downstairs On Hours query: 'SELECT Hours FROM homeassistant.Heating_Downstairs' column: 'Hours' unit_of_measurement: 'Hours'

Also receiving these errors in the system log:

2020-08-13 17:07:40 WARNING (MainThread) [homeassistant.components.sensor] Updating sql sensor took longer than the scheduled update interval 0:00:30

mariadb logs:

2020-08-13 16:33:14 53 [Warning] Aborted connection 53 to db: 'homeassistant' user: 'homeassistant' host: '172.30.32.1' (Got an error reading communication packets)

Environment

• Home Assistant Core release with the issue: 0.114
• Last working Home Assistant Core release (if known): 0.113
• Operating environment (OS/Container/Supervised/Core): Linux Ubuntu 20
• Integration causing this issue: sql platform (sensors)
• Link to integration documentation on our website:

Problem-relevant sensors.yaml

Traceback/Error logs

2020-08-13 17:07:40 WARNING (MainThread) [homeassistant.components.sensor] Updating sql sensor took longer than the scheduled update interval 0:00:30

On the dashboard Entity not available: sensor.master_bedroom_heating_cost

mariadb logs

2020-08-13 16:33:14 53 [Warning] Aborted connection 53 to db: 'homeassistant' user: 'homeassistant' host: '172.30.32.1' (Got an error reading communication packets)

If I increase the timeout on mysql workbench the data comes through. Appears it is timing out through the integration on HA possibly

Additional information