[MDEV-15541] Backport MDEV-13968 to 10.1: SST mysqldump fails at /usr//bin/wsrep_sst_common: line 94: WSREP_SST_OPT_PORT: readonly variable Created: 2018-03-11  Updated: 2021-05-13  Resolved: 2018-03-23

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.1
Fix Version/s: 10.1.32, 10.0.36-galera

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-14305 Add smoke sst test Closed
blocks MDEV-15409 make sure every sst script is tested ... Closed

 Description   

SST method mysqldump does not seem to work at all.

/usr//bin/wsrep_sst_common: line 94: WSREP_SST_OPT_PORT: readonly variable
 
2018-03-11 15:41:39 140711682767616 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --address '10.0.2.15:8308' --port '8308' --local-port '8307' --socket '/tmp/node2.sock'  '' --gtid 'abf3a5e3-253e-11e8-993f-72f1d4d8f4d2:2' --gtid-domain-id '0' --bypass: 1 (Operation not permitted)

WSREP_SST_OPT_PORT is set to readonly first when --address is processed, and then again when --port is processed. The second attempt fails, and so does the whole script. I don't see how it can be avoided, maybe it doesn't happen when it runs on the default port.

It seems to have been fixed in 10.2 in the scope of MDEV-13968.

 Comments   
Comment by Daniel Black [ 2018-03-12 ]

--address is formed with mysqld_port in sst_prepare_mysqldump and --port is also formed with mysqld_port in sst_donate_mysqldump. Luckily the same.

Because the fixes conflicted with MDEV-15496 I've backported the MDEV-15409 fixes to this pull request: https://github.com/MariaDB/server/pull/644.

I've checked 5.5-galera isn't affected however 10.0-galera is.

Generated at Thu Feb 08 08:22:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.