Uptime Kuma Web-UI broken (empty)

[simon]

I have about 50 monitors running. Monitoring is reliable, notifications are coming in.
However, the web UI regularly crashes after a little longer uptime (haha!). Then the entries/monitors are not updated, or are missing, or the whole app is not loaded.
Browser Reload does not help, Server Restart does.
The log is unremarkable. I couldn't find any comparable reports in the forum yet. Am I the only one with this problem?

[joseph]

Can you check the size of the sqlite database ? It's inside /app/data . Maybe there is too much historical information ?

We use uptime kuma as well - https://status.cloudron.io but haven't faced this. I think it's up for last 3 years or so.

[msbt]

@simon I had that as well a few years (!) ago, when I was using a non-SSD VPS with little CPU and just too many records in the sqlite db. The quick fix was using a lower interval and regularly hit the "Shrink Database" button in the settings, the real fix was migrating to a server with a faster storage

[robi]

@joseph do all the SQLite configurations have the Write Ahead Log WAL enabled?

It's a bit of a must since it's not configured by default.

[simon]

Thank you for the feedback.
Kuma has only been running for 3 months. The database is about 800 MB in size and cannot be reduced in size via the settings. I have now reduced the data retention to 100 days. Since I have seen the problem several times in the last few weeks, I don't expect this to solve the problem.

[joseph]

@robi you are right. It seems https://github.com/louislam/uptime-kuma/blob/efdffca06ccf4a8ca96a2ffce44467386c3fb852/server/database.js#L359 sets this though

[joseph]

@simon might be worth reporting upstream . Closest I found similar to your issue is https://github.com/louislam/uptime-kuma/issues/3276