[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
mysql's install also fails with the same error when using a native Jammy Desktop with zfs. I can also confirm fallocate fails on this system as it produces zero-size files on its own. I'm going to mark mysql invalid here and set this up as a kernel bug for zfs ** Changed in: mysql-8.0 (Ubuntu) Status: Confirmed => Invalid ** Changed in: mysql-8.0 (Ubuntu) Assignee: Lena Voytek (lvoytek) => (unassigned) ** Changed in: zfs-linux (Ubuntu) Status: New => Confirmed ** Summary changed: - mysql-server install crashes in LXD container on Jammy host + fallocate produces zero-size files on zfs in Jammy -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: fallocate produces zero-size files on zfs in Jammy To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
** Also affects: zfs-linux (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container on Jammy host To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
I'm suspecting fallocate() on zfs.
To reproduce, one can follow these steps:
rm -rf /var/lib/mysql/*
mysqld --initialize
This will produce a zero-sized file:
# ll /var/lib/mysql/ib_logfile1
-rw-r- 1 mysql mysql 0 Apr 18 17:37 /var/lib/mysql/ib_logfile1
Attempting to start mysql now will fail with this error:
2022-04-18T17:41:30.181861Z 1 [ERROR] [MY-012963] [InnoDB] Log file
./ib_logfile1 is of different size 0 bytes than other log files 17809408 bytes!
On a working system, that file is not zero-sized.
straceing mysqld --initialize shows:
2253 openat(AT_FDCWD, "./ib_logfile1", O_RDWR|O_CREAT|O_EXCL, 0640) = 3
2253 fcntl(3, F_SETLK, {l_type=F_WRLCK, l_whence=SEEK_SET, l_start=0,
l_len=0}) = 0
2253 fallocate(3, FALLOC_FL_ZERO_RANGE, 0, 50331648) = 0
2253 fsync(3) = 0
2253 close(3) = 0
There have been previous bugs with zfs and fallocate():
https://bugs.launchpad.net/ubuntu/+source/libvirt/+bug/1847105
https://github.com/openzfs/zfs/issues/326
I tried --innodb-extend-and-initialize and --skip-innodb-extend-and-
initialize, from https://dev.mysql.com/worklog/task/?id=13782, but both
ended up using fallocate().
A quick attempt with using the dir backend for lxd worked. Further
investigation needs to be done.
** Bug watch added: github.com/openzfs/zfs/issues #326
https://github.com/openzfs/zfs/issues/326
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1969247
Title:
mysql-server install crashes in LXD container on Jammy host
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
This seems to be due to a zfs regression when running fallocate, causing mysql's initialization to produce an ib_logfile1 of size 0: 1893 fallocate(3, FALLOC_FL_ZERO_RANGE, 0, 50331648) = 0 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container on Jammy host To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
I was also able to confirm this by using a Jammy VM (launched with lxd) and then launching a Focal container inside it. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container on Jammy host To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
Confirmed by others with Jammy host systems and by me on a second Jammy host system ** Changed in: mysql-8.0 (Ubuntu) Status: New => Confirmed ** Changed in: mysql-8.0 (Ubuntu) Assignee: (unassigned) => Lena Voytek (lvoytek) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container on Jammy host To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container on Jammy host
** Summary changed: - mysql-server install crashes in LXD container + mysql-server install crashes in LXD container on Jammy host -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container on Jammy host To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container
This affects Focal, Impish, and Jammy (not Bionic). I figured out that the error only shows up on my laptop (on Jammy) though. Meanwhile my Desktop (on Focal) installs it successfully for all. Both systems are running the same LXD snap version 5.0.0-e478009 (latest/stable). -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1969247] Re: mysql-server install crashes in LXD container
** Summary changed: - mysql-server install crashes after installing mysql-common and libmysqlclient21 first + mysql-server install crashes in LXD container ** Description changed: 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. This bug does not seem urgent but the - report may help me categorize it if it comes up again later. + 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 + [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 + 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) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1969247 Title: mysql-server install crashes in LXD container To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1969247/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
