Database status strange after 2 installs and restarts

[pyramation-bot]

Description

I'm noticing that the database is not reliably being set up, hope this helps. I have everything else green except the db, I tried two fresh installs and also restarts and still have this issue. I have a brand new mac studio with all the bells an whistles, node, rust etc on here.

I found this because my LLMs dont work, so I decided to look into the doctor command, perhaps this is the source of my issue

Daemon Health:
✔ Running agents: 2
✘ Database status: connected

• Integration health: 0/2 healthy

Expected Behavior

expecting the database to be properly running. expecting LLMs to be able to chat.

Steps to Reproduce

I don't believe this is reproducible which is likely part of the problem. I do do a lot of database work with docker and use port 5432 but I don't believe that would be what you're using for sql lite. Wish I had a way to capture this bug!

for me it just happens when I install, uninstall and install, restart, uninstall and install, and so on

OpenFang Version

openfang 0.3.27

Operating System

macOS (Apple Silicon)

Logs / Screenshots

No response

[technerd-official]

I have the exact same error but on Ubuntu 24.04.4 LTS tried to run doctor but it didn't fixed it.

[jaberjaber23]

Not reproducible in v0.3.36. The database migration system is idempotent with CREATE TABLE IF NOT EXISTS and version checks. WAL mode + busy_timeout handle concurrent access. The health endpoint performs a real SQLite query to verify connectivity. If you can still reproduce on v0.3.36 please reopen with logs.