Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-2232

LP #1662163: innodb_fts.sync_block test unstable due to slow query log nondeterminism

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 07-02-2017 14:30:50

      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 @@

      1. 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 @@
      2. 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;

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist