[MDEV-21260] MariadDB on Windows (datadir as network resource) Created: 2019-12-09 Updated: 2019-12-12 Resolved: 2019-12-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Platform Windows |
| Affects Version/s: | 10.4.8 |
| Fix Version/s: | 10.4.12 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Kai Klueber | Assignee: | Vladislav Vaintroub |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | CreateFile, datadir, network, unc, windows | ||
| Environment: |
Windows Server 2012 R2 / Windows 10 Enterprise |
||
| Attachments: |
|
| Description |
|
We run MariaDB 10.4.8 with the parameter datadir as network resource (UNC-Path) Our configuration:
The mariadb-error-log shows the following entries as soon a new InnoDB-table is created ("CREATE TABLE ..."):
If we set "innodb_file_per_table = OFF" the problem is not showing up. |
| Comments |
| Comment by Vladislav Vaintroub [ 2019-12-10 ] | ||||||||||||||
|
An easy workaround seem to be to create a symbolic link (with mklink) pointing to the UNC path, and use it as datadir. Can you attach the full error log , please? Just for my curiosity, why would you use remote SMB pathfor the database? That seems a lot of network and SMB overhead, for every IO | ||||||||||||||
| Comment by Vladislav Vaintroub [ 2019-12-11 ] | ||||||||||||||
|
I'm able to actually start database, if I put files on (local) share. This is what I got.
| ||||||||||||||
| Comment by Kai Klueber [ 2019-12-12 ] | ||||||||||||||
|
Thanks for the feedback. I attached the errorlog. Yes, the database is starting. Removing the status "blocker" is ok. Can you tell me more about the error and why this error is not cirtical. What is the cause of the error-message? I noticed that the ticket is now in the status "closed" and that there will be an fix on 10.4.12. Can you tell me more about the fix? | ||||||||||||||
| Comment by Vladislav Vaintroub [ 2019-12-12 ] | ||||||||||||||
|
The Innodb tries to find out what is the sector size on the disk, and whether it is on SSD. To achieve that, Innodb tries to open the volume where file is on (which would be like, C:\ for datadir on local disk). But for the UNC, it can't, thus the error message. But there is no big tragedy, if it can't find out about sector size or SSD, then it falls back to defaults. | ||||||||||||||
| Comment by Kai Klueber [ 2019-12-12 ] | ||||||||||||||
|
Thanks for the detailed explanation |