Locked Database

Hello All,

Tried to add regex to pi-hole, however I have been blocked from doing so and ended up with this error msg as shown below, never happened before. This issue happened in current update version.

Even when I tried to allow, as in this image below, I am still blocked with a warning of a big red X.

Domain 2

Expected Behaviour:

Simply add regex to database
Raspberrypi 4b
Linux raspberrypi 6.6.62+rpt-rpi-v8 #1
SMP PREEMPT Debian 1:6.6.62-1+rpt1 (2024-11-25)
aarch64 GNU/Linux

  • Core vDev (development, 0f318027)
  • FTL vDev (development, 84e2ad11)
  • Web interface vDev (development, 9913f888)

Actual Behaviour:

Some domain could not be add (1 domain processed)

2025-01-21 14:46:39.575 ERROR SQLite3: API called with NULL prepared statement (21)

2025-01-21 14:46:39.575 ERROR SQLite3: misuse at line 91470 of [d2fe6b05f3] (21)

2025-01-21 14:46:39.579 ERROR gravityDB_readTableGetRow() - SQL error step (21): not an error

2025-01-21 14:46:39.591 WARNING API: Could not read from gravity database (not an error)

Debug Token:

Please upload a debug log and post just the token URL that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:

pihole -d

https://tricorder.pi-hole.net/MakFi9Ru/

Problem solved, Pihole -r and a reboot.