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

Assertion `readbytes != (size_t)-1 || (*__errno_location ()) != 9' failed upon ALTER on ARCHIVE table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
    • 10.5
    • None

    Description

      INSTALL SONAME 'ha_archive';
       
      CREATE TEMPORARY TABLE t (a INT) ENGINE=ARCHIVE;
      OPTIMIZE TABLE t;
      --error ER_CANT_CREATE_TABLE
      ALTER TABLE t ADD PRIMARY KEY(a);
       
      # Cleanup
      DROP TABLE t;
      UNINSTALL SONAME 'ha_archive';
      

      10.2 aebb1112

      mysqld: /data/src/10.2/mysys/my_pread.c:72: my_pread: Assertion `readbytes != (size_t)-1 || (*__errno_location ()) != 9' failed.
      201216 17:33:25 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f3655b84f36 in __GI___assert_fail (assertion=0x55f2dca685e0 "readbytes != (size_t)-1 || (*__errno_location ()) != 9", file=0x55f2dca68570 "/data/src/10.2/mysys/my_pread.c", line=72, function=0x55f2dca686b0 <__PRETTY_FUNCTION__.14575> "my_pread") at assert.c:101
      #8  0x000055f2dc7244a7 in my_pread (Filedes=-1, Buffer=0x7f36504dc790 "\320\307MP6\177", Count=78, offset=0, MyFlags=0) at /data/src/10.2/mysys/my_pread.c:72
      #9  0x00007f36504862e6 in azflush (s=0x7f3634055c20, flush=2) at /data/src/10.2/storage/archive/azio.c:691
      #10 0x00007f365048baf9 in ha_archive::info (this=0x7f3634055798, flag=64) at /data/src/10.2/storage/archive/ha_archive.cc:1714
      #11 0x00007f365048b7b9 in ha_archive::update_create_info (this=0x7f3634055798, create_info=0x7f36504de290) at /data/src/10.2/storage/archive/ha_archive.cc:1661
      #12 0x000055f2dbe27ed1 in mysql_prepare_alter_table (thd=0x7f3634000d90, table=0x7f3634034e80, create_info=0x7f36504de290, alter_info=0x7f36504de1e0, alter_ctx=0x7f36504dd670) at /data/src/10.2/sql/sql_table.cc:8282
      #13 0x000055f2dbe2a8ab in mysql_alter_table (thd=0x7f3634000d90, new_db=0x7f3634012df8 "test", new_name=0x0, create_info=0x7f36504de290, table_list=0x7f36340127e0, alter_info=0x7f36504de1e0, order_num=0, order=0x0, ignore=false) at /data/src/10.2/sql/sql_table.cc:9286
      #14 0x000055f2dbea9824 in Sql_cmd_alter_table::execute (this=0x7f3634012ec0, thd=0x7f3634000d90) at /data/src/10.2/sql/sql_alter.cc:333
      #15 0x000055f2dbd5816a in mysql_execute_command (thd=0x7f3634000d90) at /data/src/10.2/sql/sql_parse.cc:5993
      #16 0x000055f2dbd5d181 in mysql_parse (thd=0x7f3634000d90, rawbuf=0x7f36340126f8 "ALTER TABLE t ADD PRIMARY KEY(a)", length=32, parser_state=0x7f36504df5f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7762
      #17 0x000055f2dbd4b47a in dispatch_command (command=COM_QUERY, thd=0x7f3634000d90, packet=0x7f3634008b51 "ALTER TABLE t ADD PRIMARY KEY(a)", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
      #18 0x000055f2dbd49f75 in do_command (thd=0x7f3634000d90) at /data/src/10.2/sql/sql_parse.cc:1381
      #19 0x000055f2dbea4219 in do_handle_one_connection (connect=0x55f2de0989c0) at /data/src/10.2/sql/sql_connect.cc:1336
      #20 0x000055f2dbea3f7e in handle_one_connection (arg=0x55f2de0989c0) at /data/src/10.2/sql/sql_connect.cc:1241
      #21 0x000055f2dc6cb95c in pfs_spawn_thread (arg=0x55f2de07bd80) at /data/src/10.2/storage/perfschema/pfs.cc:1869
      #22 0x00007f3656094609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x00007f3655c70293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.2-10.6.
      No obvious problem on a non-debug build (it returns ER_CANT_CREATE_TABLE on ALTER, which is probably expected).

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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