Gravity DB Unable to Prepare SQL Statement / Docker Core Version Stuck

[AlexLamond]

This is a: Bug

Details

After upgrading to 6.0 running through Docker, all of my 7 pi-hole instances are unable to update or create a new gravity database without running into errors. Recreating the gravity database causes the same error as an existing one “Unable to prepare SQL statement to update adlist properties in database file /etc/pihole/gravity.db_temp”

Related Issues

• [ X] I have searched this repository/Pi-hole forums for existing issues and pull requests that look similar

How to reproduce the issue

1. Environment data

• Operating System: Raspberry Pi on Raspbian
• Hardware: Raspberry Pi 4
• Kernel Architecture: Linux pihole 6.6.74+rpt-rpi-v8 Readme #1 SMP PREEMPT Debian 1:6.6.74-1+rpt1 (2025-01-27) aarch64
• Docker Install Info and version:
  • Software source: Docker Image
  • Supplimentary Software: Portainer
• Hardware architecture:

2. docker-compose.yml contents, docker run shell command, or paste a screenshot of any UI based configuration of containers here

Debug Token: https://tricorder.pi-hole.net/7lNsC5Vr/

[AlexLamond]

I just pulled the latest Dockertag, but my Core version is still reporting as 5.18.3. Could this be related to my issues?

[PromoFaux]

Hmmmm this does not seem right.

What does your compose file look like please?

[AlexLamond]

I don't have a compose file, but here is the Portainer Configuration

{
    "AppArmorProfile": "",
    "Args": [],
    "Config": {
        "AttachStderr": false,
        "AttachStdin": false,
        "AttachStdout": false,
        "Cmd": null,
        "Domainname": "",
        "Entrypoint": [
            "start.sh"
        ],
        "Env": [
            "FTLCONF_LOCAL_IPV4=192.168.6.2",
            "TZ=Europe/Amsterdam",
            "REV_SERVER=true",
            "REV_SERVER_DOMAIN=local",
            "REV_SERVER_TARGET=192.168.6.1",
            "REV_SERVER_CIDR=192.168.0.0/16",
            "HOSTNAME=pihole",
            "DOMAIN_NAME=pihole.local",
            "PIHOLE_WEBPORT=80",
            "PIHOLE_DNS_=192.168.6.3#5553",
            "DNSSEC=\"true\"",
            "- DNSMASQ_LISTENING=single",
            "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
            "DNSMASQ_USER=pihole",
            "FTL_CMD=no-daemon"
        ],
        "Healthcheck": {
            "Test": [
                "CMD-SHELL",
                "dig +short +norecurse +retry=0 @127.0.0.1 pi.hole || exit 1"
            ]
        },
        "Hostname": "pihole",
        "Image": "pihole/pihole:latest",
        "Labels": {
            "org.opencontainers.image.created": "2025-02-18T18:28:09.584Z",
            "org.opencontainers.image.description": "Pi-hole in a docker container",
            "org.opencontainers.image.licenses": "NOASSERTION",
            "org.opencontainers.image.revision": "174128797c0c514d2715d9208f8e3ec517444ef1",
            "org.opencontainers.image.source": "https://github.com/pi-hole/docker-pi-hole",
            "org.opencontainers.image.title": "docker-pi-hole",
            "org.opencontainers.image.url": "https://github.com/pi-hole/docker-pi-hole",
            "org.opencontainers.image.version": "2025.02.0"
        },
        "MacAddress": "02:42:c0:a8:06:02",
        "OnBuild": null,
        "OpenStdin": false,
        "StdinOnce": false,
        "Tty": false,
        "User": "",
        "Volumes": {
            "/etc": {}
        },
        "WorkingDir": "/"
    },
    "Created": "2025-02-18T21:13:55.538770878Z",
    "Driver": "overlay2",
    "ExecIDs": null,
    "GraphDriver": {
        "Data": {
            "LowerDir": "/var/lib/docker/overlay2/212f202a33bb8a91515786a8aac74f689ea5177fc4a28e032a1239bdfa1c2559-init/diff:/var/lib/docker/overlay2/4aaf1de46f66cccf73a32048a42a57692484f11d2cd764b93b24f538bc137929/diff:/var/lib/docker/overlay2/314584aaf8b220deb1d92c843b12ab4af56c883b385f56f8b52416b6e83a7433/diff:/var/lib/docker/overlay2/051f66436d63728df843c2b1a0c4558fa2a049909271ac361504b7eae7cab139/diff:/var/lib/docker/overlay2/7084fc7003e7ee4972e1c697dc2651d39f1cfa7a82b4f298fa67fc6a6b4a3ea7/diff:/var/lib/docker/overlay2/7801d14a2654c967b745eee148322326299a5ac310f6c65df6ac1bac591bd9cf/diff:/var/lib/docker/overlay2/f967403bda598cd8418ad4961344c5bfef67c4ca1a09e5a3827419f08755925a/diff:/var/lib/docker/overlay2/712c560e8810eb1e5b8451524b29cbef0b7b73bc8e30d44d768aca2bde24f5ca/diff:/var/lib/docker/overlay2/bba197cfb01a8f40324b594ac7ddd2fcb3aaafbe195728d1d089c1dd601b63b4/diff:/var/lib/docker/overlay2/ef0ffff94311d29feaf54acc1d26f67c8bca9e0107edf783938924c951636311/diff:/var/lib/docker/overlay2/0b7ca39da21ecfa46706065f0e7da801b6439226101814e28ddd2c73d07753b8/diff:/var/lib/docker/overlay2/ac017dba9718cbfa55331964ad93d844801dda05230847d97a7a1f9975229461/diff",
            "MergedDir": "/var/lib/docker/overlay2/212f202a33bb8a91515786a8aac74f689ea5177fc4a28e032a1239bdfa1c2559/merged",
            "UpperDir": "/var/lib/docker/overlay2/212f202a33bb8a91515786a8aac74f689ea5177fc4a28e032a1239bdfa1c2559/diff",
            "WorkDir": "/var/lib/docker/overlay2/212f202a33bb8a91515786a8aac74f689ea5177fc4a28e032a1239bdfa1c2559/work"
        },
        "Name": "overlay2"
    },
    "HostConfig": {
        "AutoRemove": false,
        "Binds": [
            "pihole-vlan-6-iot:/etc"
        ],
        "BlkioDeviceReadBps": null,
        "BlkioDeviceReadIOps": null,
        "BlkioDeviceWriteBps": null,
        "BlkioDeviceWriteIOps": null,
        "BlkioWeight": 0,
        "BlkioWeightDevice": null,
        "CapAdd": [
            "AUDIT_WRITE",
            "CHOWN",
            "DAC_OVERRIDE",
            "FOWNER",
            "FSETID",
            "KILL",
            "MKNOD",
            "NET_BIND_SERVICE",
            "NET_RAW",
            "SETFCAP",
            "SETGID",
            "SETPCAP",
            "SETUID",
            "SYS_CHROOT"
        ],
        "CapDrop": [
            "AUDIT_CONTROL",
            "BLOCK_SUSPEND",
            "DAC_READ_SEARCH",
            "IPC_LOCK",
            "IPC_OWNER",
            "LEASE",
            "LINUX_IMMUTABLE",
            "MAC_ADMIN",
            "MAC_OVERRIDE",
            "NET_ADMIN",
            "NET_BROADCAST",
            "SYSLOG",
            "SYS_ADMIN",
            "SYS_BOOT",
            "SYS_MODULE",
            "SYS_NICE",
            "SYS_PACCT",
            "SYS_PTRACE",
            "SYS_RAWIO",
            "SYS_RESOURCE",
            "SYS_TIME",
            "SYS_TTY_CONFIG",
            "WAKE_ALARM"
        ],
        "Cgroup": "",
        "CgroupParent": "",
        "CgroupnsMode": "private",
        "ConsoleSize": [
            0,
            0
        ],
        "ContainerIDFile": "",
        "CpuCount": 0,
        "CpuPercent": 0,
        "CpuPeriod": 0,
        "CpuQuota": 0,
        "CpuRealtimePeriod": 0,
        "CpuRealtimeRuntime": 0,
        "CpuShares": 0,
        "CpusetCpus": "",
        "CpusetMems": "",
        "DeviceCgroupRules": null,
        "DeviceRequests": [],
        "Devices": [],
        "Dns": [
            "1.1.1.1"
        ],
        "DnsOptions": [],
        "DnsSearch": [],
        "ExtraHosts": [],
        "GroupAdd": null,
        "IOMaximumBandwidth": 0,
        "IOMaximumIOps": 0,
        "Init": false,
        "IpcMode": "private",
        "Isolation": "",
        "Links": null,
        "LogConfig": {
            "Config": {},
            "Type": "json-file"
        },
        "MaskedPaths": [
            "/proc/asound",
            "/proc/acpi",
            "/proc/kcore",
            "/proc/keys",
            "/proc/latency_stats",
            "/proc/timer_list",
            "/proc/timer_stats",
            "/proc/sched_debug",
            "/proc/scsi",
            "/sys/firmware",
            "/sys/devices/virtual/powercap"
        ],
        "Memory": 0,
        "MemoryReservation": 0,
        "MemorySwap": 0,
        "MemorySwappiness": null,
        "NanoCpus": 0,
        "NetworkMode": "vlan-6-iot",
        "OomKillDisable": null,
        "OomScoreAdj": 0,
        "PidMode": "",
        "PidsLimit": null,
        "PortBindings": {},
        "Privileged": false,
        "PublishAllPorts": false,
        "ReadonlyPaths": [
            "/proc/bus",
            "/proc/fs",
            "/proc/irq",
            "/proc/sys",
            "/proc/sysrq-trigger"
        ],
        "ReadonlyRootfs": false,
        "RestartPolicy": {
            "MaximumRetryCount": 0,
            "Name": "always"
        },
        "Runtime": "runc",
        "SecurityOpt": null,
        "ShmSize": 67108864,
        "UTSMode": "",
        "Ulimits": null,
        "UsernsMode": "",
        "VolumeDriver": "",
        "VolumesFrom": null
    },
    "HostnamePath": "/var/lib/docker/containers/ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6/hostname",
    "HostsPath": "/var/lib/docker/containers/ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6/hosts",
    "Id": "ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6",
    "Image": "sha256:b7c0ddbd740f714f4c07e20028a06efa2a039e3c1360ca87bfe7918482a53b09",
    "LogPath": "/var/lib/docker/containers/ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6/ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6-json.log",
    "MountLabel": "",
    "Mounts": [
        {
            "Destination": "/etc",
            "Driver": "local",
            "Mode": "z",
            "Name": "pihole-vlan-6-iot",
            "Propagation": "",
            "RW": true,
            "Source": "/var/lib/docker/volumes/pihole-vlan-6-iot/_data",
            "Type": "volume"
        }
    ],
    "Name": "/pihole-vlan-6-iot",
    "NetworkSettings": {
        "Bridge": "",
        "EndpointID": "",
        "Gateway": "",
        "GlobalIPv6Address": "",
        "GlobalIPv6PrefixLen": 0,
        "HairpinMode": false,
        "IPAddress": "",
        "IPPrefixLen": 0,
        "IPv6Gateway": "",
        "LinkLocalIPv6Address": "",
        "LinkLocalIPv6PrefixLen": 0,
        "MacAddress": "",
        "Networks": {
            "vlan-6-iot": {
                "Aliases": [
                    "pihole"
                ],
                "DNSNames": [
                    "pihole-vlan-6-iot",
                    "pihole",
                    "ce668fd4e051"
                ],
                "DriverOpts": null,
                "EndpointID": "d2a7d52b90fcb01252e57e801ae01018c4e3211d07f0d46b3e42d6d901b4fc38",
                "Gateway": "192.168.6.1",
                "GlobalIPv6Address": "",
                "GlobalIPv6PrefixLen": 0,
                "IPAMConfig": {
                    "IPv4Address": "192.168.6.2"
                },
                "IPAddress": "192.168.6.2",
                "IPPrefixLen": 24,
                "IPv6Gateway": "",
                "Links": null,
                "MacAddress": "02:42:c0:a8:06:02",
                "NetworkID": "3db78dde041997bb32cee8bdeb0f6758ad6ab01cd50b84cf20e0b429d03c8dc5"
            }
        },
        "Ports": {},
        "SandboxID": "4a979faa83a9152ef38da2537db4639d04f43b4d70d59b11c137b9e0ab89cad5",
        "SandboxKey": "/var/run/docker/netns/4a979faa83a9",
        "SecondaryIPAddresses": null,
        "SecondaryIPv6Addresses": null
    },
    "Path": "start.sh",
    "Platform": "linux",
    "ProcessLabel": "",
    "ResolvConfPath": "/var/lib/docker/containers/ce668fd4e05165ab6e55ccd7d4f0087a440edbb8e22d0e18b9104d90a64846f6/resolv.conf",
    "RestartCount": 0,
    "State": {
        "Dead": false,
        "Error": "",
        "ExitCode": 0,
        "FinishedAt": "0001-01-01T00:00:00Z",
        "Health": {
            "FailingStreak": 0,
            "Log": [
                {
                    "End": "2025-02-19T11:30:22.184223823+01:00",
                    "ExitCode": 0,
                    "Output": "192.168.6.2\n",
                    "Start": "2025-02-19T11:30:22.038917736+01:00"
                },
                {
                    "End": "2025-02-19T11:30:52.33250725+01:00",
                    "ExitCode": 0,
                    "Output": "192.168.6.2\n",
                    "Start": "2025-02-19T11:30:52.185825836+01:00"
                },
                {
                    "End": "2025-02-19T11:31:22.534211332+01:00",
                    "ExitCode": 0,
                    "Output": "192.168.6.2\n",
                    "Start": "2025-02-19T11:31:22.334257234+01:00"
                },
                {
                    "End": "2025-02-19T11:31:52.675744368+01:00",
                    "ExitCode": 0,
                    "Output": "192.168.6.2\n",
                    "Start": "2025-02-19T11:31:52.536120124+01:00"
                },
                {
                    "End": "2025-02-19T11:32:22.827978291+01:00",
                    "ExitCode": 0,
                    "Output": "192.168.6.2\n",
                    "Start": "2025-02-19T11:32:22.678260893+01:00"
                }
            ],
            "Status": "healthy"
        },
        "OOMKilled": false,
        "Paused": false,
        "Pid": 276102,
        "Restarting": false,
        "Running": true,
        "StartedAt": "2025-02-18T21:14:06.920672283Z",
        "Status": "running"
    }
}