ib_logfile1 is of different size 0 bytes than other log files 18874368 bytes

[RAHMAN Mostafizur]

could not install mysql

ProblemType: Package
DistroRelease: Ubuntu 22.04
Package: mysql-server-8.0 8.0.29-0ubuntu0.22.04.1
ProcVersionSignature: Ubuntu 5.15.0-27.28-generic 5.15.30
Uname: Linux 5.15.0-27-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia zfs zunicode zavl icp zcommon znvpair
ApportVersion: 2.20.11-0ubuntu82
Architecture: amd64
CasperMD5CheckResult: pass
Date: Thu May 5 11:05:17 2022
ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1
InstallationDate: Installed on 2022-05-05 (0 days ago)
InstallationMedia: Ubuntu 22.04 LTS "Jammy Jellyfish" - Release amd64 (20220419)
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: ['ib_buffer_pool', '#ib_16384_1.dblwr', 'performance_schema', 'server-cert.pem', 'ca-key.pem', 'client-cert.pem', 'auto.cnf', '#ib_16384_0.dblwr', 'sys', 'debian-5.7.flag', 'ib_logfile0', 'mysql', 'mysql.ibd', 'public_key.pem', 'server-key.pem', 'private_key.pem', 'ib_logfile1', 'ibdata1', 'undo_001', 'client-key.pem', '#innodb_temp', 'ca.pem', 'binlog.index', 'undo_002']
ProcCmdline: BOOT_IMAGE=/BOOT/ubuntu_wqyj0s@/vmlinuz-5.15.0-27-generic root=ZFS=rpool/ROOT/ubuntu_wqyj0s ro quiet splash
Python3Details: /usr/bin/python3.10, Python 3.10.4, python3-minimal, 3.10.4-0ubuntu2
PythonDetails: N/A
RelatedPackageVersions:
 dpkg 1.21.1ubuntu2
 apt 2.4.5
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.29-0ubuntu0.22.04.1 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)

[Seth Arnold (seth-arnold)]

Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find.

[Paride Legovini (paride)]

Hello and thanks for this bug report. In the attached logs I see the following:

MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf'

This looks like a local configuration problem (circular symlinking), rather than a bug in Ubuntu.

You can find pointers to get help for this sort of problem here: https://ubuntu.com/support/community-support

Since we use this bug tracker to track bugs in Ubuntu, rather than configuration problems, I'm marking this bug as Invalid. This helps us to focus on fixing bugs in Ubuntu.

If you believe that this is really a bug, then you may find it helpful to read "How to report bugs effectively" http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then provide a more complete description of the problem, explain why you believe this is a bug in Ubuntu rather than a problem specific to your system, and then change the bug status back to New. Thanks!

[Lena Voytek (lvoytek)]

Hello,

The error Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' is actually an error with the reporting system and not your configuration. The error that crashed the installer is in mysql/error.log which states:

Log file ./ib_logfile1 is of different size 0 bytes than other log files 18874368 bytes!

This is due to an error in zfs that breaks fallocate and is being worked on here:

https://bugs.launchpad.net/ubuntu/+source/zfs-linux/+bug/1969247

I am marking this bug as a duplicate. If you believe this is incorrect or your issue is not fixed when it is released to Jammy feel free to change this and let us know.

Thanks!