MariaDB: Updating sql sensor took longer than the scheduled update interval 0:00:30

[LouPaloma]

The problem

Seeing repeated issues on this subject even after reboot. Not associated with change to DST.

Running on dedicated computer that did not have this issue before 2023.3.x

What version of Home Assistant Core has the issue?

core-2023.3.6

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Recorder

Link to integration documentation on our website

https://www.home-assistant.io/integrations/sensor

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

Updating sql sensor took longer than the scheduled update interval 0:00:30

Additional information

OS: Centos 7
Python: 3.11.0
MariaDB: 10.6.12-1.el7.centos
mysqlclient: 2.1.1

Connection URL: mysql://USER:PASSWORD@localhost/homeassistant?charset=utf8mb4

Stopping Hass takes long time (than usual). Stopping MariaDB shows hanging threads from Hass causing it to fail to shutdown, requiring Kill -9 PID

Thread 38 (user : 'HASS_ADMIN_ACCT') did not exit

[home-assistant]

Hey there @home-assistant/core, mind taking a look at this issue as it has been labeled with an integration (sensor) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of sensor can trigger bot actions by commenting:

• @home-assistant close Closes the issue.
• @home-assistant rename Awesome new title Renames the issue.
• @home-assistant reopen Reopen the issue.
• @home-assistant unassign sensor Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

---

sensor documentation
sensor source
_{^{(message by IssueLinks)}}

[LouPaloma]

Have updated python to 3.11.2... awaiting recurrence (typically within 7-10 days)

[smiths78]

I think am getting the same problem.
I had Python 3.11.2, running HA core 2023.3.5 on RPi 4, with MariaDB on RPi3

1. HA takes a long time to stop
2. RPi running MariaDB becomes unresponsive when purging database every 7 days
   Just updated to HA core 2023.4.2
3. "Getting Updating sql sensor took longer than the scheduled update interval 0:00:30" reported constantly in syslog for HA
4. RPi running MariaDB is now unresponsive. I can't ssh to it.
   I shall revert to my backup

[issue-triage-workflows]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates.
Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍
This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.