[debian-mysql] Bug#1009290: Bug#1009290: mariadb-server-10.6: Fails to start on live system

[Daniel Lewart]

Faustin,

> I am not able to reproduce this with the latest
> mariadb-server-10.6-dbgsym version (10.6.8).

> Can you try with the latest version and tell me?

Yes, I tried 10.6.8-1 with the same result.

> Also, can you describe a bit better your setup?  If this is a filesystem
> related issue, I would like to try to reproduce it myself.

Yes.  This is a simplified version of my setup ...

1) sudo apt -y install apt-cacher-ng live-build

2) I used Live Build to create a live sid image:
    #!/bin/sh
    cd /dev/shm
    sudo mount /dev/shm -odev,exec,remount,size=3G
    lb config --apt-http-proxy http://localhost:3142 -d sid
    echo '! Packages Priority standard' \
        > config/package-lists/standard.list.chroot
    echo 'deb http://deb.debian.org/debian-debug sid-debug main' \
        > config/archives/live.list.binary
    sudo lb build

3) qemu-system-x86_64 -enable-kvm -cdrom /dev/shm/live-image-amd64.hybrid.iso \
        -cpu host -m 4G -smp 2

4) In the guest, it didn't matter what I tried:
    sudo apt -y install mariadb-server
    sudo apt -y install mariadb-server-10.6-dbgsym
mariadb-server-core-10.6-dbgsym

I'm sure it is an overlay filesystem issue:

$ sudo ls -l /var/lib/mysql/ibdata1
-rw-rw---- 1 mysql mysql 0 May 25 12:34 /var/lib/mysql/ibdata1

$ df -hT /var/lib/mysql
Filesystem     Type     Size  Used Avail Use% Mounted on
overlay        overlay  2.0G  355M  1.6G  19% /

$ findmnt -J /
{
   "filesystems": [
      {
         "target": "/",
         "source": "overlay",
         "fstype": "overlay",
         "options":
"rw,noatime,lowerdir=/run/live/rootfs/filesystem.squashfs/,upperdir=/run/live/overlay/rw,workdir=/run/live/overlay/work"
      }
   ]
}

> I have tested with a systemd container that I have created for these
> kind of testing, here are the commands (using podman):
>
> | podman run --name sys-test --rm -d fauust/docker-systemd:debian-sid
> | podman exec -it sys-test bash -c "echo \"deb http://deb.debian.org/debian-debug/ sid-debug main\" >> /etc/apt/sources.list && apt update && apt install -y mariadb-server-10.6-dbgsym"

I will give this a try.  I'm curious what filesystem the container uses.

Thank you!
Dan
Urbana, IL