Once an updated kernel is made available, this will just work. On Mon, 23 May 2022, 18:40 Lena Voytek, <[email protected]> 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 > > -- You received this bug notification because you are a member of Kernel Packages, which is subscribed to zfs-linux in Ubuntu. 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 -- Mailing list: https://launchpad.net/~kernel-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~kernel-packages More help : https://help.launchpad.net/ListHelp
