MariaDb AddOn, Error message in log after update to 2.5.2

Configuration
1

After upgading MariaDb to 2.5.2 I have started to get an error in my log:

Log Details (ERROR)

Logger: homeassistant.components.sql.sensor
Source: components/sql/sensor.py:184
Integration: SQL (documentation, issues)
First occurred: 13:11:36 (4 occurrences)
Last logged: 13:22:36

Error executing query SELECT table_schema “database”, Round(Sum(data_length + index_length) / POWER(1024,2), 1) “value” FROM information_schema.tables WHERE table_schema=“homeassistant” GROUP BY table_schema LIMIT 1;: Can’t reconnect until invalid transaction is rolled back. (Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)

I’m new to HA and all this and can’t figure out what it is about. I googled it and some wrote about the MariaDb size sensor, but that looks to work, at least it was both updated (seconds ago) and changed (2h ago), so as far I can see that sensor works.
But how do I figure out what it is about, and what to do about it?

2

See the release notes topic. There has been some discussion about updates required for SQL sensors.

3

ehhmmmm…release notes topic…can’t even find that…
I tried all three links in the log message, but nothing fresh or anything that looks exactly the same
Is there something I can do, or is it just to wait until dev team comes out with some fix?

4

Is it possible to post the full log text and any other useful information in the log file?

5

sure! If I understand how and what…and from what I can see it doesn’t contain anything personal/secret…

I copied the complete log message and it looks like above

The full log was to long to be pasted into the forum and I was not allowed to add it as a file
Had to cut what I think was related to this - se below
Is there some other way to provide the full log file?

zwave_js_server.exceptions.FailedZWaveCommand: Z-Wave error 202: The node did not respond after 3 attempts, it is presumed dead (ZW0202)
2023-02-02 11:46:06.097 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 11:48:09.056 WARNING (MainThread) [homeassistant.config_entries] Config entry 'Z-Wave JS' for zwave_js integration not ready yet: Failed to connect: Cannot connect to host a0d7b954-zwavejs2mqtt:3000 ssl:default [Connect call failed ('172.30.33.1', 3000)]; Retrying in background
2023-02-02 11:52:06.105 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 11:55:06.111 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 11:56:36.116 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:00:36.126 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:07:06.144 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:12:06.156 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:17:36.171 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:26:36.196 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:33:36.218 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:36:06.225 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:43:36.247 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:52:06.267 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 12:57:36.284 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:00:06.290 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:07:06.306 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:11:36.321 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:13:06.324 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:21:36.345 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:22:36.349 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:24:15.249 ERROR (DbWorker_0) [homeassistant] Error doing job: Task was destroyed but it is pending!
2023-02-02 13:37:06.389 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:38:06.392 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:42:36.402 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:43:36.404 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:45:06.409 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:54:36.429 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:56:06.432 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 13:59:36.439 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:03:36.451 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:04:06.451 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:05:06.455 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:09:36.467 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:10:06.468 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:22:06.501 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:25:36.510 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:27:06.513 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:30:36.522 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:43:36.552 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:44:06.554 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:48:36.563 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:49:36.566 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:50:36.569 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:51:06.572 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
2023-02-02 14:52:06.574 ERROR (SyncWorker_2) [homeassistant.components.sql.sensor] Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: Can't reconnect until invalid transaction is rolled back. (Background on this error at: https://sqlalche.me/e/14/8s2b)
6

It looks like it is stuck as there is a transaction that needs to be rolled back. The transaction should get rolled back automatically once the clients are disconnected.

I’d try shutting down and restarting MariaDB; see if that helps. If not try restarting everything.

What is the disk media you are using for storage?

7
8

it’s running on an NVMe SSD drive

9

aha…but that was HA 2023.2 and I have not applied that update yet. Planned to wait until tonight.
The error I posted about came after updating MariaDb the other day.

10

Ah. I misread your first sentence. Sorry.

11

Cleared log, stopped and restarted MariaDb and got two long error messages in log:

Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: (MySQLdb.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: SELECT table_schema "database", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;] (Background on this error at: https://sqlalche.me/e/14/e3q8)

15:28:06 – (ERROR) SQL

Unhandled database error while processing task EventTask(event=<Event state_changed[L]: entity_id=sensor.ute_trh_signal_strength, old_state=<state sensor.ute_trh_signal_strength=-64; state_class=measurement, event=0a52097f8e0080053f0179, unit_of_measurement=dBm, assumed_state=True, device_class=signal_strength, friendly_name=Ute Signal Strength @ 2023-02-02T15:25:29.010651+01:00>, new_state=<state sensor.ute_trh_signal_strength=-56; state_class=measurement, event=0a52098f8e0080053f0189, unit_of_measurement=dBm, assumed_state=True, device_class=signal_strength, friendly_name=Ute Signal Strength @ 2023-02-02T15:27:52.903271+01:00>>): (MySQLdb.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: SELECT state_attributes.attributes_id FROM state_attributes WHERE state_attributes.hash = %s AND state_attributes.shared_attrs = %s] [parameters: (2559563188, '{"state_class":"measurement","event":"0a52098f8e0080053f0189","unit_of_measurement":"dBm","assumed_state":true,"device_class":"signal_strength","friendly_name":"Ute Signal Strength"}')] (Background on this error at: https://sqlalche.me/e/14/e3q8)

15:27:52 – (ERROR) Recorder

Tried a full restart of HA and…fingers crossed…still nothing in the log…but I have restarted since update of MariaDb as well…

12

I justed tried updating my DB, and it crashed big time to the point that I had to restore the Home Assistant from Backup. is there is a procedure to update the DB and HA Core without the database crashing.

13

Same issue here I updated mariadb to the latest version on docker but HA feels so slow and sluggish. Did you find any solutions to this?

1 Like
14

I don’t believe that this is strictly related to maria. I am running timescale and have this after updating

Also, I don’t have any SQL sensors configured anywhere…

Logger: homeassistant.components.sql.sensor
Source: components/sql/sensor.py:352
Integration: SQL ([documentation](https://www.home-assistant.io/integrations/sql), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+sql%22))
First occurred: 20:59:03 (195 occurrences)
Last logged: 22:36:55

* Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: (psycopg2.errors.UndefinedColumn) column "data_length" does not exist LINE 1: SELECT table_schema "database", Round(Sum(data_length + inde... ^ [SQL: SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;] (Background on this error at: https://sqlalche.me/e/20/f405)
* Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: (psycopg2.errors.InFailedSqlTransaction) current transaction is aborted, commands ignored until end of transaction block [SQL: SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;] (Background on this error at: https://sqlalche.me/e/20/2j85)
* Error executing query SELECT table_schema "database", Round(Sum(data_length + index_length) / 1048576, 2) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema LIMIT 1;: (psycopg2.OperationalError) connection to server at "77b2833f-timescaledb" (172.30.33.1), port 5432 failed: FATAL: sorry, too many clients already (Background on this error at: https://sqlalche.me/e/20/e3q8)