[MDEV-30512] mysqldump.exe not working with 'innodb_flush_method=unbuffered' Created: 2023-01-30  Updated: 2023-01-31  Resolved: 2023-01-30

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.7.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Mitchell Lee Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Windows 11 22H2


Issue Links:
Relates
relates to MDEV-30517 On windows 11, difference of innodb_f... Closed

 Description   

C:\Program Files\MariaDB\bin\mysqldump.exe: unknown variable 'innodb_flush_method=unbuffered'

Fix it.

--------------
[mysqldump]
default-character-set=utf8mb4_unicode_ci
innodb_flush_method=unbuffered



 Comments   
Comment by Daniel Black [ 2023-01-30 ]

While Mariabackup will take several innodb variables because it directly interacts with the database files directly, mysqldump.exe/mariadb-dump.exe purely interacts with the server via SQL and as such doesn't support any storage engine variables. All mysqldump.exe interactions with the server rely on the server settings.

Comment by Mitchell Lee [ 2023-01-31 ]

Now understand the behavior why the messages occured,
but what people what is
"Okay sir, will fix it by ignore unsupported properties(and even display as ignored). Thanks" it is.
Be professional MaraDB guys. in attitude and product deliverable quality since it is kinda commercial product.

Comment by Daniel Black [ 2023-01-31 ]

Hi Sir,

Ignoring incorrect options would be inconsistent with the existing handling of options server wide. An error provides the ability to correct a misspelling or understand why the option isn't there. If an ignore is required there is the --loose prefix that can apply to any option.

This will produce an ignored warning like:

$ client/mysqldump --loose-innodb_flush_method=unbuffered -S /tmp/build-mariadb-server-10.7-base.sock  --all-databases  > /dev/null
Warning: client/mysqldump: unknown variable 'loose-innodb_flush_method=unbuffered'

I see you've had a series of fairly serious bugs you have reported (much appreciated). As a former DBA I empathize with the pain this has caused.

I apologize if my standard of prompt responses falls short of your standards. I suspect the commercial support offering have staff that will offer a attitude you find more agreeable. I am trying to improve the quality with bug fixes (like MDEV-30492) to the reported problems, and/to identify systemic quality problems.

Comment by Mitchell Lee [ 2023-01-31 ]

Appreciate for the reply. Truly.
(But pains still, as crashs as you know. Let people get out of here. Damn)

Generated at Thu Feb 08 10:16:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.