Unexpected Restarting

[Ragetti13]

The problem

Home Assistant keeps restarting unexpectedly and unfortunately, I cannot find any reason for the restart or any noticeable pattern for the restarts.

I will keep monitoring and update this issues if I notice any specific causes or patterns.

What version of Home Assistant Core has the issue?

core-2023.5.0b0

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

No response

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

`Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:576 
Integration: Recorder (documentation, issues) 
First occurred: 17:07:57 (1 occurrences) 
Last logged: 17:07:57

Ended unfinished session (id=70 from 2023-04-27 15:25:14.294346)`

`Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:243 
Integration: Recorder (documentation, issues) 
First occurred: 17:07:57 (1 occurrences) 
Last logged: 17:07:57

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly`

Additional information

No response

[MartinAM80]

Same issue here. It seems like the issue is on OS 10.0 and 10.1. I tied first downgrading CORE but same happens, so it has to be OS. Latest 10.1 didn't solve this issue...

[home-assistant[bot]]

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

Code owner commands

Code owners of recorder 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 recorder Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

---

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

[balloob]

Can you keep an eye on your memory use

[Ragetti13]

Can you keep an eye on your memory use

I've been checking every few hours and memory usage is staying steady at around 23%

I have since updated to 2023.5.0 and the restart are still occuring

[silfa718]

Can you keep an eye on your memory use

I've been checking every few hours and memory usage is staying steady at around 23%

I have since updated to 2023.5.0 and the restart are still occurring

I am seeing the same issue and restarting, also noticeable change on memory use before it restarts.

[Ragetti13]

The issue is still present and occurring regularly - twice today within the last 2 hours with no direct interaction with HA.

`Logger: homeassistant.components.recorder.util Source: components/recorder/util.py:576 Integration: Recorder (documentation, issues) First occurred: 08:18:20 (1 occurrences) Last logged: 08:18:20

Ended unfinished session (id=206 from 2023-05-13 06:28:28.639571)`

`Logger: homeassistant.components.recorder.util Source: components/recorder/util.py:243 Integration: Recorder (documentation, issues) First occurred: 08:18:20 (1 occurrences) Last logged: 08:18:20

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly`

[schildgenb]

I have been having the same issue as well. Its been going on within the last couple of months. It would just randomly restart at different periods of the day. Sometimes it will go a good period without restarting but then it would start again. I am using a Homeassistant Yellow with 8 GBs of ram. I have been looking at the memory usage for a bit here and it has been below 50%. I also have been looking through the logs and have not found anything that could be causing this issue. If there is anything I can provide I will try to do so.

[Ragetti13]

Issue still persisting but with increased regularity since 23.6.1

logger:%20homeassistant.components.recorder.util%0ASource%3A%20components/recorder/util.py:243%0AIntegration:%20Recorder%20(documentation,%20issues)%0AFirst%20occurred:%2020:35:16%20(1%20occurrences)%0ALast%20logged:%2020:35:16%0A%0AThe%20system%20could%20not%20validate%20that%20the%20sqlite3%20database%20at%20//config/home-assistant_v2.db%20was%20shutdown%20cleanly

logger:%20homeassistant.components.recorder.util%0ASource%3A%20components/recorder/util.py:576%0AIntegration:%20Recorder%20(documentation,%20issues)%0AFirst%20occurred:%2020:35:16%20(1%20occurrences)%0ALast%20logged:%2020:35:16%0A%0AEnded%20unfinished%20session%20(id=369%20from%202023-06-12%2018:29:30.580834)

[Ragetti13]

Since my last comment 2 days ago and more frequent restarts; I have made the drastic decision to completely factory reset my Yellow and reinstall from fresh without a backup.

I have since reinstalled a few essential addons and my hue lights and ZHA but the issue still occurs.

This is from a restart this morning when there were no automations running at the time, and due to the complete reinstall - a vastly lower process load than my previous instance of Home Assistant.

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:243
Integration: Recorder (documentation, issues)
First occurred: 06:02:55 (1 occurrences)
Last logged: 06:02:55

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:576
Integration: Recorder (documentation, issues)
First occurred: 06:02:55 (1 occurrences)
Last logged: 06:02:55

Ended unfinished session (id=40 from 2023-06-15 04:08:53.072616)

As i am writing this (07:06) the Yellow has restarted again as i was navigating through to "Settings>About" in order to collect version information for the bug report.

Any assistance would be greatly appreciated as this presently causes even the basic Home Assistant functionality from being used.

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:243
Integration: Recorder (documentation, issues)
First occurred: 07:07:17 (1 occurrences)
Last logged: 07:07:17

The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly

Logger: homeassistant.components.recorder.util
Source: components/recorder/util.py:576
Integration: Recorder (documentation, issues)
First occurred: 07:07:17 (1 occurrences)
Last logged: 07:07:17

Ended unfinished session (id=41 from 2023-06-15 05:02:55.017529)

Currently running:

Home Assistant 2023.6.1 Supervisor 2023.06.2 Operating System 10.2 Frontend 20230608.0 - latest

home-assistant_2023-06-15T06-10-30.337Z.log

[Ragetti13]

@homeassistant

Home Assistant keeps restarting unexpectedly. Since my first post regarding this issue in April, I have still been running the betas for HA and the issue still occurs, but I have been gradually narrowing down what actions seem to be linked with the restarts.

Within the last 2 weeks I have completely wiped, and reinstalled Home Assistant on my Yellow with a brand new NVME and not from a backup instance - painstakingly reinstalling my home piece by piece.

I am currently running 2023.7.0b

My last known working instance of Home Assistant is likely to have been somewhere around Jan/Feb time running 2023.2 which is prior to my Yellow being shipped to me and i was running on a Raspberry Pi 4b.

The issues really started to become noticeable moving from a Conbee Zigbee Stick to the Yellow with the Multiprotocol Addon. On this fresh install, i setup with the Multiprotocol again and the issues have persisted this week I have removed the multiprotocol addon and reverted back to ZHA which has proved far more stable.

I am having fewer unexpected restarts, however, I have also noticed restarts occurring when editing YAML within the VSCode Addon whilst rebuilding my dashboards (UI-Minimalist HACs Integration).

I hope that this helps to narrow down the cause of this, as i have encountered a few other users on Discord and HA Forum that seem to be having similar issues. Happy to assist with any further information or troubleshooting steps to find a solution that will benefit the HA community.

[issue-triage-workflows[bot]]

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.