At high speed, DB table is locked errors arise with 500 status codes

binwiederhier / ntfy

Send push notifications to your phone or desktop using PUT/POST

https://ntfy.sh

Apache License 2.0

18.48k stars 727 forks source link

At high speed, DB table is locked errors arise with 500 status codes #561

Closed RaitoBezarius closed 1 year ago

RaitoBezarius commented 1 year ago

Hi there, thank you for the amazing piece of software.

I am using it to monitor my highly frequent backups (10-15 jobs every 5 minutes) and I am running into 500 errors of this form:

Dec 29 06:25:05 amadeus ntfy[4167557]: 2022/12/29 06:25:05 INFO 2001:bc8:38ee::1 HTTP POST /backups Connection closed with HTTP 500 (ntfy error 50001): database table is locked

Is there any way to reduce the locks contention or something? Thank you!

RaitoBezarius commented 1 year ago

Nevermind, I just stumbled on https://docs.ntfy.sh/config/#message-cache_1 !