If using default php-cgi and not php-fpm:
Not sure how to make that persistent in Docker.
1 Like
You can copy the php.ini (or the folder) out of the container, and bind mount it back in, which should make it persist.
I do note that after a restart/flush logs, the error doesn't occur - it's only after a days log when clearly something "got large". My FTL.db was 1.6GB when I last checked - and doesn't resize when "Flush logs" gets run (not sure if that's right/wrong?)
Also, the Docker image doesn't have vi or nano installed and "service X restart" doesn't work within the containers either - pihole restartdns kind of works, and kill -9'ing the php-cgi processes works as they are "supervised" and get restarted.
Looks like that one only flushes the log files and not the data in the database:
When invoked manually, this command will allow you to empty Pi-hole's log, which is located at /var/log/pihole.log. The command also serves to rotate the log daily, if the logrotate application is installed.
That is correct on both parts. The containers are not meant to be edited in use. There are no extra packages inside them, and there is no init system. s6-init handles some of the init system functions but docker as a concept does not use in-container inits.
Well for the time being I've kludged it to 256M and will see what occurs tomorrow 
It should also remove the last 24h from the ftl.db, but this is not reflected in the file size as deleted entries do not free space but will be overwritten with new entries. Unless you are vacuum the database it will increase in size only.
So, how does this get fixed? I am interested on being able to see info past yesterday.
Thanks in advance!
2 Likes
does anybody have a solution here? I have the same problem, but not using a docker.
If I increase the PHP Memory, the system is freezing, even if I have 2GB of free RAM available.
1 Like
Did you increase the php memory limit already?
yes, I tried it in several steps.
- 256
- 512
- 1024
...but it did not fixed the problem. So I did a clean new install of Ubuntu Core, updated and upgraded everything. Now it is Version: Ubuntu 20.04.2 LTS
After this, installed Pihole and directly set memory limitation to 1000M
Today its about one month ago that I did this installation and it seems to work fine. Now I can retrieve data 25+ days
So for all others out there with the same problem, maybe an OS update fixes the problem 
For me it also helps with core temp, which is about 5°C lower now.
The most realistic fix at this stage is probably to wait for v6.0 - which will include, among other things, server side pagination for the datatables, making OOM exceptions a thing of the past!
1 Like
<1a62da6bfbb5> is the name of my pi-hole docker container (replace it with the name of your pi-hole container name)
<2048M> is the new amount of ram I set for my pi-hole conatiner (replace this with the amount of ram you want)
I used this to get the name of my pi-hole docker:
docker container list
results of command:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1a62da6bfbb5 pihole/pihole:latest "/s6-init" 21 minutes ago Up 6 minutes (healthy) pihole-template
I used to change the php.ini file:
docker exec 1a62da6bfbb5 sed -i 's/memory_limit = 128M/memory_limit = 2048M/g' /etc/php/7.3/cgi/php.ini
I used this to confirm the changes took:
docker exec 1a62da6bfbb5 cat /etc/php/7.3/cgi/php.ini |grep memory_limit
I then restarted the docker "container for pi-hole"
Which would have restarted the container and wiped out any changes you made.
I fixed the wording in my previous post.
From: I then restarted the docker
To: I then restarted the docker container for pi-hole
docker restart doesn't create a new container, I was incorrect about that. As soon as you create a new container it will all go away.
I guess all that matters is that it works for you now. I will break again in the future but that's a problem for another day.
Made a script to do this out of boredom
Admin Edit: We do not allow users to post scripts to our forums.
Just mount the file in to your container and be done with it all.
Just image if there was an option on the settings page.
Happy to accept your Pull Requests with the code changes.