[MDEV-12948] ERROR in log file: IOCTL_STORAGE_QUERY_PROPERTY Created: 2017-05-29  Updated: 2018-04-14  Resolved: 2017-08-17

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.4, 10.2.5, 10.3.0, 10.2.6
Fix Version/s: 10.2.9

Type: Bug Priority: Minor
Reporter: Andrew Ramsay Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 1
Labels: None
Environment:

win7 x64, 32GB RAM, SSD, Mariadb 10.2.6 x64 version

Issue Links:
Duplicate
is duplicated by MDEV-13558 OS Error 201 appears in MariaDB log Closed
Problem/Incident
is caused by MDEV-11254 innodb-use-trim has no effect in 10.2 Closed

 Description   

When importing a database using a previous dump, The following errors appear in the error log. The sequence of three lines seem to appear once per table created. I can find no helpful reference to any of the statements.
The tables are created ok, and populated with data. I have tried this multiple times, with multiple databases, also a single table manually - in each case the result is the same:

2017-05-29 16:41:03 1092 [ERROR] InnoDB: Operating system error number 1 in a file operation.
2017-05-29 16:41:03 1092 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2017-05-29 16:41:03 1092 [ERROR] InnoDB: File \\.\d:: 'DeviceIoControl(IOCTL_STORAGE_QUERY_PROPERTY)' returned OS error 201.

 Comments   
Comment by Marko Mäkelä [ 2017-06-01 ]

The call DeviceIoControl(handle, IOCTL_STORAGE_QUERY_PROPERTY, …) was originally added in MDEV-11254, in this commit.
One problem in the patch was fixed 2 days later.

Both changes were first released in MariaDB 10.2.4.

According to this MSDN article, the "Operating system error 1" could be ERROR_INVALID_FUNCTION.

Comment by Jan Lindström (Inactive) [ 2017-06-01 ]

wlad This seems to be Windows problem and both patches mentioned above are by you.

Comment by Sergii Volikov [ 2017-06-24 ]

A similar situation for Windows Server 2008 R2

Comment by Sergii Volikov [ 2017-08-18 ]

Vladislav Vaintroub, thank you!

Comment by Sergii Volikov [ 2017-09-29 ]

10.2.9-MariaDB

2017-09-28 17:32:50 5784 [ERROR] InnoDB: File \\.\C:: 'DeviceIoControl(IOCTL_STORAGE_QUERY_PROPERTY)' returned OS error 250.

Generated at Thu Feb 08 08:01:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.