[New LWP 46929] [New LWP 46892] [New LWP 46917] [New LWP 46893] [New LWP 46894] [New LWP 46913] [New LWP 46915] [New LWP 46922] [New LWP 46898] [New LWP 46911] [New LWP 46914] [New LWP 46902] [New LWP 46910] [New LWP 46919] [New LWP 46907] [New LWP 46908] [New LWP 46899] [New LWP 46906] [New LWP 46918] [New LWP 46916] [New LWP 46895] [New LWP 46905] [New LWP 46912] [New LWP 46923] [New LWP 46890] [New LWP 46897] [New LWP 46909] [New LWP 46928] [New LWP 46924] [New LWP 46891] [New LWP 46901] [New LWP 46889] [New LWP 46900] [New LWP 46925] [New LWP 46926] [New LWP 46927] [New LWP 46896] [New LWP 46888] [New LWP 46930] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/home/elenst/git/bb-10.2-monty/sql/mysqld --no-defaults --basedir=/home/elenst/'. Program terminated with signal SIGABRT, Aborted. #0 0x00007f0e9cb64f8c in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0 Thread 39 (Thread 0x7f0e9be5a300 (LWP 46930)): #0 0x00007f0e9cb6740d in fsync () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed59bb9 in os_file_fsync_posix (file=13) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:3044 #2 0x00007f0e9ed59fb4 in os_file_flush_func (file=13) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:3158 #3 0x00007f0e9efb91b5 in pfs_os_file_flush_func (file=13, src_file=0x7f0e9f4a4e98 "/home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc", src_line=1035) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/os0file.ic:409 #4 0x00007f0e9efbc912 in fil_flush_low (space=0x7f0e9b455d00) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:1035 #5 0x00007f0e9efca4c6 in fil_flush (space_id=4294967280) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5743 #6 0x00007f0e9ed3272d in log_write_flush_to_disk_low () at /home/elenst/git/bb-10.2-monty/storage/innobase/log/log0log.cc:1164 #7 0x00007f0e9ed331a7 in log_write_up_to (lsn=5513107, flush_to_disk=true) at /home/elenst/git/bb-10.2-monty/storage/innobase/log/log0log.cc:1400 #8 0x00007f0e9efc23e9 in fil_delete_tablespace (id=279, buf_remove=BUF_REMOVE_FLUSH_NO_WRITE) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:3141 #9 0x00007f0e9edef900 in row_drop_single_table_tablespace (space_id=279, tablename=0x7f0e5a410788 "test/trigger146311", filepath=0x7f0e5a452260 "./test/trigger146311.ibd", is_temp=false, is_encrypted=false, trx=0x7f0e870039b8) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0mysql.cc:3648 #10 0x00007f0e9edf0c1b in row_drop_table_for_mysql (name=0x7f0e9be56330 "test/trigger146311", trx=0x7f0e870039b8, drop_db=false, create_failed=0, nonatomic=true) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0mysql.cc:4194 #11 0x00007f0e9eca9bc7 in ha_innobase::delete_table (this=0x7f0e5a5252b0, name=0x7f0e9be57e70 "./test/trigger146311") at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14688 #12 0x00007f0e9ea9909e in handler::ha_delete_table (this=0x7f0e5a5252b0, name=0x7f0e9be57e70 "./test/trigger146311") at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4328 #13 0x00007f0e9ea93aea in ha_delete_table (thd=0x7f0e5a4c2070, table_type=0x7f0e9b454e70, path=0x7f0e9be57e70 "./test/trigger146311", db=0x7f0e5a5247f8 "test", alias=0x7f0e5a5241a8 "trigger146311", generate_warning=true) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:2351 #14 0x00007f0e9e8dc9a9 in mysql_rm_table_no_locks (thd=0x7f0e5a4c2070, tables=0x7f0e5a5241f0, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:2470 #15 0x00007f0e9e8dbbd2 in mysql_rm_table (thd=0x7f0e5a4c2070, tables=0x7f0e5a5241f0, if_exists=1 '\001', drop_temporary=0 '\000') at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:2090 #16 0x00007f0e9e820b5a in mysql_execute_command (thd=0x7f0e5a4c2070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:4690 #17 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5a4c2070, rawbuf=0x7f0e5a524088 "DROP TABLE IF EXISTS trigger146311, transforms.trigger246311 /* QNO 1149 CON_ID 22 */", length=86, parser_state=0x7f0e9be58db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #18 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5a4c2070, packet=0x7f0e5a518071 "DROP TABLE IF EXISTS trigger146311, transforms.trigger246311 /* QNO 1149 CON_ID 22 */ ", packet_length=87, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #19 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5a4c2070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #20 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e82bfe390) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #21 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e82bfe390) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #22 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #23 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #24 0x0000000000000000 in ?? () Thread 38 (Thread 0x7f0e9e250780 (LWP 46888)): #0 0x00007f0e9c06b303 in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00007f0e9e7468fc in handle_connections_sockets () at /home/elenst/git/bb-10.2-monty/sql/mysqld.cc:6618 #2 0x00007f0e9e745c13 in mysqld_main (argc=16, argv=0x7f0e9b4501a0) at /home/elenst/git/bb-10.2-monty/sql/mysqld.cc:6084 #3 0x00007f0e9e73a4c8 in main (argc=16, argv=0x7fff319d5a08) at /home/elenst/git/bb-10.2-monty/sql/main.cc:25 Thread 37 (Thread 0x7f0e643fb700 (LWP 46896)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e643fad10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e643fad10, m1=0x7f0e643fadb0, m2=0x7f0e643fadb8, request=0x7f0e643fadc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=4, m1=0x7f0e643fadb0, m2=0x7f0e643fadb8, request=0x7f0e643fadc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=4, m1=0x7f0e643fadb0, m2=0x7f0e643fadb8, request=0x7f0e643fadc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=4) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc280 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 36 (Thread 0x7f0e9bf38300 (LWP 46927)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6880) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6880, reset_sig_count=11) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6880, reset_sig_count=11) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e9bf34ef0: 0x7f0e9b7d5240) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ecc0748 in TTASEventMutex::enter (this=0x7f0e9b493900, max_spins=60, max_delay=6, filename=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=7031) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/ib0mutex.h:515 #6 0x00007f0e9ecbec82 in PolicyMutex >::enter (this=0x7f0e9b493900, n_spins=30, n_delay=6, name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=7031) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/ib0mutex.h:634 #7 0x00007f0e9ec99a34 in ha_innobase::open (this=0x7f0e5eca9088, name=0x7f0e5ecc9d90 "./test/B", mode=2, test_if_locked=18) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:7031 #8 0x00007f0e9ea94316 in handler::ha_open (this=0x7f0e5eca9088, table_arg=0x7f0e5ec8a470, name=0x7f0e5ecc9d90 "./test/B", mode=2, test_if_locked=18) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:2500 #9 0x00007f0e9e91cc02 in open_table_from_share (thd=0x7f0e5ec29070, share=0x7f0e5ecc9888, alias=0x7f0e5ed6f468 "B", db_stat=33, prgflag=8, ha_open_flags=18, outparam=0x7f0e5ec8a470, is_create_table=false) at /home/elenst/git/bb-10.2-monty/sql/table.cc:3279 #10 0x00007f0e9e7ac32c in open_table (thd=0x7f0e5ec29070, table_list=0x7f0e5ed6f470, ot_ctx=0x7f0e9bf35b70) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:1860 #11 0x00007f0e9e7aedda in open_and_process_table (thd=0x7f0e5ec29070, lex=0x7f0e5ec2ca80, tables=0x7f0e5ed6f470, counter=0x7f0e9bf35c04, flags=0, prelocking_strategy=0x7f0e9bf35c80, has_prelocking_list=false, ot_ctx=0x7f0e9bf35b70) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:3392 #12 0x00007f0e9e7aff38 in open_tables (thd=0x7f0e5ec29070, options=..., start=0x7f0e9bf35be8, counter=0x7f0e9bf35c04, flags=0, prelocking_strategy=0x7f0e9bf35c80) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:3911 #13 0x00007f0e9e7b174f in open_and_lock_tables (thd=0x7f0e5ec29070, options=..., tables=0x7f0e5ec72d68, derived=true, flags=0, prelocking_strategy=0x7f0e9bf35c80) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:4664 #14 0x00007f0e9e7a6319 in open_and_lock_tables (thd=0x7f0e5ec29070, tables=0x7f0e5ec72d68, derived=true, flags=0) at /home/elenst/git/bb-10.2-monty/sql/sql_base.h:493 #15 0x00007f0e9e826eb2 in execute_sqlcom_select (thd=0x7f0e5ec29070, all_tables=0x7f0e5ec72d68) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:6317 #16 0x00007f0e9e81cd7b in mysql_execute_command (thd=0x7f0e5ec29070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3426 #17 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5ec29070, rawbuf=0x7f0e5ec72088 "SELECT * FROM (test.`view_B` AS table1 INNER JOIN INFORMATION_SCHEMA.`PROCESSLIST` AS table2 ON ( table2.`ID` = table1.`col_time_nokey` ) ) WHERE ( (NOT ( ( ( ( table1.`col_date_nokey` <= 2 AND table1"..., length=575, parser_state=0x7f0e9bf36db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #18 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5ec29070, packet=0x7f0e5ec66071 " SELECT * FROM (test.`view_B` AS table1 INNER JOIN INFORMATION_SCHEMA.`PROCESSLIST` AS table2 ON ( table2.`ID` = table1.`col_time_nokey` ) ) WHERE ( (NOT ( ( ( ( table1.`col_date_nokey` <= 2 AND table"..., packet_length=577, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #19 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5ec29070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #20 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45d0f0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #21 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45d0f0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #22 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #23 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #24 0x0000000000000000 in ?? () Thread 35 (Thread 0x7f0e9bf82300 (LWP 46926)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6880) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6880, reset_sig_count=11) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6880, reset_sig_count=11) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e9bf7f1f0: 0x7f0e9b7d5100) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ecc0748 in TTASEventMutex::enter (this=0x7f0e9b493900, max_spins=90, max_delay=6, filename=0x7f0e9f40eff8 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/i_s.cc", line=7868) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/ib0mutex.h:515 #6 0x00007f0e9ecbec82 in PolicyMutex >::enter (this=0x7f0e9b493900, n_spins=30, n_delay=6, name=0x7f0e9f40eff8 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/i_s.cc", line=7868) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/ib0mutex.h:634 #7 0x00007f0e9ecf32f1 in i_s_sys_foreign_fill_table (thd=0x7f0e5f08b070, tables=0x7f0e5f0d4b48) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/i_s.cc:7868 #8 0x00007f0e9e8c6da0 in get_schema_tables_result (join=0x7f0e5f0d6ce0, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/elenst/git/bb-10.2-monty/sql/sql_show.cc:8204 #9 0x00007f0e9e86597d in JOIN::exec_inner (this=0x7f0e5f0d6ce0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3352 #10 0x00007f0e9e8650cc in JOIN::exec (this=0x7f0e5f0d6ce0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3199 #11 0x00007f0e9e866267 in mysql_select (thd=0x7f0e5f08b070, tables=0x7f0e5f0d4b48, wild_num=1, fields=..., conds=0x7f0e5f0d6458, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552440433408, result=0x7f0e5f0d6cc0, unit=0x7f0e5f08eb48, select_lex=0x7f0e5f08f278) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3584 #12 0x00007f0e9e85b2cd in handle_select (thd=0x7f0e5f08b070, lex=0x7f0e5f08ea80, result=0x7f0e5f0d6cc0, setup_tables_done_option=0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:373 #13 0x00007f0e9e82734f in execute_sqlcom_select (thd=0x7f0e5f08b070, all_tables=0x7f0e5f0d4b48) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:6396 #14 0x00007f0e9e81cd7b in mysql_execute_command (thd=0x7f0e5f08b070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3426 #15 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5f08b070, rawbuf=0x7f0e5f0d4088 "SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_FOREIGN` AS table1 LEFT JOIN test.`CC` AS table2 ON ( table2.`col_varchar_key` = table1.`N_COLS` ) ) WHERE table1.`ID` <= 'x' LIMIT 6 /* QNO 1692 CON_ID 1"..., length=270, parser_state=0x7f0e9bf80db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #16 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5f08b070, packet=0x7f0e5f0c8071 " SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_FOREIGN` AS table1 LEFT JOIN test.`CC` AS table2 ON ( table2.`col_varchar_key` = table1.`N_COLS` ) ) WHERE table1.`ID` <= 'x' LIMIT 6 /* QNO 1692 CON_ID "..., packet_length=272, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #17 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5f08b070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #18 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45d010) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #19 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45d010) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #20 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #21 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #22 0x0000000000000000 in ?? () Thread 34 (Thread 0x7f0e9e0b9300 (LWP 46925)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e80be8800) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e80be8800, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e80be8800, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee9054a in trx_purge_stop () at /home/elenst/git/bb-10.2-monty/storage/innobase/trx/trx0purge.cc:1947 #5 0x00007f0e9ee4e64f in row_quiesce_table_start (table=0x7f0e60505308, trx=0x7f0e87001638) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0quiesce.cc:733 #6 0x00007f0e9ecaf1b9 in ha_innobase::external_lock (this=0x7f0e604a8088, thd=0x7f0e60431070, lock_type=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:17769 #7 0x00007f0e9ea9cbe2 in handler::ha_external_lock (this=0x7f0e604a8088, thd=0x7f0e60431070, lock_type=0) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:5862 #8 0x00007f0e9eba3881 in lock_external (thd=0x7f0e60431070, tables=0x7f0e60469348, count=4) at /home/elenst/git/bb-10.2-monty/sql/lock.cc:395 #9 0x00007f0e9eba3591 in mysql_lock_tables (thd=0x7f0e60431070, sql_lock=0x7f0e60469330, flags=4096) at /home/elenst/git/bb-10.2-monty/sql/lock.cc:341 #10 0x00007f0e9eba344b in mysql_lock_tables (thd=0x7f0e60431070, tables=0x7f0e6047ca98, count=4, flags=4096) at /home/elenst/git/bb-10.2-monty/sql/lock.cc:303 #11 0x00007f0e9e7b1fad in lock_tables (thd=0x7f0e60431070, tables=0x7f0e6047b1b0, count=4, flags=4096) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:4884 #12 0x00007f0e9e7b17c7 in open_and_lock_tables (thd=0x7f0e60431070, options=..., tables=0x7f0e6047b1b0, derived=false, flags=4096, prelocking_strategy=0x7f0e9e0b7100) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:4673 #13 0x00007f0e9e99cb4e in open_and_lock_tables (thd=0x7f0e60431070, tables=0x7f0e6047b1b0, derived=false, flags=4096, prelocking_strategy=0x7f0e9e0b7100) at /home/elenst/git/bb-10.2-monty/sql/sql_base.h:249 #14 0x00007f0e9e99d885 in flush_tables_with_read_lock (thd=0x7f0e60431070, all_tables=0x7f0e6047b1b0) at /home/elenst/git/bb-10.2-monty/sql/sql_reload.cc:552 #15 0x00007f0e9e823225 in mysql_execute_command (thd=0x7f0e60431070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:5284 #16 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e60431070, rawbuf=0x7f0e6047b088 "FLUSH TABLE BB, E, D, DD FOR EXPORT /* QNO 832 CON_ID 18 */", length=60, parser_state=0x7f0e9e0b7db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #17 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e60431070, packet=0x7f0e6046f071 " FLUSH TABLE BB, E, D, DD FOR EXPORT /* QNO 832 CON_ID 18 */ ", packet_length=62, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #18 0x00007f0e9e8171a6 in do_command (thd=0x7f0e60431070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #19 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45cf30) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #20 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45cf30) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #21 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #22 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #23 0x0000000000000000 in ?? () Thread 33 (Thread 0x7f0e623f7700 (LWP 46900)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e623f6d10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e623f6d10, m1=0x7f0e623f6db0, m2=0x7f0e623f6db8, request=0x7f0e623f6dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=8, m1=0x7f0e623f6db0, m2=0x7f0e623f6db8, request=0x7f0e623f6dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=8, m1=0x7f0e623f6db0, m2=0x7f0e623f6db8, request=0x7f0e623f6dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=8) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc2a0 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 32 (Thread 0x7f0e9b3ff700 (LWP 46889)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9f21fc51 in safe_cond_timedwait (cond=0x7f0ea05fde60 , mp=0x7f0ea05fdda0 , abstime=0x7f0e9b3fee50, file=0x7f0e9f515f70 "/home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/git/bb-10.2-monty/mysys/thr_mutex.c:545 #2 0x00007f0e9f220be9 in inline_mysql_cond_timedwait (that=0x7f0ea05fde60 , mutex=0x7f0ea05fdda0 , abstime=0x7f0e9b3fee50, src_file=0x7f0e9f515fb0 "/home/elenst/git/bb-10.2-monty/mysys/thr_timer.c", src_line=292) at /home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h:1186 #3 0x00007f0e9f221695 in timer_handler (arg=0x0) at /home/elenst/git/bb-10.2-monty/mysys/thr_timer.c:292 #4 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x0000000000000000 in ?? () Thread 31 (Thread 0x7f0e61bf6700 (LWP 46901)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e61bf5d10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e61bf5d10, m1=0x7f0e61bf5db0, m2=0x7f0e61bf5db8, request=0x7f0e61bf5dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=9, m1=0x7f0e61bf5db0, m2=0x7f0e61bf5db8, request=0x7f0e61bf5dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=9, m1=0x7f0e61bf5db0, m2=0x7f0e61bf5db8, request=0x7f0e61bf5dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=9) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc2a8 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 30 (Thread 0x7f0e883ff700 (LWP 46891)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9f21f94f in safe_cond_wait (cond=0x7f0e9fd9a7a0 , mp=0x7f0e883fed90, file=0x7f0e9f3f7b20 "/home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/git/bb-10.2-monty/mysys/thr_mutex.c:491 #2 0x00007f0e9ec8a7bb in inline_mysql_cond_wait (that=0x7f0e9fd9a7a0 , mutex=0x7f0e883fed90, src_file=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", src_line=339) at /home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h:1149 #3 0x00007f0e9ec8fbe9 in thd_destructor_proxy () at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:339 #4 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x0000000000000000 in ?? () Thread 29 (Thread 0x7f0e9e103300 (LWP 46924)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e9e0fdd08: 0x7f0e9b7d5040) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6f0f9 in rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:772 #6 0x00007f0e9ede348f in pfs_rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:562 #7 0x00007f0e9edecd26 in row_mysql_lock_data_dictionary_func (trx=0x7f0e87003548, file=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0mysql.cc:2389 #8 0x00007f0e9eca8e43 in ha_innobase::create (this=0x7f0e87512088, name=0x7f0e9e100e60 "./test/trigger146298", form=0x7f0e9e0fe640, create_info=0x7f0e9e1014b0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14381 #9 0x00007f0e9ea99180 in handler::ha_create (this=0x7f0e87512088, name=0x7f0e9e100e60 "./test/trigger146298", form=0x7f0e9e0fe640, info_arg=0x7f0e9e1014b0) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4362 #10 0x00007f0e9ea9a094 in ha_create_table (thd=0x7f0e87464070, path=0x7f0e9e100e60 "./test/trigger146298", db=0x7f0e874ad7e8 "test", table_name=0x7f0e874ad198 "trigger146298", create_info=0x7f0e9e1014b0, frm=0x7f0e9e100e50) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4733 #11 0x00007f0e9e933be2 in rea_create_table (thd=0x7f0e87464070, frm=0x7f0e9e100e50, path=0x7f0e9e100e60 "./test/trigger146298", db=0x7f0e874ad7e8 "test", table_name=0x7f0e874ad198 "trigger146298", create_info=0x7f0e9e1014b0, file=0x7f0e874adb88, no_ha_create_table=false) at /home/elenst/git/bb-10.2-monty/sql/unireg.cc:419 #12 0x00007f0e9e8e3747 in create_table_impl (thd=0x7f0e87464070, orig_db=0x7f0e874ad7e8 "test", orig_table_name=0x7f0e874ad198 "trigger146298", db=0x7f0e874ad7e8 "test", table_name=0x7f0e874ad198 "trigger146298", path=0x7f0e9e100e60 "./test/trigger146298", options=..., create_info=0x7f0e9e1014b0, alter_info=0x7f0e9e101400, create_table_mode=0, is_trans=0x7f0e9e1010ce, key_info=0x7f0e9e100e40, key_count=0x7f0e9e100e34, frm=0x7f0e9e100e50) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4870 #13 0x00007f0e9e8e3d6e in mysql_create_table_no_lock (thd=0x7f0e87464070, db=0x7f0e874ad7e8 "test", table_name=0x7f0e874ad198 "trigger146298", create_info=0x7f0e9e1014b0, alter_info=0x7f0e9e101400, is_trans=0x7f0e9e1010ce, create_table_mode=0) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4981 #14 0x00007f0e9e8e3ff1 in mysql_create_table (thd=0x7f0e87464070, create_table=0x7f0e874ad1e0, create_info=0x7f0e9e1014b0, alter_info=0x7f0e9e101400) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:5044 #15 0x00007f0e9e81e20e in mysql_execute_command (thd=0x7f0e87464070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3921 #16 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e87464070, rawbuf=0x7f0e874ad088 "CREATE TABLE IF NOT EXISTS trigger146298 (f1 INTEGER) /* QNO 781 CON_ID 15 */", length=77, parser_state=0x7f0e9e101db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #17 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e87464070, packet=0x7f0e874a1071 "CREATE TABLE IF NOT EXISTS trigger146298 (f1 INTEGER) /* QNO 781 CON_ID 15 */ ", packet_length=78, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #18 0x00007f0e9e8171a6 in do_command (thd=0x7f0e87464070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #19 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45ce50) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #20 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45ce50) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #21 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #22 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #23 0x0000000000000000 in ?? () Thread 28 (Thread 0x7f0e9beee300 (LWP 46928)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e9bee78b8: 0x7f0e9b7d5140) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6f0f9 in rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:772 #6 0x00007f0e9ede348f in pfs_rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:562 #7 0x00007f0e9edecd26 in row_mysql_lock_data_dictionary_func (trx=0x7f0e87004708, file=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0mysql.cc:2389 #8 0x00007f0e9eca8e43 in ha_innobase::create (this=0x7f0e5acc0088, name=0x7f0e9beeaa10 "./transforms/trigger246307", form=0x7f0e9bee81f0, create_info=0x7f0e9beec4b0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14381 #9 0x00007f0e9ea99180 in handler::ha_create (this=0x7f0e5acc0088, name=0x7f0e9beeaa10 "./transforms/trigger246307", form=0x7f0e9bee81f0, info_arg=0x7f0e9beec4b0) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4362 #10 0x00007f0e9ea9a094 in ha_create_table (thd=0x7f0e5ac7c070, path=0x7f0e9beeaa10 "./transforms/trigger246307", db=0x7f0e5adae2c8 "transforms", table_name=0x7f0e5adae2d8 "trigger246307", create_info=0x7f0e9beec4b0, frm=0x7f0e9beeaa00) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4733 #11 0x00007f0e9e933be2 in rea_create_table (thd=0x7f0e5ac7c070, frm=0x7f0e9beeaa00, path=0x7f0e9beeaa10 "./transforms/trigger246307", db=0x7f0e5adae2c8 "transforms", table_name=0x7f0e5adae2d8 "trigger246307", create_info=0x7f0e9beec4b0, file=0x7f0e5adb0a50, no_ha_create_table=false) at /home/elenst/git/bb-10.2-monty/sql/unireg.cc:419 #12 0x00007f0e9e8e3747 in create_table_impl (thd=0x7f0e5ac7c070, orig_db=0x7f0e5adae2c8 "transforms", orig_table_name=0x7f0e5adae2d8 "trigger246307", db=0x7f0e5adae2c8 "transforms", table_name=0x7f0e5adae2d8 "trigger246307", path=0x7f0e9beeaa10 "./transforms/trigger246307", options=..., create_info=0x7f0e9beec4b0, alter_info=0x7f0e9beec400, create_table_mode=2, is_trans=0x0, key_info=0x7f0e9beea9f0, key_count=0x7f0e9beea9e4, frm=0x7f0e9beeaa00) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4870 #13 0x00007f0e9e8e3d6e in mysql_create_table_no_lock (thd=0x7f0e5ac7c070, db=0x7f0e5adae2c8 "transforms", table_name=0x7f0e5adae2d8 "trigger246307", create_info=0x7f0e9beec4b0, alter_info=0x7f0e9beec400, is_trans=0x0, create_table_mode=2) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4981 #14 0x00007f0e9e800b22 in create_table_from_items (thd=0x7f0e5ac7c070, create_info=0x7f0e9beec4b0, create_table=0x7f0e5adae320, alter_info=0x7f0e9beec400, items=0x7f0e5ac803a0, lock=0x7f0e9beebde8, hooks=0x7f0e9beebe20) at /home/elenst/git/bb-10.2-monty/sql/sql_insert.cc:4107 #15 0x00007f0e9e8011d9 in select_create::prepare (this=0x7f0e5adaf9e0, values=..., u=0x7f0e5ac7fb48) at /home/elenst/git/bb-10.2-monty/sql/sql_insert.cc:4284 #16 0x00007f0e9e85d60b in JOIN::prepare (this=0x7f0e5adafad8, tables_init=0x7f0e5adaeaa8, wild_num=1, conds_init=0x7f0e5adaf2a8, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x7f0e5adaf5f0, proc_param_init=0x0, select_lex_arg=0x7f0e5ac80278, unit_arg=0x7f0e5ac7fb48) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:1012 #17 0x00007f0e9e8661b5 in mysql_select (thd=0x7f0e5ac7c070, tables=0x7f0e5adaeaa8, wild_num=1, fields=..., conds=0x7f0e5adaf2a8, og_num=0, order=0x0, group=0x0, having=0x7f0e5adaf5f0, proc_param=0x0, select_options=552171997952, result=0x7f0e5adaf9e0, unit=0x7f0e5ac7fb48, select_lex=0x7f0e5ac80278) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3562 #18 0x00007f0e9e85b2cd in handle_select (thd=0x7f0e5ac7c070, lex=0x7f0e5ac7fa80, result=0x7f0e5adaf9e0, setup_tables_done_option=0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:373 #19 0x00007f0e9e81dfb9 in mysql_execute_command (thd=0x7f0e5ac7c070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3886 #20 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5ac7c070, rawbuf=0x7f0e5adae088 "CREATE TABLE IF NOT EXISTS transforms.trigger246307 SELECT * FROM mysql.`time_zone` AS table1 WHERE table1.`Use_leap_seconds` < 8 HAVING table1.`Use_leap_seconds` < 'lb' /* QNO 1098 CON_ID 20 */ LI"..., length=230, parser_state=0x7f0e9beecdb0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #21 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5ac7c070, packet=0x7f0e5ac91071 "CREATE TABLE IF NOT EXISTS transforms.trigger246307 SELECT * FROM mysql.`time_zone` AS table1 WHERE table1.`Use_leap_seconds` < 8 HAVING table1.`Use_leap_seconds` < 'lb' /* QNO 1098 CON_ID 20 */ LI"..., packet_length=231, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #22 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5ac7c070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #23 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45d1d0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #24 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45d1d0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #25 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #26 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #27 0x0000000000000000 in ?? () Thread 27 (Thread 0x7f0e5d3fc700 (LWP 46909)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e5d3fbab8: 0x7f0e9b7d5080) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6e7c8 in rw_lock_s_lock_spin (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:391 #6 0x00007f0e9ee09053 in rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:298 #7 0x00007f0e9ee09441 in pfs_rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:655 #8 0x00007f0e9ee0de35 in row_purge_parse_undo_rec (node=0x7f0e9b4712f0, undo_rec=0x7f0e5ad4e098 "\v0\016\004\016", updated_extern=0x7f0e5d3fbc5e, thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:861 #9 0x00007f0e9ee0e45c in row_purge (node=0x7f0e9b4712f0, undo_rec=0x7f0e5ad4e098 "\v0\016\004\016", thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1028 #10 0x00007f0e9ee0e6d6 in row_purge_step (thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1110 #11 0x00007f0e9ed98050 in que_thr_step (thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1056 #12 0x00007f0e9ed9824f in que_run_threads_low (thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1118 #13 0x00007f0e9ed9840f in que_run_threads (thr=0x7f0e9b471228) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1158 #14 0x00007f0e9ee9005e in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at /home/elenst/git/bb-10.2-monty/storage/innobase/trx/trx0purge.cc:1859 #15 0x00007f0e9ee5e389 in srv_do_purge (thd=0x7f0e5ac16070, n_threads=4, n_total_purged=0x7f0e5d3fbe30) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2881 #16 0x00007f0e9ee5eacd in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:3059 #17 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #18 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #19 0x0000000000000000 in ?? () Thread 26 (Thread 0x7f0e63bfa700 (LWP 46897)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e63bf9d10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e63bf9d10, m1=0x7f0e63bf9db0, m2=0x7f0e63bf9db8, request=0x7f0e63bf9dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=5, m1=0x7f0e63bf9db0, m2=0x7f0e63bf9db8, request=0x7f0e63bf9dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=5, m1=0x7f0e63bf9db0, m2=0x7f0e63bf9db8, request=0x7f0e63bf9dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc288 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 25 (Thread 0x7f0e893ff700 (LWP 46890)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9f21fc51 in safe_cond_timedwait (cond=0x7f0ea05ec680 , mp=0x7f0ea05ec5c0 , abstime=0x7f0e893feda0, file=0x7f0e9f4da230 "/home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/git/bb-10.2-monty/mysys/thr_mutex.c:545 #2 0x00007f0e9f0a7991 in inline_mysql_cond_timedwait (that=0x7f0ea05ec680 , mutex=0x7f0ea05ec5c0 , abstime=0x7f0e893feda0, src_file=0x7f0e9f4da270 "/home/elenst/git/bb-10.2-monty/storage/maria/ma_servicethread.c", src_line=116) at /home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h:1186 #3 0x00007f0e9f0a7e27 in my_service_thread_sleep (control=0x7f0e9fbac7a0 , sleep_time=29000000000) at /home/elenst/git/bb-10.2-monty/storage/maria/ma_servicethread.c:115 #4 0x00007f0e9f09cad9 in ma_checkpoint_background (arg=0x1e) at /home/elenst/git/bb-10.2-monty/storage/maria/ma_checkpoint.c:708 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 24 (Thread 0x7f0e9e14d300 (LWP 46923)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e9e147d08: 0x7f0e9b7d51c0) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6f0f9 in rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:772 #6 0x00007f0e9ede348f in pfs_rw_lock_x_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:562 #7 0x00007f0e9edecd26 in row_mysql_lock_data_dictionary_func (trx=0x7f0e87003e28, file=0x7f0e9f3f9718 "/home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc", line=14381) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0mysql.cc:2389 #8 0x00007f0e9eca8e43 in ha_innobase::create (this=0x7f0e884c7888, name=0x7f0e9e14ae60 "./test/trigger146309", form=0x7f0e9e148640, create_info=0x7f0e9e14b4b0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:14381 #9 0x00007f0e9ea99180 in handler::ha_create (this=0x7f0e884c7888, name=0x7f0e9e14ae60 "./test/trigger146309", form=0x7f0e9e148640, info_arg=0x7f0e9e14b4b0) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4362 #10 0x00007f0e9ea9a094 in ha_create_table (thd=0x7f0e88447070, path=0x7f0e9e14ae60 "./test/trigger146309", db=0x7f0e884947e8 "test", table_name=0x7f0e88494198 "trigger146309", create_info=0x7f0e9e14b4b0, frm=0x7f0e9e14ae50) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:4733 #11 0x00007f0e9e933be2 in rea_create_table (thd=0x7f0e88447070, frm=0x7f0e9e14ae50, path=0x7f0e9e14ae60 "./test/trigger146309", db=0x7f0e884947e8 "test", table_name=0x7f0e88494198 "trigger146309", create_info=0x7f0e9e14b4b0, file=0x7f0e88494b88, no_ha_create_table=false) at /home/elenst/git/bb-10.2-monty/sql/unireg.cc:419 #12 0x00007f0e9e8e3747 in create_table_impl (thd=0x7f0e88447070, orig_db=0x7f0e884947e8 "test", orig_table_name=0x7f0e88494198 "trigger146309", db=0x7f0e884947e8 "test", table_name=0x7f0e88494198 "trigger146309", path=0x7f0e9e14ae60 "./test/trigger146309", options=..., create_info=0x7f0e9e14b4b0, alter_info=0x7f0e9e14b400, create_table_mode=0, is_trans=0x7f0e9e14b0ce, key_info=0x7f0e9e14ae40, key_count=0x7f0e9e14ae34, frm=0x7f0e9e14ae50) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4870 #13 0x00007f0e9e8e3d6e in mysql_create_table_no_lock (thd=0x7f0e88447070, db=0x7f0e884947e8 "test", table_name=0x7f0e88494198 "trigger146309", create_info=0x7f0e9e14b4b0, alter_info=0x7f0e9e14b400, is_trans=0x7f0e9e14b0ce, create_table_mode=0) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:4981 #14 0x00007f0e9e8e3ff1 in mysql_create_table (thd=0x7f0e88447070, create_table=0x7f0e884941e0, create_info=0x7f0e9e14b4b0, alter_info=0x7f0e9e14b400) at /home/elenst/git/bb-10.2-monty/sql/sql_table.cc:5044 #15 0x00007f0e9e81e20e in mysql_execute_command (thd=0x7f0e88447070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3921 #16 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e88447070, rawbuf=0x7f0e88494088 "CREATE TABLE IF NOT EXISTS trigger146309 (f1 INTEGER) /* QNO 764 CON_ID 21 */", length=77, parser_state=0x7f0e9e14bdb0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #17 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e88447070, packet=0x7f0e88485071 "CREATE TABLE IF NOT EXISTS trigger146309 (f1 INTEGER) /* QNO 764 CON_ID 21 */ ", packet_length=78, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #18 0x00007f0e9e8171a6 in do_command (thd=0x7f0e88447070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #19 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45cc90) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #20 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45cc90) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #21 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #22 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #23 0x0000000000000000 in ?? () Thread 23 (Thread 0x7f0e5bbf9700 (LWP 46912)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e5bbf8b88: 0x7f0e9b7d5280) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6e7c8 in rw_lock_s_lock_spin (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:391 #6 0x00007f0e9ee09053 in rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:298 #7 0x00007f0e9ee09441 in pfs_rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:655 #8 0x00007f0e9ee0de35 in row_purge_parse_undo_rec (node=0x7f0e9b5f18f0, undo_rec=0x7f0e9b4e1b18 "1}\016\001\021", updated_extern=0x7f0e5bbf8d2e, thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:861 #9 0x00007f0e9ee0e45c in row_purge (node=0x7f0e9b5f18f0, undo_rec=0x7f0e9b4e1b18 "1}\016\001\021", thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1028 #10 0x00007f0e9ee0e6d6 in row_purge_step (thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1110 #11 0x00007f0e9ed98050 in que_thr_step (thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1056 #12 0x00007f0e9ed9824f in que_run_threads_low (thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1118 #13 0x00007f0e9ed9840f in que_run_threads (thr=0x7f0e9b5f1828) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1158 #14 0x00007f0e9ee5de80 in srv_task_execute () at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2721 #15 0x00007f0e9ee5dfff in srv_worker_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2771 #16 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #17 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #18 0x0000000000000000 in ?? () Thread 22 (Thread 0x7f0e5ffff700 (LWP 46905)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e7effa800, abstime=0x7f0e5fffedd0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e7effa800, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e7effa800, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9ed2e479 in lock_wait_timeout_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/lock/lock0wait.cc:535 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 21 (Thread 0x7f0e64bfc700 (LWP 46895)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e64bfbd10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e64bfbd10, m1=0x7f0e64bfbdb0, m2=0x7f0e64bfbdb8, request=0x7f0e64bfbdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=3, m1=0x7f0e64bfbdb0, m2=0x7f0e64bfbdb8, request=0x7f0e64bfbdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=3, m1=0x7f0e64bfbdb0, m2=0x7f0e64bfbdb8, request=0x7f0e64bfbdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=3) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc278 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 20 (Thread 0x7f0e583fc700 (LWP 46916)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e9b7f7f80) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e9b7f7f80, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e9b7f7f80, reset_sig_count=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ef30c51 in buf_resize_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/buf/buf0buf.cc:3160 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 19 (Thread 0x7f0e9e22b300 (LWP 46918)): #0 0x00007f0e9cb679f7 in do_sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9cb67a79 in sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0 #2 0x00007f0e9e740dde in signal_hand (arg=0x0) at /home/elenst/git/bb-10.2-monty/sql/mysqld.cc:3560 #3 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #4 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x0000000000000000 in ?? () Thread 18 (Thread 0x7f0e5ebff700 (LWP 46906)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e9b7f7d80, abstime=0x7f0e5ebfead0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e9b7f7d80, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e9b7f7d80, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9ee5c3fc in srv_error_monitor_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:1989 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 17 (Thread 0x7f0e62bf8700 (LWP 46899)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e62bf7d10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e62bf7d10, m1=0x7f0e62bf7db0, m2=0x7f0e62bf7db8, request=0x7f0e62bf7dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=7, m1=0x7f0e62bf7db0, m2=0x7f0e62bf7db8, request=0x7f0e62bf7dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=7, m1=0x7f0e62bf7db0, m2=0x7f0e62bf7db8, request=0x7f0e62bf7dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=7) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc298 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 16 (Thread 0x7f0e5dbfd700 (LWP 46908)): #0 0x00007f0e9cb6752d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66432 in os_thread_sleep (tm=1000000) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0thread.cc:225 #2 0x00007f0e9ee5d9a4 in srv_master_sleep () at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2574 #3 0x00007f0e9ee5dae8 in srv_master_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2621 #4 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x0000000000000000 in ?? () Thread 15 (Thread 0x7f0e5e3fe700 (LWP 46907)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e9b7f7e00, abstime=0x7f0e5e3fdda0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e9b7f7e00, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e9b7f7e00, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9ee5bd75 in srv_monitor_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:1757 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 14 (Thread 0x7f0e9e1e1300 (LWP 46919)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9f21f94f in safe_cond_wait (cond=0x7f0e9fd6a8c0 , mp=0x7f0e9fd6db40 , file=0x7f0e9f2d0480 "/home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/git/bb-10.2-monty/mysys/thr_mutex.c:491 #2 0x00007f0e9e767734 in inline_mysql_cond_wait (that=0x7f0e9fd6a8c0 , mutex=0x7f0e9fd6db40 , src_file=0x7f0e9f2d0cf8 "/home/elenst/git/bb-10.2-monty/sql/slave.cc", src_line=339) at /home/elenst/git/bb-10.2-monty/include/mysql/psi/mysql_thread.h:1149 #3 0x00007f0e9e76835c in handle_slave_background (arg=0x0) at /home/elenst/git/bb-10.2-monty/sql/slave.cc:339 #4 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x0000000000000000 in ?? () Thread 13 (Thread 0x7f0e5cbfb700 (LWP 46910)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e807f6900) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e807f6900, reset_sig_count=5) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee6b958 in sync_array_wait_event (arr=0x7f0e9b45b3a0, cell=@0x7f0e5cbfab88: 0x7f0e9b7d5000) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0arr.cc:490 #5 0x00007f0e9ee6e7c8 in rw_lock_s_lock_spin (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/sync/sync0rw.cc:391 #6 0x00007f0e9ee09053 in rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:298 #7 0x00007f0e9ee09441 in pfs_rw_lock_s_lock_func (lock=0x7f0e9b45be20, pass=0, file_name=0x7f0e9f4486f8 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc", line=861) at /home/elenst/git/bb-10.2-monty/storage/innobase/include/sync0rw.ic:655 #8 0x00007f0e9ee0de35 in row_purge_parse_undo_rec (node=0x7f0e9b471088, undo_rec=0x7f0e9b4e1cd8 "1\350\016\002\021", updated_extern=0x7f0e5cbfad2e, thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:861 #9 0x00007f0e9ee0e45c in row_purge (node=0x7f0e9b471088, undo_rec=0x7f0e9b4e1cd8 "1\350\016\002\021", thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1028 #10 0x00007f0e9ee0e6d6 in row_purge_step (thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0purge.cc:1110 #11 0x00007f0e9ed98050 in que_thr_step (thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1056 #12 0x00007f0e9ed9824f in que_run_threads_low (thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1118 #13 0x00007f0e9ed9840f in que_run_threads (thr=0x7f0e9b5f1a90) at /home/elenst/git/bb-10.2-monty/storage/innobase/que/que0que.cc:1158 #14 0x00007f0e9ee5de80 in srv_task_execute () at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2721 #15 0x00007f0e9ee5dfff in srv_worker_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2771 #16 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #17 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #18 0x0000000000000000 in ?? () Thread 12 (Thread 0x7f0e613f5700 (LWP 46902)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e9b7f7f00, abstime=0x7f0e613f4880) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e9b7f7f00, time_in_usec=1000000, reset_sig_count=2) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e9b7f7f00, time_in_usec=1000000, reset_sig_count=2) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9ef515e4 in pc_sleep_if_needed (next_loop_time=1483750263830, sig_count=2) at /home/elenst/git/bb-10.2-monty/storage/innobase/buf/buf0flu.cc:2716 #5 0x00007f0e9ef526ca in buf_flush_page_cleaner_coordinator (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/buf/buf0flu.cc:3218 #6 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x0000000000000000 in ?? () Thread 11 (Thread 0x7f0e593fe700 (LWP 46914)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e7effb080, abstime=0x7f0e593fddf0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e7effb080, time_in_usec=10000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e7effb080, time_in_usec=10000000, reset_sig_count=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9efb152c in dict_stats_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/dict/dict0stats_bg.cc:425 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 10 (Thread 0x7f0e5c3fa700 (LWP 46911)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e9b7f7c80) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e9b7f7c80, reset_sig_count=20) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e9b7f7c80, reset_sig_count=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ee5dffa in srv_worker_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0srv.cc:2769 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 9 (Thread 0x7f0e633f9700 (LWP 46898)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e633f8d10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e633f8d10, m1=0x7f0e633f8db0, m2=0x7f0e633f8db8, request=0x7f0e633f8dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=6, m1=0x7f0e633f8db0, m2=0x7f0e633f8db8, request=0x7f0e633f8dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=6, m1=0x7f0e633f8db0, m2=0x7f0e633f8db8, request=0x7f0e633f8dc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=6) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc290 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 8 (Thread 0x7f0e9e197300 (LWP 46922)): #0 0x00007f0e9c06b303 in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00007f0e9f27deeb in vio_io_wait (vio=0x7f0e803ee970, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/git/bb-10.2-monty/vio/viosocket.c:945 #2 0x00007f0e9f27c75e in vio_socket_io_wait (vio=0x7f0e803ee970, event=VIO_IO_EVENT_READ) at /home/elenst/git/bb-10.2-monty/vio/viosocket.c:108 #3 0x00007f0e9f27c912 in vio_read (vio=0x7f0e803ee970, buf=0x7f0e9a485070 "\a", size=4) at /home/elenst/git/bb-10.2-monty/vio/viosocket.c:184 #4 0x00007f0e9e74f352 in my_real_read (net=0x7f0e9a447330, complen=0x7f0e9e1964e0, header=1 '\001') at /home/elenst/git/bb-10.2-monty/sql/net_serv.cc:888 #5 0x00007f0e9e74fb3a in my_net_read_packet_reallen (net=0x7f0e9a447330, read_from_server=1 '\001', reallen=0x7f0e9e196548) at /home/elenst/git/bb-10.2-monty/sql/net_serv.cc:1158 #6 0x00007f0e9e74fae4 in my_net_read_packet (net=0x7f0e9a447330, read_from_server=1 '\001') at /home/elenst/git/bb-10.2-monty/sql/net_serv.cc:1142 #7 0x00007f0e9e816c52 in do_command (thd=0x7f0e9a447070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1241 #8 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e9b45cbb0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #9 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e9b45cbb0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #10 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #11 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #12 0x0000000000000000 in ?? () Thread 7 (Thread 0x7f0e58bfd700 (LWP 46915)): #0 0x00007f0e9cb640fe in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed65988 in os_event::timed_wait (this=0x7f0e80ffb180, abstime=0x7f0e58bfcbe0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:286 #2 0x00007f0e9ed65cac in os_event::wait_time_low (this=0x7f0e80ffb180, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:413 #3 0x00007f0e9ed65e98 in os_event_wait_time_low (event=0x7f0e80ffb180, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:518 #4 0x00007f0e9eeca136 in ib_wqueue_timedwait (wq=0x7f0e80ffb080, wait_in_usecs=5000000) at /home/elenst/git/bb-10.2-monty/storage/innobase/ut/ut0wqueue.cc:160 #5 0x00007f0e9f01707f in fts_optimize_thread (arg=0x7f0e80ffb080) at /home/elenst/git/bb-10.2-monty/storage/innobase/fts/fts0opt.cc:3046 #6 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x0000000000000000 in ?? () Thread 6 (Thread 0x7f0e59bff700 (LWP 46913)): #0 0x00007f0e9cb63d84 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66105 in os_event::wait (this=0x7f0e9b7f7e80) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:166 #2 0x00007f0e9ed65af5 in os_event::wait_low (this=0x7f0e9b7f7e80, reset_sig_count=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:336 #3 0x00007f0e9ed65ebd in os_event_wait_low (event=0x7f0e9b7f7e80, reset_sig_count=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0event.cc:535 #4 0x00007f0e9ef47e64 in buf_dump_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/buf/buf0dump.cc:803 #5 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x0000000000000000 in ?? () Thread 5 (Thread 0x7f0e653fd700 (LWP 46894)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e653fcd10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e653fcd10, m1=0x7f0e653fcdb0, m2=0x7f0e653fcdb8, request=0x7f0e653fcdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=2, m1=0x7f0e653fcdb0, m2=0x7f0e653fcdb8, request=0x7f0e653fcdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=2, m1=0x7f0e653fcdb0, m2=0x7f0e653fcdb8, request=0x7f0e653fcdc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=2) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc270 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 4 (Thread 0x7f0e65bfe700 (LWP 46893)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e65bfdd10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e65bfdd10, m1=0x7f0e65bfddb0, m2=0x7f0e65bfddb8, request=0x7f0e65bfddc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=1, m1=0x7f0e65bfddb0, m2=0x7f0e65bfddb8, request=0x7f0e65bfddc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=1, m1=0x7f0e65bfddb0, m2=0x7f0e65bfddb8, request=0x7f0e65bfddc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc268 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 3 (Thread 0x7f0e57bfb700 (LWP 46917)): #0 0x00007f0e9cb6752d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9ed66432 in os_thread_sleep (tm=1000000) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0thread.cc:225 #2 0x00007f0e9ef23dc8 in btr_defragment_thread (arg=0x0) at /home/elenst/git/bb-10.2-monty/storage/innobase/btr/btr0defragment.cc:757 #3 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #4 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x0000000000000000 in ?? () Thread 2 (Thread 0x7f0e663ff700 (LWP 46892)): #0 0x00007f0e9de3e644 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00007f0e9ed584e8 in LinuxAIOHandler::collect (this=0x7f0e663fed10) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2491 #2 0x00007f0e9ed58a22 in LinuxAIOHandler::poll (this=0x7f0e663fed10, m1=0x7f0e663fedb0, m2=0x7f0e663fedb8, request=0x7f0e663fedc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2637 #3 0x00007f0e9ed58bbe in os_aio_linux_handler (global_segment=0, m1=0x7f0e663fedb0, m2=0x7f0e663fedb8, request=0x7f0e663fedc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:2693 #4 0x00007f0e9ed5d586 in os_aio_handler (segment=0, m1=0x7f0e663fedb0, m2=0x7f0e663fedb8, request=0x7f0e663fedc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/os/os0file.cc:6341 #5 0x00007f0e9efca285 in fil_aio_wait (segment=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/fil/fil0fil.cc:5682 #6 0x00007f0e9ee622f3 in io_handler_thread (arg=0x7f0e9fddc260 ) at /home/elenst/git/bb-10.2-monty/storage/innobase/srv/srv0start.cc:327 #7 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x0000000000000000 in ?? () Thread 1 (Thread 0x7f0e9bea4300 (LWP 46929)): #0 0x00007f0e9cb64f8c in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x00007f0e9f21a44d in my_write_core (sig=6) at /home/elenst/git/bb-10.2-monty/mysys/stacktrace.c:477 #2 0x00007f0e9ea8e349 in handle_fatal_signal (sig=6) at /home/elenst/git/bb-10.2-monty/sql/signal_handler.cc:296 #3 #4 0x00007f0e9bfb9425 in raise () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00007f0e9bfbcb8b in abort () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x00007f0e9eec5df5 in ut_dbg_assertion_failed (expr=0x7f0e9f44ca93 "templ->mysql_null_bit_mask", file=0x7f0e9f44bd10 "/home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc", line=3137) at /home/elenst/git/bb-10.2-monty/storage/innobase/ut/ut0dbg.cc:59 #7 0x00007f0e9ee21ff7 in row_sel_store_mysql_field_func (mysql_rec=0x7f0e5a824d88 "", prebuilt=0x7f0e5a9b5088, rec=0x7f0e69e4841d "\200", index=0x7f0e8851b388, offsets=0x7f0e9bea0da0, field_no=8, templ=0x7f0e5a901fc0) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc:3137 #8 0x00007f0e9ee2263f in row_sel_store_mysql_rec (mysql_rec=0x7f0e5a824d88 "", prebuilt=0x7f0e5a9b5088, rec=0x7f0e69e4841d "\200", vrow=0x0, rec_clust=1, index=0x7f0e8851b388, offsets=0x7f0e9bea0da0) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc:3307 #9 0x00007f0e9ee277ea in row_search_mvcc (buf=0x7f0e5a824d88 "", mode=PAGE_CUR_G, prebuilt=0x7f0e5a9b5088, match_mode=0, direction=1) at /home/elenst/git/bb-10.2-monty/storage/innobase/row/row0sel.cc:5540 #10 0x00007f0e9eca27ef in ha_innobase::general_fetch (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "", direction=1, match_mode=0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:10646 #11 0x00007f0e9eca2a70 in ha_innobase::index_next (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "") at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:10713 #12 0x00007f0e9ea9547d in handler::ha_index_next (this=0x7f0e5a93b888, buf=0x7f0e5a824d88 "") at /home/elenst/git/bb-10.2-monty/sql/handler.cc:2677 #13 0x00007f0e9ea9b9da in handler::read_range_next (this=0x7f0e5a93b888) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:5365 #14 0x00007f0e9e9b33d4 in handler::multi_range_read_next (this=0x7f0e5a93b888, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:257 #15 0x00007f0e9e9b3674 in Mrr_simple_index_reader::get_next (this=0x7f0e5a93bdf0, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:322 #16 0x00007f0e9e9b61ec in DsMrr_impl::dsmrr_next (this=0x7f0e5a93bcb0, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/sql/multi_range_read.cc:1408 #17 0x00007f0e9ecb6cbe in ha_innobase::multi_range_read_next (this=0x7f0e5a93b888, range_info=0x7f0e9bea18a0) at /home/elenst/git/bb-10.2-monty/storage/innobase/handler/ha_innodb.cc:23473 #18 0x00007f0e9ebeaa2c in QUICK_RANGE_SELECT::get_next (this=0x7f0e5a9e6140) at /home/elenst/git/bb-10.2-monty/sql/opt_range.cc:11190 #19 0x00007f0e9ebfb9c1 in rr_quick (info=0x7f0e5a9acd48) at /home/elenst/git/bb-10.2-monty/sql/records.cc:353 #20 0x00007f0e9e88b891 in sub_select (join=0x7f0e5a9b05c0, join_tab=0x7f0e5a9acc80, end_of_records=false) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:18362 #21 0x00007f0e9e88ad99 in do_select (join=0x7f0e5a9b05c0, procedure=0x0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:17887 #22 0x00007f0e9e865b7a in JOIN::exec_inner (this=0x7f0e5a9b05c0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3388 #23 0x00007f0e9e8650cc in JOIN::exec (this=0x7f0e5a9b05c0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3199 #24 0x00007f0e9e866267 in mysql_select (thd=0x7f0e5a89e070, tables=0x7f0e5a8dfaa8, wild_num=1, fields=..., conds=0x7f0e5a8e1468, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f0e5a8e4e48, unit=0x7f0e5a8a1b48, select_lex=0x7f0e5a8a2278) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:3584 #25 0x00007f0e9e85b2cd in handle_select (thd=0x7f0e5a89e070, lex=0x7f0e5a8a1a80, result=0x7f0e5a8e4e48, setup_tables_done_option=0) at /home/elenst/git/bb-10.2-monty/sql/sql_select.cc:373 #26 0x00007f0e9e82734f in execute_sqlcom_select (thd=0x7f0e5a89e070, all_tables=0x7f0e5a8dfaa8) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:6396 #27 0x00007f0e9e81cd7b in mysql_execute_command (thd=0x7f0e5a89e070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:3426 #28 0x00007f0e9e82ad45 in mysql_parse (thd=0x7f0e5a89e070, rawbuf=0x7f0e5a8df088 "SELECT * FROM (test.`view_D` AS table1 INNER JOIN test.`D` AS table2 ON ( table2.`col_time_key` = table1.`col_time_key` ) ) WHERE table2.`col_datetime_key` < '1988-12-27 19:50:42.048505' LIMIT 7 /* QN"..., length=219, parser_state=0x7f0e9bea2db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 #29 0x00007f0e9e8187e6 in dispatch_command (command=COM_QUERY, thd=0x7f0e5a89e070, packet=0x7f0e5a8d5071 "", packet_length=221, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 #30 0x00007f0e9e8171a6 in do_command (thd=0x7f0e5a89e070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 #31 0x00007f0e9e961894 in do_handle_one_connection (connect=0x7f0e82bfe2b0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 #32 0x00007f0e9e961621 in handle_one_connection (arg=0x7f0e82bfe2b0) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 #33 0x00007f0e9cb5fe9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #34 0x00007f0e9c076cbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 #35 0x0000000000000000 in ?? ()