Help - I'm losing my history after restarting the container

Help Synology
1

Hi

For some random reason my pi-hole container running on DSM 7.1 is losing history after any restart of the container

I'm running pi-hole 5.17.3 and nothing has changed since I built the platform 12 odd months ago

I deployed the container using a portioner stack and done a few updates since its been deployed.

Could someone please help. Many Thanks

version: "3.9"
services:
  pihole:
    image: pihole/pihole
    container_name: pihole
    mem_limit: 2g
    cpu_shares: 768
    security_opt:
      - no-new-privileges:false
    restart: on-failure:5
    network_mode: host
    volumes:
      - /volume1/docker/pihole/dnsmasq.d:/etc/dnsmasq.d:rw
      - /volume1/docker/pihole/pihole:/etc/pihole:rw
    environment:
      WEB_PORT: 8888
      WEBPASSWORD: password123
      WEB_BIND_ADDR: 192.168.0.200
      TZ: Europe/London
      DNSMASQ_USER: root
      DNSMASQ_LISTENING: local

Could someone please help fault find the issue

Many Thanks

2

Also:

Please upload a debug log and post just the token URL that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:

pihole -d

or do it through the Web interface:

Tools > Generate Debug Log

1 Like
3

https://tricorder.pi-hole.net/ffLNvPov/

4

Apparently the queries were never saved to the database, because the database file is incomplete.

An empty database should be 80Kb, but your file is only 44Kb:

*** [ DIAGNOSING ]: Pi-hole FTL Query Database
-rw-rw-r-- 1 pihole pihole 44K Feb 27 14:25 /etc/pihole/pihole-FTL.db

To fix this, you need to:

  • stop your container;

  • move the existing database to a new filename (a new database will be automatically created):

    # change the path if needed
sudo mv /volume1/docker/pihole/pihole/pihole-FTL.db /volume1/docker/pihole/pihole/pihole-FTL-old.db

  • restart your container.

After your container is fully started, check the size of the database file. It should be > 80Kb.

1 Like
5

Hi

Its still the same 8(

https://tricorder.pi-hole.net/XCxAoShp/

I removed the DB and its recreated it but still not 80KB

10

Could you try uploading more of the log file?

Try running

head -n 200 /var/log/pihole/FTL.log | pihole tricorder
head -n 200 /var/log/pihole/FTL.log.1 | pihole tricorder

and please provide the two generated tokens. Hopefully, this will include the relevant parts.