Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12277

rocksdb.rocksdb fails with Sort Aborted error in server stderr

    Details

      Description

      It started to fail like this after the last merge:

      rocksdb.rocksdb                          [ fail ]  Found warnings/errors in server log file!
              Test ended at 2017-03-15 22:07:01
      line
      2017-03-15 22:06:03 139761695200000 [Warning] Sort aborted, host: localhost, user: root, thread: 9, query: DELETE IGNORE FROM t1 ORDER BY i
      ^ Found warnings in /home/psergey/dev-git/10.2-mariarocks/mysql-test/var/log/mysqld.1.err
      ok
       
       - saving '/home/psergey/dev-git/10.2-mariarocks/mysql-test/var/log/rocksdb.rocksdb/' to '/home/psergey/dev-git/10.2-mariarocks/mysql-test/var/log/rocksdb.rocksdb/'
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 94 seconds executing testcases
      mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/home/psergey/dev-git/10.2-mariarocks/mysql-test/var/log/warnings' for details.
      

      maybe other tests have similar issues.

      The error:

      2017-03-15 22:06:03 139761695200000 [ERROR] mysqld: Lock wait timeout exceeded; try restarting transaction
      2017-03-15 22:06:03 139761695200000 [Warning] Sort aborted, host: localhost, user: root, thread: 9, query: DELETE IGNORE FROM t1 ORDER BY i
      

      The relevant rocksdb.rocksdb test:

      --echo # 
      --echo # MDEV-4298: RocksDB: Assertion `thd->is_error() || kill_errno' fails in ha_rows filesort
      --echo # 
      CREATE TABLE t1 (pk INT PRIMARY KEY, i INT, KEY(i)) ENGINE=RocksDB;
      INSERT INTO t1 VALUES (1,1),(2,2);
      BEGIN;
      UPDATE t1 SET i = 100;
       
      --connect (con1,localhost,root,,test)
      --error ER_LOCK_WAIT_TIMEOUT
      DELETE IGNORE FROM t1 ORDER BY i;
      --disconnect con1
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: