[MDEV-20594] InnoDB ibdata1 preallocation fails on 9p fs. mount Created: 2019-09-15  Updated: 2022-02-20  Resolved: 2022-02-20

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: BLSoft Team Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: innodb
Environment:

Docker, Alpine 3.8


Issue Links:
Duplicate
duplicates MDEV-16015 Unhandled EOPNOTSUPP of posix_falloca... Closed

 Description   

When using docker volumes for /var/lib/mysql on 9p fs. mounts, the initial preallocation fails for ibdata1 file. The error was stating that fallocate failed with exit code 95. Our further investigation revealed that 9p fs (and ZFS) does not support fallocate at all. We tried a few workarounds that we found online, but nothing worked. As it is a common pratice to use MariaDB in a virtual environment, we need a way to use it and it's not realy possible with the current version of MariaDB.


Generated at Thu Feb 08 09:00:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.