Test sys_vars.rpl_init_slave_func is unstable

Bug #1658006 reported by Laurynas Biveinis on 2017-01-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Low
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Fix Released
Low
Laurynas Biveinis

Bug Description

On 5.6 trunk:

sys_vars.rpl_init_slave_func w2 [ fail ]
        Test ended at 2016-12-23 09:37:59

CURRENT_TEST: sys_vars.rpl_init_slave_func
mysqltest: In included file "./include/assert.inc":
included from ./include/assert.inc at line 67:
At line 66: Test assertion failed in assert.inc
...
Assertion text: '@@global.max_connections = @start_max_connections'
Assertion condition: '@@global.max_connections = @start_max_connections'
Assertion condition, interpolated: '@@global.max_connections = @start_max_connections'
Assertion result: '0'

This is also https://jira.mariadb.org/browse/MDEV-10149

tags: added: ci upstream

A new failure with extra diagnostics:

CURRENT_TEST: sys_vars.rpl_init_slave_func
mysqltest: In included file "./include/assert.inc":
included from ./include/assert.inc at line 75:
At line 74: Test assertion failed in assert.inc
...
Assertion text: '@@global.max_connections = @start_max_connections'
Assertion condition: '@@global.max_connections = @start_max_connections'
Assertion condition, interpolated: '@@global.max_connections = @start_max_connections'
Assertion result: '0'
Assertion debug statement:
SELECT @@global.max_connections, @start_max_connections;
@@global.max_connections @start_max_connections
152 151

This shows that init_slave command has been executed already. It is possible because of a race condition: the slave SQL thread is set to running state very early in its initialisation, and before running the init_slave command. Thus, it's possible that the initial "source include/master-slave.inc;" pick up the command.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2222

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers