percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00209
[Bug 326445] Re: XtraDB hangs in 10 threads TPC-C
more info from hang
mysql> show processlist;
+-----+------+-----------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
| 2 | root | | test | Execute | 422 | statistics | SELECT count(*) FROM stock WHERE s_w_id = ? AND s_i_id = ? AND s_quantity < ? |
| 3 | root | | test | Execute | 422 | update | INSERT INTO history(h_c_d_id, h_c_w_id, h_c_id, h_d_id, h_w_id, h_date, h_amount, h_data) VALUES(?, |
| 4 | root | | test | Execute | 422 | Updating | UPDATE orders SET o_carrier_id = ? WHERE o_id = ? AND o_d_id = ? AND o_w_id = ? |
| 5 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 6 | root | | test | Execute | 422 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES(?, ?, ?, |
| 7 | root | | test | Execute | 422 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_ |
| 8 | root | | test | Execute | 422 | Updating | UPDATE order_line SET ol_delivery_d = ? WHERE ol_o_id = ? AND ol_d_id = ? AND ol_w_id = ? |
| 9 | root | | test | Execute | 422 | statistics | SELECT w_street_1, w_street_2, w_city, w_state, w_zip, w_name FROM warehouse WHERE w_id = ? |
| 10 | root | | test | Execute | 422 | statistics | SELECT c_discount, c_last, c_credit, w_tax FROM customer, warehouse WHERE w_id = ? AND c_w_id = w_id |
| 11 | root | | test | Execute | 422 | init | UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? |
| 12 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 13 | root | | test | Execute | 422 | statistics | SELECT c_discount, c_last, c_credit, w_tax FROM customer, warehouse WHERE w_id = ? AND c_w_id = w_id |
| 14 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 15 | root | | test | Execute | 422 | init | UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? |
| 16 | root | | test | Execute | 422 | init | UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? |
| 17 | root | | test | Execute | 422 | update | INSERT INTO history(h_c_d_id, h_c_w_id, h_c_id, h_d_id, h_w_id, h_date, h_amount, h_data) VALUES(?, |
| 18 | root | | test | Execute | 422 | init | UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? |
| 19 | root | | test | Execute | 422 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_ |
| 20 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 22 | root | | test | Execute | 422 | Updating | UPDATE customer SET c_balance = c_balance + ? , c_delivery_cnt = c_delivery_cnt + 1 WHERE c_id = ? A |
| 23 | root | | test | Execute | 422 | Updating | UPDATE district SET d_ytd = d_ytd + ? WHERE d_w_id = ? AND d_id = ? |
| 24 | root | | test | Execute | 422 | statistics | SELECT c_discount, c_last, c_credit, w_tax FROM customer, warehouse WHERE w_id = ? AND c_w_id = w_id |
| 25 | root | | test | Execute | 422 | statistics | SELECT count(c_id) FROM customer WHERE c_w_id = ? AND c_d_id = ? AND c_last = ? |
| 26 | root | | test | Execute | 422 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_ |
| 27 | root | | test | Query | 422 | NULL | commit |
| 28 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 29 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 31 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 32 | root | | test | Execute | 422 | statistics | SELECT count(*) FROM stock WHERE s_w_id = ? AND s_i_id = ? AND s_quantity < ? |
| 33 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 34 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 35 | root | | test | Execute | 422 | init | UPDATE customer SET c_balance = c_balance + ? , c_delivery_cnt = c_delivery_cnt + 1 WHERE c_id = ? A |
| 36 | root | | test | Execute | 422 | init | UPDATE orders SET o_carrier_id = ? WHERE o_id = ? AND o_d_id = ? AND o_w_id = ? |
| 37 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 38 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 39 | root | | test | Execute | 422 | statistics | SELECT count(*) FROM stock WHERE s_w_id = ? AND s_i_id = ? AND s_quantity < ? |
| 40 | root | | test | Execute | 422 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_ |
| 41 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 42 | root | | test | Execute | 422 | Updating | UPDATE orders SET o_carrier_id = ? WHERE o_id = ? AND o_d_id = ? AND o_w_id = ? |
| 43 | root | | test | Execute | 422 | query end | UPDATE district SET d_ytd = d_ytd + ? WHERE d_w_id = ? AND d_id = ? |
| 44 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 45 | root | | test | Execute | 422 | update | INSERT INTO new_orders (no_o_id, no_d_id, no_w_id) VALUES (?,?,?) |
| 46 | root | | test | Execute | 422 | statistics | SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, |
| 47 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 48 | root | | test | Execute | 422 | Updating | UPDATE warehouse SET w_ytd = w_ytd + ? WHERE w_id = ? |
| 49 | root | | test | Execute | 422 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES(?, ?, ?, |
| 50 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 51 | root | | test | Execute | 422 | updating | DELETE FROM new_orders WHERE no_o_id = ? AND no_d_id = ? AND no_w_id = ? |
| 52 | root | | test | Execute | 422 | Updating | UPDATE orders SET o_carrier_id = ? WHERE o_id = ? AND o_d_id = ? AND o_w_id = ? |
| 53 | root | | test | Execute | 422 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, |
| 111 | root | localhost | NULL | Query | 419 | NULL | SHOW ENGINE INNODB STATUS |
| 112 | root | localhost | NULL | Query | 398 | NULL | SHOW ENGINE INNODB STATUS |
| 113 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+-----+------+-----------+------+---------+------+------------+------------------------------------------------------------------------------------------------------+
53 rows in set (0.00 sec)
--
XtraDB hangs in 10 threads TPC-C
https://bugs.launchpad.net/bugs/326445
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.
Status in Percona XtraDB Storage Engine for MySQL: New
Bug description:
(gdb) info threads
20 Thread 0x40a2f950 (LWP 13698) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
19 Thread 0x41776950 (LWP 13699) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
18 Thread 0x41f77950 (LWP 13700) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
17 Thread 0x42778950 (LWP 13701) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
16 Thread 0x4377a950 (LWP 13721) 0x00007ffdc811c482 in select () from /lib/libc.so.6
15 Thread 0x43f7b950 (LWP 13722) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
14 Thread 0x4477c950 (LWP 13723) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
13 Thread 0x447bd950 (LWP 13724) 0x00007ffdc93d4e7b in sigwait () from /lib/libpthread.so.0
12 Thread 0x40a70950 (LWP 13761) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
11 Thread 0x447fe950 (LWP 13763) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
10 Thread 0x4483f950 (LWP 13766) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
9 Thread 0x44880950 (LWP 13768) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
8 Thread 0x448c1950 (LWP 13770) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
7 Thread 0x44902950 (LWP 13771) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
6 Thread 0x44943950 (LWP 13772) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
5 Thread 0x44984950 (LWP 13773) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
4 Thread 0x449c5950 (LWP 13774) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
3 Thread 0x44a06950 (LWP 13775) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
2 Thread 0x40c8c950 (LWP 15994) 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
1 Thread 0x7ffdc97f46f0 (LWP 13695) 0x00007ffdc811c482 in select () from /lib/libc.so.6
(gdb) thread apply all backtrace
Thread 20 (Thread 0x40a2f950 (LWP 13698)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x0000000000794123 in os_aio_simulated_handle ()
#3 0x000000000075db3f in fil_aio_wait ()
#4 0x00000000007d5540 in io_handler_thread ()
#5 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#6 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 19 (Thread 0x41776950 (LWP 13699)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x0000000000794123 in os_aio_simulated_handle ()
#3 0x000000000075db3f in fil_aio_wait ()
#4 0x00000000007d5540 in io_handler_thread ()
#5 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#6 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 18 (Thread 0x41f77950 (LWP 13700)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x0000000000794123 in os_aio_simulated_handle ()
#3 0x000000000075db3f in fil_aio_wait ()
#4 0x00000000007d5540 in io_handler_thread ()
#5 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#6 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 17 (Thread 0x42778950 (LWP 13701)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d97a2 in mutex_spin_wait ()
#4 0x000000000073c1cc in buf_page_io_complete ()
#5 0x000000000075dcb7 in fil_aio_wait ()
#6 0x00000000007d5540 in io_handler_thread ()
#7 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#8 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#9 0x0000000000000000 in ?? ()
Thread 16 (Thread 0x4377a950 (LWP 13721)):
#0 0x00007ffdc811c482 in select () from /lib/libc.so.6
#1 0x0000000000797adb in os_thread_sleep ()
#2 0x00000000007d4435 in srv_lock_timeout_and_monitor_thread ()
#3 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#4 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#5 0x0000000000000000 in ?? ()
Thread 15 (Thread 0x43f7b950 (LWP 13722)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d97a2 in mutex_spin_wait ()
#4 0x00000000007d31eb in srv_error_monitor_thread ()
---Type <return> to continue, or q <return> to quit---
#5 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#6 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 14 (Thread 0x4477c950 (LWP 13723)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d97a2 in mutex_spin_wait ()
#4 0x000000000078607b in log_buffer_flush_to_disk ()
#5 0x00000000007d22b1 in srv_master_thread ()
#6 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#7 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#8 0x0000000000000000 in ?? ()
Thread 13 (Thread 0x447bd950 (LWP 13724)):
#0 0x00007ffdc93d4e7b in sigwait () from /lib/libpthread.so.0
#1 0x000000000059e45b in signal_hand ()
#2 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#3 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#4 0x0000000000000000 in ?? ()
Thread 12 (Thread 0x40a70950 (LWP 13761)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007778fd in ibuf_insert_low ()
#6 0x0000000000778ad5 in ibuf_insert ()
#7 0x000000000072ccf8 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
#9 0x00000000007b4bc7 in row_ins_step ()
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 11 (Thread 0x447fe950 (LWP 13763)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007778fd in ibuf_insert_low ()
#6 0x0000000000778ad5 in ibuf_insert ()
---Type <return> to continue, or q <return> to quit---
#7 0x000000000072ccf8 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
#9 0x00000000007b4bc7 in row_ins_step ()
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 10 (Thread 0x4483f950 (LWP 13766)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x0000000000742732 in buf_flush_buffered_writes ()
#3 0x0000000000743bea in buf_flush_batch ()
#4 0x00000000007444fa in buf_flush_free_margin ()
#5 0x0000000000749e8f in buf_read_page ()
#6 0x000000000073ee3d in buf_page_get_gen ()
#7 0x000000000072ca0e in btr_cur_search_to_nth_level ()
#8 0x00000000007c61b3 in row_search_for_mysql ()
#9 0x000000000071ceda in ha_innobase::index_read ()
#10 0x0000000000686609 in handler::index_read_idx_map ()
#11 0x00000000005ffb65 in join_read_const ()
#12 0x000000000060790d in join_read_const_table ()
#13 0x000000000060cdfe in make_join_statistics ()
#14 0x000000000060e7db in JOIN::optimize ()
#15 0x0000000000611d40 in mysql_select ()
#16 0x000000000061754c in handle_select ()
#17 0x00000000005abecd in execute_sqlcom_select ()
#18 0x00000000005afbc3 in mysql_execute_command ()
#19 0x0000000000622cca in Prepared_statement::execute ()
#20 0x0000000000625c8c in Prepared_statement::execute_loop ()
#21 0x0000000000626365 in mysql_stmt_execute ()
#22 0x00000000005b482e in dispatch_command ()
#23 0x00000000005b5ad6 in do_command ()
#24 0x00000000005a8646 in handle_one_connection ()
#25 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#26 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#27 0x0000000000000000 in ?? ()
Thread 9 (Thread 0x44880950 (LWP 13768)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x000000000072ca0e in btr_cur_search_to_nth_level ()
#6 0x00000000007c5f78 in row_search_for_mysql ()
---Type <return> to continue, or q <return> to quit---
#7 0x000000000071ceda in ha_innobase::index_read ()
#8 0x0000000000686609 in handler::index_read_idx_map ()
#9 0x00000000005ffb65 in join_read_const ()
#10 0x000000000060790d in join_read_const_table ()
#11 0x000000000060cdfe in make_join_statistics ()
#12 0x000000000060e7db in JOIN::optimize ()
#13 0x0000000000611d40 in mysql_select ()
#14 0x000000000061754c in handle_select ()
#15 0x00000000005abecd in execute_sqlcom_select ()
#16 0x00000000005afbc3 in mysql_execute_command ()
#17 0x0000000000622cca in Prepared_statement::execute ()
#18 0x0000000000625c8c in Prepared_statement::execute_loop ()
#19 0x0000000000626365 in mysql_stmt_execute ()
#20 0x00000000005b482e in dispatch_command ()
#21 0x00000000005b5ad6 in do_command ()
#22 0x00000000005a8646 in handle_one_connection ()
#23 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#24 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#25 0x0000000000000000 in ?? ()
Thread 8 (Thread 0x448c1950 (LWP 13770)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007778fd in ibuf_insert_low ()
#6 0x0000000000778ad5 in ibuf_insert ()
#7 0x000000000072ccf8 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
#9 0x00000000007b4bc7 in row_ins_step ()
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 7 (Thread 0x44902950 (LWP 13771)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007778fd in ibuf_insert_low ()
#6 0x0000000000778ad5 in ibuf_insert ()
#7 0x000000000072ccf8 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
---Type <return> to continue, or q <return> to quit---
#9 0x00000000007b4bc7 in row_ins_step ()
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 6 (Thread 0x44943950 (LWP 13772)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d936f in rw_lock_x_lock_func ()
#4 0x0000000000747a9b in buf_LRU_free_block ()
#5 0x0000000000748abe in buf_LRU_search_and_free_block ()
#6 0x0000000000748eea in buf_LRU_try_free_flushed_blocks ()
#7 0x000000000072cf85 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
#9 0x00000000007b4bc7 in row_ins_step ()
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 5 (Thread 0x44984950 (LWP 13773)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d97a2 in mutex_spin_wait ()
#4 0x0000000000785f76 in log_close ()
#5 0x000000000079162c in mtr_commit ()
#6 0x00000000007ca9ce in row_upd_clust_rec ()
#7 0x00000000007ce410 in row_upd_clust_step ()
#8 0x00000000007cee6b in row_upd_step ()
#9 0x00000000007ba416 in row_update_for_mysql ()
#10 0x000000000071ff4b in ha_innobase::update_row ()
#11 0x000000000068a7c8 in handler::ha_update_row ()
---Type <return> to continue, or q <return> to quit---
#12 0x000000000062aac8 in mysql_update ()
#13 0x00000000005afa84 in mysql_execute_command ()
#14 0x0000000000622cca in Prepared_statement::execute ()
#15 0x0000000000625c8c in Prepared_statement::execute_loop ()
#16 0x0000000000626365 in mysql_stmt_execute ()
#17 0x00000000005b482e in dispatch_command ()
#18 0x00000000005b5ad6 in do_command ()
#19 0x00000000005a8646 in handle_one_connection ()
#20 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#21 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#22 0x0000000000000000 in ?? ()
Thread 4 (Thread 0x449c5950 (LWP 13774)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007721e5 in ibuf_bitmap_get_map_page ()
#6 0x0000000000779702 in ibuf_merge_or_delete_for_page ()
#7 0x000000000073c237 in buf_page_io_complete ()
#8 0x00000000007495f7 in buf_read_page_low ()
#9 0x0000000000749e76 in buf_read_page ()
#10 0x000000000073ee3d in buf_page_get_gen ()
#11 0x000000000072ca0e in btr_cur_search_to_nth_level ()
#12 0x00000000007c61b3 in row_search_for_mysql ()
#13 0x000000000071ceda in ha_innobase::index_read ()
#14 0x0000000000686609 in handler::index_read_idx_map ()
#15 0x00000000005ffb65 in join_read_const ()
#16 0x000000000060790d in join_read_const_table ()
#17 0x000000000060cdfe in make_join_statistics ()
#18 0x000000000060e7db in JOIN::optimize ()
#19 0x0000000000611d40 in mysql_select ()
#20 0x000000000061754c in handle_select ()
#21 0x00000000005abecd in execute_sqlcom_select ()
#22 0x00000000005afbc3 in mysql_execute_command ()
#23 0x0000000000622cca in Prepared_statement::execute ()
#24 0x0000000000625c8c in Prepared_statement::execute_loop ()
#25 0x0000000000626365 in mysql_stmt_execute ()
#26 0x00000000005b482e in dispatch_command ()
#27 0x00000000005b5ad6 in do_command ()
#28 0x00000000005a8646 in handle_one_connection ()
#29 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#30 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#31 0x0000000000000000 in ?? ()
Thread 3 (Thread 0x44a06950 (LWP 13775)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d88ca in rw_lock_s_lock_spin ()
#4 0x000000000073e16f in buf_page_get_gen ()
#5 0x00000000007778fd in ibuf_insert_low ()
#6 0x0000000000778ad5 in ibuf_insert ()
#7 0x000000000072ccf8 in btr_cur_search_to_nth_level ()
#8 0x00000000007b3766 in row_ins_index_entry_low ()
#9 0x00000000007b4bc7 in row_ins_step ()
---Type <return> to continue, or q <return> to quit---
#10 0x00000000007bb656 in row_insert_for_mysql ()
#11 0x000000000072095e in ha_innobase::write_row ()
#12 0x000000000068a8a5 in handler::ha_write_row ()
#13 0x0000000000619abc in write_record ()
#14 0x000000000061d865 in mysql_insert ()
#15 0x00000000005af4bb in mysql_execute_command ()
#16 0x0000000000622cca in Prepared_statement::execute ()
#17 0x0000000000625c8c in Prepared_statement::execute_loop ()
#18 0x0000000000626365 in mysql_stmt_execute ()
#19 0x00000000005b482e in dispatch_command ()
#20 0x00000000005b5ad6 in do_command ()
#21 0x00000000005a8646 in handle_one_connection ()
#22 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#23 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#24 0x0000000000000000 in ?? ()
Thread 2 (Thread 0x40c8c950 (LWP 15994)):
#0 0x00007ffdc93d12d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
#1 0x0000000000796f8d in os_event_wait_low ()
#2 0x00000000007d811c in sync_array_wait_event ()
#3 0x00000000007d97a2 in mutex_spin_wait ()
#4 0x00000000007864b3 in log_print ()
#5 0x00000000007d3bb3 in srv_printf_innodb_monitor ()
#6 0x000000000071e076 in innodb_show_status ()
#7 0x000000000068c417 in ha_show_status ()
#8 0x00000000005af951 in mysql_execute_command ()
#9 0x00000000005b43d7 in mysql_parse ()
#10 0x00000000005b4f3b in dispatch_command ()
#11 0x00000000005b5ad6 in do_command ()
#12 0x00000000005a8646 in handle_one_connection ()
#13 0x00007ffdc93cd3ea in start_thread () from /lib/libpthread.so.0
#14 0x00007ffdc8123c6d in clone () from /lib/libc.so.6
#15 0x0000000000000000 in ?? ()
Thread 1 (Thread 0x7ffdc97f46f0 (LWP 13695)):
#0 0x00007ffdc811c482 in select () from /lib/libc.so.6
#1 0x00000000005a2b4d in handle_connections_sockets ()
#2 0x00000000005a36e8 in main ()
#0 0x00007ffdc811c482 in select () from /lib/libc.so.6
References