Attaching to process 17169 Reading symbols from /home/sbester/mysql/5.1/mysql-5.1.59-linux-x86_64-glibc23/bin/mysqld...done. Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done. [Thread debugging using libthread_db enabled] [New Thread 0x7f5a57119710 (LWP 17318)] [New Thread 0x7f5a573a3710 (LWP 17317)] [New Thread 0x7f5a5a2d5710 (LWP 17315)] [New Thread 0x7f5a5a212710 (LWP 17313)] [New Thread 0x7f5a5a294710 (LWP 17311)] [New Thread 0x7f5a573e4710 (LWP 17309)] [New Thread 0x7f5a5a10e710 (LWP 17307)] [New Thread 0x7f5a59f88710 (LWP 17305)] [New Thread 0x7f5a57362710 (LWP 17303)] [New Thread 0x7f5a6c058710 (LWP 17301)] [New Thread 0x7f5a59f47710 (LWP 17299)] [New Thread 0x7f5a5a316710 (LWP 17297)] [New Thread 0x7f5a572e0710 (LWP 17295)] [New Thread 0x7f5a5725e710 (LWP 17293)] [New Thread 0x7f5a59fc9710 (LWP 17291)] [New Thread 0x7f5a5a190710 (LWP 17289)] [New Thread 0x7f5a5a08c710 (LWP 17287)] [New Thread 0x7f5a5721d710 (LWP 17285)] [New Thread 0x7f5a571dc710 (LWP 17283)] [New Thread 0x7f5a5719b710 (LWP 17281)] [New Thread 0x7f5a5a04b710 (LWP 17279)] [New Thread 0x7f5a5a1d1710 (LWP 17277)] [New Thread 0x7f5a5729f710 (LWP 17275)] [New Thread 0x7f5a5a253710 (LWP 17273)] [New Thread 0x7f5a57321710 (LWP 17271)] [New Thread 0x7f5a57466710 (LWP 17269)] [New Thread 0x7f5a57425710 (LWP 17267)] [New Thread 0x7f5a5a0cd710 (LWP 17265)] [New Thread 0x7f5a5715a710 (LWP 17263)] [New Thread 0x7f5a5a00a710 (LWP 17260)] [New Thread 0x7f5a5a14f710 (LWP 17256)] [New Thread 0x7f5a6c099710 (LWP 17186)] [New Thread 0x7f5a59c6a710 (LWP 17185)] [New Thread 0x7f5a57e67710 (LWP 17184)] [New Thread 0x7f5a58868710 (LWP 17183)] [New Thread 0x7f5a59269710 (LWP 17182)] [New Thread 0x7f5a5ad17710 (LWP 17180)] [New Thread 0x7f5a5b718710 (LWP 17179)] [New Thread 0x7f5a5c119710 (LWP 17178)] [New Thread 0x7f5a5cb1a710 (LWP 17177)] [New Thread 0x7f5a5d51b710 (LWP 17176)] [New Thread 0x7f5a5df1c710 (LWP 17175)] [New Thread 0x7f5a5e91d710 (LWP 17174)] [New Thread 0x7f5a5f31e710 (LWP 17173)] [New Thread 0x7f5a5fd1f710 (LWP 17172)] [New Thread 0x7f5a6e3d8710 (LWP 17171)] Loaded symbols for /lib64/libpthread.so.0 Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libnsl.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libnsl.so.1 Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done. Loaded symbols for /lib64/libfreebl3.so Reading symbols from /lib64/libgcc_s.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libgcc_s.so.1 Reading symbols from /home/sbester/mysql/5.1/mysql-5.1.59-linux-x86_64-glibc23/lib/plugin/ha_innodb_plugin.so...done. Loaded symbols for /home/sbester/mysql/5.1/mysql-5.1.59-linux-x86_64-glibc23/lib/plugin/ha_innodb_plugin.so Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libnss_files.so.2 0x00000030e14da043 in select () from /lib64/libc.so.6 Thread 47 (Thread 0x7f5a6e3d8710 (LWP 17171)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b000, reset_sig_count=1) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=0, message1=0x7f5a6e3d7e88, message2=0x7f5a6e3d7e80, type=0x7f5a6e3d7e78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=0) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 46 (Thread 0x7f5a5fd1f710 (LWP 17172)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b090, reset_sig_count=43) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=1, message1=0x7f5a5fd1ee88, message2=0x7f5a5fd1ee80, type=0x7f5a5fd1ee78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=1) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 45 (Thread 0x7f5a5f31e710 (LWP 17173)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b120, reset_sig_count=7) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=2, message1=0x7f5a5f31de88, message2=0x7f5a5f31de80, type=0x7f5a5f31de78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=2) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 44 (Thread 0x7f5a5e91d710 (LWP 17174)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b1b0, reset_sig_count=2) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=3, message1=0x7f5a5e91ce88, message2=0x7f5a5e91ce80, type=0x7f5a5e91ce78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=3) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 43 (Thread 0x7f5a5df1c710 (LWP 17175)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b240, reset_sig_count=6) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=4, message1=0x7f5a5df1be88, message2=0x7f5a5df1be80, type=0x7f5a5df1be78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=4) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 42 (Thread 0x7f5a5d51b710 (LWP 17176)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b2d0, reset_sig_count=2) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=5, message1=0x7f5a5d51ae88, message2=0x7f5a5d51ae80, type=0x7f5a5d51ae78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=5) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 41 (Thread 0x7f5a5cb1a710 (LWP 17177)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b360, reset_sig_count=1515) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=6, message1=0x7f5a5cb19e88, message2=0x7f5a5cb19e80, type=0x7f5a5cb19e78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=6) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 40 (Thread 0x7f5a5c119710 (LWP 17178)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b3f0, reset_sig_count=743) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=7, message1=0x7f5a5c118e88, message2=0x7f5a5c118e80, type=0x7f5a5c118e78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=7) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 39 (Thread 0x7f5a5b718710 (LWP 17179)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b480, reset_sig_count=213) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=8, message1=0x7f5a5b717e88, message2=0x7f5a5b717e80, type=0x7f5a5b717e78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=8) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x7f5a5ad17710 (LWP 17180)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x176b510, reset_sig_count=181) at os/os0sync.c:399 #2 0x00007f5a6d002a97 in os_aio_simulated_handle (global_segment=9, message1=0x7f5a5ad16e88, message2=0x7f5a5ad16e80, type=0x7f5a5ad16e78) at os/os0file.c:4198 #3 0x00007f5a6cfbe5ec in fil_aio_wait (segment=9) at fil/fil0fil.c:4485 #4 0x00007f5a6d051d25 in io_handler_thread (arg=) at srv/srv0start.c:474 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x7f5a59269710 (LWP 17182)): #0 0x00000030e14da043 in select () from /lib64/libc.so.6 #1 0x00007f5a6d00572b in os_thread_sleep (tm=) at os/os0thread.c:295 #2 0x00007f5a6d04cc7a in srv_lock_timeout_thread (arg=) at srv/srv0srv.c:2148 #3 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #4 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x7f5a58868710 (LWP 17183)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=31) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d074cd9 "buf/buf0lru.c", line=1851) at sync/sync0sync.c:609 #4 0x00007f5a6cf9f607 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_LRU_stat_update () at buf/buf0lru.c:1851 #6 0x00007f5a6d04cf48 in srv_error_monitor_thread (arg=) at srv/srv0srv.c:2286 #7 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #8 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7f5a57e67710 (LWP 17184)): #0 0x00000030e14da043 in select () from /lib64/libc.so.6 #1 0x00007f5a6d00572b in os_thread_sleep (tm=) at os/os0thread.c:295 #2 0x00007f5a6d04d7e8 in srv_monitor_thread (arg=) at srv/srv0srv.c:2006 #3 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #4 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7f5a59c6a710 (LWP 17185)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x17ac060, reset_sig_count=295) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=7) at sync/sync0arr.c:451 #3 0x00007f5a6d05380f in rw_lock_s_lock_spin (lock=0x7f5a5fd45828, pass=, file_name=0x7f5a6d074770 "buf/buf0flu.c", line=1171) at sync/sync0rw.c:442 #4 0x00007f5a6cf9e990 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at ./include/sync0rw.ic:418 #5 buf_flush_page (flush_type=, bpage=) at buf/buf0flu.c:1170 #6 buf_flush_try_neighbors (flush_type=, offset=, space=) at buf/buf0flu.c:1309 #7 buf_flush_batch (flush_type=BUF_FLUSH_LIST, min_n=200, lsn_limit=18446744073709551615) at buf/buf0flu.c:1424 #8 0x00007f5a6d04e5af in srv_master_thread (arg=) at srv/srv0srv.c:2593 #9 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #10 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7f5a6c099710 (LWP 17186)): #0 0x00000030e180f1e5 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000005e4f8b in signal_hand (arg=) at mysqld.cc:2823 #2 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #3 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7f5a5a14f710 (LWP 17256)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=26) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=199, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a5a14c180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1b1d388, mtr=0x7f5a5a14c180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1ba0780 "", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1ba0590, buf=0x1ba0780 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x7f5a2c00a398) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x7f5a2c00dc50, join_tab=0x7f5a2c00a318, end_of_records=26) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x7f5a2c00dc50, fields=0x1b64028, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x7f5a2c00dc50) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b62070, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7f5a2c0099e0, unit=0x1b63af8, select_lex=0x1b63f20) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b62070, lex=0x1b63a58, result=0x7f5a2c0099e0, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b62070, all_tables=0x7f5a2c0092d0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b62070) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b62070, rawbuf=0x7f5a2c0090e0 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a5a14ede0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b62070, packet=0x1b4f665 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b62070) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7f5a5a00a710 (LWP 17260)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=17) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a007180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1b0e138, mode=4, latch_mode=1, cursor=0x1afcda8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a007180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b903a0 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b901b0, buf=0x1b903a0 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b807d8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1cb64d0, join_tab=0x1b80758, end_of_records=17) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1cb64d0, fields=0x1afc378, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cb64d0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1afa3c0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b7fc38, unit=0x1afbe48, select_lex=0x1afc270) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1afa3c0, lex=0x1afbda8, result=0x1b7fc38, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1afa3c0, all_tables=0x1b7f0c0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1afa3c0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1afa3c0, rawbuf=0x1b7eec0 "select * from test.t1 where a=@a and b=@b", length=41, found_semicolon=0x7f5a5a009de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1afa3c0, packet=0x1b5dc45 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1afa3c0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7f5a5715a710 (LWP 17263)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=11) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a57157180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1bdb0c8, mode=4, latch_mode=1, cursor=0x1ba1338, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a57157180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b419a0 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b417b0, buf=0x1b419a0 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b5c048) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1c91ad0, join_tab=0x1b5bfc8, end_of_records=4) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1c91ad0, fields=0x1b8c2e8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1c91ad0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b8a330, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b5b690, unit=0x1b8bdb8, select_lex=0x1b8c1e0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b8a330, lex=0x1b8bd18, result=0x1b5b690, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b8a330, all_tables=0x1b5af80) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b8a330) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b8a330, rawbuf=0x1b5ad90 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a57159de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b8a330, packet=0x1b53a95 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b8a330) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7f5a5a0cd710 (LWP 17265)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=21) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=132, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a5a0ca180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1c12758, mtr=0x7f5a5a0ca180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1c159c0 "Z\006\063\064\061\067\062\066Z\177", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c157d0, buf=0x1c159c0 "Z\006\063\064\061\067\062\066Z\177", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b7cdd8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d883e0, join_tab=0x1b7cd58, end_of_records=21) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d883e0, fields=0x1b47468, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d883e0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b454b0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b7c420, unit=0x1b46f38, select_lex=0x1b47360) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b454b0, lex=0x1b46e98, result=0x1b7c420, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b454b0, all_tables=0x1b7bd10) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b454b0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b454b0, rawbuf=0x1b7bb20 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a5a0ccde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b454b0, packet=0x1b47e25 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b454b0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7f5a57425710 (LWP 17267)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=10) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=51, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a57422180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1b967b8, mtr=0x7f5a57422180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1c8a950 "\216\006\071\066\067\062\064\066\217\353f|_*\233A\217\353f|] \006\062\065\062\062\060\064", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c8a760, buf=0x1c8a950 "\216\006\071\066\067\062\064\066\217\353f|_*\233A\217\353f|] \006\062\065\062\062\060\064", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b6e648) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1cdb120, join_tab=0x1b6e5c8, end_of_records=true) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1cdb120, fields=0x1b72708, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cdb120) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b70750, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b6dc90, unit=0x1b721d8, select_lex=0x1b72600) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b70750, lex=0x1b72138, result=0x1b6dc90, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b70750, all_tables=0x1b6d580) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b70750) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b70750, rawbuf=0x1b6d390 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a57424de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b70750, packet=0x1b730c5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b70750) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7f5a57466710 (LWP 17269)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=25) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=25, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a57463180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1bcab28, mtr=0x7f5a57463180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1cf9ec0 "", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1cf9cd0, buf=0x1cf9ec0 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b2ace8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1cbb6f0, join_tab=0x1b2ac68, end_of_records=25) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1cbb6f0, fields=0x1b1f918, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cbb6f0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b1d960, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b2a330, unit=0x1b1f3e8, select_lex=0x1b1f810) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b1d960, lex=0x1b1f348, result=0x1b2a330, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b1d960, all_tables=0x1b29c20) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b1d960) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b1d960, rawbuf=0x1b29a30 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a57465de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b1d960, packet=0x1b21a05 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b1d960) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7f5a57321710 (LWP 17271)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=18) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5731e180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1c28aa8, mode=4, latch_mode=1, cursor=0x1c28828, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5731e180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1bda360 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1bda170, buf=0x1bda360 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b3bc88) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1c7dde0, join_tab=0x1b3bc08, end_of_records=18) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1c7dde0, fields=0x1b319d8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1c7dde0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b2fa20, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b3b110, unit=0x1b314a8, select_lex=0x1b318d0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b2fa20, lex=0x1b31408, result=0x1b3b110, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b2fa20, all_tables=0x1b3a5c0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b2fa20) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b2fa20, rawbuf=0x1b3a3c0 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a57320de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b2fa20, packet=0x1b32395 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b2fa20) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7f5a5a253710 (LWP 17273)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=30) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a250180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1d3b188, mode=4, latch_mode=1, cursor=0x1cc5cf8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a250180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1c4ab80 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c4a990, buf=0x1c4ab80 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1b9ce68) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1caf080, join_tab=0x1b9cde8, end_of_records=27) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1caf080, fields=0x1b2e7e8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1caf080) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b2c830, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1b9c4b0, unit=0x1b2e2b8, select_lex=0x1b2e6e0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b2c830, lex=0x1b2e218, result=0x1b9c4b0, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b2c830, all_tables=0x1b9bda0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b2c830) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b2c830, rawbuf=0x1b9bbb0 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a5a252de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b2c830, packet=0x1b91b95 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b2c830) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7f5a5729f710 (LWP 17275)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=23) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5729c180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1cd2448, mode=4, latch_mode=1, cursor=0x1cd21c8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5729c180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1cb62d0 "\230\006\066\067\066\061\071\063\230\201@\225j\221\343=\254\201@\225]\273\006\071\065\063\063\060\066", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1cb60e0, buf=0x1cb62d0 "\230\006\066\067\066\061\071\063\230\201@\225j\221\343=\254\201@\225]\273\006\071\065\063\063\060\066", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1baced8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d0cb10, join_tab=0x1bace58, end_of_records=23) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d0cb10, fields=0x1b1b938, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d0cb10) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1b19980, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1bac360, unit=0x1b1b408, select_lex=0x1b1b830) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1b19980, lex=0x1b1b368, result=0x1bac360, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1b19980, all_tables=0x1bab810) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1b19980) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1b19980, rawbuf=0x1bab610 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a5729ede0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1b19980, packet=0x1ba35e5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1b19980) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7f5a5a1d1710 (LWP 17277)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=8) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a1ce180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1bb7f68, mode=4, latch_mode=1, cursor=0x1bf1748, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a1ce180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1c07760 "\230\006\061\064\062\061\061\062\231?s\211]!\031B>\326r\211^)\006\067\070\061\061\062\066", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c07570, buf=0x1c07760 "\230\006\061\064\062\061\061\062\231?s\211]!\031B>\326r\211^)\006\067\070\061\061\062\066", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1bed3c8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d8a3d0, join_tab=0x1bed348, end_of_records=255) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d8a3d0, fields=0x1bdd4c8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d8a3d0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1bdb510, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1beca10, unit=0x1bdcf98, select_lex=0x1bdd3c0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1bdb510, lex=0x1bdcef8, result=0x1beca10, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1bdb510, all_tables=0x1bec300) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1bdb510) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1bdb510, rawbuf=0x1bec110 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a5a1d0de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1bdb510, packet=0x1c08115 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1bdb510) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7f5a5a04b710 (LWP 17279)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=5) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a048180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x7f5a2c007228, mode=4, latch_mode=1, cursor=0x7f5a2c006fa8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a048180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x7f5a2c017330 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x7f5a2c017140, buf=0x7f5a2c017330 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1c00018) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d8c3c0, join_tab=0x1bfff98, end_of_records=16) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d8c3c0, fields=0x1bf6378, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d8c3c0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1bf43c0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1bff660, unit=0x1bf5e48, select_lex=0x1bf6270) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1bf43c0, lex=0x1bf5da8, result=0x1bff660, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1bf43c0, all_tables=0x1bfef50) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1bf43c0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1bf43c0, rawbuf=0x1bfed60 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a5a04ade0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1bf43c0, packet=0x1bf6d35 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1bf43c0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7f5a5719b710 (LWP 17281)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=29) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a57198150) at buf/buf0buf.c:1698 #6 0x00007f5a6cf8ba80 in btr_cur_open_at_index_side_func (from_left=1, index=0x7f5a2c0088f8, latch_mode=1, cursor=0x1c53778, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a57198150) at btr/btr0cur.c:745 #7 0x00007f5a6d03b383 in btr_pcur_open_at_index_side (from_left=24641188, index=0x80, latch_mode=819720, pcur=0x1c53778, do_init=, mtr=) at ./include/btr0pcur.ic:577 #8 0x00007f5a6d03eadb in row_search_for_mysql (buf=0x1c65110 "\n\006\066\061\071\067\062\071\025", mode=1, prebuilt=, match_mode=0, direction=0) at row/row0sel.c:3888 #9 0x00007f5a6cfd5c55 in ha_innodb::index_read (this=0x1c64f20, buf=0x1c65110 "\n\006\066\061\071\067\062\071\025", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at handler/ha_innodb.cc:5460 #10 0x00007f5a6cfd3107 in ha_innodb::index_first (this=0x1c64f20, buf=0x1c65110 "\n\006\066\061\071\067\062\071\025") at handler/ha_innodb.cc:5762 #11 0x000000000064cdaa in join_read_first (tab=0x1bbd878) at sql_select.cc:12208 #12 0x0000000000646fd5 in sub_select (join=0x1cfac50, join_tab=0x80, end_of_records=8) at sql_select.cc:11458 #13 0x000000000064ad5d in do_select (join=0x1cfac50, fields=0x1bd3cd8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cfac50) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1bd1d20, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1bbcf40, unit=0x1bd37a8, select_lex=0x1bd3bd0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1bd1d20, lex=0x1bd3708, result=0x1bbcf40, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1bd1d20, all_tables=0x1bbc830) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1bd1d20) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1bd1d20, rawbuf=0x1bbc640 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a5719ade0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1bd1d20, packet=0x1bd4695 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1bd1d20) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7f5a571dc710 (LWP 17283)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=16) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a571d9180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1b4e978, mode=4, latch_mode=1, cursor=0x1b91988, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a571d9180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b0ecf0 "\236\006\065\064\060\066\060\064\237\031\245\221\\D\314\t\366N\244\221\247\372\006\071\067\063\062\070\060", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b0eb00, buf=0x1b0ecf0 "\236\006\065\064\060\066\060\064\237\031\245\221\\D\314\t\366N\244\221\247\372\006\071\067\063\062\070\060", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1bd1098) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d75150, join_tab=0x1bd1018, end_of_records=11) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d75150, fields=0x1c02d28, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d75150) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c00d70, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1bd0520, unit=0x1c027f8, select_lex=0x1c02c20) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c00d70, lex=0x1c02758, result=0x1bd0520, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c00d70, all_tables=0x1bcf9d0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c00d70) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c00d70, rawbuf=0x1bcf7d0 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a571dbde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c00d70, packet=0x1bc57b5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c00d70) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f5a5721d710 (LWP 17285)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=12) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=122, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5721a180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1c10ab8, mode=4, latch_mode=1, cursor=0x1c04b68, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5721a180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1c04900 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c04710, buf=0x1c04900 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1c230a8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1c8ec30, join_tab=0x1c23028, end_of_records=5) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1c8ec30, fields=0x1c18df8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1c8ec30) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c16e40, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c22530, unit=0x1c188c8, select_lex=0x1c18cf0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c16e40, lex=0x1c18828, result=0x1c22530, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c16e40, all_tables=0x1c219e0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c16e40) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c16e40, rawbuf=0x1c217e0 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a5721cde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c16e40, packet=0x1c197b5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c16e40) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f5a5a08c710 (LWP 17287)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=19) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a089180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x7f5a2c018798, mode=4, latch_mode=1, cursor=0x7f5a2c012038, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a5a089180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x7f5a2c0118e0 "f\006\065\070\067\066\066\071\061\002t1\001a\001a\f!", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x7f5a2c0116f0, buf=0x7f5a2c0118e0 "f\006\065\070\067\066\066\071\061\002t1\001a\001a\f!", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1c3c198) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d63450, join_tab=0x1c3c118, end_of_records=19) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d63450, fields=0x1c2fdc8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d63450) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c2de10, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c3b620, unit=0x1c2f898, select_lex=0x1c2fcc0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c2de10, lex=0x1c2f7f8, result=0x1c3b620, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c2de10, all_tables=0x1c3aad0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c2de10) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c2de10, rawbuf=0x1c3a8d0 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a5a08bde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c2de10, packet=0x1c30ba5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c2de10) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f5a5a190710 (LWP 17289)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=27) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5a18d150) at buf/buf0buf.c:1698 #6 0x00007f5a6cf8ba80 in btr_cur_open_at_index_side_func (from_left=1, index=0x7f5a2c0088f8, latch_mode=1, cursor=0x1ca45f8, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5a18d150) at btr/btr0cur.c:745 #7 0x00007f5a6d03b383 in btr_pcur_open_at_index_side (from_left=24641188, index=0x80, latch_mode=819714, pcur=0x1ca45f8, do_init=, mtr=) at ./include/btr0pcur.ic:577 #8 0x00007f5a6d03eadb in row_search_for_mysql (buf=0x1ca3d30 "", mode=1, prebuilt=, match_mode=0, direction=0) at row/row0sel.c:3888 #9 0x00007f5a6cfd5c55 in ha_innodb::index_read (this=0x1ca3b40, buf=0x1ca3d30 "", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at handler/ha_innodb.cc:5460 #10 0x00007f5a6cfd3107 in ha_innodb::index_first (this=0x1ca3b40, buf=0x1ca3d30 "") at handler/ha_innodb.cc:5762 #11 0x000000000064cdaa in join_read_first (tab=0x1c2a0a8) at sql_select.cc:12208 #12 0x0000000000646fd5 in sub_select (join=0x1cdd110, join_tab=0x80, end_of_records=2) at sql_select.cc:11458 #13 0x000000000064ad5d in do_select (join=0x1cdd110, fields=0x1c41ab8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cdd110) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c3fb00, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c29770, unit=0x1c41588, select_lex=0x1c419b0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c3fb00, lex=0x1c414e8, result=0x1c29770, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c3fb00, all_tables=0x1c29060) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c3fb00) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c3fb00, rawbuf=0x1c28e70 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a5a18fde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c3fb00, packet=0x1c42475 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c3fb00) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7f5a59fc9710 (LWP 17291)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=14) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a59fc6150) at buf/buf0buf.c:1698 #6 0x00007f5a6cf8ba80 in btr_cur_open_at_index_side_func (from_left=1, index=0x7f5a2c0088f8, latch_mode=1, cursor=0x1c5ddf8, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a59fc6150) at btr/btr0cur.c:745 #7 0x00007f5a6d03b383 in btr_pcur_open_at_index_side (from_left=24641188, index=0x80, latch_mode=819719, pcur=0x1c5ddf8, do_init=, mtr=) at ./include/btr0pcur.ic:577 #8 0x00007f5a6d03eadb in row_search_for_mysql (buf=0x1baf810 "\024\006\066\061\071\067\062\071", mode=1, prebuilt=, match_mode=0, direction=0) at row/row0sel.c:3888 #9 0x00007f5a6cfd5c55 in ha_innodb::index_read (this=0x1baf620, buf=0x1baf810 "\024\006\066\061\071\067\062\071", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at handler/ha_innodb.cc:5460 #10 0x00007f5a6cfd3107 in ha_innodb::index_first (this=0x1baf620, buf=0x1baf810 "\024\006\066\061\071\067\062\071") at handler/ha_innodb.cc:5762 #11 0x000000000064cdaa in join_read_first (tab=0x1c63348) at sql_select.cc:12208 #12 0x0000000000646fd5 in sub_select (join=0x1ce9a60, join_tab=0x80, end_of_records=7) at sql_select.cc:11458 #13 0x000000000064ad5d in do_select (join=0x1ce9a60, fields=0x1c55a88, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1ce9a60) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c53ad0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c62a10, unit=0x1c55558, select_lex=0x1c55980) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c53ad0, lex=0x1c554b8, result=0x1c62a10, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c53ad0, all_tables=0x1c62300) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c53ad0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c53ad0, rawbuf=0x1c62110 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a59fc8de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c53ad0, packet=0x1c56865 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c53ad0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f5a5725e710 (LWP 17293)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=24) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=23, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a5725b180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1d3a4e8, mtr=0x7f5a5725b180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1d3a280 "", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1d3a090, buf=0x1d3a280 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1c76bd8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d8e3b0, join_tab=0x1c76b58, end_of_records=24) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d8e3b0, fields=0x1bc3598, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d8e3b0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1bc15e0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c76220, unit=0x1bc3068, select_lex=0x1bc3490) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1bc15e0, lex=0x1bc2fc8, result=0x1c76220, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1bc15e0, all_tables=0x1c75b10) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1bc15e0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1bc15e0, rawbuf=0x1c75920 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a5725dde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1bc15e0, packet=0x1c6d8f5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1bc15e0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f5a572e0710 (LWP 17295)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=9) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a572dd180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1c2c678, mode=4, latch_mode=1, cursor=0x1bd9e48, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a572dd180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1c3d1f0 "\212\006\067\071\064\063\070\071\374\031h|\256\322aB\nfd\030M\020\005\065\067\071\062\060\061", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1c3d000, buf=0x1c3d1f0 "\212\006\067\071\064\063\070\071\374\031h|\256\322aB\nfd\030M\020\005\065\067\071\062\060\061", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1c4fc58) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d3ba80, join_tab=0x1c4fbd8, end_of_records=false) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d3ba80, fields=0x1c81d78, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d3ba80) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c7fdc0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c4f0b8, unit=0x1c81848, select_lex=0x1c81c70) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c7fdc0, lex=0x1c817a8, result=0x1c4f0b8, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c7fdc0, all_tables=0x1c4e540) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c7fdc0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c7fdc0, rawbuf=0x1c4e340 "select * from test.t1 where a=@a and b=@b", length=41, found_semicolon=0x7f5a572dfde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c7fdc0, packet=0x1c82735 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c7fdc0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f5a5a316710 (LWP 17297)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=15) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d0897fb "row/row0ins.c", line=2012, mtr=0x7f5a5a313410) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1c27498, mode=4, latch_mode=2, cursor=0x7f5a5a313cb0, has_search_latch=0, file=0x7f5a6d0897fb "row/row0ins.c", line=2012, mtr=0x7f5a5a313410) at btr/btr0cur.c:535 #7 0x00007f5a6d02ab45 in row_ins_index_entry_low (mode=2, index=0x7f5a2c0080d8, entry=0x1c27498, n_ext=0, thr=0x1c3dc38) at row/row0ins.c:2010 #8 0x00007f5a6d02c0e7 in row_ins_index_entry (thr=, foreign=, n_ext=, entry=, index=) at row/row0ins.c:2216 #9 row_ins_index_entry_step (thr=, node=) at row/row0ins.c:2301 #10 row_ins (thr=, node=) at row/row0ins.c:2433 #11 row_ins_step (thr=0x1c3dc38) at row/row0ins.c:2543 #12 0x00007f5a6d034d7e in row_insert_for_mysql (mysql_rec=0x1c30980 "\376\006\064\067\071\065\062\063", prebuilt=0x1c3e8c8) at row/row0mysql.c:1148 #13 0x00007f5a6cfdacf4 in ha_innodb::write_row (this=0x1c30790, record=0x1c30980 "\376\006\064\067\071\065\062\063") at handler/ha_innodb.cc:4763 #14 0x00000000006d99a7 in handler::ha_write_row (this=0x1c30790, buf=0x1c30980 "\376\006\064\067\071\065\062\063") at handler.cc:4681 #15 0x0000000000664aad in write_record (thd=0x1c77930, table=0x1c35bd0, info=0x7f5a5a3140e0) at sql_insert.cc:1605 #16 0x0000000000668952 in mysql_insert (thd=0x1c77930, table_list=0x1c98828, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at sql_insert.cc:836 #17 0x00000000005f65df in mysql_execute_command (thd=0x1c77930) at sql_parse.cc:3270 #18 0x00000000005fb510 in mysql_parse (thd=0x1c77930, rawbuf=0x1c98720 "insert ignore into test.t1 set a=@a+2,b=@b+2", length=44, found_semicolon=0x7f5a5a315de0) at sql_parse.cc:6090 #19 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c77930, packet=0x1c68295 "insert ignore into test.t1 set a=@a+2,b=@b+2", packet_length=) at sql_parse.cc:1277 #20 0x00000000005fcdc6 in do_command (thd=0x1c77930) at sql_parse.cc:891 #21 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #22 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #23 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f5a59f47710 (LWP 17299)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=22) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a59f44180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1b20fc8, mode=4, latch_mode=1, cursor=0x1b20d48, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a59f44180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b772d0 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b770e0, buf=0x1b772d0 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1cae318) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d2cb40, join_tab=0x1cae298, end_of_records=22) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d2cb40, fields=0x1ca8688, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d2cb40) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1ca66d0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1cad960, unit=0x1ca8158, select_lex=0x1ca8580) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1ca66d0, lex=0x1ca80b8, result=0x1cad960, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1ca66d0, all_tables=0x1cad250) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1ca66d0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1ca66d0, rawbuf=0x1cad060 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a59f46de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1ca66d0, packet=0x1ca9045 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1ca66d0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f5a6c058710 (LWP 17301)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=2) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a6c055180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1bf3588, mode=4, latch_mode=1, cursor=0x1d20c28, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a6c055180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1ce2d70 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1ce2b80, buf=0x1ce2d70 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1ccd918) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1cb9580, join_tab=0x1ccd898, end_of_records=13) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1cb9580, fields=0x1cb5718, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1cb9580) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1cb3760, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1cccda0, unit=0x1cb51e8, select_lex=0x1cb5610) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1cb3760, lex=0x1cb5148, result=0x1cccda0, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1cb3760, all_tables=0x1ccc250) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1cb3760) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1cb3760, rawbuf=0x1ccc050 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a6c057de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1cb3760, packet=0x1cbde75 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1cb3760) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f5a57362710 (LWP 17303)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=20) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5735f150) at buf/buf0buf.c:1698 #6 0x00007f5a6cf8ba80 in btr_cur_open_at_index_side_func (from_left=1, index=0x7f5a2c0088f8, latch_mode=1, cursor=0x1bb1a68, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5735f150) at btr/btr0cur.c:745 #7 0x00007f5a6d03b383 in btr_pcur_open_at_index_side (from_left=24641188, index=0x80, latch_mode=819732, pcur=0x1bb1a68, do_init=, mtr=) at ./include/btr0pcur.ic:577 #8 0x00007f5a6d03eadb in row_search_for_mysql (buf=0x1b58060 "0\006\066\061\071\067\062\071", mode=1, prebuilt=, match_mode=0, direction=0) at row/row0sel.c:3888 #9 0x00007f5a6cfd5c55 in ha_innodb::index_read (this=0x1b57e70, buf=0x1b58060 "0\006\066\061\071\067\062\071", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at handler/ha_innodb.cc:5460 #10 0x00007f5a6cfd3107 in ha_innodb::index_first (this=0x1b57e70, buf=0x1b58060 "0\006\066\061\071\067\062\071") at handler/ha_innodb.cc:5762 #11 0x000000000064cdaa in join_read_first (tab=0x1c9e708) at sql_select.cc:12208 #12 0x0000000000646fd5 in sub_select (join=0x1d6f480, join_tab=0x80, end_of_records=20) at sql_select.cc:11458 #13 0x000000000064ad5d in do_select (join=0x1d6f480, fields=0x1c9c6e8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d6f480) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1c9a730, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1c9ddd0, unit=0x1c9c1b8, select_lex=0x1c9c5e0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1c9a730, lex=0x1c9c118, result=0x1c9ddd0, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1c9a730, all_tables=0x1c9d6c0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1c9a730) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1c9a730, rawbuf=0x1c9d4d0 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a57361de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1c9a730, packet=0x1cd30f5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1c9a730) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f5a59f88710 (LWP 17305)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=4) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a59f85180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1b6a948, mode=4, latch_mode=1, cursor=0x1b6a6c8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a59f85180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b695a0 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b693b0, buf=0x1b695a0 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1cf1508) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d0eb00, join_tab=0x1cf1488, end_of_records=15) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d0eb00, fields=0x1ce5088, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d0eb00) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1ce30d0, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1cf0b50, unit=0x1ce4b58, select_lex=0x1ce4f80) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1ce30d0, lex=0x1ce4ab8, result=0x1cf0b50, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1ce30d0, all_tables=0x1cf0440) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1ce30d0) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1ce30d0, rawbuf=0x1cf0250 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a59f87de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1ce30d0, packet=0x1ce5a45 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1ce30d0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f5a5a10e710 (LWP 17307)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=3) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=199, rw_latch=1, guess=0x0, mode=10, file=0x7f5a6d073228 "btr/btr0pcur.c", line=393, mtr=0x7f5a5a10b180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf902a7 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at ./include/btr0btr.ic:55 #7 btr_pcur_move_to_next_page (cursor=0x1b9f968, mtr=0x7f5a5a10b180) at btr/btr0pcur.c:392 #8 0x00007f5a6d03d9f1 in btr_pcur_move_to_next (cursor=0x177fea4, mtr=0x80) at ./include/btr0pcur.ic:387 #9 0x00007f5a6d03e193 in row_search_for_mysql (buf=0x1b878a0 "Z\006\071\065\061\063\061\070Z\177", mode=1, prebuilt=, match_mode=0, direction=1) at row/row0sel.c:4588 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b876b0, buf=0x1b878a0 "Z\006\071\065\061\063\061\070Z\177", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1d08e98) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d7cab0, join_tab=0x1d08e18, end_of_records=14) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d7cab0, fields=0x1cfebe8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d7cab0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1cfcc30, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1d08320, unit=0x1cfe6b8, select_lex=0x1cfeae0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1cfcc30, lex=0x1cfe618, result=0x1d08320, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1cfcc30, all_tables=0x1d077d0) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1cfcc30) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1cfcc30, rawbuf=0x1d075d0 "select * from test.t1 where a=@a or b=@b", length=40, found_semicolon=0x7f5a5a10dde0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1cfcc30, packet=0x1cff5a5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1cfcc30) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f5a573e4710 (LWP 17309)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=1) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a573e1180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1b40308, mode=4, latch_mode=1, cursor=0x1b40088, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a573e1180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1b3f560 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1b3f370, buf=0x1b3f560 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1d1fcd8) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d4e9b0, join_tab=0x1d1fc58, end_of_records=12) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d4e9b0, fields=0x1d16038, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d4e9b0) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1d14080, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1d1f320, unit=0x1d15b08, select_lex=0x1d15f30) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1d14080, lex=0x1d15a68, result=0x1d1f320, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1d14080, all_tables=0x1d1ec10) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1d14080) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1d14080, rawbuf=0x1d1ea20 "select * from test.t1 where a=@a", length=32, found_semicolon=0x7f5a573e3de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1d14080, packet=0x1d169f5 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1d14080) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f5a5a294710 (LWP 17311)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=0) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5a291150) at buf/buf0buf.c:1698 #6 0x00007f5a6cf8ba80 in btr_cur_open_at_index_side_func (from_left=1, index=0x7f5a2c0088f8, latch_mode=1, cursor=0x1c0c198, file=0x7f5a6d077706 "./include/btr0pcur.ic", line=578, mtr=0x7f5a5a291150) at btr/btr0cur.c:745 #7 0x00007f5a6d03b383 in btr_pcur_open_at_index_side (from_left=24641188, index=0x80, latch_mode=819721, pcur=0x1c0c198, do_init=, mtr=) at ./include/btr0pcur.ic:577 #8 0x00007f5a6d03eadb in row_search_for_mysql (buf=0x1c56640 "", mode=1, prebuilt=, match_mode=0, direction=0) at row/row0sel.c:3888 #9 0x00007f5a6cfd5c55 in ha_innodb::index_read (this=0x1c56450, buf=0x1c56640 "", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at handler/ha_innodb.cc:5460 #10 0x00007f5a6cfd3107 in ha_innodb::index_first (this=0x1c56450, buf=0x1c56640 "") at handler/ha_innodb.cc:5762 #11 0x000000000064cdaa in join_read_first (tab=0x1d735a0) at sql_select.cc:12208 #12 0x0000000000646fd5 in sub_select (join=0x1d35e28, join_tab=0x80, end_of_records=9) at sql_select.cc:11458 #13 0x000000000064ad5d in do_select (join=0x1d35e28, fields=0x1d37498, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d35e28) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1d22d90, rref_pointer_array=, tables=, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1d35e08, unit=0x1d24818, select_lex=0x1d24c40) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1d22d90, lex=0x1d24778, result=0x1d35e08, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1d22d90, all_tables=0x1d35a40) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1d22d90) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1d22d90, rawbuf=0x1d357b0 "select count(*) from test.t1", length=28, found_semicolon=0x7f5a5a293de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1d22d90, packet=0x1d25705 "\036", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1d22d90) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f5a5a212710 (LWP 17313)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=28) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0718db "./include/buf0buf.ic", line=787) at sync/sync0sync.c:609 #4 0x00007f5a6cffbbb4 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_block_free (block=) at ./include/buf0buf.ic:787 #6 mem_heap_block_free (heap=, block=0x7f5a605ec000) at mem/mem0mem.c:515 #7 0x00007f5a6cfd0918 in ha_remove_all_nodes_to_page (table=0x1ae06d8, fold=, page=0x7f5a60684000 "ޭ\276", ) at ha/ha0ha.c:333 #8 0x00007f5a6cf92d46 in btr_search_drop_page_hash_index (block=0x7f5a5fd45770) at btr/btr0sea.c:1143 #9 0x00007f5a6cf98323 in buf_pool_drop_hash_index () at buf/buf0buf.c:1035 #10 0x00007f5a6cf92351 in btr_search_disable () at btr/btr0sea.c:212 #11 0x000000000075fe95 in sys_var_pluginvar::update (this=0x12c7f90, thd=0x1d3fa50, var=0x1d4a550) at sql_plugin.cc:2865 #12 0x00000000005fe215 in set_var::update (this=0x1d4a550, thd=0x1d3fa50) at set_var.cc:3613 #13 0x00000000006085c9 in sql_set_variables (thd=0x1d3fa50, var_list=0x1d41e30) at set_var.cc:3488 #14 0x00000000005f5cd4 in mysql_execute_command (thd=0x1d3fa50) at sql_parse.cc:3573 #15 0x00000000005fb510 in mysql_parse (thd=0x1d3fa50, rawbuf=0x1d4a3f0 "set global innodb_adaptive_hash_index=0", length=39, found_semicolon=0x7f5a5a211de0) at sql_parse.cc:6090 #16 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1d3fa50, packet=0x1d423c5 "set global innodb_adaptive_hash_index=0", packet_length=) at sql_parse.cc:1277 #17 0x00000000005fcdc6 in do_command (thd=0x1d3fa50) at sql_parse.cc:891 #18 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #19 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #20 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f5a5a2d5710 (LWP 17315)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x17b18b0, reset_sig_count=344) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=6) at sync/sync0arr.c:451 #3 0x00007f5a6d053edd in rw_lock_x_lock_wait (line=, file_name=, lock=) at sync/sync0rw.c:521 #4 rw_lock_x_lock_low (line=, file_name=, pass=, lock=) at sync/sync0rw.c:564 #5 rw_lock_x_lock_func (lock=0x7f5a5fd4a2e8, pass=0, file_name=0x7f5a6d0897fb "row/row0ins.c", line=2012) at sync/sync0rw.c:620 #6 0x00007f5a6cf9aea7 in buf_page_get_gen (space=4, zip_size=0, offset=45, rw_latch=2, guess=0x0, mode=11, file=0x7f5a6d0897fb "row/row0ins.c", line=2012, mtr=0x7f5a5a2d2410) at buf/buf0buf.c:2010 #7 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0088f8, level=0, tuple=0x1cb9028, mode=4, latch_mode=2, cursor=0x7f5a5a2d2cb0, has_search_latch=0, file=0x7f5a6d0897fb "row/row0ins.c", line=2012, mtr=0x7f5a5a2d2410) at btr/btr0cur.c:535 #8 0x00007f5a6d02ab45 in row_ins_index_entry_low (mode=2, index=0x7f5a2c0088f8, entry=0x1cb9028, n_ext=0, thr=0x1cdf8e8) at row/row0ins.c:2010 #9 0x00007f5a6d02c0e7 in row_ins_index_entry (thr=, foreign=, n_ext=, entry=, index=) at row/row0ins.c:2216 #10 row_ins_index_entry_step (thr=, node=) at row/row0ins.c:2301 #11 row_ins (thr=, node=) at row/row0ins.c:2433 #12 row_ins_step (thr=0x1cdf8e8) at row/row0ins.c:2543 #13 0x00007f5a6d034d7e in row_insert_for_mysql (mysql_rec=0x1bde870 "\376\006\065\067\071\071\061\065", prebuilt=0x1cd0578) at row/row0mysql.c:1148 #14 0x00007f5a6cfdacf4 in ha_innodb::write_row (this=0x1bde680, record=0x1bde870 "\376\006\065\067\071\071\061\065") at handler/ha_innodb.cc:4763 #15 0x00000000006d99a7 in handler::ha_write_row (this=0x1bde680, buf=0x1bde870 "\376\006\065\067\071\071\061\065") at handler.cc:4681 #16 0x0000000000664aad in write_record (thd=0x1d54aa0, table=0x1ccfc60, info=0x7f5a5a2d30e0) at sql_insert.cc:1605 #17 0x0000000000668952 in mysql_insert (thd=0x1d54aa0, table_list=0x1d5f548, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at sql_insert.cc:836 #18 0x00000000005f65df in mysql_execute_command (thd=0x1d54aa0) at sql_parse.cc:3270 #19 0x00000000005fb510 in mysql_parse (thd=0x1d54aa0, rawbuf=0x1d5f440 "insert ignore into test.t1 set a=@a,b=@b", length=40, found_semicolon=0x7f5a5a2d4de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1d54aa0, packet=0x1d57415 "insert ignore into test.t1 set a=@a,b=@b", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1d54aa0) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f5a573a3710 (LWP 17317)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f5a6d004b5d in os_event_wait_low (event=0x177fe60, reset_sig_count=28129) at os/os0sync.c:399 #2 0x00007f5a6d0532af in sync_array_wait_event (arr=0x12d1b70, index=13) at sync/sync0arr.c:451 #3 0x00007f5a6d0544bf in mutex_spin_wait (mutex=0x7f5a6d1ae800, file_name=0x7f5a6d0736de "buf/buf0buf.c", line=1698) at sync/sync0sync.c:609 #4 0x00007f5a6cf9a8e8 in mutex_enter_func (line=, file_name=, mutex=) at ./include/sync0sync.ic:221 #5 buf_page_get_gen (space=4, zip_size=0, offset=3, rw_latch=3, guess=0x7f5a5fd4de90, mode=10, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a573a0180) at buf/buf0buf.c:1698 #6 0x00007f5a6cf894af in btr_cur_search_to_nth_level (index=0x7f5a2c0080d8, level=0, tuple=0x1cf3e38, mode=4, latch_mode=1, cursor=0x1cf3bb8, has_search_latch=0, file=0x7f5a6d08dc20 "row/row0sel.c", line=2914, mtr=0x7f5a573a0180) at btr/btr0cur.c:535 #7 0x00007f5a6d03f2ad in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at ./include/btr0pcur.ic:541 #8 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at row/row0sel.c:2912 #9 row_search_for_mysql (buf=0x1ca2f00 "", mode=1, prebuilt=0x0, match_mode=0, direction=1) at row/row0sel.c:4379 #10 0x00007f5a6cfd47bc in ha_innodb::general_fetch (this=0x1ca2d10, buf=0x1ca2f00 "", direction=1, match_mode=4294967295) at handler/ha_innodb.cc:5673 #11 0x000000000064d4f2 in join_read_next (info=0x1d6e718) at sql_select.cc:12222 #12 0x0000000000646ff1 in sub_select (join=0x1d61460, join_tab=0x1d6e698, end_of_records=6) at sql_select.cc:11464 #13 0x000000000064ad5d in do_select (join=0x1d61460, fields=0x1ce21b8, table=0x0, procedure=0x0) at sql_select.cc:11217 #14 0x0000000000660817 in JOIN::exec (this=0x1d61460) at sql_select.cc:2343 #15 0x000000000065c6fd in mysql_select (thd=0x1ce0200, rref_pointer_array=, tables=, wild_num=1, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x1d6dd60, unit=0x1ce1c88, select_lex=0x1ce20b0) at sql_select.cc:2553 #16 0x00000000006621dc in handle_select (thd=0x1ce0200, lex=0x1ce1be8, result=0x1d6dd60, setup_tables_done_option=0) at sql_select.cc:269 #17 0x00000000005f2c5a in execute_sqlcom_select (thd=0x1ce0200, all_tables=0x1d6d650) at sql_parse.cc:5173 #18 0x00000000005f5f9b in mysql_execute_command (thd=0x1ce0200) at sql_parse.cc:2309 #19 0x00000000005fb510 in mysql_parse (thd=0x1ce0200, rawbuf=0x1d6d460 "select * from test.t1 where b=@b", length=32, found_semicolon=0x7f5a573a2de0) at sql_parse.cc:6090 #20 0x00000000005fbcd6 in dispatch_command (command=COM_QUERY, thd=0x1ce0200, packet=0x1d65435 " ", packet_length=) at sql_parse.cc:1277 #21 0x00000000005fcdc6 in do_command (thd=0x1ce0200) at sql_parse.cc:891 #22 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f5a57119710 (LWP 17318)): #0 0x00000030e180e48d in read () from /lib64/libpthread.so.0 #1 0x00000000005d9206 in my_real_read (net=0x1d81b38, complen=0x7f5a57118df0) at net_serv.cc:816 #2 0x00000000005d9825 in my_net_read (net=0x2d) at net_serv.cc:1011 #3 0x00000000005fcd66 in do_command (thd=0x1d81a50) at sql_parse.cc:833 #4 0x00000000005ef386 in handle_one_connection (arg=) at sql_connect.cc:1429 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f5a6e3da700 (LWP 17169)): #0 0x00000030e14da043 in select () from /lib64/libc.so.6 #1 0x00000000005e999d in handle_connections_sockets (arg=) at mysqld.cc:5138 #2 0x00000000005ea5cc in main (argc=, argv=) at mysqld.cc:4622