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

LP #1662909: Test tokudb.locks-select-update-3 is unstable

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Laurynas Biveinis last update 25-05-2017 19:48:50

      On 5.6 trunk, ASan build:

      tokudb.locks-select-update-3 w3 [ fail ]
      Test ended at 2017-02-06 14:16:01

      CURRENT_TEST: tokudb.locks-select-update-3
      mysqltest: At line 27: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction

      The result from queries just before the failure was:
      SET DEFAULT_STORAGE_ENGINE='tokudb';
      drop table if exists t;
      create table t (a int primary key, b int);
      insert into t values (1,0);
      set session transaction isolation level read committed;
      begin;
      select * from t where a=1 for update;
      a b
      1 0
      update t set b=b+1 where a=1;
      set session transaction isolation level read committed;
      begin;
      select * from t where a=1 for update;
      commit;
      safe_process[8432]: Child process: 8434, exit: 1

      Server [mysqld.1 - pid: 8152, winpid: 8152] log:
      Server log from this test:
      ---------SERVER LOG START----------
      ---------SERVER LOG END------------

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist