Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5
-
None
Description
prior to MDEV-14425 , commit 9ef2d29ff44de2013c95666a011b993e5c2e5674
Innodb used the file sharing modes on Windows, to prevent opening the same files in write mode multiple times. This avoided e.g different mysqld instances to run with the same innodb_datadir (without innodb_readonly)
With MDEV-14425, this got broken and files are always opened as FILE_SHARE_READ|FILE_SHARE_WRITE| FILE_SHARE_DELETE , since both log_sys and recv_sys redo log in readwrite mode.
This should be changed back to avoid GENERIC_WRITE with FILE_SHARE_WRITE in general case (mariabackup will still need this flag, but the server won't)
Either log_sys.log can be opened after recv_sys is done, or log_sys.log can open file as readonly (FILE_SHARE_WRITE) is log_sys on some reason must be initialized first.