Bug#1028429: akonadi-backend-mysql: mysqld crashes when started on overlayfs (a seen on a live image)

[Roland Clobus <rclobus@rclobus.nl>]

Package: akonadi-backend-mysql
Version: 4:22.08.3-1
Severity: normal
User: debian-qa@lists.debian.org
X-Debbugs-Cc: phil@hands.com

Hello maintainers of akonadi-backend-mysql,

As seen on the recent live images for Sid:
https://openqa.debian.net/tests/113442#step/kmail/1

kmail (and kaddressbook, korganizer and pimdataexporter) do not start the
akonadi server properly; the akonadi server crashes.

Some investigation using strace suggests that a mariadb server cannot be
started on a location that uses overlayfs, because the fallocate function
return 0 instead of the allocated space.

I've found a work-around: I've installed akonadi-backend-sqlite instead of
akonadi-backend-mysql.
However, the mysql backend is installed per default, because it is the first
backend listed in the dependencies.

What do you propose?
Should the live images install akonadi-backend-sqlite instead of akonadi-
backend-mysql?

Step to get a working akonadi while in a live environment:
* apt-get install akonadi-backend-sqlite
* apt-get remove --purge akonadi-backend-mysql
* apt autoremove
* # Delete all user settings:
* find ~ -name "*akonadi*" -delete -print
* akonadictl start

With kind regards,
Roland Clobus

PS If the link above went stale, use this:
- Go to https://openqa.debian.net/group_overview/14
- Go to the latest sid_kde image
- Go to the link with 'apps_startstop'
- Under 'Logs & Assets', the actual ISO image can be downloaded



-- System Information:
Debian Release: bookworm/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'testing-debug'), (50, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 6.0.0-6-amd64 (SMP w/8 CPU threads; PREEMPT)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages akonadi-backend-mysql depends on:
pn  default-mysql-client-core | virtual-mysql-client-core  <none>
pn  default-mysql-server-core | virtual-mysql-server-core  <none>
pn  libqt5sql5-mysql                                       <none>

Versions of packages akonadi-backend-mysql recommends:
pn  akonadi-server  <none>

akonadi-backend-mysql suggests no packages.