更新到8.0.22后出现MySQL服务器InnoDB posix_fallocate()错误

Question

在我将MySQL服务器更新到8.0.22版本后，我的mysqld设置出现问题，并且我无法启动MySQL服务器。

以下是错误日志：

2020-10-20T16:35:36.489961Z 1 [ERROR] [MY-012128] [InnoDB] posix_fallocate(): Failed to preallocate data for file ./#innodb_temp/temp_1.ibt, desired size 81920 Operating system error number 22. Check that the disk is not full or a disk quota exceeded. Make sure the file system supports this function. Refer to your operating system documentation for operating system error code information
2020-10-20T16:35:36.490507Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Out of disk space.
2020-10-20T16:35:36.807468Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-10-20T16:35:36.808412Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-10-20T16:35:36.809642Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-10-20T16:35:36.811459Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22)  MySQL Community Server - GPL.

我的操作系统是Debian 9。

Answer 1

我已经提交了一个与mysql bug类似的bug。

基本上，就像https://bugs.mysql.com/bug.php?id=74167一样，EXT3文件系统不支持posix_fallocate，它将返回EINVAL。