MySQL 8 LXC/ZFS issues

lk7777 · April 15, 2022, 4:33pm

I didn’t have a chance to try install MySQL 8 on Ubuntu host with ZFS storage but have Proxmox on ZFS and Ubuntu 20.04 LXC container.
There is something about ZFS storage which prevents MySQL 8 installation on it. InnoDB complains about different size of the following logs:

-rw-rw----  1 mysql mysql 17825792  Apr  7 17:43 ib_logfile0
-rw-rw----  1 mysql mysql 0         Apr  7 17:43 ib_logfile1

So a suspect in this situation is ZFS.

It doesn’t work and on Debian 11 lxc container either.
I do no not know exactly what causes this issue. LXC/ZFS ?

Ubuntu 20.04 host on BTRFS there are no issues with MySQL 8 in LXD containers.

sdeziel · April 18, 2022, 11:04pm

Sounds similar to:

github.com/openzfs/zfs

MySQL's ib_logfile1 cannot be created properly

opened 09:27PM - 14 Apr 22 UTC

tomposmiko

Type: Defect

### System information Type | Version/Name --- | --- Distribution Name | Ubuntu Distribution Version | 22.04 and 18.04 Kernel Version | 5.15 and 5.4 Architecture | amd64 OpenZFS Version | zfs-2.1.2-1ubuntu3 and zfs-2.1.4-0york0~18.04  ### Describe the problem you're observing I'm not sure, if it's caused by ZFS, though its probability is quite high. If I start Percona MySQL Server 8.0 backed with ZFS, I get the following error: ``` 2022-04-14T21:10:15.443147Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-18) starting as process 2259 2022-04-14T21:10:15.463221Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-04-14T21:10:15.547437Z 1 [ERROR] [MY-012963] [InnoDB] Log file ./ib_logfile1 is of different size 0 bytes than other log files 17793024 bytes! 2022-04-14T21:10:15.547485Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 2022-04-14T21:10:16.534037Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2022-04-14T21:10:16.534204Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2022-04-14T21:10:16.534296Z 0 [ERROR] [MY-010119] [Server] Aborting ``` ### Describe how to reproduce the problem Create a dataset with recent ZFS version, get it mounted to /var/lib/mysql and initialize a database instance on it (eg. `apt install percona-server-server`). Version 5.7 works properly. I tested Percona only, did not test classic MySQL. I am pretty sure, it worked with a previous version from York's repository, just don't know, which was that, because I restarted that machine with the recent version. MySQL works well if the database is created somewhere else, eg. on xfs or ext4 and migrated to ZFS.