Can't see protocol of "Blocked adult websites","Blocked malware/phishing" and "rewritten"

[ElBarto2022]

If i try to open the logs of "Blocked adult websites","Blocked malware/phishing" and "rewritten" over the webinterface i only see the circle going round and nothing else. I use the actual version on a pfsense with FreeBSD. (Querylog.json has 24MB, sessions.db has 32KB and stats.db has 64KB)

[ainar-g]

Hello. Are there any queries that were blocked at all? That is, do you see them on the dashboard?

24 MiB isn't a lot, and unless the disk i/o is very slow, it should scan the log relatively quickly. You can also enable verbose logs to see if there are errors while reading the log.

[ainar-g]

It looks like the frontend keeps requesting the same thing over and over. I think we've fixed a similar issue in the edge version. Could you please check if the edge version has that problem? You can download it here. Don't forget to backup AGH data.

[ElBarto2022]

Tried the edge Version (v0.108.0-a.128+79d85a24) and still having the problem. :(
I think the querylog.json is the problem. After it is generated the view of different protocols starts to hang.

[ainar-g]

@ElBarto2022, what OS are you running?

Also, if the issue is still there, are you comfortable with sending us your querylog.json (or any querylog.json` with which the issue is reproduced at [email protected]? You could replace yours with a new one, try reproducing the issue, and send the new one to us. Thanks.

[ElBarto2022]

It is a pfsense 2..6.0 enviroment with FreeBSD 12.3-STABLE. The json file is growing over days to hunderts of MB. I send you the file which was new created after i recognized that it is hanging again. Using Edge v0.108.0-a.130+c0ac82be
Maybe it is the combination of the Filterlist https://raw.githubusercontent.com/StevenBlack/hosts/master/alternates/gambling-porn-social/hosts and the adguard parental control web service option

[ainar-g]

@ElBarto2022, thank you very much, we're able to reproduce that on a Linux system as well. We'll try to fix it in #4591.