[MDEV-33095] innodb_flush_method=O_DIRECT creates excessive errors on Solaris - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4, 10.11.6
Fix Version/s: 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2, 11.4.1
Component/s: Storage Engine - InnoDB
Labels:
- portability
- regression
Environment:
Solaris 11.4/x86

Description

After upgrading MariaDB from 10.3.9 to 10.11.6, we got an excessive number of errors in the server logs:
```
2023-12-20 11:25:48 0 [ERROR] InnoDB: Failed to set DIRECTIO_ON on file ./mysql/gtid_slave_pos.ibd; OPEN: Inappropriate ioctl for device, continuing anyway.
```
It seems the general change of default for `innodb_flush_method` from `fsync` to `O_DIRECT` on every platform is ill-advised: `O_DIRECT` is *not* portable across Unix platforms, but is a Linux extensions that has been adopted by some non-Linux targets, but is certainly not POSIX.

While I can manually restore the default to `fsync` to avoid this flood of errors, `mysqld` should only change the default to `O_DIRECT` on targets where it's supported and known to work.

Attachments

Issue Links

blocks

MDEV-33203 storage/innobase/os/os0file.cc doesn't compile on Solaris

Closed

is caused by

MDEV-24854 Change innodb_flush_method=O_DIRECT by default

Closed

relates to

MDEV-30136 Map innodb_flush_method to new settable Booleans innodb_{log,data}_file_{buffering,write_through}

Closed

MDEV-33581 Modern versions of MariaDB no longer build on OpenBSD

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Rainer Orth

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-12-20 13:16

Updated:: 2024-03-04 06:05

Resolved:: 2024-01-19 10:54

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.