Test rpl.rpl_semi_sync_shutdown_hang is unstable

Bug #1644569 reported by Laurynas Biveinis
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
Undecided
Unassigned
5.6
Fix Released
Low
Laurynas Biveinis
5.7
Invalid
Undecided
Unassigned

Bug Description

On 5.6 trunk:

rpl.rpl_semi_sync_shutdown_hang 'mix' w1 [ fail ]
        Test ended at 2016-10-13 03:41:11

CURRENT_TEST: rpl.rpl_semi_sync_shutdown_hang
mysqltest: At line 52: query 'reap' failed: 2013: Lost connection to MySQL server during query

The fix is to backport

commit a9840ba26e9f2af18c5f16ee79d0b008f98f22d0
Author: Sujatha Sivakumar <email address hidden>
Date: Mon Oct 27 11:49:59 2014 +0530

    Bug#19583563: RPL.RPL_SEMI_SYNC_SHUTDOWN_HANG FAILS
    SPORADICALLY ON PB2

    Problem:
    ========
    CURRENT_TEST: rpl.rpl_semi_sync_shutdown_hang
    mysqltest: At line 52: query 'reap' failed: 2013: Lost
    connection to MySQL server during query

    Analysis:
    ========
    As part of test script with semisync enabled we stop the
    slave's IO thread and execute a CREATE TABLE on master. This
    statement will hang waiting for acknowledgement from slave
    and IO thread has gone away. This CREATE TABLE statement is
    kept in hang mode using --send command. Then master server
    goes down because of shutdown causing the CREATE TABLE
    statement to end successfully. When ever --send is used in
    MTR it expects a --reap command to be used to capture the
    return status of the statement that used --send. Because of
    timing issue some times --reap command is able to get the
    successful return status of --send command and some times
    the --reap command is executed post the server has actually
    shutdown. Because of this the reap command complains that it
    has lost connection to mysql server during query. --reap
    commands return code is not important for the actual bugfix
    verification. The main aim of test script is shutdown should
    not hang.

    Fix:
    ===
    As part of fix --error 0,2013 is added above the --reap
    command.

Tags: ci upstream
tags: added: ci upstream
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.