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

#1028429#5
Date:
2023-01-10 22:06:19 UTC
From:
To:
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