My PI4b HA is starting to crash

First, take backups of all the data you can.

After that, you’ve probably worked out that there are database issues.

  • sqlite3 is complaining the database file wasn’t shut down cleanly, which could be both a cause and symptom of crashes.
  • The InfluxDB server isn’t running, which suggests something similar

I’d suggest using code blocks and not screenshots as reading images is a PITA, and prevents goggling of errors.

Most modern RPi issues are power supply rather than uSD cards these days as wear-levelling improved a lot. In this case, it’s hard to say what the root cause is - but you do need to fix the sqlite3 database.

I’d suggest (as always) search for the error message - e.g. could not validate the sqlite3 database or corrupt database.

Some hits suggest deleting the database & core.device_registry file, but that seems very strange to this greybeard ex-dba! Lock files for the database might be OK to clean out, but unless the db file is re-created somehow from another, deletion seems silly.

That’s as much I personally can help - just make sure you have as many copies and backups as possible to give options for recovery.