All Historical Data is gone since some versions

Installation Home Assistant OS
1

Since some versions, i have the problem, that all historical log data is gone - also all data from the energy dashboards.
Further, there are some errors with every restart occuring:

Notification:
image

Log Entries:

> Logger: homeassistant.setup
> Quelle: setup.py:269
> Erstmals aufgetreten: 11:08:35 (5 Vorkommnisse)
> Zuletzt protokolliert: 11:08:38
> 
> Setup failed for 'alias': Integration not found.
> Setup failed for 'action': Integration not found.
> Setup failed for 'trigger': Integration not found.
> Setup failed for 'mode': Integration not found.
> Setup failed for 'no_ip': Integration failed to initialize.

Logger: homeassistant.components.frontend
Quelle: components/frontend/init.py:389
Integration: Home Assistant Frontend (Dokumentation, Probleme)
Erstmals aufgetreten: 11:08:34 (1 Vorkommnisse)
Zuletzt protokolliert: 11:08:34

Please remove javascript_version from your frontend config. It is no longer supported

Maybe they are refering to each other?

Sys Info

Core 2024.8.2
Supervisor 2024.08.0
Operating System 13.1
Frontend 20240809.0

Hardware: Raspberry Pi 4 rpi4-64
2

There seems to be also a corrupt DB file:
image

Im using standard DB (SQLite?!)

3

Hello Namxx,

Welcome to the forum. Let’s see if I can be of any assistance.

It sounds like you have a major problem with the database.
Based on that I’m going to predict that you have a ras-pi of one form or another using an SD card, further that the SD card has failed. All SD cards fail. Generally the cheaper they are the sooner they fail.

If this is the case, I would read this over and see if it helps you at all…
How to Troubleshoot Raspberry Pi Crashing.

If this is not the case, please share what your hardware is and what kind of install you are using.

4

My installation is quite new, I use it for 3-4 month maybe with a brand new Raspi and SD Card (Class 10)

Is there a way to check the SD card integrity out of HA?

Power Supply is done by RasPi 4 PoE Hat. RPi Power Status checker is “ok”
… but maybe i will switch to SSD if you think that it could be the SD… some other threat creators seems to have the same problems.

5

So: Finally i switched now from SD to SSD and rebuild HA from backup.

But errors are still there:

image
image2233×353 69.2 KB

6

From the screenshots you were having corrupt databases several times per month, multiple months in a row. So either the card wasn’t great to begin with, or you had multiple abnormal program terminations. I assume you’re not restarting or shutting down any other way than through the HA user interface? Or are you interacting with the database while HA is running?

7

Thanks for your answer.
I managed now to reinstall HA on the SSD and put in another backup - now the installation is “clean” - means the errors from the DB are gone.

What I have still are some errors on every restart:

Logger: homeassistant.setup
Quelle: setup.py:269
Erstmals aufgetreten: 22:35:30 (4 Vorkommnisse)
Zuletzt protokolliert: 22:35:30

  • Setup failed for ‘action’: Integration not found.
  • Setup failed for ‘trigger’: Integration not found.
  • Setup failed for ‘alias’: Integration not found.
  • Setup failed for ‘mode’: Integration not found.
8

Those errors are related to an/ (multiple) automation(s) where you referred to a device/entity that doesn’t exist anymore.
Check your automations.

9

All automations work fine. I checked all and also all scripts…

The error always goes in hand with the warning:

Logger: homeassistant.helpers.translation
Quelle: helpers/translation.py:226
Erstmals aufgetreten: 20:44:18 (4 Vorkommnisse)
Zuletzt protokolliert: 20:44:18

  • Failed to load integration for translation: Integration ‘action’ not found.
  • Failed to load integration for translation: Integration ‘trigger’ not found.
  • Failed to load integration for translation: Integration ‘mode’ not found.
  • Failed to load integration for translation: Integration ‘alias’ not found.

I tried to update the custom panels, like described here: GitHub - PiotrMachowski/Home-Assistant-custom-components-Custom-Templates: This integration adds possibility to use new functions in Home Assistant Jinja2 templating engine.