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

rocksdb.rocksdb fails with Sort Aborted error in server stderr

    XMLWordPrintable

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

              Unassigned Unassigned
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.