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

Assertion `(buff[7] & 7) == HEAD_PAGE' failed in _ma_read_block_record

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      CREATE TABLE t1 (a INT) ENGINE=Aria;
      REPLACE INTO t1 VALUES (1),(2);
      CREATE TABLE t2 (b INT) ENGINE=Aria PARTITION BY RANGE(b) (PARTITION p1 VALUES LESS THAN (1), PARTITION p2 VALUES LESS THAN MAXVALUE);
      CREATE ALGORITHM = MERGE VIEW v AS SELECT b FROM t1, t2;
      INSERT INTO t2 VALUES (NULL);
      UPDATE v SET b = 5 ORDER BY b;
       
      # Cleanup
      DROP VIEW v;
      DROP TABLE t1, t2;
      

      10.3 ec32c050726

      mysqld: /data/src/10.3/storage/maria/ma_blockrec.c:5163: _ma_read_block_record: Assertion `(buff[7] & 7) == HEAD_PAGE' failed.
      180121 23:50:48 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007febf5e06ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000555824fba478 in _ma_read_block_record (info=0x7febe0053950, record=0x7febe0048de0 "\375\005", record_pos=256) at /data/src/10.3/storage/maria/ma_blockrec.c:5163
      #9  0x0000555824fa7c2c in maria_rrnd (info=0x7febe0053950, buf=0x7febe0048de0 "\375\005", filepos=256) at /data/src/10.3/storage/maria/ma_rrnd.c:44
      #10 0x0000555824f51002 in ha_maria::rnd_pos (this=0x7febe0049228, buf=0x7febe0048de0 "\375\005", pos=0x7febe007b7fb "") at /data/src/10.3/storage/maria/ha_maria.cc:2490
      #11 0x0000555824d2db5d in handler::ha_rnd_pos (this=0x7febe0049228, buf=0x7febe0048de0 "\375\005", pos=0x7febe007b7fb "") at /data/src/10.3/sql/handler.cc:2784
      #12 0x00005558254c7756 in ha_partition::rnd_pos (this=0x7febe0048558, buf=0x7febe0048de0 "\375\005", pos=0x7febe007b7f9 "") at /data/src/10.3/sql/ha_partition.cc:5143
      #13 0x0000555824d2db07 in handler::ha_rnd_pos (this=0x7febe0048558, buf=0x7febe0048de0 "\375\005", pos=0x7febe007b7f9 "") at /data/src/10.3/sql/handler.cc:2784
      #14 0x0000555824b3f0b2 in multi_update::do_updates (this=0x7febe0019508) at /data/src/10.3/sql/sql_update.cc:2580
      #15 0x0000555824b3f9af in multi_update::send_eof (this=0x7febe0019508) at /data/src/10.3/sql/sql_update.cc:2743
      #16 0x0000555824ab4f04 in do_select (join=0x7febe00195e0, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18822
      #17 0x0000555824a8e24a in JOIN::exec_inner (this=0x7febe00195e0) at /data/src/10.3/sql/sql_select.cc:4051
      #18 0x0000555824a8d4b6 in JOIN::exec (this=0x7febe00195e0) at /data/src/10.3/sql/sql_select.cc:3834
      #19 0x0000555824a8e92f in mysql_select (thd=0x7febe0000b00, tables=0x7febe0014d20, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7febe0015640, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7febe0019508, unit=0x7febe0004890, select_lex=0x7febe0004fe8) at /data/src/10.3/sql/sql_select.cc:4250
      #20 0x0000555824b3c08a in mysql_multi_update (thd=0x7febe0000b00, table_list=0x7febe0014d20, fields=0x7febe0005108, values=0x7febe00055f0, conds=0x0, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x7febe0004890, select_lex=0x7febe0004fe8, result=0x7febf00747b0) at /data/src/10.3/sql/sql_update.cc:1736
      #21 0x0000555824a44826 in mysql_execute_command (thd=0x7febe0000b00) at /data/src/10.3/sql/sql_parse.cc:4623
      #22 0x0000555824a4f2aa in mysql_parse (thd=0x7febe0000b00, rawbuf=0x7febe0014c38 "UPDATE v SET b = 5 ORDER BY b", length=29, parser_state=0x7febf00755f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
      #23 0x0000555824a3caef in dispatch_command (command=COM_QUERY, thd=0x7febe0000b00, packet=0x7febe000b141 "UPDATE v SET b = 5 ORDER BY b", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
      #24 0x0000555824a3b523 in do_command (thd=0x7febe0000b00) at /data/src/10.3/sql/sql_parse.cc:1370
      #25 0x0000555824ba2768 in do_handle_one_connection (connect=0x55582874f0c0) at /data/src/10.3/sql/sql_connect.cc:1401
      #26 0x0000555824ba24f5 in handle_one_connection (arg=0x55582874f0c0) at /data/src/10.3/sql/sql_connect.cc:1307
      #27 0x00005558250400b8 in pfs_spawn_thread (arg=0x55582876a8a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #28 0x00007febf7add494 in start_thread (arg=0x7febf0076700) at pthread_create.c:333
      #29 0x00007febf5ec393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.