percona-discussion team mailing list archive

Thread
Date
[Bug 326445] Re: XtraDB hangs in 10 threads TPC-C

To: percona-discussion@xxxxxxxxxxxxxxxxxxx
From: Vadim Tkachenko <vadim@xxxxxxxxxxx>
Date: Sun, 08 Feb 2009 17:33:22 -0000
Reply-to: Bug 326445 <326445@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
In many others runs it worked fine, bit I again hung with 50 threads
(gdb) info threads
  66 Thread 0x421d6950 (LWP 5330)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  65 Thread 0x429d7950 (LWP 5331)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  64 Thread 0x431d8950 (LWP 5332)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  63 Thread 0x439d9950 (LWP 5333)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  62 Thread 0x441da950 (LWP 5334)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  61 Thread 0x449db950 (LWP 5335)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  60 Thread 0x451dc950 (LWP 5336)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  59 Thread 0x459dd950 (LWP 5337)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  58 Thread 0x461de950 (LWP 5338)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  57 Thread 0x469df950 (LWP 5339)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  56 Thread 0x4132a950 (LWP 5364)  0x00007fa620df8482 in select () from /lib/libc.so.6
  55 Thread 0x471e0950 (LWP 5365)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  54 Thread 0x479e1950 (LWP 5367)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  53 Thread 0x47a22950 (LWP 5368)  0x00007fa6220b0e7b in sigwait () from /lib/libpthread.so.0
  52 Thread 0x4136b950 (LWP 5406)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  51 Thread 0x47a63950 (LWP 5408)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  50 Thread 0x47aa4950 (LWP 5410)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  49 Thread 0x47ae5950 (LWP 5414)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  48 Thread 0x47b26950 (LWP 5415)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  47 Thread 0x47b67950 (LWP 5416)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  46 Thread 0x47ba8950 (LWP 5417)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  45 Thread 0x47be9950 (LWP 5419)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  44 Thread 0x47c2a950 (LWP 5422)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  43 Thread 0x47c6b950 (LWP 5423)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  42 Thread 0x47cac950 (LWP 5424)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  41 Thread 0x47ced950 (LWP 5426)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  40 Thread 0x47d2e950 (LWP 5428)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  39 Thread 0x47d6f950 (LWP 5429)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  38 Thread 0x47db0950 (LWP 5432)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  37 Thread 0x47df1950 (LWP 5433)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  36 Thread 0x47e32950 (LWP 5437)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  35 Thread 0x47e73950 (LWP 5439)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  34 Thread 0x47eb4950 (LWP 5443)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  33 Thread 0x47ef5950 (LWP 5444)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  32 Thread 0x47f36950 (LWP 5445)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  31 Thread 0x47f77950 (LWP 5446)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  30 Thread 0x47fb8950 (LWP 5448)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  29 Thread 0x47ff9950 (LWP 5449)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  28 Thread 0x4803a950 (LWP 5451)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  27 Thread 0x4807b950 (LWP 5453)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  26 Thread 0x480bc950 (LWP 5455)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  25 Thread 0x480fd950 (LWP 5457)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  24 Thread 0x4813e950 (LWP 5460)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  23 Thread 0x4817f950 (LWP 5463)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  22 Thread 0x481c0950 (LWP 5465)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  21 Thread 0x48201950 (LWP 5466)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  20 Thread 0x48242950 (LWP 5468)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  19 Thread 0x48283950 (LWP 5469)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  18 Thread 0x482c4950 (LWP 5471)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  17 Thread 0x48305950 (LWP 5472)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  16 Thread 0x48346950 (LWP 5477)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  15 Thread 0x48387950 (LWP 5488)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  14 Thread 0x483c8950 (LWP 5497)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  13 Thread 0x48409950 (LWP 5498)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  12 Thread 0x4844a950 (LWP 5499)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  11 Thread 0x4848b950 (LWP 5501)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  10 Thread 0x484cc950 (LWP 5502)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
---Type <return> to continue, or q <return> to quit---
  9 Thread 0x4850d950 (LWP 5504)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  8 Thread 0x4854e950 (LWP 5505)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  7 Thread 0x4858f950 (LWP 5506)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  6 Thread 0x485d0950 (LWP 5507)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  5 Thread 0x48611950 (LWP 5529)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  4 Thread 0x413ac950 (LWP 5531)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  3 Thread 0x413ed950 (LWP 5532)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  2 Thread 0x4142e950 (LWP 8568)  0x00007fa6220ad2d9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0
  1 Thread 0x7fa6224d06f0 (LWP 5327)  0x00007fa620df8482 in select () from /lib/libc.so.6

-- 
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

[Bug 326445] [NEW] XtraDB hangs in 10 threads TPC-C
From: Vadim Tkachenko, 2009-02-07