Interesting, I don't have a drop trigger and it still works. But now that you remind me, I'll add it.
Good catch though. Also yes, I should call it _add !!
I removed the drop again, it gave me this error:
[✓] Storing downloaded domains in new gravity database
[✓] Building tree
[i] Swapping databases...
[✗] Unable to copy data from /etc/pihole/gravity.db to /etc/pihole/gravity_temp.db
Error: near line 10: no such trigger: tr_group_add
[i] Number of gravity domains: 14578098 (2161132 unique domains)
[i] Number of exact blacklisted domains: 60
[i] Number of regex blacklist filters: 68
[i] Number of exact whitelisted domains: 803
[i] Number of regex whitelist filters: 0
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is running
[✓] Pi-hole blocking is Enabled
Didn't add the drop trigger and it still works fine. Here is my gravity_copy.sql.
Here is the log from last nights pihole -g run:
[✓] Storing downloaded domains in new gravity database
[✓] Building tree
[✓] Swapping databases
[i] Number of gravity domains: 1190673 (343611 unique domains)
[i] Number of exact blacklisted domains: 245
[i] Number of regex blacklist filters: 406
[i] Number of exact whitelisted domains: 601
[i] Number of regex whitelist filters: 10
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is running
[✓] Pi-hole blocking is Enabled
No error.
now same result for me (without the drop line) and things still work