Once an updated kernel is made available, this will just work.

On Mon, 23 May 2022, 18:40 Lena Voytek, <email address hidden> wrote:

> That's fair, it does seem to work when using that method. However, for
> this to be an actual fix it needs to work out of the box. Since mysql
> still fails to install and fallocate still fails on kinetic after
> installing with zfs, it isn't ready for normal users yet
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1969247
>
> Title:
>   fallocate with FALLOC_FL_ZERO_RANGE produces zero-size files on zfs in
>   Jammy
>
> Status in Native ZFS for Linux:
>   Fix Released
> Status in mysql-8.0 package in Ubuntu:
>   Invalid
> Status in zfs-linux package in Ubuntu:
>   Fix Released
> Status in zfs-linux source package in Jammy:
>   Fix Committed
>
> Bug description:
>   [Summary]
>
>   When running Jammy on zfs or LXD with a zfs pool on a Jammy host,
>   fallocate creates a zero-sized file.
>
>   The issue was originally found when installing mysql on LXD, where
>   fallocate would create a zero-sized ib_logfile1 file. The original
>   information in this bug is based on that.
>
>   [Steps to Reproduce]
>
>   touch foo.img
>   fallocate -z -l 10M foo.img
>   ls -la foo.img
>
>   On a non-zfs Jammy system this will show something like:
>   -rw-r--r-- 1 root root 10M ...
>
>   while on zfs it will show:
>   -rw-rw-r-- 1 root root 0 ...
>
>   [Original Description]
>   I came across this error when testing various mysql setups in an LXD
> container and managed to reproduce it consistently. I'm unable to reproduce
> on Ubuntu desktop or server though since the prerequisites are probably
> handled properly there.
>
>   ProblemType: Package
>   DistroRelease: Ubuntu 20.04
>   Package: mysql-server-8.0 8.0.28-0ubuntu0.20.04.3
>   ProcVersionSignature: Ubuntu 5.15.0-25.25-generic 5.15.30
>   Uname: Linux 5.15.0-25-generic x86_64
>   ApportVersion: 2.20.11-0ubuntu27.23
>   Architecture: amd64
>   CasperMD5CheckResult: skip
>   Date: Fri Apr 15 21:31:09 2022
>   Dmesg:
>
>   ErrorMessage: installed mysql-server-8.0 package post-installation
> script subprocess returned error exit status 1
>   KernLog:
>
>   Logs.var.log.daemon.log:
>
>   MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
>   MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
>    [mysqldump]
>    quick
>    quote-names
>    max_allowed_packet   = 16M
>   MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of
> symbolic links: '/etc/mysql/my.cnf'
>   MySQLVarLibDirListing: ['ibdata1', 'ib_logfile0', '#innodb_temp',
> 'debian-5.7.flag', '#ib_16384_0.dblwr', 'client-cert.pem', 'undo_001',
> 'server-cert.pem', 'mysql.ibd', '#ib_16384_1.dblwr', 'client-key.pem',
> 'ca-key.pem', 'sys', 'private_key.pem', 'mysql', 'undo_002',
> 'binlog.index', 'performance_schema', 'ib_buffer_pool', 'auto.cnf',
> 'ib_logfile1', 'public_key.pem', 'ca.pem', 'server-key.pem']
>   ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.15.0-25-generic
> root=UUID=93666562-b5e4-4fb4-ba8c-7b42a3e6bf61 ro quiet splash
> mem_sleep_default=deep vt.handoff=7
>   Python3Details: /usr/bin/python3.8, Python 3.8.10, python3-minimal,
> 3.8.2-0ubuntu2
>   PythonDetails: N/A
>   RelatedPackageVersions:
>    dpkg 1.19.7ubuntu3
>    apt  2.0.6
>   SourcePackage: mysql-8.0
>   Title: package mysql-server-8.0 8.0.28-0ubuntu0.20.04.3 failed to
> install/upgrade: installed mysql-server-8.0 package post-installation
> script subprocess returned error exit status 1
>   UpgradeStatus: No upgrade log present (probably fresh install)
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/zfs/+bug/1969247/+subscriptions
>
>