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.