Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
None
Description
CREATE TABLE C (pk int, i2 int) ENGINE=Aria; |
INSERT INTO C VALUES (1,2), (2,3),(3,4); |
|
DELETE FROM tt.*, C.* USING C AS tt |
LEFT JOIN C ON (tt.i2 = C.pk); |
5.5
mysqld: /home/alice/git/5.5/storage/maria/ma_blockrec.c:5125: _ma_read_block_record: Assertion `(buff[7] & 7) == HEAD_PAGE' failed.
|
180704 11:36:04 [ERROR] mysqld got signal 6 ;
|
|
Server version: 5.5.61-MariaDB-debug
|
stack_bottom = 0x7f0552c30e20 thread_stack 0x48000
|
/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7f0561a64077]
|
include/rem0rec.ic:448(rec_get_n_fields_old)[0x157aa2b]
|
sql/sql_list.h:695(base_ilist::push_back(ilink*))[0xa580c6]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f0560fb6390]
|
linux/raise.c:54(__GI_raise)[0x7f0560585428]
|
stdlib/abort.c:91(__GI_abort)[0x7f056058702a]
|
assert/assert.c:92(__assert_fail_base)[0x7f056057dbd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f056057dc82]
|
sql/item_func.h:96(Item_func::Item_func(Item*, Item*))[0xf5bb7f]
|
sql/item_func.h:96(Item_func::Item_func(Item*, Item*))[0xf41ecd]
|
sql/sql_string.h:369(String::append(char))[0xe9258a]
|
sql/item_func.h:95(Item_func::Item_func(Item*, Item*))[0xd6860c]
|
sql/mysqld.h:534(_current_thd())[0xdcbb1a]
|
sql/sql_yacc.cc:37761(MYSQLparse(THD*))[0xdcc24f]
|
sql/sql_list.h:266(base_list::pop())[0xdcc491]
|
/home/alice/git/5.5/sql/mysqld[0x74b2cc]
|
/home/alice/git/5.5/sql/mysqld(_ZN4JOIN4execEv+0x79f1)[0x78b025]
|
/home/alice/git/5.5/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x209a)[0x778865]
|
/home/alice/git/5.5/sql/mysqld(_Z21mysql_execute_commandP3THD+0x932a)[0x694eac]
|
/home/alice/git/5.5/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x3e9)[0x69eff7]
|
/home/alice/git/5.5/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x19d7)[0x6a23e9]
|
/home/alice/git/5.5/sql/mysqld(_Z10do_commandP3THD+0x695)[0x6a64dd]
|
/home/alice/git/5.5/sql/mysqld(_Z24do_handle_one_connectionP3THD+0x34d)[0x8e6694]
|
/home/alice/git/5.5/sql/mysqld(handle_one_connection+0xdc)[0x8e690d]
|
handler/ha_innodb.cc:7131(ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function))[0x14d2ca6]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f0560fac6ba]
|
x86_64/clone.S:111(clone)[0x7f056065741d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x610000012558): DELETE FROM tt.*, C.* USING C AS tt LEFT JOIN C ON (tt.i2 = C.pk)
|
Connection ID (thread ID): 2
|
Status: NOT_KILLED
|
10.0
Server version: 10.0.36-MariaDB-debug
|
|
/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7fe9aaaeb077]
|
include/mach0data.ic:186(mach_read_from_4)[0x18004a3]
|
sql/debug_sync.cc:688(debug_sync_get_action)[0xb0039f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fe9aa03d390]
|
linux/raise.c:54(__GI_raise)[0x7fe9a960c428]
|
stdlib/abort.c:91(__GI_abort)[0x7fe9a960e02a]
|
assert/assert.c:92(__assert_fail_base)[0x7fe9a9604bd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe9a9604c82]
|
sql/item_create.cc:5302(__static_initialization_and_destruction_0)[0x1016797]
|
sql/sql_string.h:69(String::String())[0xffe582]
|
sql/my_decimal.h:116(my_decimal::init())[0xf584e6]
|
psi/mysql_file.h:1276(inline_mysql_file_delete)[0xb10acc]
|
psi/mysql_thread.h:1068(inline_mysql_rwlock_unlock)[0xe2974c]
|
sql-common/client.c:744(free_old_query)[0xe89d78]
|
sql-common/client.c:894(cli_report_progress)[0xe8a4b0]
|
sql-common/client.c:618(cli_safe_read)[0xe8a702]
|
/home/alice/git/10.0/sql/mysqld[0x77e06c]
|
/home/alice/git/10.0/sql/mysqld(_ZN4JOIN10exec_innerEv+0x7ecd)[0x7bcf59]
|
/home/alice/git/10.0/sql/mysqld(_ZN4JOIN4execEv+0xe2)[0x7be104]
|
/home/alice/git/10.0/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x20dc)[0x7b39ba]
|
/home/alice/git/10.0/sql/mysqld(_Z21mysql_execute_commandP3THD+0xb7e0)[0x6bf4cc]
|
/home/alice/git/10.0/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x4d6)[0x6cb5f3]
|
/home/alice/git/10.0/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1fe9)[0x6cec7f]
|
/home/alice/git/10.0/sql/mysqld(_Z10do_commandP3THD+0x919)[0x6d34af]
|
sql/item.h:1126(Item::print(String*, enum_query_type))[0x948cfa]
|
sql/item.h:1703(Item_basic_value::str_eq(String const*, String const*, charset_info_st const*, bool) const)[0x948f69]
|
include/sync0sync.ic:146(mutex_get_waiters)[0x173ca8a]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe9aa0336ba]
|
x86_64/clone.S:111(clone)[0x7fe9a96de41d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x611000102620): DELETE FROM tt.*, C.* USING C AS tt LEFT JOIN C ON (tt.i2 = C.pk)
|
Connection ID (thread ID): 3
|
Status: NOT_KILLED
|
10.1
Server version: 10.1.35-MariaDB-debug
|
|
stack_bottom = 0x7f408215f1c0 thread_stack 0x48400
|
/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7f4096fe3077]
|
/home/alice/git/10.1/sql/mysqld(my_print_stacktrace+0xc8)[0x55cf71b000d5]
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x55cf70d884f9]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f4096535390]
|
linux/raise.c:54(__GI_raise)[0x7f4095b04428]
|
stdlib/abort.c:91(__GI_abort)[0x7f4095b0602a]
|
assert/assert.c:92(__assert_fail_base)[0x7f4095afcbd7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f4095afcc82]
|
maria/ma_blockrec.c:5165(_ma_read_block_record)[0x55cf712acbfa]
|
maria/ma_rrnd.c:45(maria_rrnd)[0x55cf71294f3d]
|
maria/ha_maria.cc:2479(ha_maria::rnd_pos(unsigned char*, unsigned char*))[0x55cf711ee0d6]
|
sql/handler.cc:2635(handler::ha_rnd_pos(unsigned char*, unsigned char*))[0x55cf70d9912b]
|
sql/records.cc:548(rr_from_pointers(READ_RECORD*))[0x55cf710c108f]
|
sql/sql_delete.cc:1232(multi_delete::do_table_deletes(TABLE*, bool))[0x55cf71123efb]
|
sql/sql_delete.cc:1188(multi_delete::do_deletes())[0x55cf711245fe]
|
sql/sql_delete.cc:1299(multi_delete::send_eof())[0x55cf7112499f]
|
sql/sql_select.cc:18152(do_select(JOIN*, List<Item>*, TABLE*, Procedure*))[0x55cf709a51df]
|
sql/sql_select.cc:3260(JOIN::exec_inner())[0x55cf709e8fe1]
|
sql/sql_select.cc:2548(JOIN::exec())[0x55cf709ea10c]
|
sql/sql_select.cc:3486(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55cf709df3c8]
|
sql/sql_parse.cc:4181(mysql_execute_command(THD*))[0x55cf708e0fa7]
|
sql/sql_parse.cc:7449(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55cf708ed66f]
|
sql/sql_parse.cc:1515(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x55cf708f3770]
|
sql/sql_parse.cc:1121(do_command(THD*))[0x55cf708f9cd8]
|
sql/sql_connect.cc:1330(do_handle_one_connection(THD*))[0x55cf70b7d34c]
|
sql/sql_connect.cc:1244(handle_one_connection)[0x55cf70b7d838]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55cf71a37576]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f409652b6ba]
|
x86_64/clone.S:111(clone)[0x7f4095bd641d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x611000093fe0): DELETE FROM tt.*, C.* USING C AS tt LEFT JOIN C ON (tt.i2 = C.pk)
|
Connection ID (thread ID): 3
|
Status: NOT_KILLED
|
|
Attachments
Issue Links
- relates to
-
MDEV-14847 Assertion `(buff[7] & 7) == HEAD_PAGE' failed in _ma_read_block_record
- Closed