[MDEV-31470] When set at runtime, wsrep_sst_method accepts any value - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4.30
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1
Component/s: Galera
Labels:
- Papercut
- beginner-friendly

Description

Invalid values are accepted:

MariaDB [(none)]> set global wsrep_sst_method := 'handwrite rows and send them via post';

Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> select @@wsrep_sst_method;

+---------------------------------------+

| @@wsrep_sst_method                    |

+---------------------------------------+

| handwrite rows and send them via post |

+---------------------------------------+

1 row in set (0.000 sec)

Attachments

Issue Links

relates to

MDEV-23884 donor uses invalid SST methods

Closed

Activity

Ascending order - Click to sort in descending order

Federico Razzoli created issue - 2023-06-13 10:09

Daniel Black made changes - 2023-06-13 22:09

Field	Original Value	New Value
Description	Invalid values are accepted: <<sql>> MariaDB [(none)]> set global wsrep_sst_method := 'handwrite rows and send them via post'; Query OK, 0 rows affected (0.000 sec) MariaDB [(none)]> select @@wsrep_sst_method; +---------------------------------------+ \| @@wsrep_sst_method \| +---------------------------------------+ \| handwrite rows and send them via post \| +---------------------------------------+ 1 row in set (0.000 sec) <</sql>>	Invalid values are accepted: {code:sql} MariaDB [(none)]> set global wsrep_sst_method := 'handwrite rows and send them via post'; Query OK, 0 rows affected (0.000 sec) MariaDB [(none)]> select @@wsrep_sst_method; +---------------------------------------+ \| @@wsrep_sst_method \| +---------------------------------------+ \| handwrite rows and send them via post \| +---------------------------------------+ 1 row in set (0.000 sec) {code:sql}

Daniel Black made changes - 2023-06-13 22:09

Description

Invalid values are accepted:

{code:sql}
MariaDB [(none)]> set global wsrep_sst_method := 'handwrite rows and send them via post';
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> select @@wsrep_sst_method;
+---------------------------------------+
| @@wsrep_sst_method |
+---------------------------------------+
| handwrite rows and send them via post |
+---------------------------------------+
1 row in set (0.000 sec)
{code:sql}

Daniel Black made changes - 2023-06-13 22:11

Affects Version/s

10.4.30 [ 28912 ]

Daniel Black made changes - 2023-06-13 22:11

Component/s

Galera [ 10124 ]

Daniel Black made changes - 2023-06-13 22:11

Fix Version/s

10.4 [ 22408 ]

Daniel Black made changes - 2023-06-13 22:11

Labels

Papercut beginner-friendly

Daniel Black made changes - 2023-06-13 22:28

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Fix Version/s		11.2 [ 28603 ]

Sergei Golubchik made changes - 2023-06-29 16:24

Assignee

Seppo Jaakola [ seppo ]

Sergei Golubchik made changes - 2023-06-29 16:24

Priority

Major [ 3 ]

Critical [ 2 ]

Seppo Jaakola made changes - 2023-10-18 07:17

Status

Open [ 1 ]

In Progress [ 3 ]

Seppo Jaakola made changes - 2023-10-18 07:20

Link

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

Seppo Jaakola made changes - 2023-10-18 17:34

Status

In Progress [ 3 ]

Stalled [ 10000 ]