180508 12:30:07 [ERROR] mysqld got signal 11 ;
|
|
Server version: 10.3.7-MariaDB-debug-log
|
|
stack_bottom = 0x7fbddc221ec0 thread_stack 0x49000
|
mysys/stacktrace.c:269(my_print_stacktrace)[0x5583a1ddaae1]
|
sql/signal_handler.cc:168(handle_fatal_signal)[0x5583a1623f12]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fbde0d98390]
|
sql/field.cc:2339(Field::clone(st_mem_root*, TABLE*))[0x5583a15ef247]
|
sql/table.cc:3230(open_table_from_share(THD*, TABLE_SHARE*, st_mysql_const_lex_string const*, unsigned int, unsigned int, unsigned int, TABLE*, bool, List<String>*))[0x5583a145360e]
|
sql/sql_base.cc:1928(open_table(THD*, TABLE_LIST*, Open_table_context*))[0x5583a12b6080]
|
sql/sql_base.cc:3529(open_and_process_table(THD*, LEX*, TABLE_LIST*, unsigned int*, unsigned int, Prelocking_strategy*, bool, Open_table_context*))[0x5583a12b9020]
|
sql/sql_base.cc:4049(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x5583a12ba24b]
|
sql/sql_base.cc:4924(open_and_lock_table(sTHD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x5583a12bbf66]
|
sql/sql_base.h:482(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int))[0x5583a1357e99]
|
sql/sql_parse.cc:4186(mysql_execute_command(THD*))[0x5583a1345882]
|
sql/sql_parse.cc:8001(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5583a1351cd5]
|
sql/sql_parse.cc:1848(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5583a133f1f9]
|
sql/sql_parse.cc:1391(do_command(THD*))[0x5583a133dc31]
|
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5583a14a05df]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x5583a14a035f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fbde0d8e6ba]
|
x86_64/clone.S:111(clone)[0x7fbde022341d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fbd28013a38): CREATE TABLE transforms.insert_select_21832 SELECT table1.`col_varchar_nokey` AS field1, ( SELECT SQL_SMALL_RESULT MIN( SUBQUERY1_t1.`col_int_key` ) AS SUBQUERY1_field1 FROM ( A AS SUBQUERY1_t1 INNER JOIN ( CC AS SUBQUERY1_t2 INNER JOIN C AS SUBQUERY1_t3 ON (SUBQUERY1_t3.`col_int_nokey` = SUBQUERY1_t2.`col_int_key` ) ) ON (SUBQUERY1_t3.`col_varchar_nokey` = SUBQUERY1_t2.`col_varchar_key` ) ) WHERE SUBQUERY1_t2.`col_int_nokey` <= table1.`col_int_key` AND SUBQUERY1_t1.`col_varchar_nokey` <= SUBQUERY1_t3.`col_varchar_nokey` ) AS field2, ( ( table1.`pk` ) + ( table1.`col_int_key` ) ) AS field3, ( SELECT MAX( SUBQUERY2_t1.`col_int_key` ) AS SUBQUERY2_field1 FROM ( CC AS SUBQUERY2_t1 INNER JOIN ( BB AS SUBQUERY2_t2 STRAIGHT_JOIN BB AS SUBQUERY2_t3 ON (SUBQUERY2_t3.`col_int_nokey` = SUBQUERY2_t2.`pk` ) ) ON (SUBQUERY2_t3.`col_varchar_key` = SUBQUERY2_t2.`col_varchar_nokey` ) ) WHERE SUBQUERY2_t1.`col_int_key` >= table1.`pk` AND SUBQUERY2_t3.`col_varchar_key` >= table1.`col_varchar_key` ) AS field4 FROM ( ( SELECT SUBQUERY3_t1.* FROM C AS SUBQUERY3_t1 ) AS table1 STRAIGHT_JOIN ( ( C AS table2 STRAIGHT_JOIN C AS table3 ON (table3.`col_varchar_key` = table2.`col_varchar_key` ) ) ) ON (table3.`pk` = table2.`col_int_nokey` ) ) WHERE ( EXISTS ( SELECT SUBQUERY4_t1.`col_varchar_key` AS SUBQUERY4_field1 FROM ( C AS SUBQUERY4_t1 INNER JOIN ( D AS SUBQUERY4_t2 INNER JOIN CC AS SUBQUERY4_t3 ON (SUBQUERY4_t3.`col_varchar_key` = SUBQUERY4_t2.`col_varchar_key` ) ) ON (SUBQUERY4_t3.`col_varchar_key` = SUBQUERY4_t2.`col_varchar_nokey` ) ) WHERE SUBQUERY4_t1.`col_varchar_nokey` != table1.`col_varchar_nokey` AND SUBQUERY4_t3.`pk` <= 3 ) ) AND ( table1.`pk` >= table1.`col_int_key` OR table1.`col_int_nokey` IS NOT NULL ) GROUP BY field1, field2, field3, field4 HAVING field3 <> 7 ORDER BY table1.`pk` DESC, field1, field2, field3, field4 /* QNO 112 CON_ID 32 */ /* QNO 145 CON_ID 32 */
|
Connection ID (thread ID): 32
|
Status: NOT_KILLED
|