Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
Description
CREATE TABLE v0 ( v1 NUMERIC NOT NULL PRIMARY KEY , v2 TINYTEXT ) Engine = InnoDB ; |
INSERT INTO v0 VALUES ( 88 , 50 ) ; |
UPDATE v0 SET v1 = 63 WHERE v1 = 255 ; |
UPDATE v0 SET v2 = 39 WHERE v1 = NULL ; |
UPDATE v0 SET v1 = 0 WHERE v1 = 0 OR v1 = 16 ; |
UPDATE v0 SET v1 = 18 WHERE v2 = 50 ; |
SELECT * FROM v0 ORDER BY - v1 , v2 DESC , ( SELECT v1 AS v3 GROUP BY v2 LIMIT 8 OFFSET 24 ) ASC ; |
SELECT * FROM v0 ORDER BY v1 ; |
SELECT v2 , v2 , v1 FROM v0 JOIN v0 ON v1 = v2 ORDER BY v1 ; |
DROP TABLE v0 ; , t2 , t3 |
When replace the engine with MYISAM, the crash will not happen.
Stack Trace:
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f7b05b34880 thread_stack 0x5fc00
/usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x781b5b]
mysys/stacktrace.c:215(my_print_stacktrace)[0x228cfae]
sql/signal_handler.cc:0(handle_fatal_signal)[0x12bd0d2]
sigaction.c:0(__restore_rt)[0x7f7b298cb420]
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
/lib/x86_64-linux-gnu/libc.so.6(memcpy+0x1b)[0x7f7b29573aeb]
/usr/local/mysql/bin/mariadbd(__asan_memcpy+0x2a8)[0x7c27b8]
sql/my_decimal.h:134(my_decimal::operator=(my_decimal const&))[0x16fda2f]
/usr/local/mysql/bin/mariadbd(_ZNK27Type_handler_decimal_result25make_packed_sort_key_partEPhP4ItemPK15SORT_FIELD_ATTRP6String+0x213)[0x12b9e83]
sql/filesort.cc:3012(make_packed_sortkey(Sort_param*, unsigned char*))[0x12b15cd]
sql/sql_sort.h:706(Sort_param::is_packed_format() const)[0x12ae16b]
sql/sql_select.cc:26909(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0xca6c82]
/usr/local/mysql/bin/mariadbd(_Z21join_init_read_recordP13st_join_table+0x2d5)[0xc41765]
sql/sql_select.cc:23501(sub_select(JOIN*, st_join_table*, bool))[0xbe6b87]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN10exec_innerEv+0x2681)[0xc48751]
sql/sql_select.cc:4721(JOIN::exec())[0xc45f19]
sql/sql_select.cc:5251(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe89b8]
sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
sql/sql_parse.cc:6041(execute_sqlcom_select(THD*, TABLE_LIST*))[0xb41bc6]
/usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x18b7)[0xb319a7]
sql/sql_class.h:2830(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xb24c79]
/usr/local/mysql/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2cf8)[0xb1e648]
sql/sql_parse.cc:1407(do_command(THD*, bool))[0xb25971]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0xf0d066]
sql/sql_connect.cc:1322(handle_one_connection)[0xf0caa9]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x19d710b]
nptl/pthread_create.c:478(start_thread)[0x7f7b298bf609]
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f7b295d7133]
Attachments
Issue Links
- duplicates
-
MDEV-32324 Server crashes inside filesort at my_decimal::to_binary
- Closed