Your message dated Sat, 13 Feb 2021 13:54:23 +0000
with message-id <[email protected]>
and subject line Bug#969095: Removed package(s) from unstable
has caused the Debian Bug report #793504,
regarding sysbench dep8 test
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
793504: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=793504
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Source: mysql-5.6
Version: 5.6.25-3
Severity: wishlist
Tags: patch
The attached patch adds a dep8 test that runs sysbench against the server
for 60s. This reproduces a data corruption issue on arm64 and ppc64el
on certain systems.
diff -urpN mysql-5.6-5.6.25.orig/debian/tests/control mysql-5.6-5.6.25/debian/tests/control
--- mysql-5.6-5.6.25.orig/debian/tests/control 2015-07-22 10:51:55.000000000 -0600
+++ mysql-5.6-5.6.25/debian/tests/control 2015-07-24 11:54:12.973732556 -0600
@@ -2,6 +2,10 @@ Tests: smoke
Depends: mysql-server-5.6
Restrictions: allow-stderr needs-root breaks-testbed
+Tests: sysbench
+Depends: mysql-server-5.6, sysbench
+Restrictions: allow-stderr needs-root breaks-testbed
+
Tests: upstream
Depends: mysql-testsuite-5.6
Restrictions: allow-stderr breaks-testbed
diff -urpN mysql-5.6-5.6.25.orig/debian/tests/sysbench mysql-5.6-5.6.25/debian/tests/sysbench
--- mysql-5.6-5.6.25.orig/debian/tests/sysbench 1969-12-31 17:00:00.000000000 -0700
+++ mysql-5.6-5.6.25/debian/tests/sysbench 2015-07-24 11:55:22.526624572 -0600
@@ -0,0 +1,57 @@
+#!/bin/sh
+set -ex
+
+# dep8 sysbench test for mysql-server
+# Author: dann frazier <[email protected]>
+#
+# This test should be declared in debian/tests/control with the
+# following restrictions:
+#
+# needs-root (needed to reset the root mysql password)
+# breaks-testbed (because it resets the root mysql password)
+# allow-stderr
+#
+# This test runs sysbench against a test database. The goal is to see if the
+# server is stable enough to deal with multiple threads of concurrent activity.
+# It serves as a regression test for LP: #1427406 (arm64/ppc64-specific).
+#
+
+debconf-set-selections <<EOT
+mysql-server-5.6 mysql-server/root_password password rootpassword
+mysql-server-5.6 mysql-server/root_password_again password rootpassword
+EOT
+
+DEBIAN_FRONTEND=noninteractive dpkg-reconfigure mysql-server-5.6
+
+cleanup() {
+ local ret=0
+ local mysqlclient="mysql --user=root --password=rootpassword"
+
+ echo "DROP DATABASE sbtest;" | $mysqlclient || ret=1
+ echo "DROP USER 'testuser'@'localhost';" | $mysqlclient || ret=1
+
+ return $ret
+}
+
+do_sysbench() {
+ sysbench \
+ --test=oltp \
+ --num-threads=128 \
+ --max-time=60 \
+ --mysql-user=testuser \
+ --mysql-password=testpassword \
+ $1
+}
+
+cleanup || /bin/true # in case a previous run failed
+
+mysql --user=root --password=rootpassword <<EOT
+CREATE DATABASE sbtest;
+CREATE USER 'testuser'@'localhost' identified by 'testpassword';
+GRANT ALL ON sbtest.* TO 'testuser'@'localhost';
+EOT
+
+do_sysbench prepare
+do_sysbench run
+
+cleanup
--- End Message ---
--- Begin Message ---
Version: 5.7.26-1+rm
Dear submitter,
as the package mysql-5.7 has just been removed from the Debian archive
unstable we hereby close the associated bug reports. We are sorry
that we couldn't deal with your issue properly.
For details on the removal, please see https://bugs.debian.org/969095
The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.
Please note that the changes have been done on the master archive and
will not propagate to any mirrors until the next dinstall run at the
earliest.
This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].
Debian distribution maintenance software
pp.
Joerg Jaspert (the ftpmaster behind the curtain)
--- End Message ---
