[MDEV-24248] my_print_defaults is not taking all the values when using -e option which is called from mysql.server (extra_args). - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.8, 10.5
Fix Version/s: 10.5.12
Component/s: Scripts & Clients
Labels:
None

Description

It is reported by one of our customers the my_print_defaults -e option is not working with MariaDB server 10.5

Here are the test results:

At MariaDB server 10.4.17, my_print_defaults -e giving the required output. Whereas at MariaDB server 10.5.x, -e option is not working instead has to specify --defaults-extra-file (alias).

/root/my.cnf

[mariadb-10.4]

key_buffer_size=20M

max_allowed_packet=250M

table_open_cache=1000

table_definition_cache=2000

read_buffer_size=1M

thread_cache_size=8

max_connections=1024

long_query_time=60

slow_query_log=1

[root@test001 ~]# mysql --version

mysql  Ver 15.1 Distrib 10.4.17-MariaDB, for Linux (x86_64) using readline 5.1

[root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server

--key_buffer_size=20M

--max_allowed_packet=250M

--table_open_cache=1000

--table_definition_cache=2000

--read_buffer_size=1M

--thread_cache_size=8

--max_connections=1024

--long_query_time=60

--slow_query_log=1

/root/my.cnf

[mariadb-10.5]

key_buffer_size=20M

max_allowed_packet=250M

table_open_cache=1000

table_definition_cache=2000

read_buffer_size=1M

thread_cache_size=8

max_connections=1024

long_query_time=60

slow_query_log=1

[root@test001 ~]# mysql --version

mysql  Ver 15.1 Distrib 10.5.8-MariaDB, for Linux (x86_64) using readline 5.1

[root@test001 ~]#

[root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server

[root@test001 ~]# my_print_defaults --defaults-extra-file=/root/my.cnf --mysqld mysql.server

--key_buffer_size=20M

--max_allowed_packet=250M

--table_open_cache=1000

--table_definition_cache=2000

--read_buffer_size=1M

--thread_cache_size=8

--max_connections=1024

--long_query_time=60

--slow_query_log=1

Attachments

Issue Links

relates to

MDEV-25908 -e does not work for my_print_defaults

Closed

Activity

Ascending order - Click to sort in descending order

suresh ramagiri created issue - 2020-11-19 00:36

Sergei Golubchik made changes - 2020-11-19 13:01

Field	Original Value	New Value
Description	It is reported by one of our customers the my_print_defaults -e option is not working with MariaDB server 10.5 Here are the test results: At MariaDB server 10.4.17, my_print_defaults -e giving the required output. Whereas at MariaDB server 10.5.x, -e option is not working instead has to specify --defaults-extra-file (alias). /root/my.cnf [mariadb-10.4] key_buffer_size=20M max_allowed_packet=250M table_open_cache=1000 table_definition_cache=2000 read_buffer_size=1M thread_cache_size=8 max_connections=1024 long_query_time=60 slow_query_log=1 [root@test001 ~]# mysql --version mysql Ver 15.1 Distrib 10.4.17-MariaDB, for Linux (x86_64) using readline 5.1 [root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server --key_buffer_size=20M --max_allowed_packet=250M --table_open_cache=1000 --table_definition_cache=2000 --read_buffer_size=1M --thread_cache_size=8 --max_connections=1024 --long_query_time=60 --slow_query_log=1 /root/my.cnf [mariadb-10.5] key_buffer_size=20M max_allowed_packet=250M table_open_cache=1000 table_definition_cache=2000 read_buffer_size=1M thread_cache_size=8 max_connections=1024 long_query_time=60 slow_query_log=1 [root@test001 ~]# mysql --version mysql Ver 15.1 Distrib 10.5.8-MariaDB, for Linux (x86_64) using readline 5.1 [root@test001 ~]# [root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server [root@test001 ~]# my_print_defaults --defaults-extra-file=/root/my.cnf --mysqld mysql.server --key_buffer_size=20M --max_allowed_packet=250M --table_open_cache=1000 --table_definition_cache=2000 --read_buffer_size=1M --thread_cache_size=8 --max_connections=1024 --long_query_time=60 --slow_query_log=1	It is reported by one of our customers the my_print_defaults -e option is not working with MariaDB server 10.5 Here are the test results: At MariaDB server 10.4.17, my_print_defaults -e giving the required output. Whereas at MariaDB server 10.5.x, -e option is not working instead has to specify --defaults-extra-file (alias). /root/my.cnf {noformat} [mariadb-10.4] key_buffer_size=20M max_allowed_packet=250M table_open_cache=1000 table_definition_cache=2000 read_buffer_size=1M thread_cache_size=8 max_connections=1024 long_query_time=60 slow_query_log=1 {noformat} {noformat} [root@test001 ~]# mysql --version mysql Ver 15.1 Distrib 10.4.17-MariaDB, for Linux (x86_64) using readline 5.1 [root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server --key_buffer_size=20M --max_allowed_packet=250M --table_open_cache=1000 --table_definition_cache=2000 --read_buffer_size=1M --thread_cache_size=8 --max_connections=1024 --long_query_time=60 --slow_query_log=1 {noformat} /root/my.cnf {noformat} [mariadb-10.5] key_buffer_size=20M max_allowed_packet=250M table_open_cache=1000 table_definition_cache=2000 read_buffer_size=1M thread_cache_size=8 max_connections=1024 long_query_time=60 slow_query_log=1 {noformat} {noformat} [root@test001 ~]# mysql --version mysql Ver 15.1 Distrib 10.5.8-MariaDB, for Linux (x86_64) using readline 5.1 [root@test001 ~]# [root@test001 ~]# my_print_defaults -e /root/my.cnf --mysqld mysql.server [root@test001 ~]# my_print_defaults --defaults-extra-file=/root/my.cnf --mysqld mysql.server --key_buffer_size=20M --max_allowed_packet=250M --table_open_cache=1000 --table_definition_cache=2000 --read_buffer_size=1M --thread_cache_size=8 --max_connections=1024 --long_query_time=60 --slow_query_log=1 {noformat}

Elena Stepanova made changes - 2020-11-24 13:00

Assignee

Elena Stepanova [ elenst ]

Elena Stepanova made changes - 2020-11-24 15:14

Component/s		Scripts & Clients [ 11002 ]
Fix Version/s		10.5 [ 23123 ]
Affects Version/s		10.5 [ 23123 ]
Assignee	Elena Stepanova [ elenst ]	Sergei Golubchik [ serg ]

Elena Stepanova made changes - 2020-11-24 15:14

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2021-06-02 08:38

Priority

Minor [ 4 ]

Major [ 3 ]

Sergei Golubchik made changes - 2021-06-02 10:17

Assignee

Sergei Golubchik [ serg ]

Rucha Deodhar [ rucha174 ]

Julien Fritsch made changes - 2021-06-03 08:31

Priority

Major [ 3 ]

Critical [ 2 ]

Julien Fritsch made changes - 2021-06-03 08:32

Priority

Critical [ 2 ]

Major [ 3 ]

Rucha Deodhar made changes - 2021-06-08 09:28

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Rucha Deodhar made changes - 2021-06-08 09:28

Assignee	Rucha Deodhar [ rucha174 ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2021-06-10 14:59

Assignee	Sergei Golubchik [ serg ]	Rucha Deodhar [ rucha174 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Rucha Deodhar made changes - 2021-06-14 07:16

Link

This issue relates to ~~MDEV-25908~~ [ ~~MDEV-25908~~ ]

Rucha Deodhar made changes - 2021-06-14 07:18

Assignee	Rucha Deodhar [ rucha174 ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Julien Fritsch made changes - 2021-06-28 07:45

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-07-12 08:34

Assignee	Sergei Golubchik [ serg ]	Rucha Deodhar [ rucha174 ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Rucha Deodhar made changes - 2021-07-12 10:39

Assignee	Rucha Deodhar [ rucha174 ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2021-07-12 11:36

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2021-07-12 11:36

Assignee

Sergei Golubchik [ serg ]

Rucha Deodhar [ rucha174 ]

Rucha Deodhar made changes - 2021-07-12 11:41

Fix Version/s		10.5.12 [ 26025 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Rucha Deodhar made changes - 2021-07-15 11:39

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2021-07-15 15:45

Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.5.12 [ 26025 ]

Rucha Deodhar made changes - 2021-07-23 09:33

Fix Version/s		10.5.12 [ 26025 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-07-26 06:31

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Sergei Golubchik made changes - 2021-07-26 06:31

Fix Version/s		10.5 [ 23123 ]
Fix Version/s	10.5.12 [ 26025 ]

Sergei Golubchik made changes - 2021-07-26 06:34

Priority

Critical [ 2 ]

Major [ 3 ]

Rucha Deodhar made changes - 2021-07-26 09:09

Fix Version/s		10.5.12 [ 26025 ]
Fix Version/s	10.5 [ 23123 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

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

Workflow

MariaDB v3 [ 115947 ]

MariaDB v4 [ 158603 ]

Jira Automation (IT) made changes - 2024-07-04 02:37

Zendesk Related Tickets

183102

People

Assignee:: Rucha Deodhar

Reporter:: suresh ramagiri

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2020-11-19 00:36

Updated:: 2024-07-07 21:55

Resolved:: 2021-07-26 09:09

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration