Mass deletion of domains, fail

[Redback]

Hello all.

The issue I'm running into has been able to delete a large selection of either domains or regexes from the domain section with failure.

In the subsection of Domains, List of domains, drop menu, I can select All. However, I am not sure whether this is a bug or simple a limitation on deleting large selections at once, say over 1000+ selected domains or regexes. When I click on the garbage can, it pops up with an error msg. However, if I do it in smaller lots, no issue, but clicking on 100 is not feasible if you have multiply tabs.

Error msg:
Could not remove entries from table
Argument is not an array

Details about my system:
Raspberry Pi 4B
Pi.hole beta6

What I have changed since installing Pi-hole:
Nothing

Thank you in advance.

[rdwebdesign]

Can you please repeat the process with the browser developer tools open?

• Do you see any error messages in the Console tab?

• Also, using the Network tab, what is the content of /api/domains:batchDelete request?

  Note: I'm using Firefox Devtools, but other browsers will have similar tools.
  Network request details — Firefox Source Docs documentation

  1. select Network tab;
  2. find domains:batchDelete and select it;
  3. select Request tab, on the right pane;
  4. turn on the Raw toggle button and select the text.

  @Redback

  Argument is not an array

  Probably the request is too long, resulting in a broken request.

EDIT:

I tested with 1000 exact domains and Pi-hole deleted all. No issues. (domains with only 8 characters like wxyz.com)

[rdwebdesign]

I ran a few more tests and I replicated the issue.

I was able to delete 100 regex (like this one: (\.|^)domain\.xyz1234\.com$ - containing 3 letters and 1 to 4 digits) without issues.

I replicated the issue deleting 1000 regex.

The issue is the payload size:

2024-11-06 02:09:13.449 WARNING API: Received too large payload - DISCARDING
2024-11-06 02:09:13.450 ERROR gravityDB_delFromTable(8): Argument is not an array
2024-11-06 02:09:13.450 WARNING API: Could not remove entries from table (Argument is not an array)

[Redback]

Disable Cache

56 requests

9.05 kB / 36.95 kB transferred

Finish: 5.54 min

error	Object { key: "database_error", message: "Could not remove entries from table", hint: "Argument is not an array" }
key	"database_error"
message	"Could not remove entries from table"
hint	"Argument is not an array"
took	0.007541656494140625

Request entries
2,605