main.percona_bug1008609 breaks any replication test further in the same run
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
New
|
High
|
Unassigned | |||
5.7 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
When main.percona_
main.auth_rpl [ fail ]
Test ended at 2015-11-12 14:06:00
CURRENT_TEST: main.auth_rpl
mysqltest: In included file ./include/
included from ./include/
included from ./include/
included from ./include/
included from ./include/
included from ./include/
included from ./include/
included from ./include/
included from /Users/
At line 156: Timeout in include/
The result from queries just before the failure was:
< snip >
relaylog_name = 'No such row'
SHOW RELAYLOG EVENTS IN 'No such row';
Log_name Pos Event_type Server_id End_log_pos Info
**** slave_relay_info on server_1 ****
SELECT * FROM mysql.slave_
Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id Channel_name
**** slave_master_info on server_1 ****
SELECT * FROM mysql.slave_
Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_
**** mysql.gtid_executed on server_1 ****
SELECT * FROM mysql.gtid_
source_uuid interval_start interval_end
rpl_topology= 1->2
rand_seed: '' _rand_state: ''
extra debug info if any: ''
rpl_topology=1->2
connection server_2;
safe_process[
Checking the error log of the slave shows failure to connect to master because server uuid is identical to that master.
This is caused by main.percona_
And percona_bug1008609 re-creates auto.cnf with an UUID, which is then copied for the servers to use, resulting in identical UUIDs for masters and slaves.
tags: | added: ci |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-942