Comment 27 for bug 1969247

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
>
>