[MDEV-14847] Assertion `(buff[7] & 7) == HEAD_PAGE' failed in _ma_read_block_record Created: 2018-01-01  Updated: 2018-07-04  Resolved: 2018-05-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Aria
Affects Version/s: 10.3
Fix Version/s: 10.3.7

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-14551 Can't find record in table on multi-t... Closed
relates to MDEV-16682 Assertion `(buff[7] & 7) == HEAD_PAGE... Closed

 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



 Comments   
Comment by Oleksandr Byelkin [ 2018-05-17 ]

should be checked after MDEV-14551 push

Comment by Oleksandr Byelkin [ 2018-05-22 ]

Fixed in MDEV-14551

Generated at Thu Feb 08 08:16:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.