From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 2A415138334 for ; Sun, 11 Nov 2018 23:17:48 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 20222E0AFA; Sun, 11 Nov 2018 23:17:47 +0000 (UTC) Received: from smtp.gentoo.org (dev.gentoo.org [IPv6:2001:470:ea4a:1:5054:ff:fec7:86e4]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id CCAC1E0AFA for ; Sun, 11 Nov 2018 23:17:46 +0000 (UTC) Received: from oystercatcher.gentoo.org (oystercatcher.gentoo.org [148.251.78.52]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id 7B18F335C38 for ; Sun, 11 Nov 2018 23:17:44 +0000 (UTC) Received: from localhost.localdomain (localhost [IPv6:::1]) by oystercatcher.gentoo.org (Postfix) with ESMTP id ACC113CF for ; Sun, 11 Nov 2018 23:17:42 +0000 (UTC) From: "Thomas Deutschmann" To: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: 8bit Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Thomas Deutschmann" Message-ID: <1541978069.0f5f17c5a15d7a2bba4fd46615a655b0f0bf5ca7.whissi@gentoo> Subject: [gentoo-commits] proj/mysql-extras:master commit in: / X-VCS-Repository: proj/mysql-extras X-VCS-Files: 20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch X-VCS-Directories: / X-VCS-Committer: whissi X-VCS-Committer-Name: Thomas Deutschmann X-VCS-Revision: 0f5f17c5a15d7a2bba4fd46615a655b0f0bf5ca7 X-VCS-Branch: master Date: Sun, 11 Nov 2018 23:17:42 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org X-Archives-Salt: 190e6aaf-5d12-4ae3-acef-7f9610b5c749 X-Archives-Hash: 967f30ab17a8d84ce90fc6637394fff1 commit: 0f5f17c5a15d7a2bba4fd46615a655b0f0bf5ca7 Author: Thomas Deutschmann gentoo org> AuthorDate: Sun Nov 11 23:14:29 2018 +0000 Commit: Thomas Deutschmann gentoo org> CommitDate: Sun Nov 11 23:14:29 2018 +0000 URL: https://gitweb.gentoo.org/proj/mysql-extras.git/commit/?id=0f5f17c5 Add 20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch Bug: https://bugs.gentoo.org/670882 Signed-off-by: Thomas Deutschmann gentoo.org> ...-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch | 52 ++++++++++++++++++++++ 1 file changed, 52 insertions(+) diff --git a/20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch b/20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch new file mode 100644 index 0000000..97bd08e --- /dev/null +++ b/20036_all_mysql-5.6-fix-rpl_semi_sync_shutdown_hang.test.patch @@ -0,0 +1,52 @@ +From a9840ba26e9f2af18c5f16ee79d0b008f98f22d0 Mon Sep 17 00:00:00 2001 +From: Sujatha Sivakumar +Date: Mon, 27 Oct 2014 11:49:59 +0530 +Subject: [PATCH] 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. +--- + mysql-test/suite/rpl/t/rpl_semi_sync_shutdown_hang.test | 1 + + 1 file changed, 1 insertion(+) + +diff --git a/mysql-test/suite/rpl/t/rpl_semi_sync_shutdown_hang.test b/mysql-test/suite/rpl/t/rpl_semi_sync_shutdown_hang.test +index c632ee1b971..397450e19d5 100644 +--- a/mysql-test/suite/rpl/t/rpl_semi_sync_shutdown_hang.test ++++ b/mysql-test/suite/rpl/t/rpl_semi_sync_shutdown_hang.test +@@ -49,6 +49,7 @@ SET GLOBAL rpl_semi_sync_master_timeout = 10000000; + --enable_result_log + + --source include/rpl_connection_master.inc ++--error 0,2013 + --reap + --let $rpl_server_number=1 + --source include/rpl_start_server.inc