PiHole causes complete lockdown of system when adding/deleting whitelist/blacklist

Problem with Beta 5.0:
Using the WebUI, when I add/delete an entry to the white or black lists, the system locks up. Networking dies, can’t ssh into the box. After a few minutes, SSH recovers and Pihole needs to be manually restarted.

Debug Token:
https://tricorder.pi-hole.net/ylxoxjx9cp

Noticed the same thing the other day when troubleshooting 5.0 crashing non-stop. Something is up with the gravity.db.

There is a branch that optimized database handling. Might be worth trying, even without knowing what caused your issues…

pihole checkout ftl tweak/sqlite_debugging

In addition you can enable DEBUG_DATABASE=true in /etc/pihole/pihole-FTL.conf which should give additional logging to /var/log/pihole-FTL.log

It has been merged into the regular beta by now.