Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-3962

SELECT with ORDER BY causes "ERROR 1030 (HY000): Got error 122 from storage engine"

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=LevelDB;
      # Query OK, 0 rows affected (0.06 sec)
       
      INSERT INTO t1 VALUES (2),(1);
      # Query OK, 2 rows affected (0.01 sec)
      # Records: 2  Duplicates: 0  Warnings: 0
       
      SELECT * FROM t1 ORDER BY pk;
      # ERROR 1030 (HY000): Got error 122 from storage engine

      revision-id: psergey@askmonty.org-20121221152341-9stvnkuiinslrt9h
      date: 2012-12-21 19:23:41 +0400
      build-date: 2012-12-21 21:15:42 +0400
      revno: 4471
      branch: mysql-5.6-leveldb

      Same happens with ORDER BY <non-pk column>

      DELETE IGNORE .. ORDER BY .. causes an assertion failure, but I assume it's a result of the described problem.

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            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.