High CPU Usage and Sensor Stuck Issue during HA Backup in Virtual Machine

Hello,

Over the past three days, I have encountered an issue where the CPU usage reaches 100% and remains at that level until I reboot the system. This problem occurs during Home Assistant’s backup process, which starts at 3 AM and involves uploading the backup to Google Drive. It appears that the CPU, memory, and disk sensors become stuck during this time.

This graph illustrates the situation:

image

As shown, the CPU usage reaches 100% during the backup process, and the disk and memory usage start to increase as well. However, the sensors stop reporting, resulting in a flat line. In this instance, the occurrence happened around 6 AM.

Additionally, I have noticed that all other sensors in HA become stuck simultaneously. The following temperature graph demonstrates this:

image

Furthermore, some automations cease to function during this period.

Based on the graph from my UDM Pro, there is a significant upload observed around 6:50 AM, indicating that the backup is likely being uploaded to Google Drive.

After a reboot, everything returns to normal. However, data from this occurrence is not saved in the database, resulting in flat lines on the graphs.

Currently, I am running HA on a virtual machine, using MariaDB. All components are updated to the latest stable release. The backup has a size of 10.2GB and is successfully created and uploaded to Google Drive.

I would greatly appreciate any suggestions on how I can troubleshoot this issue effectively.

UPDATE:
This morning, I refrained from rebooting the system and observed that the data on the graphs is being updated if I allow it to display for a moment. However, it seems that the data is not being stored in the database. When I refresh the graph, it displays a flat line and starts updating the data from that point onward.

image

Same graph but after refresh the page:
image

It appears that there may be an issue with the database. Do you have any suggestions on how to address this situation?