Experiments for T288500
ArchivedPublic
Actions

Authored by Kormat on Aug 13 2021, 12:19 PM.

Tags

None

Referenced Files

	F34594534: raw-paste-data.txt
	Aug 13 2021, 12:20 PM

	F34594533: raw-paste-data.txt
	Aug 13 2021, 12:20 PM

	F34594532: raw-paste-data.txt
	Aug 13 2021, 12:20 PM

	F34594530: raw-paste-data.txt
	Aug 13 2021, 12:19 PM

Subscribers

None

	# Starting state:
	$ semisync-status db2104
	+------------------------------------+-------+
	\| Variable_name \| Value \|
	+------------------------------------+-------+
	\| rpl_semi_sync_master_enabled \| ON \|
	\| rpl_semi_sync_master_timeout \| 10000 \|
	\| rpl_semi_sync_master_wait_no_slave \| ON \|
	\| rpl_semi_sync_slave_enabled \| OFF \|
	+------------------------------------+-------+
	+------------------------------+-------+
	\| Variable_name \| Value \|
	+------------------------------+-------+
	\| Rpl_semi_sync_master_clients \| 4 \|
	\| Rpl_semi_sync_master_status \| ON \|
	\| Rpl_semi_sync_slave_send_ack \| 0 \|
	\| Rpl_semi_sync_slave_status \| OFF \|
	+------------------------------+-------+

	$ semisync-status db1162
	+------------------------------------+-------+
	\| Variable_name \| Value \|
	+------------------------------------+-------+
	\| rpl_semi_sync_master_enabled \| OFF \|
	\| rpl_semi_sync_master_timeout \| 10000 \|
	\| rpl_semi_sync_master_wait_no_slave \| ON \|
	\| rpl_semi_sync_slave_enabled \| ON \|
	+------------------------------------+-------+
	+------------------------------+---------+
	\| Variable_name \| Value \|
	+------------------------------+---------+
	\| Rpl_semi_sync_master_clients \| 0 \|
	\| Rpl_semi_sync_master_status \| OFF \|
	\| Rpl_semi_sync_slave_send_ack \| 8487410 \|
	\| Rpl_semi_sync_slave_status \| ON \|
	+------------------------------+---------+

Event Timeline

Kormat created this paste.Aug 13 2021, 12:19 PM

Kormat edited the content of this paste. (Show Details)

$ sudo DEBUG=1 db-switchover --replicating-master --read-only-master --only-slave-move db1122.eqiad.wmnet db1162.
eqiad.wmnet |& tee T288500#7275512.step1
...
[ERROR]: db1182/(none) failed to be moved under the new master

Second attempt, with a high timeout:

$ sudo DEBUG=1 db-switchover --replicating-master --read-only-master --only-slave-move --timeout 45 db1122.eqiad.wmnet db1162.eqiad.wmnet |& tee -a T288500#7275512.step1
...
SUCCESS: All slaves moved correctly, but not continuing further because --only-slave-move

$ semisync-status db1162
+------------------------------------+-------+
| Variable_name                      | Value |
+------------------------------------+-------+
| rpl_semi_sync_master_enabled       | ON    |
| rpl_semi_sync_master_timeout       | 10000 |
| rpl_semi_sync_master_wait_no_slave | ON    |
| rpl_semi_sync_slave_enabled        | OFF   |
+------------------------------------+-------+
+------------------------------+-------+
| Variable_name                | Value |
+------------------------------+-------+
| Rpl_semi_sync_master_clients | 3     |
| Rpl_semi_sync_master_status  | ON    |
| Rpl_semi_sync_slave_send_ack | 0     |
| Rpl_semi_sync_slave_status   | OFF   |
+------------------------------+-------+

Kormat mentioned this in T288500: db-switchover got stuck while failing over db2107 to db2104.Aug 13 2021, 1:24 PM

Kormat archived this paste.Aug 18 2021, 2:06 PM

Kormat changed the title of this paste from untitled to Experiments for T288500.

Experiments for T288500ArchivedPublicActions

Event Timeline

Experiments for T288500
ArchivedPublic
Actions