The issue I am facing:
Updating to V. 5.0 caused gravity.db building error - and finally no blocking behaviour at all.
Error message upon 'pihole -g':
"Unable to build build build gravity tree in /etc/pihole/gravity_temp.db
Error: database or disk is full"
Details about my system:
Raspi 4, 4GB; Kernel 4.19.97-v7l+;
Pi-hole Version** v5.0 Web Interface Version v5.0 FTL Version** v5.0
What I have changed since installing Pi-hole:
Switching from 4.x to V. 5
** Results of 1st own investigations:
Looks like the change in gravity.sh in function gravity_swap_databases() introduced via PR #3100 is causing the problem. By disabling lines 95 up to 101, the gravity DB could be created and blocking seems to work again.
yes and no; the diff you have was just to narrow down the place, where the error is thrown; the actual temporary change I did was in /opt/pihole/gravity.sh (code lines starting w/ #):
# The index is intentionally not UNIQUE as prro quality adlists may contain domains more than once
# output=$( { sqlite3 "${gravityTEMPfile}" "CREATE INDEX idx_gravity ON gravity (domain, adlist_id);"; } 2>&1 )
# status="$?"
# if [[ "${status}" -ne 0 ]]; then
# echo -e "\\n ${CROSS} Unable to build build build gravity tree in ${gravityTEMPfile}\\n ${output}"
# return 1
# fi
echo -e "${OVER} ${TICK} ${str}"
Further analysis shwoed, that my former (i.e. V. 4.x) adlist was shortened by the update process; Trying to add some of the dropped URLs is causing a UNIQUE CONTRAINT error, which points in the direction of some trouble when trying to deal w/ indexing, or?
You can't add duplicate adlists (or domains either, if I recall) to the database in V5. In the previous version V4, you could have duplicates in file /etc/pihole/adlists.list
[2020-05-14 17:58:47.005 10757] domain_in_list("20.177.168.192.in-addr.arpa", 0x1187208, whitelist): Database is busy, assuming domain is NOT on list
[2020-05-14 17:58:47.006 10757] domain_in_list("20.177.168.192.in-addr.arpa", 0x1191168, blacklist): Database is busy, assuming domain is NOT on list
[2020-05-14 17:58:47.006 10757] domain_in_list("20.177.168.192.in-addr.arpa", 0x118e288, gravity): Database is busy, assuming domain is NOT on list
This from your debug log. What were you trying to do here?
If I remember right, in that moment it turned out, that some of my adlist URLs do not longer exist. Basically all those coming from "https://hosts-file.net".