When the amount of data is too large, the service will crash directly. My current sqlite file is 2G. about server HOT 6 CLOSED

After investigation, it was found that the issue was caused by the messages table containing messages with excessively long content, approximately around 1 gigabyte in size.

from server.

How does it crash, what is the error message?

from server.

No information, the process exited directly because it was running as a service, so there is no console log recorded.

from server.

Could you share the sqlite file with me? Otherwise there isn't much to debug here for me. That said, the clients likely cannot handle 1gb messages. Gotify is more designed for smaller messages.

from server.

Sorry I can't share the file since it contains private information, but as you said, this issue should not be considered a BUG, normally there shouldn't be messages of 1GB and the program worked fine after I deleted this anomalous data from the database, but it would be nice to have an alert that helps non-technical people to solve this issue.

from server.

Sqlite doesn't do well with large databases. I'd switch to an actual server at that point.

from server.