The original post: /r/pihole by /u/tritri301 on 2024-11-05 01:04:26.
Hi everyone! I’m running Pi-hole on a Raspberry Pi 4 with 2GB of RAM in a Docker container, alongside Nginx Proxy Manager. About a month ago, my Pi started having a weird recurring issue: Pi-hole would gradually eat up all the memory until the system locked up, forcing me to reboot it.
I tried a temporary fix by deleting the Pi-hole database, which seemed to solve the problem—until it came back a month later. Now I’m stuck with the same issue.
When I checked the logs, I found the same error message as before:
ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1699160581;" failed: database is locked (SQLITE_BUSY)
I’ve tried searching online, but I haven’t found any solid answers. At idle, the CPU sits at 0%, but Pi-hole is hogging 57% of memory, causing the Pi to slow down due to heavy reliance on swap.
Anyone else had this issue or have ideas for a more permanent fix?