Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
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
- relates to
-
MDEV-14551 Can't find record in table on multi-table update with ORDER BY
- Closed
-
MDEV-16682 Assertion `(buff[7] & 7) == HEAD_PAGE' failed.
- Closed