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"

    Details

    • Type: Technical task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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.

        Gliffy Diagrams

          Attachments

            Activity

            There are no comments yet on this issue.

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 15 minutes
                  15m