(gdb) print LRU_list_mutex $1 = {event = 0x24e0c60, lock_word = 1, os_fast_mutex = {__data = {__lock = 1, __count = 0, __owner = 30676, __nusers = 1, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000?w\000\000\001\000\000\000\003", '\0' , __align = 1}, waiters = 1, list = {prev = 0xbd18a0, next = 0xbd17a0}, cfile_name = 0x8c5224 "buf/buf0buf.c", cline = 938, count_os_wait = 19309} (gdb) print flush_list_mutex $2 = {event = 0x24e0d00, lock_word = 1, os_fast_mutex = {__data = {__lock = 1, __count = 0, __owner = 30676, __nusers = 1, __kind = 3, __spins = 0, __list = {__prev = 0x0, __next = 0x0}}, __size = "\001\000\000\000\000\000\000\000?w\000\000\001\000\000\000\003", '\0' , __align = 1}, waiters = 1, list = {prev = 0xbd1720, next = 0xbd1620}, cfile_name = 0x8c5224 "buf/buf0buf.c", cline = 939, count_os_wait = 2199} (gdb) print page_hash_latch $3 = {s_event = 0x24e0da0, x_event = 0x24e0e40, wait_ex_event = 0x24e0ee0, lock_word = 1048576, reader_count = 0, writer = 351, writer_thread = 1204177232, writer_count = 0, pass = 0, s_waiters = 1, x_waiters = 0, wait_ex_waiters = 1, list = { prev = 0x7fbdc4db80f0, next = 0xbcf720}, cfile_name = 0x8c5224 "buf/buf0buf.c", last_s_file_name = 0x8c413a "btr/btr0sea.c", last_x_file_name = 0x8c5f16 "buf/buf0lru.c", writer_is_wait_ex = 1, cline = 940, last_s_line = 821, last_x_line = 1450, magic_n = 22643} Thread 68 (Thread 0x4096c950 (LWP 30531)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc1a0, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=0, message1=0x4096c0e0, message2=0x4096c0d8, type=0x4096c0d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=0) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 67 (Thread 0x4116d950 (LWP 30532)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc240, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=1, message1=0x4116d0e0, message2=0x4116d0d8, type=0x4116d0d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=1) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 66 (Thread 0x4196e950 (LWP 30533)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=27) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=16, zip_size=0, offset=1, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x4196db70) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000711a1e in ibuf_merge_or_delete_for_page (block=0x7fbdc548b060, space=16, page_no=279, zip_size=0, update_ibuf_bitmap=1) at ibuf/ibuf0ibuf.c:3261 #7 0x00000000006db98a in buf_page_io_complete (bpage=0x7fbdc548b060) at buf/buf0buf.c:3161 #8 0x00000000006f9ec4 in fil_aio_wait (segment=2) at fil/fil0fil.c:4524 #9 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #10 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #11 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #12 0x0000000000000000 in ?? () Thread 65 (Thread 0x4216f950 (LWP 30534)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc380, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=3, message1=0x4216f0e0, message2=0x4216f0d8, type=0x4216f0d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=3) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 64 (Thread 0x42970950 (LWP 30535)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc420, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=4, message1=0x429700e0, message2=0x429700d8, type=0x429700d0) ---Type to continue, or q to quit--- at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=4) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 63 (Thread 0x43171950 (LWP 30536)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc4c0, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=5, message1=0x431710e0, message2=0x431710d8, type=0x431710d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=5) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 62 (Thread 0x43972950 (LWP 30537)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc560, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=6, message1=0x439720e0, message2=0x439720d8, type=0x439720d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=6) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 61 (Thread 0x44173950 (LWP 30538)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0c60, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=28) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd1620, file_name=0x8c5224 "buf/buf0buf.c", line=3173) at sync/sync0sync.c:570 #4 0x00000000006d9c47 in mutex_enter_func (mutex=0xbd1620, file_name=0x8c5224 "buf/buf0buf.c", line=3173) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006db9a5 in buf_page_io_complete (bpage=0x7fbdc4fef160) at buf/buf0buf.c:3173 #6 0x00000000006f9ec4 in fil_aio_wait (segment=7) at fil/fil0fil.c:4524 #7 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #8 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #9 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #10 0x0000000000000000 in ?? () Thread 60 (Thread 0x44974950 (LWP 30539)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc6a0, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=8, message1=0x449740e0, message2=0x449740d8, type=0x449740d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=8) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 59 (Thread 0x45175950 (LWP 30540)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24cc740, reset_sig_count=) at os/os0sync.c:422 ---Type to continue, or q to quit--- #2 0x000000000072c144 in os_aio_simulated_handle (global_segment=9, message1=0x451750e0, message2=0x451750d8, type=0x451750d0) at os/os0file.c:3955 #3 0x00000000006f9e23 in fil_aio_wait (segment=9) at fil/fil0fil.c:4500 #4 0x00000000007692ca in io_handler_thread (arg=) at srv/srv0start.c:433 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 58 (Thread 0x46177950 (LWP 30548)): #0 0x00007fbe8b7d8482 in select () from /lib/libc.so.6 #1 0x000000000072e1e3 in os_thread_sleep (tm=) at os/os0thread.c:272 #2 0x0000000000766959 in srv_lock_timeout_and_monitor_thread (arg=) at srv/srv0srv.c:2000 #3 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #4 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #5 0x0000000000000000 in ?? () Thread 57 (Thread 0x46978950 (LWP 30549)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=50) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=366) at sync/sync0sync.c:570 #4 0x0000000000765c69 in srv_error_monitor_thread (arg=) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #6 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 56 (Thread 0x47179950 (LWP 30550)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ceac40, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=46) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8aba5ab8, file_name=0x8c5792 "buf/buf0flu.c", line=553) at sync/sync0sync.c:570 #4 0x00000000006e24ca in buf_flush_try_page (space=, offset=, flush_type=) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006e2fef in buf_flush_batch (flush_type=BUF_FLUSH_LIST, min_n=800, lsn_limit=18446744073709551615) at buf/buf0flu.c:1002 #6 0x0000000000764adb in srv_master_thread (arg=) at srv/srv0srv.c:2455 #7 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #8 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #9 0x0000000000000000 in ?? () Thread 55 (Thread 0x471ba950 (LWP 30551)): #0 0x00007fbe8ca90e7b in sigwait () from /lib/libpthread.so.0 #1 0x0000000000577c7f in signal_hand (arg=) at mysqld.cc:2710 #2 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #3 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #4 0x0000000000000000 in ?? () Thread 54 (Thread 0x471fb950 (LWP 30597)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce41b0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=45) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8aba9cc0, file_name=0x8da170 "trx/trx0trx.c", line=738) at sync/sync0sync.c:570 #4 0x000000000077c90c in trx_commit_off_kernel (trx=0x7fbe8ac378b8) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x000000000077d3af in trx_commit_for_mysql (trx=0x7fbe8ac378b8) at trx/trx0trx.c:1553 ---Type to continue, or q to quit--- #6 0x00000000006bc469 in innobase_commit_low (trx=0x9ce41ec) at handler/ha_innodb.cc:2238 #7 0x00000000006be515 in innobase_commit (hton=, thd=0x9d00830, all=true) at handler/ha_innodb.cc:2370 #8 0x000000000063eb90 in ha_commit_one_phase (thd=0x9d00830, all=true) at handler.cc:1202 #9 0x000000000063f65f in ha_commit_trans (thd=0x9d00830, all=) at handler.cc:1171 #10 0x0000000000581d63 in end_trans (thd=0x9ce41ec, completion=COMMIT) at sql_parse.cc:714 #11 0x0000000000585520 in mysql_execute_command (thd=0x9d00830) at sql_parse.cc:3947 #12 0x0000000000587ac4 in mysql_parse (thd=0x9d00830, inBuf=0x9d33dd0 "commit", length=6, found_semicolon=0x471fac88) at sql_parse.cc:5787 #13 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0x9d00830, packet=0x9d214e1 "commit", packet_length=) at sql_parse.cc:1200 #14 0x000000000058a19c in do_command (thd=0x9d00830) at sql_parse.cc:857 #15 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #16 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #17 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #18 0x0000000000000000 in ?? () Thread 53 (Thread 0x4723c950 (LWP 30598)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=25) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=27, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x472393f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abd90b8, level=0, tuple=0x7fbd78083d40, mode=2, latch_mode=1, cursor=0x7fbd780729a0, has_search_latch=1, mtr=0x472393f0) at btr/btr0cur.c:465 #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbd7807cba0 "???+", mode=2, prebuilt=0x7fbd78083a70, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd78072530, buf=0x7fbd7807cba0 "???+", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd78072530, buf=0x7fbd7807cba0 "???+", key=0x9d89158 "T", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd78072530, buf=0x7fbd7807cba0 "???+", index=, key=0x9d89158 "T", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9d88d18) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9d88d18, pos=0x9d87408) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9d87370, tables=, conds=0x9d871c0, keyuse_array=0x9d88930) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9d87370) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x9d254f0, rref_pointer_array=0xac451d0, tables=0xac45d38, wild_num=0, fields=@0xac45100, conds=0x9d871c0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xac46b08, unit=0xac44bd0, select_lex=0xac45000) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x9d254f0, lex=0xac44b30, result=0xac46b08, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x9d254f0, all_tables=0xac45d38) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x9d254f0) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0xac447c0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xac447c0, expanded_query=0x4723b5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x9d254f0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x9d254f0, packet=0x9d27d91 "#", packet_length=29) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x9d254f0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 ---Type to continue, or q to quit--- #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 52 (Thread 0x4727d950 (LWP 30600)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=35) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=27, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x4727ad60) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abd90b8, level=0, tuple=0x7fbd64083570, mode=2, latch_mode=1, cursor=0x7fbd64080720, has_search_latch=0, mtr=0x4727ad60) at btr/btr0cur.c:465 #6 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd6407fec0 "??", mode=2, prebuilt=0x7fbd64077500, match_mode=1, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd6407d4e0, buf=0x7fbd6407fec0 "??", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd6407d4e0, buf=0x7fbd6407fec0 "??", key=0x7fbd6408b6d8 "\023", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063d3c4 in handler::read_range_first (this=0x7fbd6407d4e0, start_key=, end_key=, eq_range_arg=, sorted=) at handler.cc:4155 #10 0x000000000063d4a4 in handler::read_multi_range_first (this=0x7fbd6407d4e0, found_range_p=0x4727b318, ranges=, range_count=, sorted=, buffer=) at handler.cc:4029 #11 0x000000000062641d in QUICK_RANGE_SELECT::get_next (this=0x7fbd6408ae10) at opt_range.cc:8444 #12 0x0000000000638ec8 in rr_quick (info=0x4727b3d0) at records.cc:313 #13 0x00000000005f353c in mysql_update (thd=0x7fbdbc0008c0, table_list=0xa37d6e0, fields=@0xa37cc68, values=@0xa37d040, conds=0x9d41e70, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:571 #14 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0008c0) at sql_parse.cc:2959 #15 0x00000000005ed343 in Prepared_statement::execute (this=0xa1d7230, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1d7230, expanded_query=0x4727c5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0008c0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0008c0, packet=0x7fbdbc003a61 "\b", packet_length=29) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc0008c0) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 51 (Thread 0x472be950 (LWP 30601)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=11) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=65537, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x472ba280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbd54051950, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=79599, thr=0x7fbd5404e470) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbd54051950, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=79599, ---Type to continue, or q to quit--- thr=0x7fbd5404e470) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd54051950, mode=4, latch_mode=2, cursor=0x472bb790, has_search_latch=0, mtr=0x472bbcd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd54051950, n_ext=0, thr=0x7fbd5404e470) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd54051950, n_ext=0, foreign=, thr=0x7fbd5404e470) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd5404e470) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd5404f530 "\211?\v", prebuilt=0x7fbd54042f70) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd5404f340, record=0x7fbd5404f530 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd5404f340, buf=0x7fbd5404f530 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc007ba0, table=0x7fbd540500e0, info=0x472bc4a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc007ba0, table_list=0xa215610, fields=@0xa214e88, values_list=@0xa214ed0, update_fields=@0xa214eb8, update_values=@0xa214ea0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc007ba0) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x9ef4570, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x9ef4570, expanded_query=0x472bd5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc007ba0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc007ba0, packet=0x7fbdbc00ad41 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc007ba0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 50 (Thread 0x472ff950 (LWP 30602)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=10) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at sync/sync0sync.c:570 #4 0x0000000000729064 in mutex_enter_func (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x0000000000729183 in mtr_commit (mtr=0x472fcca0) at ../../storage/innobase/include/log0log.ic:306 #6 0x000000000075dcd4 in row_upd_clust_rec (node=0x7fbd8c087828, index=0x7fbe8abd90b8, thr=0x7fbd8c087d68, mtr=0x472fcca0) at row/row0upd.c:1682 #7 0x000000000076080a in row_upd_clust_step (node=0x7fbd8c087828, thr=0x7fbd8c087d68) at row/row0upd.c:1921 #8 0x0000000000760dc4 in row_upd_step (thr=0x7fbd8c087d68) at row/row0upd.c:1998 #9 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd8c083a40) at row/row0mysql.c:1367 #10 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd8c0835d0, old_row=0x7fbd8c088ad8 "p=\205", new_row=0x7fbd8c07de40 "") at handler/ha_innodb.cc:4508 #11 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd8c0835d0, old_data=0x7fbd8c07df78 "", new_data=0x7fbd8c07de40 "") at handler.cc:4591 #12 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc00ee80, table_list=0xa1ff4d0, fields=@0xa1fea58, values=@0xa1fee30, conds=0x9d7d130, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc00ee80) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0xa1900a0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1900a0, expanded_query=0x472fe5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 ---Type to continue, or q to quit--- #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc00ee80, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc00ee80, packet=0x7fbdbc012021 "\b", packet_length=29) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc00ee80) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 49 (Thread 0x47340950 (LWP 30604)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=26) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=29, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x4733dcd0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abc14b8, level=0, tuple=0x7fbd8408b6a0, mode=4, latch_mode=2, cursor=0x4733d790, has_search_latch=0, mtr=0x4733dcd0) at btr/btr0cur.c:465 #6 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abc14b8, entry=0x7fbd8408b6a0, n_ext=0, thr=0x7fbdb00eaf80) at row/row0ins.c:2025 #7 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abc14b8, entry=0x7fbd8408b6a0, n_ext=0, foreign=, thr=0x7fbdb00eaf80) at row/row0ins.c:2194 #8 0x0000000000749961 in row_ins_step (thr=0x7fbdb00eaf80) at row/row0ins.c:2279 #9 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbdb00e89a0 "??\v", prebuilt=0x7fbdb00e01f0) at row/row0mysql.c:1120 #10 0x00000000006be888 in ha_innobase::write_row (this=0x7fbdb00e87b0, record=0x7fbdb00e89a0 "??\v") at handler/ha_innodb.cc:4218 #11 0x000000000064088d in handler::ha_write_row (this=0x7fbdb00e87b0, buf=0x7fbdb00e89a0 "??\v") at handler.cc:4570 #12 0x00000000005e4035 in write_record (thd=0x7fbdbc016160, table=0x7fbdb00e7f10, info=0x4733e4a0) at sql_insert.cc:1568 #13 0x00000000005e797c in mysql_insert (thd=0x7fbdbc016160, table_list=0x7fbdb406f540, fields=@0x7fbdb406ee28, values_list=@0x7fbdb406ee70, update_fields=@0x7fbdb406ee58, update_values=@0x7fbdb406ee40, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #14 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc016160) at sql_parse.cc:3066 #15 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdb406e120, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdb406e120, expanded_query=0x4733f5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc016160, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc016160, packet=0x7fbdbc019301 "\004", packet_length=69) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc016160) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 48 (Thread 0x47381950 (LWP 30607)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=13) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8ac27cb8, info=0x7fbe8ac27ec0, tuple=0x7fbd8407fde0, mode=2, latch_mode=1, cursor=0x7fbd8406c7d0, has_search_latch=1, mtr=0x4737e3f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbd8407fde0, mode=2, latch_mode=1, cursor=0x7fbd8406c7d0, has_search_latch=1, mtr=0x4737e3f0) at btr/btr0cur.c:370 ---Type to continue, or q to quit--- #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbd84075fe0 "??_\001", mode=2, prebuilt=0x7fbd8406c500, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd84075df0, buf=0x7fbd84075fe0 "??_\001", key_ptr=, key_len=4, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd84075df0, buf=0x7fbd84075fe0 "??_\001", key=0x9d78ea8 "*\227", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd84075df0, buf=0x7fbd84075fe0 "??_\001", index=, key=0x9d78ea8 "*\227", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9d789f0) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9d789f0, pos=0x9d771c8) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9d77130, tables=, conds=0x9d788a0, keyuse_array=0x9d786f0) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9d77130) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc01d440, rref_pointer_array=0xa153850, tables=0xa1544f0, wild_num=0, fields=@0xa153700, conds=0xa154e00, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xa154f78, unit=0xa153250, select_lex=0xa153680) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc01d440, lex=0xa1531b0, result=0xa154f78, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc01d440, all_tables=0xa1544f0) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc01d440) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x9e83a00, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x9e83a00, expanded_query=0x473805e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc01d440, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc01d440, packet=0x7fbdbc0205e1 "\006", packet_length=17) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc01d440) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 47 (Thread 0x473c2950 (LWP 30608)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9cce420, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=9) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbdca4aa5a0, pass=, file_name=0x8c3460 "../../storage/innobase/include/btr0btr.ic", line=31) at sync/sync0rw.c:371 #4 0x00000000006de829 in buf_page_get_gen (space=10, zip_size=0, offset=3, rw_latch=1, guess=0x0, mode=10, file=0x8c3460 "../../storage/innobase/include/btr0btr.ic", line=31, mtr=0x473bf3f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006c824f in btr_cur_latch_leaves (page=0x7fbe8a2d4000 "??\212J", space=10, zip_size=0, page_no=3, latch_mode=, cursor=0x7fbd940aa160, mtr=0x473bf3f0) at ../../storage/innobase/include/btr0btr.ic:31 #6 0x00000000006cc3fd in btr_cur_search_to_nth_level (index=0x7fbe8abd70b8, level=0, tuple=0x7fbd940b2f90, mode=2, latch_mode=1, cursor=0x7fbd940aa160, has_search_latch=0, mtr=0x473bf3f0) at btr/btr0cur.c:529 #7 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd940ad980 "", mode=2, prebuilt=0x7fbd940a7fc0, match_mode=1, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #8 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd940ad790, buf=0x7fbd940ad980 "", key_ptr=, key_len=2, find_flag=) at handler/ha_innodb.cc:4933 #9 0x0000000000641f8e in handler::index_read_map (this=0x7fbd940ad790, buf=0x7fbd940ad980 "", key=0x9d85f78 ">", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #10 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd940ad790, buf=0x7fbd940ad980 "", index=, key=0x9d85f78 ">", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #11 0x00000000005c56bd in join_read_const (tab=0x9d85ac0) at sql_select.cc:11513 #12 0x00000000005c8c36 in join_read_const_table (tab=0x9d85ac0, pos=0x9d84298) at sql_select.cc:11412 ---Type to continue, or q to quit--- #13 0x00000000005d78ab in make_join_statistics (join=0x9d84200, tables=, conds=0x9d85970, keyuse_array=0x9d857c0) at sql_select.cc:2735 #14 0x00000000005d8d92 in JOIN::optimize (this=0x9d84200) at sql_select.cc:945 #15 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc024720, rref_pointer_array=0xa414f60, tables=0xa415f68, wild_num=0, fields=@0xa414e00, conds=0xa4168e0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xa416880, unit=0xa414960, select_lex=0xa414d90) at sql_select.cc:2347 #16 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc024720, lex=0xa4148c0, result=0xa416880, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc024720, all_tables=0xa415f68) at sql_parse.cc:4888 #18 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc024720) at sql_parse.cc:2184 #19 0x00000000005ed343 in Prepared_statement::execute (this=0xa2cc1d0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #20 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa2cc1d0, expanded_query=0x473c15e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #21 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc024720, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #22 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc024720, packet=0x7fbdbc0278c1 "\v", packet_length=17) at sql_parse.cc:1155 #23 0x000000000058a19c in do_command (thd=0x7fbdbc024720) at sql_parse.cc:857 #24 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #25 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #26 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #27 0x0000000000000000 in ?? () Thread 46 (Thread 0x47403950 (LWP 30610)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0c60, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=5) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd1620, file_name=0x8c5f16 "buf/buf0lru.c", line=1448) at sync/sync0sync.c:570 #4 0x00000000006e3b50 in mutex_enter_func (mutex=0xbd1620, file_name=0x8c5f16 "buf/buf0lru.c", line=1448) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006e6ab6 in buf_LRU_free_block (bpage=0x7fbdc50a12a0, zip=1, buf_pool_mutex_released=0x0, have_LRU_mutex=0) at buf/buf0lru.c:1448 #6 0x00000000006e7c0f in buf_LRU_search_and_free_block (n_iterations=) at buf/buf0lru.c:616 #7 0x00000000006e7e43 in buf_LRU_try_free_flushed_blocks () at buf/buf0lru.c:711 #8 0x00000000006cc660 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd4c0536c0, mode=4, latch_mode=2, cursor=0x47400790, has_search_latch=0, mtr=0x47400cd0) at ../../storage/innobase/include/ibuf0ibuf.ic:96 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd4c0536c0, n_ext=0, thr=0x7fbd4c052180) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd4c0536c0, n_ext=0, foreign=, thr=0x7fbd4c052180) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd4c052180) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd4c04c770 "\211?\v", prebuilt=0x7fbd4c04f290) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd4c04c580, record=0x7fbd4c04c770 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd4c04c580, buf=0x7fbd4c04c770 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc02ba00, table=0x7fbd4c04fc50, info=0x474014a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc02ba00, table_list=0xa23d6e0, fields=@0xa23cf58, values_list=@0xa23cfa0, update_fields=@0xa23cf88, update_values=@0xa23cf70, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc02ba00) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0xa1ba260, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1ba260, expanded_query=0x474025e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc02ba00, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 ---Type to continue, or q to quit--- #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc02ba00, packet=0x7fbdbc02eba1 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc02ba00) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 45 (Thread 0x47444950 (LWP 30621)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce41b0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=55) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8aba9cc0, file_name=0x8d97e3 "trx/trx0roll.c", line=927) at sync/sync0sync.c:570 #4 0x0000000000776f71 in trx_roll_pop_top_rec_of_trx (trx=0x7fbe8ac968b8, limit={high = 0, low = 0}, roll_ptr=0x47443220, heap=0x7fbd4804df90) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x000000000075d33f in row_undo_step (thr=0x7fbd480448d8) at row/row0undo.c:234 #6 0x0000000000740f9d in que_run_threads (thr=0x7fbd480448d8) at que/que0que.c:1255 #7 0x0000000000776244 in trx_general_rollback_for_mysql (trx=0x7fbe8ac968b8, partial=, savept=0x7fbe8ac96bd0) at trx/trx0roll.c:82 #8 0x000000000077650d in trx_rollback_last_sql_stat_for_mysql (trx=0x9ce41ec) at trx/trx0roll.c:163 #9 0x00000000006c259d in innobase_rollback (hton=, thd=0x7fbdbc032ce0, all=false) at handler/ha_innodb.cc:2460 #10 0x000000000063ea02 in ha_rollback_trans (thd=0x7fbdbc032ce0, all=false) at handler.cc:1269 #11 0x000000000063f752 in ha_autocommit_or_rollback (thd=0x9ce41ec, error=1) at handler.cc:1338 #12 0x00000000005b439a in close_thread_tables (thd=0x7fbdbc032ce0) at sql_base.cc:1255 #13 0x00000000005eaf29 in Prepared_statement::cleanup_stmt (this=0x9f24de0) at sql_prepare.cc:2914 #14 0x00000000005ed391 in Prepared_statement::execute (this=0x9f24de0, expanded_query=, open_cursor=false) at sql_prepare.cc:3589 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x9f24de0, expanded_query=0x474435e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc032ce0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc032ce0, packet=0x7fbdbc035e81 "\002", packet_length=23) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc032ce0) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 44 (Thread 0x47485950 (LWP 30624)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=16) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8ac27cb8, info=0x7fbe8ac27ec0, tuple=0x7fbd5c06a7f0, mode=2, latch_mode=1, cursor=0x7fbd5c060f80, has_search_latch=1, mtr=0x474823f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbd5c06a7f0, mode=2, latch_mode=1, cursor=0x7fbd5c060f80, has_search_latch=1, mtr=0x474823f0) at btr/btr0cur.c:370 #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbd5c066b80 "", mode=2, prebuilt=0x7fbd5c065bb0, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd5c066990, buf=0x7fbd5c066b80 "", key_ptr=, key_len=4, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd5c066990, buf=0x7fbd5c066b80 "", key=0x9d51d08 "\002?", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 ---Type to continue, or q to quit--- #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd5c066990, buf=0x7fbd5c066b80 "", index=, key=0x9d51d08 "\002?", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9d51850) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9d51850, pos=0x9d50028) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9d4ff90, tables=, conds=0x9d51700, keyuse_array=0x9d51550) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9d4ff90) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc039fc0, rref_pointer_array=0x7fbdac031270, tables=0x7fbdac031f10, wild_num=0, fields=@0x7fbdac031100, conds=0x7fbdac032820, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbdac032998, unit=0x7fbdac030c70, select_lex=0x7fbdac0310a0) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc039fc0, lex=0x7fbdac030bd0, result=0x7fbdac032998, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc039fc0, all_tables=0x7fbdac031f10) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc039fc0) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdac02b4e0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdac02b4e0, expanded_query=0x474845e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc039fc0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc039fc0, packet=0x7fbdbc03d161 "\006", packet_length=17) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc039fc0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 43 (Thread 0x474c6950 (LWP 30625)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x2499f40, reset_sig_count=) at os/os0sync.c:422 #2 0x000000000072ad3a in os_aio_wait_until_no_pending_writes () at os/os0file.c:3041 #3 0x00000000006e1b32 in buf_flush_buffered_writes () at buf/buf0flu.c:528 #4 0x00000000006e3309 in buf_flush_batch (flush_type=, min_n=185, lsn_limit=0) at buf/buf0flu.c:1195 #5 0x00000000006e35f1 in buf_flush_free_margin (wait=0) at buf/buf0flu.c:1310 #6 0x00000000006e8c90 in buf_read_page (space=28, zip_size=, offset=28805) at buf/buf0rea.c:368 #7 0x00000000006dda77 in buf_page_get_gen (space=28, zip_size=0, offset=28805, rw_latch=1, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x474bfeb0) at buf/buf0buf.c:1933 #8 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abbe0b8, level=0, tuple=0x7fbd740968f0, mode=2, latch_mode=1, cursor=0x474bfe30, has_search_latch=0, mtr=0x474bfeb0) at btr/btr0cur.c:465 #9 0x00000000006ce21f in btr_estimate_n_rows_in_range (index=0x7fbe8abbe0b8, tuple1=, mode1=, tuple2=0x7fbd74096980, mode2=1) at btr/btr0cur.c:3028 #10 0x00000000006c1ced in ha_innobase::records_in_range (this=0x7fbdbc2474f0, keynr=, min_key=0x474c0480, max_key=0x474c0460) at handler/ha_innodb.cc:6705 #11 0x000000000062dadb in check_quick_keys (param=0x474c0a50, idx=, key_tree=0x7fbd7409ab88, min_key=0x474c0dc3 "", min_key_flag=0, min_keypart=1, max_key=0x474c1cc1 "", max_key_flag=0, max_keypart=1) at opt_range.cc:7538 #12 0x000000000062d71c in check_quick_keys (param=0x474c0a50, idx=1, key_tree=0x7fbd7409a8c8, min_key=, min_key_flag=0, min_keypart=0, max_key=, max_key_flag=0, max_keypart=0) at opt_range.cc:7444 #13 0x000000000062d71c in check_quick_keys (param=0x474c0a50, idx=1, key_tree=0x7fbd7409a5b0, min_key=, min_key_flag=0, min_keypart=-1, max_key=, max_key_flag=0, max_keypart=-1) at opt_range.cc:7444 #14 0x000000000062dce1 in check_quick_select (param=0x474c0a50, idx=1, tree=0x7fbd7409a5b0, update_tbl_stats=true) at opt_range.cc:7313 #15 0x000000000062deaf in get_key_scans_params (param=0x474c0a50, tree=0x7fbd7409a2f8, index_read_must_be_used=false, update_tbl_stats=, read_time=1238.2531536557065) at opt_range.cc:4848 #16 0x0000000000635929 in SQL_SELECT::test_quick_select (this=0x7fbd74098570, thd=0x7fbdbc0412a0, keys_to_use=, prev_tables=, limit=, ---Type to continue, or q to quit--- force_quick_range=) at opt_range.cc:2374 #17 0x00000000005d7d67 in make_join_statistics (join=0x9d53100, tables=, conds=, keyuse_array=0x9d546c0) at sql_select.cc:2409 #18 0x00000000005d8d92 in JOIN::optimize (this=0x9d53100) at sql_select.cc:945 #19 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc0412a0, rref_pointer_array=0xa3e4ea0, tables=0xa3e5a98, wild_num=0, fields=@0xa3e4d00, conds=0x9d52f50, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xa3e74e0, unit=0xa3e48a0, select_lex=0xa3e4cd0) at sql_select.cc:2347 #20 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc0412a0, lex=0xa3e4800, result=0xa3e74e0, setup_tables_done_option=0) at sql_select.cc:269 #21 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc0412a0, all_tables=0xa3e5a98) at sql_parse.cc:4888 #22 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc0412a0) at sql_parse.cc:2184 #23 0x00000000005ed343 in Prepared_statement::execute (this=0xa2d5690, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #24 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa2d5690, expanded_query=0x474c55e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #25 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0412a0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #26 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0412a0, packet=0x7fbdbc044441 "\016", packet_length=37) at sql_parse.cc:1155 #27 0x000000000058a19c in do_command (thd=0x7fbdbc0412a0) at sql_parse.cc:857 #28 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #29 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #30 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #31 0x0000000000000000 in ?? () Thread 42 (Thread 0x47507950 (LWP 30627)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=19) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8abd90b8, info=0x7fbe8abda0b8, tuple=0x7fbdb00ee9c0, mode=2, latch_mode=1, cursor=0x7fbdb00e5d40, has_search_latch=1, mtr=0x475043f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbdb00ee9c0, mode=2, latch_mode=1, cursor=0x7fbdb00e5d40, has_search_latch=1, mtr=0x475043f0) at btr/btr0cur.c:370 #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbdb00e50f0 "", mode=2, prebuilt=0x7fbdb00e6fc0, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbdb00e4d00, buf=0x7fbdb00e50f0 "", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbdb00e4d00, buf=0x7fbdb00e50f0 "", key=0x9d5bf38 "4", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbdb00e4d00, buf=0x7fbdb00e50f0 "", index=, key=0x9d5bf38 "4", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9d5baf8) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9d5baf8, pos=0x9d5a1e8) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9d5a150, tables=, conds=0x9d59fa0, keyuse_array=0x9d5b710) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9d5a150) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc048580, rref_pointer_array=0x7fbd7c048f80, tables=0x7fbd7c049ae8, wild_num=0, fields=@0x7fbd7c048e00, conds=0x9d59fa0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbd7c04a8b8, unit=0x7fbd7c048980, select_lex=0x7fbd7c048db0) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc048580, lex=0x7fbd7c0488e0, result=0x7fbd7c04a8b8, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc048580, all_tables=0x7fbd7c049ae8) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc048580) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd7c020780, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 ---Type to continue, or q to quit--- #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd7c020780, expanded_query=0x475065e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc048580, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc048580, packet=0x7fbdbc04b721 "#", packet_length=29) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc048580) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 41 (Thread 0x47548950 (LWP 30638)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=48) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=147457, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x47544280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbd500688d0, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=155112, thr=0x7fbd500662c0) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbd500688d0, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=155112, thr=0x7fbd500662c0) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd500688d0, mode=4, latch_mode=2, cursor=0x47545790, has_search_latch=0, mtr=0x47545cd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd500688d0, n_ext=0, thr=0x7fbd500662c0) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd500688d0, n_ext=0, foreign=, thr=0x7fbd500662c0) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd500662c0) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd5005a4e0 "\211?\v", prebuilt=0x7fbd50067e90) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd5005a2f0, record=0x7fbd5005a4e0 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd5005a2f0, buf=0x7fbd5005a4e0 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc04f860, table=0x7fbd50067180, info=0x475464a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc04f860, table_list=0x7fbd9801f2a0, fields=@0x7fbd9801eb18, values_list=@0x7fbd9801eb60, update_fields=@0x7fbd9801eb48, update_values=@0x7fbd9801eb30, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc04f860) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd9800e290, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd9800e290, expanded_query=0x475475e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc04f860, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc04f860, packet=0x7fbdbc052a01 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc04f860) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () ---Type to continue, or q to quit--- Thread 40 (Thread 0x47589950 (LWP 30640)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=36) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=27, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x47583a20) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abd94b8, level=0, tuple=0x7fbd6c08f780, mode=2, latch_mode=1, cursor=0x475839a0, has_search_latch=0, mtr=0x47583a20) at btr/btr0cur.c:465 #6 0x00000000006ce21f in btr_estimate_n_rows_in_range (index=0x7fbe8abd94b8, tuple1=, mode1=, tuple2=0x7fbd6c08f7c8, mode2=1) at btr/btr0cur.c:3028 #7 0x00000000006c1ced in ha_innobase::records_in_range (this=0x7fbd4c05cef0, keynr=, min_key=0x47583ff0, max_key=0x47583fd0) at handler/ha_innodb.cc:6705 #8 0x000000000062dadb in check_quick_keys (param=0x475843c0, idx=, key_tree=0x7fbd6c0945f0, min_key=0x47584730 "?_\001", min_key_flag=0, min_keypart=-1, max_key=0x4758562e "?_\001", max_key_flag=0, max_keypart=-1) at opt_range.cc:7538 #9 0x000000000062dce1 in check_quick_select (param=0x475843c0, idx=1, tree=0x7fbd6c0945f0, update_tbl_stats=true) at opt_range.cc:7313 #10 0x000000000062deaf in get_key_scans_params (param=0x475843c0, tree=0x7fbd6c094338, index_read_must_be_used=false, update_tbl_stats=, read_time=1.21) at opt_range.cc:4848 #11 0x0000000000635929 in SQL_SELECT::test_quick_select (this=0x9d3ef58, thd=0x7fbdbc056b40, keys_to_use=, prev_tables=, limit=, force_quick_range=) at opt_range.cc:2374 #12 0x00000000005f2c45 in mysql_update (thd=0x7fbdbc056b40, table_list=0x7fbda0042570, fields=@0x7fbda0041af8, values=@0x7fbda0041ed0, conds=0x9d3ee30, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at opt_range.h:709 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc056b40) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbda0004b80, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbda0004b80, expanded_query=0x475885e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc056b40, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc056b40, packet=0x7fbdbc059ce1 "\b", packet_length=29) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc056b40) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 39 (Thread 0x475ca950 (LWP 30642)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=7) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at sync/sync0sync.c:570 #4 0x0000000000729064 in mutex_enter_func (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x0000000000729183 in mtr_commit (mtr=0x475c6760) at ../../storage/innobase/include/log0log.ic:306 #6 0x0000000000774f94 in trx_undo_report_row_operation (flags=, op_type=1, thr=, index=0x7fbe8abd40b8, clust_entry=0x7fbd60066810, update=0x0, cmpl_info=0, rec=0x0, roll_ptr=0x475c7080) at trx/trx0rec.c:1259 #7 0x00000000006d0b1a in btr_cur_optimistic_insert (flags=0, cursor=0x475c7790, entry=0x7fbd60066810, rec=0x475c7828, big_rec=0x475c7820, n_ext=0, thr=0x7fbd60065e50, mtr=0x475c7cd0) at btr/btr0cur.c:936 #8 0x0000000000748ec4 in row_ins_index_entry_low (mode=2, index=0x7fbe8abd40b8, entry=0x7fbd60066810, n_ext=0, thr=0x7fbd60065e50) at row/row0ins.c:2114 #9 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd40b8, entry=0x7fbd60066810, n_ext=0, foreign=, ---Type to continue, or q to quit--- thr=0x7fbd60065e50) at row/row0ins.c:2194 #10 0x0000000000749961 in row_ins_step (thr=0x7fbd60065e50) at row/row0ins.c:2279 #11 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd60060da0 "\211?\v", prebuilt=0x7fbd60067a20) at row/row0mysql.c:1120 #12 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd60060bb0, record=0x7fbd60060da0 "\211?\v") at handler/ha_innodb.cc:4218 #13 0x000000000064088d in handler::ha_write_row (this=0x7fbd60060bb0, buf=0x7fbd60060da0 "\211?\v") at handler.cc:4570 #14 0x00000000005e4035 in write_record (thd=0x7fbdbc05de20, table=0x7fbd60066d10, info=0x475c84a0) at sql_insert.cc:1568 #15 0x00000000005e797c in mysql_insert (thd=0x7fbdbc05de20, table_list=0xa2a77c0, fields=@0xa2a7038, values_list=@0xa2a7080, update_fields=@0xa2a7068, update_values=@0xa2a7050, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #16 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc05de20) at sql_parse.cc:3066 #17 0x00000000005ed343 in Prepared_statement::execute (this=0xa1b1a00, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #18 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1b1a00, expanded_query=0x475c95e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #19 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc05de20, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #20 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc05de20, packet=0x7fbdbc060fc1 "\t", packet_length=87) at sql_parse.cc:1155 #21 0x000000000058a19c in do_command (thd=0x7fbdbc05de20) at sql_parse.cc:857 #22 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #23 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #24 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #25 0x0000000000000000 in ?? () Thread 38 (Thread 0x4760b950 (LWP 30646)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=2) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8abd90b8, info=0x7fbe8abda0b8, tuple=0x7fbd54065860, mode=2, latch_mode=1, cursor=0x7fbd54065560, has_search_latch=0, mtr=0x476083f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbd54065860, mode=2, latch_mode=1, cursor=0x7fbd54065560, has_search_latch=0, mtr=0x476083f0) at btr/btr0cur.c:370 #6 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd54059160 "", mode=2, prebuilt=0x7fbd54065290, match_mode=1, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd54041950, buf=0x7fbd54059160 "", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd54041950, buf=0x7fbd54059160 "", key=0x7fbdb80068c0 "\022", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd54041950, buf=0x7fbd54059160 "", index=, key=0x7fbdb80068c0 "\022", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x7fbdb8006480) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x7fbdb8006480, pos=0x7fbdb8004b78) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x7fbdb8004ae0, tables=, conds=0x7fbdb8004940, keyuse_array=0x7fbdb80060a0) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x7fbdb8004ae0) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc065100, rref_pointer_array=0x7fbda00217d0, tables=0x7fbda0023150, wild_num=0, fields=@0x7fbda0021700, conds=0x7fbdb8004940, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbda00241f0, unit=0x7fbda00211d0, select_lex=0x7fbda0021600) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc065100, lex=0x7fbda0021130, result=0x7fbda00241f0, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc065100, all_tables=0x7fbda0023150) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc065100) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbda0000f80, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 ---Type to continue, or q to quit--- #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbda0000f80, expanded_query=0x4760a5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc065100, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc065100, packet=0x7fbdbc0682a1 "\a", packet_length=23) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc065100) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 37 (Thread 0x4764c950 (LWP 30651)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=24) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd48049000, mode=4, latch_mode=2, cursor=0x47649790, has_search_latch=0, mtr=0x47649cd0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd40b8, entry=0x7fbd48049000, n_ext=0, thr=0x7fbd48048640) at row/row0ins.c:2025 #6 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd40b8, entry=0x7fbd48049000, n_ext=0, foreign=, thr=0x7fbd48048640) at row/row0ins.c:2194 #7 0x0000000000749961 in row_ins_step (thr=0x7fbd48048640) at row/row0ins.c:2279 #8 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd4804a780 "\211?\v", prebuilt=0x7fbd4804b1e0) at row/row0mysql.c:1120 #9 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd4804a590, record=0x7fbd4804a780 "\211?\v") at handler/ha_innodb.cc:4218 #10 0x000000000064088d in handler::ha_write_row (this=0x7fbd4804a590, buf=0x7fbd4804a780 "\211?\v") at handler.cc:4570 #11 0x00000000005e4035 in write_record (thd=0x7fbdbc06c3e0, table=0x7fbd48049cf0, info=0x4764a4a0) at sql_insert.cc:1568 #12 0x00000000005e797c in mysql_insert (thd=0x7fbdbc06c3e0, table_list=0x7fbdac078df0, fields=@0x7fbdac078668, values_list=@0x7fbdac0786b0, update_fields=@0x7fbdac078698, update_values=@0x7fbdac078680, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #13 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc06c3e0) at sql_parse.cc:3066 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdac067e30, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdac067e30, expanded_query=0x4764b5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc06c3e0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc06c3e0, packet=0x7fbdbc06f581 "\t", packet_length=87) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc06c3e0) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 36 (Thread 0x4768d950 (LWP 30653)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0d00, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=6) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd18a0, file_name=0x8c33f8 "../../storage/innobase/include/buf0buf.ic", line=1051) at sync/sync0sync.c:570 #4 0x000000000072941d in mtr_commit (mtr=0x4768aca0) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x000000000075dcd4 in row_upd_clust_rec (node=0x7fbd9c0a4430, index=0x7fbe8abd70b8, thr=0x7fbd9c0a4830, mtr=0x4768aca0) ---Type to continue, or q to quit--- at row/row0upd.c:1682 #6 0x000000000076080a in row_upd_clust_step (node=0x7fbd9c0a4430, thr=0x7fbd9c0a4830) at row/row0upd.c:1921 #7 0x0000000000760dc4 in row_upd_step (thr=0x7fbd9c0a4830) at row/row0upd.c:1998 #8 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd6407fba0) at row/row0mysql.c:1367 #9 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd64084810, old_row=0x7fbd9c0a4558 "\n", new_row=0x7fbd64084a00 "") at handler/ha_innodb.cc:4508 #10 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd64084810, old_data=0x7fbd64084a68 "", new_data=0x7fbd64084a00 "") at handler.cc:4591 #11 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc0736c0, table_list=0x7fbd9803b130, fields=@0x7fbd9803a6b8, values=@0x7fbd9803aa90, conds=0x7fbd9803bd78, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #12 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0736c0) at sql_parse.cc:2959 #13 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd9800ecb0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #14 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd9800ecb0, expanded_query=0x4768c5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #15 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0736c0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #16 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0736c0, packet=0x7fbdbc076861 "\n", packet_length=23) at sql_parse.cc:1155 #17 0x000000000058a19c in do_command (thd=0x7fbdbc0736c0) at sql_parse.cc:857 #18 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #19 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #20 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #21 0x0000000000000000 in ?? () Thread 35 (Thread 0x476ce950 (LWP 30654)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=8) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at sync/sync0sync.c:570 #4 0x0000000000729064 in mutex_enter_func (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x0000000000729183 in mtr_commit (mtr=0x476cbca0) at ../../storage/innobase/include/log0log.ic:306 #6 0x000000000075dcd4 in row_upd_clust_rec (node=0x7fbd5405cb18, index=0x7fbe8abd90b8, thr=0x7fbd5405d058, mtr=0x476cbca0) at row/row0upd.c:1682 #7 0x000000000076080a in row_upd_clust_step (node=0x7fbd5405cb18, thr=0x7fbd5405d058) at row/row0upd.c:1921 #8 0x0000000000760dc4 in row_upd_step (thr=0x7fbd5405d058) at row/row0upd.c:1998 #9 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd5405ea60) at row/row0mysql.c:1367 #10 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd540575a0, old_row=0x7fbd5405ddc8 "p=\205", new_row=0x7fbd540561f0 "") at handler/ha_innodb.cc:4508 #11 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd540575a0, old_data=0x7fbd54056328 "", new_data=0x7fbd540561f0 "") at handler.cc:4591 #12 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc07a9a0, table_list=0x7fbd980191d0, fields=@0x7fbd98018758, values=@0x7fbd98018b30, conds=0x9d98830, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc07a9a0) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd9800df30, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd9800df30, expanded_query=0x476cd5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc07a9a0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc07a9a0, packet=0x7fbdbc07db41 "\b", packet_length=29) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc07a9a0) at sql_parse.cc:857 ---Type to continue, or q to quit--- #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 34 (Thread 0x4770f950 (LWP 30655)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=47) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=131073, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x4770b280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbd6407ba30, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=132726, thr=0x7fbd940a2e50) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbd6407ba30, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=132726, thr=0x7fbd940a2e50) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd6407ba30, mode=4, latch_mode=2, cursor=0x4770c790, has_search_latch=0, mtr=0x4770ccd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd6407ba30, n_ext=0, thr=0x7fbd940a2e50) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd6407ba30, n_ext=0, foreign=, thr=0x7fbd940a2e50) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd940a2e50) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd940a0b60 "\211?\v", prebuilt=0x7fbd940a19b0) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd940a0970, record=0x7fbd940a0b60 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd940a0970, buf=0x7fbd940a0b60 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc081c80, table=0x7fbd940a00d0, info=0x4770d4a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc081c80, table_list=0x7fbda0018240, fields=@0x7fbda0017ab8, values_list=@0x7fbda0017b00, update_fields=@0x7fbda0017ae8, update_values=@0x7fbda0017ad0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc081c80) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbda00008c0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbda00008c0, expanded_query=0x4770e5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc081c80, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc081c80, packet=0x7fbdbc084e21 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc081c80) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 33 (Thread 0x47750950 (LWP 30656)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=23) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd54032370, mode=4, latch_mode=1, ---Type to continue, or q to quit--- cursor=0x7fbd900678c0, has_search_latch=0, mtr=0x4774dd90) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=1, cursor=0x7fbd900678c0, mtr=0x4774dd90) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075886d in sel_restore_position_for_mysql (same_user_rec=0x4774dd80, latch_mode=140452745555388, pcur=0x7fbd900678c0, moves_up=18446744073709551615, mtr=0x7fbdb401ad80) at row/row0sel.c:3117 #7 0x00000000007592cd in row_search_for_mysql (buf=0x7fbd90091080 "\201M\b", mode=2, prebuilt=0x7fbd90005a40, match_mode=1, direction=1) at row/row0sel.c:3741 #8 0x00000000006c0a57 in ha_innobase::general_fetch (this=0x7fbd90090e90, buf=0x7fbd90091080 "\201M\b", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5118 #9 0x00000000006c0c10 in ha_innobase::index_next_same (this=0x7fbd90090e90, buf=0x7fbd90091080 "\201M\b", key=, keylen=) at handler/ha_innodb.cc:5176 #10 0x000000000063d2a3 in handler::read_range_next (this=0x7fbdb401adbc) at handler.cc:4186 #11 0x000000000063c842 in handler::read_multi_range_next (this=0x7fbdb401adbc, found_range_p=0x4774e318) at handler.cc:4071 #12 0x00000000006262b1 in QUICK_RANGE_SELECT::get_next (this=0x7fbd54066230) at opt_range.cc:8400 #13 0x0000000000638ec8 in rr_quick (info=0x4774e3d0) at records.cc:313 #14 0x00000000005f353c in mysql_update (thd=0x7fbdbc088f60, table_list=0xabdaae8, fields=@0xabda028, values=@0xabda400, conds=0x7fbdb8019c10, order_num=, order=0x0, limit=18446744073709551601, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:571 #15 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc088f60) at sql_parse.cc:2959 #16 0x00000000005ed343 in Prepared_statement::execute (this=0xabd96e0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #17 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xabd96e0, expanded_query=0x4774f5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #18 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc088f60, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #19 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc088f60, packet=0x7fbdbc08c101 "\036", packet_length=51) at sql_parse.cc:1155 #20 0x000000000058a19c in do_command (thd=0x7fbdbc088f60) at sql_parse.cc:857 #21 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #22 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #23 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #24 0x0000000000000000 in ?? () Thread 32 (Thread 0x47791950 (LWP 30657)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=43) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=32769, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x4778d280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbdbc2467e0, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=41746, thr=0x7fbdbc244320) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbdbc2467e0, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=41746, thr=0x7fbdbc244320) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbdbc2467e0, mode=4, latch_mode=2, cursor=0x4778e790, has_search_latch=0, mtr=0x4778ecd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbdbc2467e0, n_ext=0, thr=0x7fbdbc244320) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbdbc2467e0, n_ext=0, foreign=, thr=0x7fbdbc244320) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbdbc244320) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbdbc242330 "\211?\v", prebuilt=0x7fbdbc245c20) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbdbc242140, record=0x7fbdbc242330 "\211?\v") ---Type to continue, or q to quit--- at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbdbc242140, buf=0x7fbdbc242330 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc090240, table=0x7fbdbc245300, info=0x4778f4a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc090240, table_list=0x7fbda00566c0, fields=@0x7fbda0055f38, values_list=@0x7fbda0055f80, update_fields=@0x7fbda0055f68, update_values=@0x7fbda0055f50, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc090240) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbda0009bd0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbda0009bd0, expanded_query=0x477905e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc090240, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc090240, packet=0x7fbdbc0933e1 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc090240) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 31 (Thread 0x477d2950 (LWP 30658)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=41) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=29, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x477cfcd0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abc14b8, level=0, tuple=0x7fbd60062610, mode=2, latch_mode=1, cursor=0x477cfbe0, has_search_latch=0, mtr=0x477cfcd0) at btr/btr0cur.c:465 #6 0x0000000000746a3d in row_ins_check_foreign_constraint (check_ref=1, foreign=0x7fbe8abc3eb8, table=0x7fbe8abc38b8, entry=0x7fbd60062610, thr=0x7fbd60061c50) at ../../storage/innobase/include/btr0pcur.ic:502 #7 0x00000000007493c1 in row_ins_index_entry (index=0x7fbe8abd40b8, entry=0x7fbd60062610, n_ext=0, foreign=, thr=0x7fbd60061c50) at row/row0ins.c:1569 #8 0x0000000000749961 in row_ins_step (thr=0x7fbd60061c50) at row/row0ins.c:2279 #9 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd600635a0 "\211?\v", prebuilt=0x7fbd6005e170) at row/row0mysql.c:1120 #10 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd600633b0, record=0x7fbd600635a0 "\211?\v") at handler/ha_innodb.cc:4218 #11 0x000000000064088d in handler::ha_write_row (this=0x7fbd600633b0, buf=0x7fbd600635a0 "\211?\v") at handler.cc:4570 #12 0x00000000005e4035 in write_record (thd=0x7fbdbc097520, table=0x7fbd60062b10, info=0x477d04a0) at sql_insert.cc:1568 #13 0x00000000005e797c in mysql_insert (thd=0x7fbdbc097520, table_list=0x7fbdb004c140, fields=@0x7fbdb004b9b8, values_list=@0x7fbdb004ba00, update_fields=@0x7fbdb004b9e8, update_values=@0x7fbdb004b9d0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #14 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc097520) at sql_parse.cc:3066 #15 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdb001ead0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdb001ead0, expanded_query=0x477d15e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc097520, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc097520, packet=0x7fbdbc09a6c1 "\t", packet_length=87) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc097520) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 ---Type to continue, or q to quit--- #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 30 (Thread 0x47813950 (LWP 30659)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=49) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=163841, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x4780f280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbdb415dc70, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=168387, thr=0x7fbdb415a9d0) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbdb415dc70, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=168387, thr=0x7fbdb415a9d0) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbdb415dc70, mode=4, latch_mode=2, cursor=0x47810790, has_search_latch=0, mtr=0x47810cd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbdb415dc70, n_ext=0, thr=0x7fbdb415a9d0) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbdb415dc70, n_ext=0, foreign=, thr=0x7fbdb415a9d0) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbdb415a9d0) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbdb415c950 "\211?\v", prebuilt=0x7fbdb415d3b0) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbdb415c760, record=0x7fbdb415c950 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbdb415c760, buf=0x7fbdb415c950 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc09e800, table=0x7fbdb415bec0, info=0x478114a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc09e800, table_list=0x7fbda005c720, fields=@0x7fbda005bf98, values_list=@0x7fbda005bfe0, update_fields=@0x7fbda005bfc8, update_values=@0x7fbda005bfb0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc09e800) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbda000a5f0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbda000a5f0, expanded_query=0x478125e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc09e800, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc09e800, packet=0x7fbdbc0a19a1 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc09e800) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 29 (Thread 0x47854950 (LWP 30660)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=38) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd9c09a790, mode=2, latch_mode=1, cursor=0x7fbd9c093d20, has_search_latch=0, mtr=0x47851d60) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd9c095c60 "?", mode=2, prebuilt=0x7fbd9c099770, match_mode=1, ---Type to continue, or q to quit--- direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd9c095a70, buf=0x7fbd9c095c60 "?", key_ptr=, key_len=7, find_flag=) at handler/ha_innodb.cc:4933 #7 0x0000000000641f8e in handler::index_read_map (this=0x7fbd9c095a70, buf=0x7fbd9c095c60 "?", key=0x7fbd6806fdd8 "b", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #8 0x000000000063d3c4 in handler::read_range_first (this=0x7fbd9c095a70, start_key=, end_key=, eq_range_arg=, sorted=) at handler.cc:4155 #9 0x000000000063d4a4 in handler::read_multi_range_first (this=0x7fbd9c095a70, found_range_p=0x47852318, ranges=, range_count=, sorted=, buffer=) at handler.cc:4029 #10 0x000000000062641d in QUICK_RANGE_SELECT::get_next (this=0x7fbd68067cf0) at opt_range.cc:8444 #11 0x0000000000638ec8 in rr_quick (info=0x478523d0) at records.cc:313 #12 0x00000000005f353c in mysql_update (thd=0x7fbdbc0a5ae0, table_list=0x7fbdb00c3ae8, fields=@0x7fbdb00c3028, values=@0x7fbdb00c3400, conds=0x9edcb70, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:571 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0a5ae0) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdb00b3480, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdb00b3480, expanded_query=0x478535e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0a5ae0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0a5ae0, packet=0x7fbdbc0a8c81 "\036", packet_length=51) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc0a5ae0) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 28 (Thread 0x47895950 (LWP 30661)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=37) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=65537, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x47891280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbd58067250, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=77717, thr=0x7fbd58066890) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbd58067250, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=77717, thr=0x7fbd58066890) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd58067250, mode=4, latch_mode=2, cursor=0x47892790, has_search_latch=0, mtr=0x47892cd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd58067250, n_ext=0, thr=0x7fbd58066890) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd58067250, n_ext=0, foreign=, thr=0x7fbd58066890) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd58066890) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd58063b90 "\211?\v", prebuilt=0x7fbd580645f0) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd580639a0, record=0x7fbd58063b90 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd580639a0, buf=0x7fbd58063b90 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc0acdc0, table=0x7fbd58063100, info=0x478934a0) at sql_insert.cc:1568 ---Type to continue, or q to quit--- #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc0acdc0, table_list=0xa331620, fields=@0xa330e98, values_list=@0xa330ee0, update_fields=@0xa330ec8, update_values=@0xa330eb0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc0acdc0) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0xa05efc0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa05efc0, expanded_query=0x478945e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0acdc0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0acdc0, packet=0x7fbdbc0aff61 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc0acdc0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 27 (Thread 0x478d6950 (LWP 30662)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=32) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=27, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x478d0a20) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abd94b8, level=0, tuple=0x7fbd8c08ea70, mode=2, latch_mode=1, cursor=0x478d09a0, has_search_latch=0, mtr=0x478d0a20) at btr/btr0cur.c:465 #6 0x00000000006ce21f in btr_estimate_n_rows_in_range (index=0x7fbe8abd94b8, tuple1=, mode1=, tuple2=0x7fbd8c08eab8, mode2=1) at btr/btr0cur.c:3028 #7 0x00000000006c1ced in ha_innobase::records_in_range (this=0x7fbdb415e130, keynr=, min_key=0x478d0ff0, max_key=0x478d0fd0) at handler/ha_innodb.cc:6705 #8 0x000000000062dadb in check_quick_keys (param=0x478d13c0, idx=, key_tree=0x7fbd8c0931d0, min_key=0x478d1730 "?", min_key_flag=0, min_keypart=-1, max_key=0x478d262e "?", max_key_flag=0, max_keypart=-1) at opt_range.cc:7538 #9 0x000000000062dce1 in check_quick_select (param=0x478d13c0, idx=1, tree=0x7fbd8c0931d0, update_tbl_stats=true) at opt_range.cc:7313 #10 0x000000000062deaf in get_key_scans_params (param=0x478d13c0, tree=0x7fbd8c092f18, index_read_must_be_used=false, update_tbl_stats=, read_time=1.21) at opt_range.cc:4848 #11 0x0000000000635929 in SQL_SELECT::test_quick_select (this=0xa0239a8, thd=0x7fbdbc0b40a0, keys_to_use=, prev_tables=, limit=, force_quick_range=) at opt_range.cc:2374 #12 0x00000000005f2c45 in mysql_update (thd=0x7fbdbc0b40a0, table_list=0xa40d8c0, fields=@0xa40ce48, values=@0xa40d220, conds=0xa023880, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at opt_range.h:709 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0b40a0) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x9e6b7c0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x9e6b7c0, expanded_query=0x478d55e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0b40a0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0b40a0, packet=0x7fbdbc0b7241 "\b", packet_length=29) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc0b40a0) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () ---Type to continue, or q to quit--- Thread 26 (Thread 0x47917950 (LWP 30663)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=39) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=0, zip_size=0, offset=2819, rw_latch=2, guess=0x0, mode=10, file=0x8d94b4 "trx/trx0rec.c", line=1233, mtr=0x479135d0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x0000000000772da5 in trx_undo_report_row_operation (flags=, op_type=2, thr=, index=0x7fbe8abd40b8, clust_entry=0x0, update=0x7fbd80097dd0, cmpl_info=1, rec=0x7fbe070c0ced "\200P\207\200", roll_ptr=0x479141f0) at trx/trx0rec.c:1230 #6 0x00000000006c9206 in btr_cur_upd_lock_and_undo (flags=2, cursor=0x7fbd80091b00, update=0x7fbd80097dd0, cmpl_info=1, thr=0x7fbd800980e8, roll_ptr=0x479141f0) at btr/btr0cur.c:1454 #7 0x00000000006d1718 in btr_cur_pessimistic_update (flags=2, cursor=0x7fbd80091b00, heap=0x479145a8, big_rec=0x479145a0, update=0x7fbd80097dd0, cmpl_info=1, thr=0x7fbd800980e8, mtr=0x47914ca0) at btr/btr0cur.c:2091 #8 0x000000000075dda1 in row_upd_clust_rec (node=0x7fbd80097cc0, index=0x7fbe8abd40b8, thr=0x7fbd800980e8, mtr=0x47914ca0) at row/row0upd.c:1709 #9 0x000000000076080a in row_upd_clust_step (node=0x7fbd80097cc0, thr=0x7fbd800980e8) at row/row0upd.c:1921 #10 0x0000000000760dc4 in row_upd_step (thr=0x7fbd800980e8) at row/row0upd.c:1998 #11 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd8009a410) at row/row0mysql.c:1367 #12 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd80087640, old_row=0x7fbd8008f030 "PE\205", new_row=0x7fbd80087830 "\201I\b") at handler/ha_innodb.cc:4508 #13 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd80087640, old_data=0x7fbd80087868 "\211I\b", new_data=0x7fbd80087830 "\201I\b") at handler.cc:4591 #14 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc0bb380, table_list=0x7fbd5c0417a8, fields=@0x7fbd5c040ce8, values=@0x7fbd5c0410c0, conds=0x7fbdb8020ca0, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #15 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0bb380) at sql_parse.cc:2959 #16 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd5c026330, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #17 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd5c026330, expanded_query=0x479165e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #18 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0bb380, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #19 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0bb380, packet=0x7fbdbc0be521 "\036", packet_length=51) at sql_parse.cc:1155 #20 0x000000000058a19c in do_command (thd=0x7fbdbc0bb380) at sql_parse.cc:857 #21 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #22 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #23 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #24 0x0000000000000000 in ?? () Thread 25 (Thread 0x47958950 (LWP 30664)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=17) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=22, zip_size=0, offset=817, rw_latch=1, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x47954cb0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abc30b8, level=0, tuple=0x7fbd980c00e0, mode=2, latch_mode=1, cursor=0x7fbd980c3db0, has_search_latch=0, mtr=0x47954cb0) at btr/btr0cur.c:465 #6 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd980c3470 "?G\b", mode=2, prebuilt=0x7fbd980c3ae0, match_mode=0, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd980c3280, buf=0x7fbd980c3470 "?G\b", key_ptr=, key_len=3, find_flag=) at handler/ha_innodb.cc:4933 ---Type to continue, or q to quit--- #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd980c3280, buf=0x7fbd980c3470 "?G\b", key=0x479552c0 "5", keypart_map=, find_flag=HA_READ_KEY_OR_NEXT) at ../../sql/handler.h:1387 #9 0x000000000063863e in opt_sum_query (tables=0x7fbd640345b0, all_fields=@0x9e02370, conds=0x9e00bf0) at opt_sum.cc:282 #10 0x00000000005d8b8d in JOIN::optimize (this=0x9e00d90) at sql_select.cc:885 #11 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc0c2660, rref_pointer_array=0x7fbd64033780, tables=0x7fbd640345b0, wild_num=0, fields=@0x7fbd64033600, conds=0x9e00bf0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbd640358c0, unit=0x7fbd64033180, select_lex=0x7fbd640335b0) at sql_select.cc:2347 #12 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc0c2660, lex=0x7fbd640330e0, result=0x7fbd640358c0, setup_tables_done_option=0) at sql_select.cc:269 #13 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc0c2660, all_tables=0x7fbd640345b0) at sql_parse.cc:4888 #14 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc0c2660) at sql_parse.cc:2184 #15 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd6401abd0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd6401abd0, expanded_query=0x479575e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0c2660, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0c2660, packet=0x7fbdbc0c5801 "\032", packet_length=23) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc0c2660) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 24 (Thread 0x47999950 (LWP 30665)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=40) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=27, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x479963f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abd90b8, level=0, tuple=0x7fbd58060fc0, mode=2, latch_mode=1, cursor=0x7fbd580575c0, has_search_latch=0, mtr=0x479963f0) at btr/btr0cur.c:465 #6 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd5805cfa0 "", mode=2, prebuilt=0x7fbd58056c90, match_mode=1, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd5805cbb0, buf=0x7fbd5805cfa0 "", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd5805cbb0, buf=0x7fbd5805cfa0 "", key=0xa4c8e10 "4", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd5805cbb0, buf=0x7fbd5805cfa0 "", index=, key=0xa4c8e10 "4", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0xa4c89d0) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0xa4c89d0, pos=0xa4c70c8) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0xa4c7030, tables=, conds=0xa4c6e90, keyuse_array=0xa4c85f0) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0xa4c7030) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc0c9940, rref_pointer_array=0x7fbdb0037750, tables=0x7fbdb00390d0, wild_num=0, fields=@0x7fbdb0037600, conds=0xa4c6e90, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbdb003a170, unit=0x7fbdb0037150, select_lex=0x7fbdb0037580) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc0c9940, lex=0x7fbdb00370b0, result=0x7fbdb003a170, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc0c9940, all_tables=0x7fbdb00390d0) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc0c9940) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdb001e410, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 ---Type to continue, or q to quit--- #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdb001e410, expanded_query=0x479985e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0c9940, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0c9940, packet=0x7fbdbc0ccae1 "\a", packet_length=23) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc0c9940) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 23 (Thread 0x479da950 (LWP 30666)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ae20, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=3) at sync/sync0arr.c:445 #3 0x000000000076adc5 in rw_lock_x_lock_func (lock=0x7fbe8abd4138, pass=0, file_name=0x8c3bb4 "btr/btr0cur.c", line=411) at sync/sync0rw.c:772 #4 0x00000000006cbfff in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd5805ba20, mode=4, latch_mode=33, cursor=0x7fbd6407ae80, has_search_latch=0, mtr=0x479d7ca0) at ../../storage/innobase/include/mtr0mtr.ic:248 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=33, cursor=0x7fbd6407ae80, mtr=0x479d7ca0) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075dd4d in row_upd_clust_rec (node=0x7fbd900a0a08, index=0x7fbe8abd40b8, thr=0x7fbd900a0e30, mtr=0x479d7ca0) at row/row0upd.c:1704 #7 0x000000000076080a in row_upd_clust_step (node=0x7fbd900a0a08, thr=0x7fbd900a0e30) at row/row0upd.c:1921 #8 0x0000000000760dc4 in row_upd_step (thr=0x7fbd900a0e30) at row/row0upd.c:1998 #9 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd9009e780) at row/row0mysql.c:1367 #10 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd9009c350, old_row=0x7fbd900a16b0 "PE\205", new_row=0x7fbd9009c540 "\201E\b") at handler/ha_innodb.cc:4508 #11 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd9009c350, old_data=0x7fbd9009c578 "\211E\b", new_data=0x7fbd9009c540 "\201E\b") at handler.cc:4591 #12 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc0d0c20, table_list=0xae49bb8, fields=@0xae490f8, values=@0xae494d0, conds=0x9dbc5f0, order_num=, order=0x0, limit=18446744073709551607, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0d0c20) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0xacd2b50, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xacd2b50, expanded_query=0x479d95e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0d0c20, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0d0c20, packet=0x7fbdbc0d3dc1 "\036", packet_length=51) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc0d0c20) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 22 (Thread 0x47a1b950 (LWP 30667)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=44) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=65537, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x47a17280) at ../../storage/innobase/include/sync0rw.ic:327 ---Type to continue, or q to quit--- #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbdb416bee0, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=79318, thr=0x7fbd5c071918) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbdb416bee0, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=79318, thr=0x7fbd5c071918) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbdb416bee0, mode=4, latch_mode=2, cursor=0x47a18790, has_search_latch=0, mtr=0x47a18cd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbdb416bee0, n_ext=0, thr=0x7fbd5c071918) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbdb416bee0, n_ext=0, foreign=, thr=0x7fbd5c071918) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd5c071918) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd5c064840 "\211?\v", prebuilt=0x7fbd5c068fa0) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd5c064650, record=0x7fbd5c064840 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd5c064650, buf=0x7fbd5c064840 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc0d7f00, table=0x7fbd5c067db0, info=0x47a194a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc0d7f00, table_list=0x7fbdb0030260, fields=@0x7fbdb002fad8, values_list=@0x7fbdb002fb20, update_fields=@0x7fbdb002fb08, update_values=@0x7fbdb002faf0, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc0d7f00) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdb001e0b0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdb001e0b0, expanded_query=0x47a1a5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0d7f00, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0d7f00, packet=0x7fbdbc0db0a1 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc0d7f00) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 21 (Thread 0x47a5c950 (LWP 30668)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=34) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=25, zip_size=0, offset=98305, rw_latch=2, guess=0x0, mode=10, file=0x8cbf3c "ibuf/ibuf0ibuf.c", line=775, mtr=0x47a58280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000070d124 in ibuf_bitmap_get_map_page (space=38669788, page_no=, zip_size=128, mtr=) at ibuf/ibuf0ibuf.c:773 #6 0x0000000000714a12 in ibuf_insert_low (mode=36, entry=0x7fbd88092d50, entry_size=20, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=109833, thr=0x7fbd88092390) at ibuf/ibuf0ibuf.c:2744 #7 0x00000000007153ee in ibuf_insert (entry=0x7fbd88092d50, index=0x7fbe8abd44b8, space=25, zip_size=0, page_no=109833, thr=0x7fbd88092390) at ibuf/ibuf0ibuf.c:2907 #8 0x00000000006cc898 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd88092d50, mode=4, latch_mode=2, cursor=0x47a59790, has_search_latch=0, mtr=0x47a59cd0) at btr/btr0cur.c:476 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd88092d50, n_ext=0, thr=0x7fbd88092390) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd88092d50, n_ext=0, foreign=, thr=0x7fbd88092390) at row/row0ins.c:2194 ---Type to continue, or q to quit--- #11 0x0000000000749961 in row_ins_step (thr=0x7fbd88092390) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd88094b00 "\211?\v", prebuilt=0x7fbd8808fc70) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd88094910, record=0x7fbd88094b00 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd88094910, buf=0x7fbd88094b00 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc0df1e0, table=0x7fbd880905b0, info=0x47a5a4a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc0df1e0, table_list=0x7fbd88017fc0, fields=@0x7fbd88017838, values_list=@0x7fbd88017880, update_fields=@0x7fbd88017868, update_values=@0x7fbd88017850, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc0df1e0) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd88012c20, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd88012c20, expanded_query=0x47a5b5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0df1e0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0df1e0, packet=0x7fbdbc0e2381 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc0df1e0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 20 (Thread 0x47a9d950 (LWP 30669)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=30) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cc9c3 "log/log0log.c", line=1456) at sync/sync0sync.c:570 #4 0x000000000071e6e3 in log_write_up_to (lsn=2048, wait=147, flush_to_disk=1) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x000000000077cc2c in trx_commit_off_kernel (trx=0x7fbe8abf60b8) at trx/trx0trx.c:906 #6 0x000000000077d3af in trx_commit_for_mysql (trx=0x7fbe8abf60b8) at trx/trx0trx.c:1553 #7 0x00000000006bc469 in innobase_commit_low (trx=0x9ce15fc) at handler/ha_innodb.cc:2238 #8 0x00000000006be515 in innobase_commit (hton=, thd=0x7fbdbc0e64c0, all=true) at handler/ha_innodb.cc:2370 #9 0x000000000063eb90 in ha_commit_one_phase (thd=0x7fbdbc0e64c0, all=true) at handler.cc:1202 #10 0x000000000063f65f in ha_commit_trans (thd=0x7fbdbc0e64c0, all=) at handler.cc:1171 #11 0x0000000000581d63 in end_trans (thd=0x9ce15fc, completion=COMMIT) at sql_parse.cc:714 #12 0x0000000000585520 in mysql_execute_command (thd=0x7fbdbc0e64c0) at sql_parse.cc:3947 #13 0x0000000000587ac4 in mysql_parse (thd=0x7fbdbc0e64c0, inBuf=0x7fbdb802ad70 "commit", length=6, found_semicolon=0x47a9cc88) at sql_parse.cc:5787 #14 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0x7fbdbc0e64c0, packet=0x7fbdbc0e9661 "commit", packet_length=) at sql_parse.cc:1200 #15 0x000000000058a19c in do_command (thd=0x7fbdbc0e64c0) at sql_parse.cc:857 #16 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #17 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #18 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #19 0x0000000000000000 in ?? () Thread 19 (Thread 0x47ade950 (LWP 30670)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=31) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=29, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, ---Type to continue, or q to quit--- file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x47ad8920) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8abc1cb8, level=0, tuple=0x7fbd4c05f6a0, mode=2, latch_mode=1, cursor=0x47ad88a0, has_search_latch=0, mtr=0x47ad8920) at btr/btr0cur.c:465 #6 0x00000000006ce21f in btr_estimate_n_rows_in_range (index=0x7fbe8abc1cb8, tuple1=, mode1=, tuple2=0x7fbd4c05f730, mode2=1) at btr/btr0cur.c:3028 #7 0x00000000006c1ced in ha_innobase::records_in_range (this=0x7fbd88096fc0, keynr=, min_key=0x47ad8ef0, max_key=0x47ad8ed0) at handler/ha_innodb.cc:6705 #8 0x000000000062dadb in check_quick_keys (param=0x47ad93c0, idx=, key_tree=0x7fbd4c068f88, min_key=0x47ad9732 "\001G\b", min_key_flag=0, min_keypart=0, max_key=0x47ada630 "\001G\b", max_key_flag=0, max_keypart=0) at opt_range.cc:7538 #9 0x000000000062d71c in check_quick_keys (param=0x47ad93c0, idx=1, key_tree=0x7fbd4c0692a0, min_key=, min_key_flag=0, min_keypart=-1, max_key=, max_key_flag=0, max_keypart=-1) at opt_range.cc:7444 #10 0x000000000062dce1 in check_quick_select (param=0x47ad93c0, idx=1, tree=0x7fbd4c0692a0, update_tbl_stats=true) at opt_range.cc:7313 #11 0x000000000062deaf in get_key_scans_params (param=0x47ad93c0, tree=0x7fbd4c0689b8, index_read_must_be_used=false, update_tbl_stats=, read_time=1.21) at opt_range.cc:4848 #12 0x0000000000635929 in SQL_SELECT::test_quick_select (this=0x9dc4818, thd=0x7fbdbc0ed7a0, keys_to_use=, prev_tables=, limit=, force_quick_range=) at opt_range.cc:2374 #13 0x00000000005f2c45 in mysql_update (thd=0x7fbdbc0ed7a0, table_list=0x7fbd90075210, fields=@0x7fbd90074778, values=@0x7fbd90074b50, conds=0x9dc46e0, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at opt_range.h:709 #14 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc0ed7a0) at sql_parse.cc:2959 #15 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd90066ab0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd90066ab0, expanded_query=0x47add5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0ed7a0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0ed7a0, packet=0x7fbdbc0f0941 "\035", packet_length=35) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc0ed7a0) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 18 (Thread 0x47b1f950 (LWP 30671)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce41b0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=54) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8aba9cc0, file_name=0x8d97e3 "trx/trx0roll.c", line=927) at sync/sync0sync.c:570 #4 0x0000000000776f71 in trx_roll_pop_top_rec_of_trx (trx=0x7fbe8ac208b8, limit={high = 0, low = 0}, roll_ptr=0x47b1e220, heap=0x7fbd5c072800) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x000000000075d33f in row_undo_step (thr=0x7fbd5c06c718) at row/row0undo.c:234 #6 0x0000000000740f9d in que_run_threads (thr=0x7fbd5c06c718) at que/que0que.c:1255 #7 0x0000000000776244 in trx_general_rollback_for_mysql (trx=0x7fbe8ac208b8, partial=, savept=0x7fbe8ac20bd0) at trx/trx0roll.c:82 #8 0x000000000077650d in trx_rollback_last_sql_stat_for_mysql (trx=0x9ce41ec) at trx/trx0roll.c:163 #9 0x00000000006c259d in innobase_rollback (hton=, thd=0x7fbdbc0f4a80, all=false) at handler/ha_innodb.cc:2460 #10 0x000000000063ea02 in ha_rollback_trans (thd=0x7fbdbc0f4a80, all=false) at handler.cc:1269 #11 0x000000000063f752 in ha_autocommit_or_rollback (thd=0x9ce41ec, error=1) at handler.cc:1338 #12 0x00000000005b439a in close_thread_tables (thd=0x7fbdbc0f4a80) at sql_base.cc:1255 #13 0x00000000005eaf29 in Prepared_statement::cleanup_stmt (this=0x9e570d0) at sql_prepare.cc:2914 #14 0x00000000005ed391 in Prepared_statement::execute (this=0x9e570d0, expanded_query=, open_cursor=false) at sql_prepare.cc:3589 ---Type to continue, or q to quit--- #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x9e570d0, expanded_query=0x47b1e5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0f4a80, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0f4a80, packet=0x7fbdbc0f7c21 "\002", packet_length=23) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc0f4a80) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 17 (Thread 0x47b60950 (LWP 30672)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x2e4ada0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=21) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbdc548b150, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=467) at sync/sync0rw.c:371 #4 0x00000000006de829 in buf_page_get_gen (space=16, zip_size=0, offset=279, rw_latch=1, guess=0x0, mode=10, file=0x8c3bb4 "btr/btr0cur.c", line=467, mtr=0x47b5d3f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cc2e8 in btr_cur_search_to_nth_level (index=0x7fbe8ac27cb8, level=0, tuple=0x7fbdb00e3ff0, mode=2, latch_mode=1, cursor=0x7fbdb00dbc10, has_search_latch=1, mtr=0x47b5d3f0) at btr/btr0cur.c:465 #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbdb00da760 "p?\237", mode=2, prebuilt=0x7fbdb00e2810, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbdb00da570, buf=0x7fbdb00da760 "p?\237", key_ptr=, key_len=4, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbdb00da570, buf=0x7fbdb00da760 "p?\237", key=0x9dd4578 "\002?", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbdb00da570, buf=0x7fbdb00da760 "p?\237", index=, key=0x9dd4578 "\002?", keypart_map=1, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9dd40c0) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9dd40c0, pos=0x9dd2898) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9dd2800, tables=, conds=0x9dd3f70, keyuse_array=0x9dd3dc0) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9dd2800) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc0fbd60, rref_pointer_array=0xa22ec10, tables=0xa22f8b0, wild_num=0, fields=@0xa22eb00, conds=0xa2301c0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xa230338, unit=0xa22e610, select_lex=0xa22ea40) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc0fbd60, lex=0xa22e570, result=0xa230338, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc0fbd60, all_tables=0xa22f8b0) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc0fbd60) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0xa1b94e0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1b94e0, expanded_query=0x47b5f5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc0fbd60, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc0fbd60, packet=0x7fbdbc0fef01 "\006", packet_length=17) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc0fbd60) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 16 (Thread 0x47ba1950 (LWP 30673)): ---Type to continue, or q to quit--- #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=15) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd48055350, mode=4, latch_mode=1, cursor=0x7fbd740264f0, has_search_latch=0, mtr=0x47b9ed90) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=1, cursor=0x7fbd740264f0, mtr=0x47b9ed90) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075886d in sel_restore_position_for_mysql (same_user_rec=0x47b9ed80, latch_mode=140452745555388, pcur=0x7fbd740264f0, moves_up=18446744073709551615, mtr=0x7fbdb401ad80) at row/row0sel.c:3117 #7 0x00000000007592cd in row_search_for_mysql (buf=0x7fbd7407c240 "\201O\b", mode=2, prebuilt=0x7fbd7407f830, match_mode=1, direction=1) at row/row0sel.c:3741 #8 0x00000000006c0a57 in ha_innobase::general_fetch (this=0x7fbd7407c050, buf=0x7fbd7407c240 "\201O\b", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5118 #9 0x00000000006c0c10 in ha_innobase::index_next_same (this=0x7fbd7407c050, buf=0x7fbd7407c240 "\201O\b", key=, keylen=) at handler/ha_innodb.cc:5176 #10 0x000000000063d2a3 in handler::read_range_next (this=0x7fbdb401adbc) at handler.cc:4186 #11 0x000000000063c842 in handler::read_multi_range_next (this=0x7fbdb401adbc, found_range_p=0x47b9f318) at handler.cc:4071 #12 0x00000000006262b1 in QUICK_RANGE_SELECT::get_next (this=0x7fbd4c059d70) at opt_range.cc:8400 #13 0x0000000000638ec8 in rr_quick (info=0x47b9f3d0) at records.cc:313 #14 0x00000000005f353c in mysql_update (thd=0x7fbdbc103040, table_list=0x7fbd800502c8, fields=@0x7fbd8004f808, values=@0x7fbd8004fbe0, conds=0x9dcf740, order_num=, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:571 #15 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc103040) at sql_parse.cc:2959 #16 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd80009860, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #17 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd80009860, expanded_query=0x47ba05e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #18 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc103040, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #19 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc103040, packet=0x7fbdbc1061e1 "\036", packet_length=51) at sql_parse.cc:1155 #20 0x000000000058a19c in do_command (thd=0x7fbdbc103040) at sql_parse.cc:857 #21 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #22 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #23 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #24 0x0000000000000000 in ?? () Thread 15 (Thread 0x47be2950 (LWP 30674)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ae20, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=22) at sync/sync0arr.c:445 #3 0x000000000076adc5 in rw_lock_x_lock_func (lock=0x7fbe8abd4138, pass=0, file_name=0x8c3bb4 "btr/btr0cur.c", line=411) at sync/sync0rw.c:772 #4 0x00000000006cbfff in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd980c1780, mode=4, latch_mode=33, cursor=0x7fbd88088030, has_search_latch=0, mtr=0x47bdfca0) at ../../storage/innobase/include/mtr0mtr.ic:248 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=33, cursor=0x7fbd88088030, mtr=0x47bdfca0) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075dd4d in row_upd_clust_rec (node=0x7fbd8808a0e0, index=0x7fbe8abd40b8, thr=0x7fbd8808a508, mtr=0x47bdfca0) at row/row0upd.c:1704 #7 0x000000000076080a in row_upd_clust_step (node=0x7fbd8808a0e0, thr=0x7fbd8808a508) at row/row0upd.c:1921 #8 0x0000000000760dc4 in row_upd_step (thr=0x7fbd8808a508) at row/row0upd.c:1998 #9 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd88087b70) at row/row0mysql.c:1367 #10 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd8808bf20, old_row=0x7fbd8808c700 "PE\205", new_row=0x7fbd8808c110 "\201N\b") at handler/ha_innodb.cc:4508 #11 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd8808bf20, old_data=0x7fbd8808c148 "\211N\b", ---Type to continue, or q to quit--- new_data=0x7fbd8808c110 "\201N\b") at handler.cc:4591 #12 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc10a320, table_list=0x7fbd4c031908, fields=@0x7fbd4c030e48, values=@0x7fbd4c031220, conds=0x9ddd7e0, order_num=, order=0x0, limit=18446744073709551609, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc10a320) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd4c028bb0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd4c028bb0, expanded_query=0x47be15e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc10a320, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc10a320, packet=0x7fbdbc10d4c1 "\036", packet_length=51) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc10a320) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 14 (Thread 0x47c23950 (LWP 30675)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=33) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd5c0671c0, mode=4, latch_mode=1, cursor=0x7fbd90095380, has_search_latch=0, mtr=0x47c20d90) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=1, cursor=0x7fbd90095380, mtr=0x47c20d90) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075886d in sel_restore_position_for_mysql (same_user_rec=0x47c20d80, latch_mode=140452745555388, pcur=0x7fbd90095380, moves_up=18446744073709551615, mtr=0x7fbdb401ad80) at row/row0sel.c:3117 #7 0x00000000007592cd in row_search_for_mysql (buf=0x7fbd9008e880 "\201E\b", mode=2, prebuilt=0x7fbd90090370, match_mode=1, direction=1) at row/row0sel.c:3741 #8 0x00000000006c0a57 in ha_innobase::general_fetch (this=0x7fbd9008e690, buf=0x7fbd9008e880 "\201E\b", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5118 #9 0x00000000006c0c10 in ha_innobase::index_next_same (this=0x7fbd9008e690, buf=0x7fbd9008e880 "\201E\b", key=, keylen=) at handler/ha_innodb.cc:5176 #10 0x000000000063d2a3 in handler::read_range_next (this=0x7fbdb401adbc) at handler.cc:4186 #11 0x000000000063c842 in handler::read_multi_range_next (this=0x7fbdb401adbc, found_range_p=0x47c21318) at handler.cc:4071 #12 0x00000000006262b1 in QUICK_RANGE_SELECT::get_next (this=0x7fbd5c067c70) at opt_range.cc:8400 #13 0x0000000000638ec8 in rr_quick (info=0x47c213d0) at records.cc:313 #14 0x00000000005f353c in mysql_update (thd=0x7fbdbc111600, table_list=0x7fbd48025378, fields=@0x7fbd480248b8, values=@0x7fbd48024c90, conds=0x9deb8a0, order_num=, order=0x0, limit=18446744073709551614, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:571 #15 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc111600) at sql_parse.cc:2959 #16 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd48020380, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #17 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd48020380, expanded_query=0x47c225e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #18 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc111600, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #19 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc111600, packet=0x7fbdbc1147a1 "\036", packet_length=51) at sql_parse.cc:1155 #20 0x000000000058a19c in do_command (thd=0x7fbdbc111600) at sql_parse.cc:857 #21 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #22 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #23 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- #24 0x0000000000000000 in ?? () Thread 13 (Thread 0x47c64950 (LWP 30676)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0ee0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=4) at sync/sync0arr.c:445 #3 0x000000000076adc5 in rw_lock_x_lock_func (lock=0xbd1920, pass=0, file_name=0x8c5f16 "buf/buf0lru.c", line=1450) at sync/sync0rw.c:772 #4 0x00000000006e6b21 in buf_LRU_free_block (bpage=0x7fbdc50a12a0, zip=1, buf_pool_mutex_released=0x0, have_LRU_mutex=0) at buf/buf0lru.c:1450 #5 0x00000000006e7c0f in buf_LRU_search_and_free_block (n_iterations=) at buf/buf0lru.c:616 #6 0x00000000006e7e43 in buf_LRU_try_free_flushed_blocks () at buf/buf0lru.c:711 #7 0x00000000006cc660 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd900aa180, mode=4, latch_mode=2, cursor=0x47c61790, has_search_latch=0, mtr=0x47c61cd0) at ../../storage/innobase/include/ibuf0ibuf.ic:96 #8 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd900aa180, n_ext=0, thr=0x7fbd900a7780) at row/row0ins.c:2025 #9 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd900aa180, n_ext=0, foreign=, thr=0x7fbd900a7780) at row/row0ins.c:2194 #10 0x0000000000749961 in row_ins_step (thr=0x7fbd900a7780) at row/row0ins.c:2279 #11 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd900a4020 "\211?\v", prebuilt=0x7fbd900a5740) at row/row0mysql.c:1120 #12 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd900a3e30, record=0x7fbd900a4020 "\211?\v") at handler/ha_innodb.cc:4218 #13 0x000000000064088d in handler::ha_write_row (this=0x7fbd900a3e30, buf=0x7fbd900a4020 "\211?\v") at handler.cc:4570 #14 0x00000000005e4035 in write_record (thd=0x7fbdbc1188e0, table=0x7fbd9009c8b0, info=0x47c624a0) at sql_insert.cc:1568 #15 0x00000000005e797c in mysql_insert (thd=0x7fbdbc1188e0, table_list=0xa4fae70, fields=@0xa4fa6e8, values_list=@0xa4fa730, update_fields=@0xa4fa718, update_values=@0xa4fa700, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #16 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc1188e0) at sql_parse.cc:3066 #17 0x00000000005ed343 in Prepared_statement::execute (this=0xa4c27b0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #18 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa4c27b0, expanded_query=0x47c635e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #19 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc1188e0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #20 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc1188e0, packet=0x7fbdbc11ba81 "\t", packet_length=87) at sql_parse.cc:1155 #21 0x000000000058a19c in do_command (thd=0x7fbdbc1188e0) at sql_parse.cc:857 #22 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #23 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #24 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #25 0x0000000000000000 in ?? () Thread 12 (Thread 0x47ce6950 (LWP 30692)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ae20, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=0) at sync/sync0arr.c:445 #3 0x000000000076adc5 in rw_lock_x_lock_func (lock=0x7fbe8abd4138, pass=0, file_name=0x8c3bb4 "btr/btr0cur.c", line=411) at sync/sync0rw.c:772 #4 0x00000000006cbfff in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbd7c06df30, mode=4, latch_mode=33, cursor=0x7fbd8c084dd0, has_search_latch=0, mtr=0x47ce3ca0) at ../../storage/innobase/include/mtr0mtr.ic:248 #5 0x000000000078d9b9 in btr_pcur_restore_position (latch_mode=33, cursor=0x7fbd8c084dd0, mtr=0x47ce3ca0) at ../../storage/innobase/include/btr0pcur.ic:544 #6 0x000000000075dd4d in row_upd_clust_rec (node=0x7fbd5404c6a8, index=0x7fbe8abd40b8, thr=0x7fbd5404cad0, mtr=0x47ce3ca0) at row/row0upd.c:1704 #7 0x000000000076080a in row_upd_clust_step (node=0x7fbd5404c6a8, thr=0x7fbd5404cad0) at row/row0upd.c:1921 #8 0x0000000000760dc4 in row_upd_step (thr=0x7fbd5404cad0) at row/row0upd.c:1998 #9 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd54042a00) at row/row0mysql.c:1367 ---Type to continue, or q to quit--- #10 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd54041260, old_row=0x7fbd54053b10 "PE\205", new_row=0x7fbd54041450 "\201E\b") at handler/ha_innodb.cc:4508 #11 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd54041260, old_data=0x7fbd54041488 "\211E\b", new_data=0x7fbd54041450 "\201E\b") at handler.cc:4591 #12 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc126ea0, table_list=0x7fbdbc1ed348, fields=@0x7fbdbc1ec888, values=@0x7fbdbc1ecc60, conds=0x9da04b0, order_num=, order=0x0, limit=18446744073709551611, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #13 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc126ea0) at sql_parse.cc:2959 #14 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdbc1ebf40, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #15 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdbc1ebf40, expanded_query=0x47ce55e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #16 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc126ea0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #17 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc126ea0, packet=0x7fbdbc12a041 "\036", packet_length=51) at sql_parse.cc:1155 #18 0x000000000058a19c in do_command (thd=0x7fbdbc126ea0) at sql_parse.cc:857 #19 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #20 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #21 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #22 0x0000000000000000 in ?? () Thread 11 (Thread 0x47ca5950 (LWP 30712)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=12) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8abd90b8, info=0x7fbe8abda0b8, tuple=0x7fbd840839e0, mode=2, latch_mode=1, cursor=0x7fbd8406a0a0, has_search_latch=1, mtr=0x47ca23f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbd840839e0, mode=2, latch_mode=1, cursor=0x7fbd8406a0a0, has_search_latch=1, mtr=0x47ca23f0) at btr/btr0cur.c:370 #6 0x0000000000758f67 in row_search_for_mysql (buf=0x7fbd84073630 "", mode=2, prebuilt=0x7fbd84083710, match_mode=1, direction=0) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd84064cf0, buf=0x7fbd84073630 "", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd84064cf0, buf=0x7fbd84073630 "", key=0x9df4998 "_", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd84064cf0, buf=0x7fbd84073630 "", index=, key=0x9df4998 "_", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9df4558) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9df4558, pos=0x9df2c48) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9df2bb0, tables=, conds=0x9df2a00, keyuse_array=0x9df4170) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9df2bb0) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc12e180, rref_pointer_array=0x7fbd8004b890, tables=0x7fbd8004c3f8, wild_num=0, fields=@0x7fbd8004b700, conds=0x9df2a00, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbd8004d1c8, unit=0x7fbd8004b290, select_lex=0x7fbd8004b6c0) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc12e180, lex=0x7fbd8004b1f0, result=0x7fbd8004d1c8, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc12e180, all_tables=0x7fbd8004c3f8) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc12e180) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd800091a0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd800091a0, expanded_query=0x47ca45e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc12e180, packet_arg=, packet_length=4294966784) ---Type to continue, or q to quit--- at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc12e180, packet=0x7fbdbc11fbc1 "#", packet_length=29) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc12e180) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 10 (Thread 0x47d27950 (LWP 30713)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0c60, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=1) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd1620, file_name=0x8c5f16 "buf/buf0lru.c", line=1448) at sync/sync0sync.c:570 #4 0x00000000006e3b50 in mutex_enter_func (mutex=0xbd1620, file_name=0x8c5f16 "buf/buf0lru.c", line=1448) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006e6ab6 in buf_LRU_free_block (bpage=0x7fbdc50a12a0, zip=1, buf_pool_mutex_released=0x0, have_LRU_mutex=0) at buf/buf0lru.c:1448 #6 0x00000000006e7c0f in buf_LRU_search_and_free_block (n_iterations=) at buf/buf0lru.c:616 #7 0x00000000006e7e43 in buf_LRU_try_free_flushed_blocks () at buf/buf0lru.c:711 #8 0x00000000006cc332 in btr_cur_search_to_nth_level (index=0x7fbe8abd44b8, level=0, tuple=0x7fbd6c088d30, mode=4, latch_mode=2, cursor=0x47d24790, has_search_latch=0, mtr=0x47d24cd0) at ../../storage/innobase/include/ibuf0ibuf.ic:96 #9 0x00000000007482de in row_ins_index_entry_low (mode=2, index=0x7fbe8abd44b8, entry=0x7fbd6c088d30, n_ext=0, thr=0x7fbd6c085f40) at row/row0ins.c:2025 #10 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd44b8, entry=0x7fbd6c088d30, n_ext=0, foreign=, thr=0x7fbd6c085f40) at row/row0ins.c:2194 #11 0x0000000000749961 in row_ins_step (thr=0x7fbd6c085f40) at row/row0ins.c:2279 #12 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd6c087890 "\211?\v", prebuilt=0x7fbd6c0882f0) at row/row0mysql.c:1120 #13 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd6c0876a0, record=0x7fbd6c087890 "\211?\v") at handler/ha_innodb.cc:4218 #14 0x000000000064088d in handler::ha_write_row (this=0x7fbd6c0876a0, buf=0x7fbd6c087890 "\211?\v") at handler.cc:4570 #15 0x00000000005e4035 in write_record (thd=0x7fbdbc123bd0, table=0x7fbd6c086e00, info=0x47d254a0) at sql_insert.cc:1568 #16 0x00000000005e797c in mysql_insert (thd=0x7fbdbc123bd0, table_list=0x7fbdac06ab70, fields=@0x7fbdac06a3e8, values_list=@0x7fbdac06a430, update_fields=@0x7fbdac06a418, update_values=@0x7fbdac06a400, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #17 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc123bd0) at sql_parse.cc:3066 #18 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbdac0696e0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbdac0696e0, expanded_query=0x47d265e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc123bd0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc123bd0, packet=0x7fbdbc134c51 "\t", packet_length=87) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc123bd0) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 9 (Thread 0x47d68950 (LWP 30716)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=20) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 ---Type to continue, or q to quit--- #4 0x00000000006dd95a in buf_page_get_gen (space=0, zip_size=0, offset=252, rw_latch=2, guess=0x0, mode=10, file=0x8d8f80 "../../storage/innobase/include/trx0undo.ic", line=137, mtr=0x47d66190) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x000000000077dc27 in trx_undo_set_state_at_finish (rseg=0x7fbe8aba9cb8, trx=, undo=0x7fbd9c095900, mtr=0x47d66190) at ../../storage/innobase/include/trx0undo.ic:136 #6 0x000000000077c926 in trx_commit_off_kernel (trx=0x7fbe8abfa0b8) at trx/trx0trx.c:741 #7 0x000000000077d3af in trx_commit_for_mysql (trx=0x7fbe8abfa0b8) at trx/trx0trx.c:1553 #8 0x00000000006bc469 in innobase_commit_low (trx=0x24e0ddc) at handler/ha_innodb.cc:2238 #9 0x00000000006be515 in innobase_commit (hton=, thd=0x7fbdbc130f30, all=true) at handler/ha_innodb.cc:2370 #10 0x000000000063eb90 in ha_commit_one_phase (thd=0x7fbdbc130f30, all=true) at handler.cc:1202 #11 0x000000000063f65f in ha_commit_trans (thd=0x7fbdbc130f30, all=) at handler.cc:1171 #12 0x0000000000581d63 in end_trans (thd=0x24e0ddc, completion=COMMIT) at sql_parse.cc:714 #13 0x0000000000585520 in mysql_execute_command (thd=0x7fbdbc130f30) at sql_parse.cc:3947 #14 0x0000000000587ac4 in mysql_parse (thd=0x7fbdbc130f30, inBuf=0x9e2e9d0 "commit", length=6, found_semicolon=0x47d67c88) at sql_parse.cc:5787 #15 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0x7fbdbc130f30, packet=0x7fbdbc138c61 "commit", packet_length=) at sql_parse.cc:1200 #16 0x000000000058a19c in do_command (thd=0x7fbdbc130f30) at sql_parse.cc:857 #17 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #18 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #19 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #20 0x0000000000000000 in ?? () Thread 8 (Thread 0x47da9950 (LWP 30718)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=14) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at sync/sync0sync.c:570 #4 0x0000000000729064 in mutex_enter_func (mutex=0x7fbe8ab9f108, file_name=0x8cea70 "../../storage/innobase/include/log0log.ic", line=306) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x0000000000729183 in mtr_commit (mtr=0x47da6cd0) at ../../storage/innobase/include/log0log.ic:306 #6 0x0000000000748f65 in row_ins_index_entry_low (mode=2, index=0x7fbe8abd40b8, entry=0x7fbd740852d0, n_ext=0, thr=0x7fbd74084910) at row/row0ins.c:2132 #7 0x00000000007494bc in row_ins_index_entry (index=0x7fbe8abd40b8, entry=0x7fbd740852d0, n_ext=0, foreign=, thr=0x7fbd74084910) at row/row0ins.c:2194 #8 0x0000000000749961 in row_ins_step (thr=0x7fbd74084910) at row/row0ins.c:2279 #9 0x000000000074f37f in row_insert_for_mysql (mysql_rec=0x7fbd7407d1a0 "\211?\v", prebuilt=0x7fbd740864e0) at row/row0mysql.c:1120 #10 0x00000000006be888 in ha_innobase::write_row (this=0x7fbd7407cfb0, record=0x7fbd7407d1a0 "\211?\v") at handler/ha_innodb.cc:4218 #11 0x000000000064088d in handler::ha_write_row (this=0x7fbd7407cfb0, buf=0x7fbd7407d1a0 "\211?\v") at handler.cc:4570 #12 0x00000000005e4035 in write_record (thd=0x7fbdbc13cc70, table=0x7fbd740857d0, info=0x47da74a0) at sql_insert.cc:1568 #13 0x00000000005e797c in mysql_insert (thd=0x7fbdbc13cc70, table_list=0xa620ee0, fields=@0xa620758, values_list=@0xa6207a0, update_fields=@0xa620788, update_values=@0xa620770, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:812 #14 0x0000000000587475 in mysql_execute_command (thd=0x7fbdbc13cc70) at sql_parse.cc:3066 #15 0x00000000005ed343 in Prepared_statement::execute (this=0xa57d720, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #16 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa57d720, expanded_query=0x47da85e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #17 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc13cc70, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #18 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc13cc70, packet=0x7fbdbc13f511 "\t", packet_length=87) at sql_parse.cc:1155 #19 0x000000000058a19c in do_command (thd=0x7fbdbc13cc70) at sql_parse.cc:857 #20 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #21 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 ---Type to continue, or q to quit--- #22 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #23 0x0000000000000000 in ?? () Thread 7 (Thread 0x47dea950 (LWP 30719)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=18) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c413a "btr/btr0sea.c", line=821) at sync/sync0rw.c:371 #4 0x00000000006d3b19 in btr_search_guess_on_hash (index=0x7fbe8abd90b8, info=0x7fbe8abda0b8, tuple=0x7fbd70086cd0, mode=2, latch_mode=1, cursor=0x7fbd700734d0, has_search_latch=0, mtr=0x47de73f0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006cbebf in btr_cur_search_to_nth_level (index=0x24e0ddc, level=0, tuple=0x7fbd70086cd0, mode=2, latch_mode=1, cursor=0x7fbd700734d0, has_search_latch=0, mtr=0x47de73f0) at btr/btr0cur.c:370 #6 0x0000000000759363 in row_search_for_mysql (buf=0x7fbd7007f990 "???=", mode=2, prebuilt=0x7fbd70086a00, match_mode=1, direction=) at ../../storage/innobase/include/btr0pcur.ic:544 #7 0x00000000006c180f in ha_innobase::index_read (this=0x7fbd70073060, buf=0x7fbd7007f990 "???=", key_ptr=, key_len=6, find_flag=) at handler/ha_innodb.cc:4933 #8 0x0000000000641f8e in handler::index_read_map (this=0x7fbd70073060, buf=0x7fbd7007f990 "???=", key=0x9e51290 "\036", keypart_map=, find_flag=HA_READ_KEY_EXACT) at ../../sql/handler.h:1387 #9 0x000000000063c960 in handler::index_read_idx_map (this=0x7fbd70073060, buf=0x7fbd7007f990 "???=", index=, key=0x9e51290 "\036", keypart_map=3, find_flag=HA_READ_KEY_EXACT) at handler.cc:4232 #10 0x00000000005c56bd in join_read_const (tab=0x9e50e50) at sql_select.cc:11513 #11 0x00000000005c8c36 in join_read_const_table (tab=0x9e50e50, pos=0x9e4f548) at sql_select.cc:11412 #12 0x00000000005d78ab in make_join_statistics (join=0x9e4f4b0, tables=, conds=0x9e4f310, keyuse_array=0x9e50a70) at sql_select.cc:2735 #13 0x00000000005d8d92 in JOIN::optimize (this=0x9e4f4b0) at sql_select.cc:945 #14 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc143520, rref_pointer_array=0xa25cce0, tables=0xa2626a0, wild_num=0, fields=@0xa25cc00, conds=0x9e4f310, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0xa263740, unit=0xa25c6e0, select_lex=0xa25cb10) at sql_select.cc:2347 #15 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc143520, lex=0xa25c640, result=0xa263740, setup_tables_done_option=0) at sql_select.cc:269 #16 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc143520, all_tables=0xa2626a0) at sql_parse.cc:4888 #17 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc143520) at sql_parse.cc:2184 #18 0x00000000005ed343 in Prepared_statement::execute (this=0xa1bfe80, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #19 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa1bfe80, expanded_query=0x47de95e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #20 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc143520, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #21 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc143520, packet=0x7fbdbc145dc1 "\a", packet_length=23) at sql_parse.cc:1155 #22 0x000000000058a19c in do_command (thd=0x7fbdbc143520) at sql_parse.cc:857 #23 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #24 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #25 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #26 0x0000000000000000 in ?? () Thread 6 (Thread 0x47e2b950 (LWP 30722)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x7fbdb401ad80, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=42) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0x7fbe8abd4138, pass=, file_name=0x8c3bb4 "btr/btr0cur.c", line=418) at sync/sync0rw.c:371 #4 0x00000000006cc11d in btr_cur_search_to_nth_level (index=0x7fbe8abd40b8, level=0, tuple=0x7fbdb816f780, mode=2, latch_mode=1, cursor=0x47e24e30, has_search_latch=0, mtr=0x47e24eb0) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x00000000006ce21f in btr_estimate_n_rows_in_range (index=0x7fbe8abd40b8, tuple1=, mode1=, tuple2=0x7fbdb816f810, mode2=1) at btr/btr0cur.c:3028 ---Type to continue, or q to quit--- #6 0x00000000006c1ced in ha_innobase::records_in_range (this=0x7fbd6406d160, keynr=, min_key=0x47e25480, max_key=0x47e25460) at handler/ha_innodb.cc:6705 #7 0x000000000062dadb in check_quick_keys (param=0x47e25a50, idx=, key_tree=0x7fbdb8173188, min_key=0x47e25dc3 "F\b", min_key_flag=0, min_keypart=1, max_key=0x47e26cc1 "F\b", max_key_flag=0, max_keypart=1) at opt_range.cc:7538 #8 0x000000000062d71c in check_quick_keys (param=0x47e25a50, idx=0, key_tree=0x7fbdb8173438, min_key=, min_key_flag=0, min_keypart=0, max_key=, max_key_flag=0, max_keypart=0) at opt_range.cc:7444 #9 0x000000000062d71c in check_quick_keys (param=0x47e25a50, idx=0, key_tree=0x7fbdb81736e8, min_key=, min_key_flag=0, min_keypart=-1, max_key=, max_key_flag=0, max_keypart=-1) at opt_range.cc:7444 #10 0x000000000062dce1 in check_quick_select (param=0x47e25a50, idx=0, tree=0x7fbdb81736e8, update_tbl_stats=true) at opt_range.cc:7313 #11 0x000000000062deaf in get_key_scans_params (param=0x47e25a50, tree=0x7fbdb8172f38, index_read_must_be_used=false, update_tbl_stats=, read_time=6155424.6999999993) at opt_range.cc:4848 #12 0x0000000000635929 in SQL_SELECT::test_quick_select (this=0x7fbdb81711d0, thd=0x7fbdbc149dd0, keys_to_use=, prev_tables=, limit=, force_quick_range=) at opt_range.cc:2374 #13 0x00000000005d7d67 in make_join_statistics (join=0x9e5c7f0, tables=, conds=, keyuse_array=0x9e5ddb0) at sql_select.cc:2409 #14 0x00000000005d8d92 in JOIN::optimize (this=0x9e5c7f0) at sql_select.cc:945 #15 0x00000000005dc2c1 in mysql_select (thd=0x7fbdbc149dd0, rref_pointer_array=0x7fbd78045a10, tables=0x7fbd780466b0, wild_num=0, fields=@0x7fbd78045900, conds=0x9e5c640, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416724480, result=0x7fbd9c07c720, unit=0x7fbd78045410, select_lex=0x7fbd78045840) at sql_select.cc:2347 #16 0x00000000005e0ff7 in handle_select (thd=0x7fbdbc149dd0, lex=0x7fbd78045370, result=0x7fbd9c07c720, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005818df in execute_sqlcom_select (thd=0x7fbdbc149dd0, all_tables=0x7fbd780466b0) at sql_parse.cc:4888 #18 0x00000000005823f9 in mysql_execute_command (thd=0x7fbdbc149dd0) at sql_parse.cc:2184 #19 0x00000000005ed343 in Prepared_statement::execute (this=0x7fbd78002400, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #20 0x00000000005ed553 in Prepared_statement::execute_loop (this=0x7fbd78002400, expanded_query=0x47e2a5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #21 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc149dd0, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #22 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc149dd0, packet=0x7fbdbc14c671 "\037", packet_length=29) at sql_parse.cc:1155 #23 0x000000000058a19c in do_command (thd=0x7fbdbc149dd0) at sql_parse.cc:857 #24 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #25 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #26 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #27 0x0000000000000000 in ?? () Thread 5 (Thread 0x47e6c950 (LWP 30723)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x24e0da0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=29) at sync/sync0arr.c:445 #3 0x000000000076a54a in rw_lock_s_lock_spin (lock=0xbd1920, pass=, file_name=0x8c5224 "buf/buf0buf.c", line=1913) at sync/sync0rw.c:371 #4 0x00000000006dd95a in buf_page_get_gen (space=0, zip_size=0, offset=2573, rw_latch=2, guess=0x0, mode=10, file=0x8d94b4 "trx/trx0rec.c", line=1233, mtr=0x47e68280) at ../../storage/innobase/include/sync0rw.ic:327 #5 0x0000000000772da5 in trx_undo_report_row_operation (flags=, op_type=2, thr=, index=0x7fbe8abd90b8, clust_entry=0x0, update=0x7fbd60069988, cmpl_info=1, rec=0x7fbdef155a45 "\200\030\200\001n?", roll_ptr=0x47e69130) at trx/trx0rec.c:1230 #6 0x00000000006cf41d in btr_cur_update_in_place (flags=, cursor=0x7fbd54057ae0, update=0x7fbd60069988, cmpl_info=1, thr=0x7fbd60069db8, mtr=0x47e69ca0) at btr/btr0cur.c:1454 #7 0x00000000006cfd3f in btr_cur_optimistic_update (flags=2, cursor=0x7fbd54057ae0, update=0x7fbd60069988, cmpl_info=1, thr=0x7fbd60069db8, mtr=0x47e69ca0) at btr/btr0cur.c:1833 #8 0x000000000075dcc9 in row_upd_clust_rec (node=0x7fbd60069878, index=0x7fbe8abd90b8, thr=0x7fbd60069db8, mtr=0x47e69ca0) at row/row0upd.c:1677 ---Type to continue, or q to quit--- #9 0x000000000076080a in row_upd_clust_step (node=0x7fbd60069878, thr=0x7fbd60069db8) at row/row0upd.c:1921 #10 0x0000000000760dc4 in row_upd_step (thr=0x7fbd60069db8) at row/row0upd.c:1998 #11 0x000000000074eedc in row_update_for_mysql (mysql_rec=, prebuilt=0x7fbd6006c440) at row/row0mysql.c:1367 #12 0x00000000006c1265 in ha_innobase::update_row (this=0x7fbd60064db0, old_row=0x7fbd6006b7a8 "p=\205", new_row=0x7fbd600651a0 "") at handler/ha_innodb.cc:4508 #13 0x00000000006407f0 in handler::ha_update_row (this=0x7fbd60064db0, old_data=0x7fbd600652d8 "", new_data=0x7fbd600651a0 "") at handler.cc:4591 #14 0x00000000005f33d6 in mysql_update (thd=0x7fbdbc150680, table_list=0xa550c50, fields=@0xa5501d8, values=@0xa5505b0, conds=0x9e6fd40, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false) at sql_update.cc:638 #15 0x00000000005837d6 in mysql_execute_command (thd=0x7fbdbc150680) at sql_parse.cc:2959 #16 0x00000000005ed343 in Prepared_statement::execute (this=0xa4f6ec0, expanded_query=, open_cursor=false) at sql_prepare.cc:3568 #17 0x00000000005ed553 in Prepared_statement::execute_loop (this=0xa4f6ec0, expanded_query=0x47e6b5e0, open_cursor=false, packet=, packet_end=) at sql_prepare.cc:3241 #18 0x00000000005ed845 in mysql_stmt_execute (thd=0x7fbdbc150680, packet_arg=, packet_length=4294966784) at sql_prepare.cc:2462 #19 0x00000000005893f5 in dispatch_command (command=4294966784, thd=0x7fbdbc150680, packet=0x7fbdbc152f21 "\b", packet_length=29) at sql_parse.cc:1155 #20 0x000000000058a19c in do_command (thd=0x7fbdbc150680) at sql_parse.cc:857 #21 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #22 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #23 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #24 0x0000000000000000 in ?? () Thread 4 (Thread 0x47ead950 (LWP 32720)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x9ce15c0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=51) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0x7fbe8ab9f108, file_name=0x8cc9c3 "log/log0log.c", line=3251) at sync/sync0sync.c:570 #4 0x000000000071fb0c in log_print (file=0x246d670) at ../../storage/innobase/include/sync0sync.ic:259 #5 0x00000000007661a1 in srv_printf_innodb_monitor (file=0x246d670, trx_start=0x47eab6d0, trx_end=0x47eab6c8) at srv/srv0srv.c:1719 #6 0x00000000006c2967 in innodb_show_status (hton=, thd=0xae6c790, stat_print=0x63c999 ) at handler/ha_innodb.cc:7986 #7 0x00000000006c2d35 in innobase_show_status (hton=0x9ce15fc, thd=0x80, stat_print=0x23a87, stat_type=4294967295) at handler/ha_innodb.cc:8152 #8 0x0000000000641af9 in ha_show_status (thd=0xae6c790, db_type=0xd70540, stat=HA_ENGINE_STATUS) at handler.cc:4364 #9 0x0000000000582a31 in mysql_execute_command (thd=0xae6c790) at sql_parse.cc:2403 #10 0x0000000000587ac4 in mysql_parse (thd=0xae6c790, inBuf=0xae77c00 "SHOW ENGINE INNODB STATUS", length=25, found_semicolon=0x47eacc88) at sql_parse.cc:5787 #11 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0xae6c790, packet=0xae6fbd1 "", packet_length=) at sql_parse.cc:1200 #12 0x000000000058a19c in do_command (thd=0xae6c790) at sql_parse.cc:857 #13 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #14 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #15 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #16 0x0000000000000000 in ?? () Thread 3 (Thread 0x47eee950 (LWP 335)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x246d5f0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=52) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd1ce0, file_name=0x8be9a8 "handler/ha_innodb.cc", line=7983) at sync/sync0sync.c:570 #4 0x00000000006c2945 in innodb_show_status (hton=, thd=0xae7b140, stat_print=0x63c999 ) ---Type to continue, or q to quit--- at ../../include/../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006c2d35 in innobase_show_status (hton=0x246d62c, thd=0x80, stat_print=0x1, stat_type=4294967295) at handler/ha_innodb.cc:8152 #6 0x0000000000641af9 in ha_show_status (thd=0xae7b140, db_type=0xd70540, stat=HA_ENGINE_STATUS) at handler.cc:4364 #7 0x0000000000582a31 in mysql_execute_command (thd=0xae7b140) at sql_parse.cc:2403 #8 0x0000000000587ac4 in mysql_parse (thd=0xae7b140, inBuf=0xae85e30 "SHOW ENGINE INNODB STATUS", length=25, found_semicolon=0x47eedc88) at sql_parse.cc:5787 #9 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0xae7b140, packet=0xae7de01 "", packet_length=) at sql_parse.cc:1200 #10 0x000000000058a19c in do_command (thd=0xae7b140) at sql_parse.cc:857 #11 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #12 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #13 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #14 0x0000000000000000 in ?? () Thread 2 (Thread 0x47f2f950 (LWP 358)): #0 0x00007fbe8ca8d2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x000000000072dede in os_event_wait_low (event=0x246d5f0, reset_sig_count=) at os/os0sync.c:422 #2 0x0000000000769d0a in sync_array_wait_event (arr=0xd707d0, index=53) at sync/sync0arr.c:445 #3 0x000000000076b194 in mutex_spin_wait (mutex=0xbd1ce0, file_name=0x8be9a8 "handler/ha_innodb.cc", line=7983) at sync/sync0sync.c:570 #4 0x00000000006c2945 in innodb_show_status (hton=, thd=0xae89370, stat_print=0x63c999 ) at ../../include/../storage/innobase/include/sync0sync.ic:259 #5 0x00000000006c2d35 in innobase_show_status (hton=0x246d62c, thd=0x80, stat_print=0x2, stat_type=4294967295) at handler/ha_innodb.cc:8152 #6 0x0000000000641af9 in ha_show_status (thd=0xae89370, db_type=0xd70540, stat=HA_ENGINE_STATUS) at handler.cc:4364 #7 0x0000000000582a31 in mysql_execute_command (thd=0xae89370) at sql_parse.cc:2403 #8 0x0000000000587ac4 in mysql_parse (thd=0xae89370, inBuf=0xae94060 "SHOW ENGINE INNODB STATUS", length=25, found_semicolon=0x47f2ec88) at sql_parse.cc:5787 #9 0x00000000005894ff in dispatch_command (command=COM_QUERY, thd=0xae89370, packet=0xae8c031 "", packet_length=) at sql_parse.cc:1200 #10 0x000000000058a19c in do_command (thd=0xae89370) at sql_parse.cc:857 #11 0x000000000057de23 in handle_one_connection (arg=) at sql_connect.cc:1115 #12 0x00007fbe8ca893ea in start_thread () from /lib/libpthread.so.0 #13 0x00007fbe8b7dfc6d in clone () from /lib/libc.so.6 #14 0x0000000000000000 in ?? () Thread 1 (Thread 0x7fbe8ceb06f0 (LWP 30519)): #0 0x00007fbe8b7d8482 in select () from /lib/libc.so.6 #1 0x0000000000576270 in handle_connections_sockets (arg=) at mysqld.cc:4880 #2 0x000000000057b1d3 in main (argc=, argv=) at mysqld.cc:4379 #0 0x00007fbe8b7d8482 in select () from /lib/libc.so.6 Yasufumi Kinoshita wrote: > If reproduce again, please take also the content of > "LRU_list_mutex" and "flush_list_mutex" and "page_hash_latch". > > They contain the owner ID of the thread. It will help analysis much. > -- Vadim Tkachenko, CTO Percona Inc. ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403 MySQL Performance Blog - http://www.mysqlperformanceblog.com MySQL Consulting http://www.percona.com/ Attend the 2009 Percona Performance Conference April 22-23 - http://conferences.percona.com/