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

mysql_ha_read: Got error 127 when reading table on HANDLER READ

    XMLWordPrintable

Details

    • Can result in data loss

    Description

      SET sql_mode='';
      CREATE TEMPORARY TABLE t (a INT,c VARCHAR(1)) ENGINE=MyISAM;
      INSERT INTO t VALUES (1,'');
      HANDLER t OPEN;
      LOAD DATA LOCAL INFILE '' INTO TABLE t FIELDS TERMINATED BY '' LINES TERMINATED BY '';
      INSERT INTO t SET c=2;
      HANDLER t READ NEXT;
      DELETE FROM t ORDER BY a LIMIT 1;
      DELETE FROM t;
      INSERT INTO t (a) VALUES (3);
      HANDLER t READ next LIMIT 1;
      

      Leads to:

      10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug)

      10.9.0-dbg>HANDLER t READ next LIMIT 1;
      ERROR 1194 (HY000): Table 't' is marked as crashed and should be repaired
      

      10.9.0 b5852ffbeebc3000982988383daeefb0549e058a (Debug)

      2022-02-21 15:36:58 4 [ERROR] mysql_ha_read: Got error 127 when reading table 't'
      2022-02-21 15:36:58 4 [ERROR] mysqld: Table 't' is marked as crashed and should be repaired
      

          Rel    o/d  Build   Commit                                    Affected
      CS  10.11  dbg  180826  8f00e6caca633c783140db86d3a48a96de67cf38  Yes
      CS  10.11  opt  180826  8f00e6caca633c783140db86d3a48a96de67cf38  Yes
      CS  11.4   dbg  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  Yes
      CS  11.4   opt  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  Yes
      CS  11.8   dbg  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  Yes
      CS  11.8   opt  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  Yes
      CS  12.3   dbg  180826  add63991988734383c5e942de2a19c6c45f511f7  Yes
      CS  12.3   opt  180826  add63991988734383c5e942de2a19c6c45f511f7  Yes
      CS  13.0   dbg  180826  a848493c6fe031f23606144420c1ca1e467cbd81  Yes
      CS  13.0   opt  180826  a848493c6fe031f23606144420c1ca1e467cbd81  Yes
      CS  13.1   dbg  180826  da18481158c81ca94689702073c3e04aad85a6a3  Yes
      CS  13.1   opt  180826  da18481158c81ca94689702073c3e04aad85a6a3  Yes
      ES  10.6   dbg  180826  fcecb2620f25965723d640decede7c018bcb1dcc  Yes
      ES  10.6   opt  180826  fcecb2620f25965723d640decede7c018bcb1dcc  Yes
      ES  11.4   dbg  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  Yes
      ES  11.4   opt  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  Yes
      ES  11.8   dbg  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  Yes
      ES  11.8   opt  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  Yes
      ES  12.3   dbg  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  Yes
      ES  12.3   opt  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  Yes
      

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1h 25m
                1h 25m

                Git Integration

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