enterprise-support team mailing list archive

[Laurynas Biveinis <laurynas.biveinis@xxxxxxxxx>]

Public bug reported:

Copy of https://bugs.mysql.com/bug.php?id=81467, as seen on e.g. 5.6
trunk under Valgrind:

innodb_fts.sync_block                    w3 [ fail ]
...
--- /mnt/workspace/percona-server-5.6-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-xenial-64bit/mysql-test/suite/innodb_fts/r/sync_block.result	2017-01-31 19:51:30.243098399 +0300
+++ /mnt/workspace/percona-server-5.6-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-xenial-64bit/build/mysql-test/var/3/log/sync_block.reject	2017-02-02 14:06:59.074782788 +0300
@@ -30,6 +30,11 @@
 # slow log results should only contain INSERT INTO t1.
 SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
 sql_text
+CREATE TABLE t1 (
+FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+title VARCHAR(200),
+FULLTEXT(title)
+) ENGINE = InnoDB
 INSERT INTO t1(title) VALUES('mysql database')
 SET GLOBAL debug="-d,fts_instrument_sync_debug,fts_instrument_sync_sleep";
 TRUNCATE TABLE mysql.slow_log;
@@ -56,6 +61,11 @@
 # slow log results should be empty here.
 SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
 sql_text
+CREATE TABLE t1 (
+FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+title VARCHAR(200),
+FULLTEXT(title)
+) ENGINE = InnoDB
 SET GLOBAL debug="-d,fts_instrument_sync_request,fts_instrument_sync_sleep";
 TRUNCATE TABLE mysql.slow_log;
 DROP TABLE t1,t2;

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Low
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: Triaged

** Affects: percona-server/5.5
     Importance: Undecided
         Status: Invalid

** Affects: percona-server/5.6
     Importance: Low
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: In Progress

** Affects: percona-server/5.7
     Importance: Low
     Assignee: Laurynas Biveinis (laurynas-biveinis)
         Status: Triaged


** Tags: ci upstream

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.7
   Importance: Undecided
       Status: New

** Changed in: percona-server/5.5
       Status: New => Invalid

** Changed in: percona-server/5.6
   Importance: Undecided => Low

** Changed in: percona-server/5.7
   Importance: Undecided => Low

** Changed in: percona-server/5.6
       Status: New => Triaged

** Changed in: percona-server/5.7
       Status: New => Triaged

** Tags added: ci upstream

** Bug watch added: MySQL Bug System #81467
   http://bugs.mysql.com/bug.php?id=81467

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=81467
   Importance: Unknown
       Status: Unknown

** Changed in: percona-server/5.6
     Assignee: (unassigned) => Laurynas Biveinis (laurynas-biveinis)

** Changed in: percona-server/5.7
     Assignee: (unassigned) => Laurynas Biveinis (laurynas-biveinis)

** Changed in: percona-server/5.6
       Status: Triaged => In Progress

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1662163

Title:
  innodb_fts.sync_block test unstable due to slow query log
  nondeterminism

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1662163/+subscriptions