[MDEV-21260] MariadDB on Windows (datadir as network resource) - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Fixed
Affects Version/s: 10.4.8
Fix Version/s: 10.4.12
Component/s: Platform Windows
Labels:
- CreateFile
- datadir
- network
- unc
- windows
Environment:
Windows Server 2012 R2 / Windows 10 Enterprise

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:

---------------------------------------------------------------------

[mysqld]

datadir			= //STA-WS001/MariaDBData/Data

port			= 3306

innodb_buffer_pool_size = 2033M

character-set-server	= utf8

[client]

port			= 3306

plugin-dir		= C:/Program Files/MariaDB 10.4/lib/plugin

---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.

2019-12-09 16:20:30 36 [ERROR] InnoDB: The error means the system cannot find the path specified.

2019-12-09 16:20:30 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

errorlog.txt
2 kB
2019-12-12 12:06

Activity

Ascending order - Click to sort in descending order

Kai Klueber created issue - 2019-12-09 16:02

Kai Klueber made changes - 2019-12-09 16:03

Field	Original Value	New Value
Description	We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path) Our configuration: --------------------------------------------------------------------- [mysqld] datadir = //STA-WS001/MariaDBData/Data port = 3306 innodb_buffer_pool_size = 2033M character-set-server = utf8 [client] port = 3306 plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin --------------------------------------------------------------------- The mariadb-error-log shows the following entries as soon a new table is created ("CREATE TABLE ..."): 2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified. 2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203. 2019-12-09 15:32:39 36 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found. If we set "innodb_file_per_table = OFF" the problem is not showing up.	We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path) Our configuration: --------------------------------------------------------------------- [mysqld] datadir = //STA-WS001/MariaDBData/Data port = 3306 innodb_buffer_pool_size = 2033M character-set-server = utf8 [client] port = 3306 plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin --------------------------------------------------------------------- The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."): 2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified. 2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203. 2019-12-09 15:32:39 36 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found. If we set "innodb_file_per_table = OFF" the problem is not showing up.

Kai Klueber made changes - 2019-12-09 16:17

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.
2019-12-09 15:32:39 36 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

Kai Klueber made changes - 2019-12-09 16:19

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

Kai Klueber made changes - 2019-12-09 16:21

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 16:20:30 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 16:20:30 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

Anel Husakovic made changes - 2019-12-09 16:22

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------

The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):

2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 16:20:30 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 16:20:30 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.

If we set "innodb_file_per_table = OFF" the problem is not showing up.

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
{code: noformat}
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------
{code}
The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):
{code:noformat}
2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 15:32:39 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 15:32:39 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.
{code}
If we set "innodb_file_per_table = OFF" the problem is not showing up.

Kai Klueber made changes - 2019-12-09 17:01

Description

We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path)

Our configuration:
{code: noformat}
---------------------------------------------------------------------
[mysqld]
datadir = //STA-WS001/MariaDBData/Data
port = 3306
innodb_buffer_pool_size = 2033M
character-set-server = utf8
[client]
port = 3306
plugin-dir = C:/Program Files/MariaDB 10.4/lib/plugin
---------------------------------------------------------------------
{code}
The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):
{code:noformat}
2019-12-09 16:20:30 36 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2019-12-09 16:20:30 36 [ERROR] InnoDB: The error means the system cannot find the path specified.
2019-12-09 16:20:30 36 [ERROR] InnoDB: File \\.\\\STA-WS001\MariaDBData: 'CreateFile()' returned OS error 203.
{code}
If we set "innodb_file_per_table = OFF" the problem is not showing up.

Vladislav Vaintroub made changes - 2019-12-11 23:46

Priority

Blocker [ 1 ]

Major [ 3 ]

Vladislav Vaintroub made changes - 2019-12-12 10:52

Assignee

Vladislav Vaintroub [ wlad ]

Vladislav Vaintroub made changes - 2019-12-12 10:52

Component/s	Data Definition - Create Table [ 14503 ]
Fix Version/s		10.4.12 [ 24019 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Vladislav Vaintroub made changes - 2019-12-12 10:53

Priority

Major [ 3 ]

Minor [ 4 ]

Kai Klueber made changes - 2019-12-12 12:04

Attachment

errorlog.txt [ 49656 ]

Kai Klueber made changes - 2019-12-12 12:06

Attachment

errorlog.txt [ 49656 ]

Kai Klueber made changes - 2019-12-12 12:06

Attachment

errorlog.txt [ 49657 ]

Sergei Golubchik made changes - 2021-12-06 21:50

Workflow

MariaDB v3 [ 101744 ]

MariaDB v4 [ 157074 ]

People

Assignee:: Vladislav Vaintroub

Reporter:: Kai Klueber

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-12-09 16:02

Updated:: 2019-12-12 13:17

Resolved:: 2019-12-12 10:52

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration