Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
11.1(EOL)
Description
CREATE TABLE t1 ( a int , b varchar ( 100 ) , fulltext ( b ) ) engine = MyISAM ; |
INSERT INTO t1 VALUES ( 1 , "a" ) , ( 2 , "b" ) ; |
UPDATE t1 SET b = 'x' WHERE a = 127 ; |
DELETE FROM t1 WHERE a = 2 ; |
SELECT * FROM t1 ORDER BY a ; |
DROP TABLE t1 ; |
CREATE TABLE v0 ( v1 INT PRIMARY KEY ) ENGINE = myisam ; |
INSERT INTO v0 VALUES ( 32 ) ; |
INSERT INTO v0 SELECT v1 + -32768 FROM v0 ; |
INSERT INTO v0 SELECT v1 + -128 FROM v0 ; |
INSERT INTO v0 SELECT v1 + 62 FROM v0 ; |
INSERT INTO v0 SELECT v1 + 79 FROM v0 ; |
INSERT INTO v0 SELECT v1 + 10 FROM v0 ; |
INSERT INTO v0 SELECT v1 + -32768 FROM v0 ; |
INSERT INTO v0 SELECT v1 + ( 31602911.000000 / 14 ) FROM v0 ; |
INSERT INTO v0 SELECT v1 + -2147483648 FROM v0 ; |
INSERT INTO v0 SELECT v1 + -128 FROM v0 AS v4 NATURAL JOIN ( SELECT * FROM v0 WHERE v1 <= 70 GROUP BY v1 HAVING v1 > 'x' ORDER BY v1 ) AS v2 NATURAL JOIN v0 AS v3 NATURAL LEFT JOIN v0 WHERE v1 IN ( SELECT DISTINCT v1 NOT LIKE 'x' FROM v0 WHERE v1 = v1 + 43 ) ; |
INSERT INTO v0 SELECT v1 + -1 FROM v0 WHERE v1 = -128 ; |
Stack Trace:
Thread pointer: 0x62b00016c218
|
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 = 0x7fab126d4880 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)[0x7fab34021420]
|
/usr/local/mysql/bin/mariadbd(_ZN13st_join_table21choose_best_splittingEjyPK8POSITIONPy+0xb62)[0x1147352]
|
/usr/local/mysql/bin/mariadbd(_Z16best_access_pathP4JOINP13st_join_tableyPK8POSITIONjbdPS3_S6_+0x62e)[0xc578be]
|
sql/sql_select.cc:11208(get_costs_for_tables(JOIN*, unsigned long long, unsigned int, double, Json_writer_object*, st_join_table**, SORT_POSITION**, unsigned long long*, bool))[0xcced27]
|
sql/sql_select.cc:11465(best_extension_by_limited_search(JOIN*, unsigned long long, unsigned int, double, double, unsigned int, unsigned int, unsigned long long*))[0xccb4b8]
|
sql_select.cc:0(best_extension_by_limited_search(JOIN*, unsigned long long, unsigned int, double, double, unsigned int, unsigned int, unsigned long long*))[0xccd46d]
|
sql_select.cc:0(best_extension_by_limited_search(JOIN*, unsigned long long, unsigned int, double, double, unsigned int, unsigned int, unsigned long long*))[0xccd46d]
|
sql_select.cc:0(best_extension_by_limited_search(JOIN*, unsigned long long, unsigned int, double, double, unsigned int, unsigned int, unsigned long long*))[0xccd46d]
|
sql/sql_select.cc:10440(greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int))[0xc61fc9]
|
sql/sql_select.cc:6192(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0xc1f7b6]
|
/usr/local/mysql/bin/mariadbd(_ZN4JOIN8optimizeEv+0x176)[0xbffb46]
|
sql/sql_select.cc:5237(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*))[0xbe886f]
|
sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
|
/usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x9d8c)[0xb39e7c]
|
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)[0x7fab34015609]
|
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fab33d2d133]
|
Attachments
Issue Links
- is caused by
-
MDEV-26301 Split optimization refills temporary table too many times
- Closed
- relates to
-
MDEV-31440 choose_best_splitting: crash on update query using correlated subquery after minor update
- Confirmed