[?1034hGNU gdb Fedora (6.8-9.fc9) Copyright (C) 2008 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "i386-redhat-linux-gnu"... Reading symbols from /lib/libpthread.so.0...done. Loaded symbols for /lib/libpthread.so.0 Reading symbols from /lib/libz.so.1...done. Loaded symbols for /lib/libz.so.1 Reading symbols from /usr/lib/libstdc++.so.6...done. Loaded symbols for /usr/lib/libstdc++.so.6 Reading symbols from /lib/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/librt.so.1...done. Loaded symbols for /lib/librt.so.1 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib/libgcc_s.so.1...done. Loaded symbols for /lib/libgcc_s.so.1 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 Core was generated by `/build/bzr/6.0-falcon/sql/mysqld --no-defaults --basedir=/build/bzr/6.0-falcon/'. Program terminated with signal 6, Aborted. [New process 9931] [New process 10017] [New process 10014] [New process 9980] [New process 9979] [New process 9978] [New process 9977] [New process 9976] [New process 9975] [New process 9974] [New process 9973] [New process 9972] [New process 9970] [New process 9946] [New process 9942] [New process 9937] [New process 9936] [New process 9900] [New process 9930] [New process 9927] [New process 9926] [New process 9925] [New process 9924] [New process 9923] [New process 9922] [New process 9920] [New process 9918] [New process 9917] [New process 9916] [New process 9915] [New process 9908] [New process 9907] [New process 9905] [New process 9904] #0 0x00110416 in __kernel_vsyscall () Missing separate debuginfos, use: debuginfo-install gcc.i386 glibc.i686 zlib.i386 (gdb) thread apply all bt Thread 34 (process 9904): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7019170) at Synchronize.cpp:123 #3 0x0842152a in Cache::ioThread (this=0xb7018da8) at Cache.cpp:926 #4 0x08421669 in Cache::ioThread (arg=0xb7018da8) at Cache.cpp:748 #5 0x084110a6 in Thread::thread (this=0xb7019170) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7019170) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 33 (process 9905): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7019250) at Synchronize.cpp:123 #3 0x0842152a in Cache::ioThread (this=0xb7018da8) at Cache.cpp:926 #4 0x08421669 in Cache::ioThread (arg=0xb7018da8) at Cache.cpp:748 #5 0x084110a6 in Thread::thread (this=0xb7019250) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7019250) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 32 (process 9907): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a332a in Synchronize::sleep (this=0xb7021f90, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:181 #3 0x084a3190 in Synchronize::sleep (this=0xb7021f90, milliseconds=1000) at Synchronize.cpp:136 #4 0x084316d6 in Database::ticker (this=0xb7219640) at Database.cpp:1880 #5 0x08431707 in Database::ticker (database=0xb7219640) at Database.cpp:1869 #6 0x084110a6 in Thread::thread (this=0xb7021f90) at Thread.cpp:167 #7 0x08411228 in Thread::thread (parameter=0xb7021f90) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 31 (process 9908): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7022070) at Synchronize.cpp:123 #3 0x084659c3 in PageWriter::writer (this=0xb701a618) at PageWriter.cpp:171 #4 0x08465aad in PageWriter::writer (arg=0xb701a618) at PageWriter.cpp:160 #5 0x084110a6 in Thread::thread (this=0xb7022070) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7022070) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 30 (process 9915): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7022470) at Synchronize.cpp:123 #3 0x084b09a3 in Gopher::gopherThread (this=0xb701a5f0) at Gopher.cpp:58 #4 0x084b0b83 in Gopher::gopherThread (arg=0xb701a5f0) at Gopher.cpp:37 #5 0x084110a6 in Thread::thread (this=0xb7022470) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7022470) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 29 (process 9916): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7022550) at Synchronize.cpp:123 #3 0x084b09a3 in Gopher::gopherThread (this=0xb701a5c8) at Gopher.cpp:58 #4 0x084b0b83 in Gopher::gopherThread (arg=0xb701a5c8) at Gopher.cpp:37 #5 0x084110a6 in Thread::thread (this=0xb7022550) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7022550) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 28 (process 9917): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7022630) at Synchronize.cpp:123 #3 0x084b09a3 in Gopher::gopherThread (this=0xb701a5a0) at Gopher.cpp:58 #4 0x084b0b83 in Gopher::gopherThread (arg=0xb701a5a0) at Gopher.cpp:37 #5 0x084110a6 in Thread::thread (this=0xb7022630) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7022630) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 27 (process 9918): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7022710) at Synchronize.cpp:123 #3 0x084b09a3 in Gopher::gopherThread (this=0xb701a578) at Gopher.cpp:58 #4 0x084b0b83 in Gopher::gopherThread (arg=0xb701a578) at Gopher.cpp:37 #5 0x084110a6 in Thread::thread (this=0xb7022710) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7022710) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 26 (process 9920): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb70227f0) at Synchronize.cpp:123 #3 0x084b09a3 in Gopher::gopherThread (this=0xb701a550) at Gopher.cpp:58 #4 0x084b0b83 in Gopher::gopherThread (arg=0xb701a550) at Gopher.cpp:37 #5 0x084110a6 in Thread::thread (this=0xb70227f0) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb70227f0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 25 (process 9922): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a3463 in Synchronize::sleep (this=0xb7045bc0) at Synchronize.cpp:123 #3 0x084765bf in Scheduler::schedule (this=0xb7021320) at Scheduler.cpp:151 #4 0x084765ff in Scheduler::schedule (lpParameter=0xb7021320) at Scheduler.cpp:158 #5 0x084110a6 in Thread::thread (this=0xb7045bc0) at Thread.cpp:167 #6 0x08411228 in Thread::thread (parameter=0xb7045bc0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 24 (process 9923): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084a332a in Synchronize::sleep (this=0xb7048ea0, milliseconds=15000, callersMutex=0x0) at Synchronize.cpp:181 #3 0x084a3190 in Synchronize::sleep (this=0xb7048ea0, milliseconds=15000) at Synchronize.cpp:136 #4 0x084765af in Scheduler::schedule (this=0xb70213b8) at Scheduler.cpp:149 #5 0x084765ff in Scheduler::schedule (lpParameter=0xb70213b8) at Scheduler.cpp:158 #6 0x084110a6 in Thread::thread (this=0xb7048ea0) at Thread.cpp:167 #7 0x08411228 in Thread::thread (parameter=0xb7048ea0) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 23 (process 9924): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9f95460, mp=0x9f95410, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9f95410, reset_sig_count=0) at os/os0sync.c:422 #4 0x0852bd07 in os_aio_simulated_handle (global_segment=0, message1=0xad1c836c, message2=0xad1c8368, type=0xad1c8364) at os/os0file.c:4207 #5 0x084fabd8 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #6 0x0855d5b5 in io_handler_thread (arg=0x88bcf40) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 22 (process 9925): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9f95500, mp=0x9f954b0, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9f954b0, reset_sig_count=0) at os/os0sync.c:422 #4 0x0852bd07 in os_aio_simulated_handle (global_segment=1, message1=0xac7c736c, message2=0xac7c7368, type=0xac7c7364) at os/os0file.c:4207 #5 0x084fabd8 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #6 0x0855d5b5 in io_handler_thread (arg=0x88bcf44) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 21 (process 9926): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9f955a0, mp=0x9f95550, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9f95550, reset_sig_count=0) at os/os0sync.c:422 #4 0x0852bd07 in os_aio_simulated_handle (global_segment=2, message1=0xabdc636c, message2=0xabdc6368, type=0xabdc6364) at os/os0file.c:4207 #5 0x084fabd8 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #6 0x0855d5b5 in io_handler_thread (arg=0x88bcf48) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 20 (process 9927): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9f95640, mp=0x9f955f0, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9f955f0, reset_sig_count=0) at os/os0sync.c:422 #4 0x0852bd07 in os_aio_simulated_handle (global_segment=3, message1=0xab3c536c, message2=0xab3c5368, type=0xab3c5364) at os/os0file.c:4207 #5 0x084fabd8 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #6 0x0855d5b5 in io_handler_thread (arg=0x88bcf4c) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 19 (process 9930): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x0852de52 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #3 0x0855a0a8 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1916 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 18 (process 9900): #0 0x0049a268 in clone () from /lib/libc.so.6 #1 0x00000000 in ?? () Thread 17 (process 9936): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9ae49a0, mp=0x9ae4950, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9ae4950, reset_sig_count=0) at os/os0sync.c:422 #4 0x08559a4c in srv_master_thread (arg=0x0) at srv/srv0srv.c:2631 #5 0x0057d32f in start_thread () from /lib/libpthread.so.0 #6 0x0049a27e in clone () from /lib/libc.so.6 Thread 16 (process 9937): #0 0x00110416 in __kernel_vsyscall () #1 0x00584e30 in sigwait () from /lib/libpthread.so.0 #2 0x08213836 in signal_hand (arg=0x0) at mysqld.cc:2843 #3 0x0057d32f in start_thread () from /lib/libpthread.so.0 #4 0x0049a27e in clone () from /lib/libc.so.6 Thread 15 (process 9942): #0 0x00110416 in __kernel_vsyscall () #1 0x00583c2b in read () from /lib/libpthread.so.0 #2 0x0859281b in vio_read (vio=0xa02a670, buf=0xa045488 "\a", size=4) at viosocket.c:44 #3 0x0820889a in my_real_read (net=0xa0201ac, complen=0xa898a318) at net_serv.cc:811 #4 0x08208dcb in my_net_read (net=0xa0201ac) at net_serv.cc:992 #5 0x0822b8c8 in do_command (thd=0xa020118) at sql_parse.cc:670 #6 0x0821bef0 in handle_one_connection (arg=0xa020118) at sql_connect.cc:1153 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 14 (process 9946): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b34df in safe_cond_timedwait (cond=0x878a0f0, mp=0x8789c04, abstime=0xa8958e70, file=0x8707e70 "log.cc", line=4445) at thr_mutex.c:289 #3 0x082b6fa0 in MYSQL_BIN_LOG::wait_for_update_bin_log (this=0x8789c00, thd=0xa057068, timeout=0xa8958e70) at log.cc:4444 #4 0x08356d76 in mysql_binlog_send (thd=0xa057068, log_ident=0xa0610f8 "", pos=4, flags=0) at sql_repl.cc:743 #5 0x0822aeb2 in dispatch_command (command=COM_BINLOG_DUMP, thd=0xa057068, packet=0xa058e99 "", packet_length=10) at sql_parse.cc:1244 #6 0x0822ba49 in do_command (thd=0xa057068) at sql_parse.cc:724 #7 0x0821bef0 in handle_one_connection (arg=0xa057068) at sql_connect.cc:1153 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 13 (process 9970): #0 0x08564762 in trx_undo_rec_get_pars (undo_rec=0xa8718608 "\025s\034\036\017", type=0xa8926770, cmpl_info=0xa8926744, updated_extern=0xa8926740, undo_no=0xa8926768, table_id=0xa8926760) at trx/trx0rec.c:277 #1 0x08564c75 in trx_undo_prev_version_build (index_rec=0xad605a56 "\200", index_mtr=0xa8926abc, rec=0xa870b2fe "\200", index=0xadb8e268, offsets=0xa8926928, heap=0xa87185c8, old_vers=0xa89267e4) at trx/trx0rec.c:1332 #2 0x085563d2 in row_vers_build_for_consistent_read (rec=0xad605a56 "\200", mtr=0xa8926abc, index=0xadb8e268, offsets=0xa8926924, view=0xadb9b268, offset_heap=0xa8926ab8, in_heap=0xa186da0, old_vers=0xa8926920) at row/row0vers.c:482 #3 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadb9b268, clust_index=0xadb8e268, prebuilt=0xadbb1c68, rec=0xad605a56 "\200", offsets=0xa8926924, offset_heap=0xa8926ab8, old_vers=0xa8926920, mtr=0xa8926abc) at row/row0sel.c:2774 #4 0x0854e978 in row_search_for_mysql (buf=0xa019cf0 "\020\024", mode=1, prebuilt=0xadbb1c68, match_mode=0, direction=1) at row/row0sel.c:4111 #5 0x084cacfc in ha_innobase::general_fetch (this=0xa019b58, buf=0xa019cf0 "\020\024", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #6 0x084cae23 in ha_innobase::rnd_next (this=0xa019b58, buf=0xa019cf0 "\020\024") at handler/ha_innodb.cc:4609 #7 0x082fe7e7 in rr_sequential (info=0xa135290) at records.cc:366 #8 0x08281628 in sub_select (join=0xa037b90, join_tab=0xa13524c, end_of_records=false) at sql_select.cc:13646 #9 0x0828197d in flush_cached_records (join=0xa037b90, join_tab=0xa1350a8, skip_last=) at sql_select.cc:14020 #10 0x08281a30 in sub_select_cache (join=0xa037b90, join_tab=0xa1350a8, end_of_records=true) at sql_select.cc:13449 #11 0x08281575 in sub_select (join=0xa037b90, join_tab=0xa134f04, end_of_records=true) at sql_select.cc:13597 #12 0x08281575 in sub_select (join=0xa037b90, join_tab=0xa134d60, end_of_records=true) at sql_select.cc:13597 #13 0x0828b5d4 in do_select (join=0xa037b90, fields=0x0, table=0xa1f7210, procedure=0x0) at sql_select.cc:13389 #14 0x0828bff0 in JOIN::exec (this=0xa037b90) at sql_select.cc:2399 #15 0x0835f3b2 in st_select_lex_unit::exec (this=0xa05dff8) at sql_union.cc:514 #16 0x08360b77 in mysql_union (thd=0xa05cea8, lex=0xa05df9c, result=0xa037af8, unit=0xa05dff8, setup_tables_done_option=0) at sql_union.cc:34 #17 0x08290f89 in handle_select (thd=0xa05cea8, lex=0xa05df9c, result=0xa037af8, setup_tables_done_option=0) at sql_select.cc:280 #18 0x082201e2 in execute_sqlcom_select (thd=0xa05cea8, all_tables=0xa0741e8) at sql_parse.cc:4847 #19 0x08220f61 in mysql_execute_command (thd=0xa05cea8) at sql_parse.cc:2015 #20 0x0822a02e in mysql_parse (thd=0xa05cea8, inBuf=0xa073730 "( SELECT K . int_nokey AS X, COUNT( L . int_key ) AS Y, MAX( L . pk ) AS Z FROM `A` AS K LEFT JOIN `A` AS L ON ( K . int_key = L . pk ) WHERE L . int_nokey IN ( SELECT L . int_key AS X FROM `A` AS K L"..., length=519, found_semicolon=0xa8928314) at sql_parse.cc:5811 #21 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa05cea8, packet=0xa06f711 "( SELECT K . int_nokey AS X, COUNT( L . int_key ) AS Y, MAX( L . pk ) AS Z FROM `A` AS K LEFT JOIN `A` AS L ON ( K . int_key = L . pk ) WHERE L . int_nokey IN ( SELECT L . int_key AS X FROM `A` AS K L"..., packet_length=520) at sql_parse.cc:1051 #22 0x0822ba49 in do_command (thd=0xa05cea8) at sql_parse.cc:724 #23 0x0821bef0 in handle_one_connection (arg=0xa05cea8) at sql_connect.cc:1153 #24 0x0057d32f in start_thread () from /lib/libpthread.so.0 #25 0x0049a27e in clone () from /lib/libc.so.6 Thread 12 (process 9972): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057edb5 in _L_lock_758 () from /lib/libpthread.so.0 #3 0x0057ecce in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x085b3a3a in safe_mutex_lock (mp=0x88bf5e0, try_lock=0 '\0', file=0x86e3ef9 "os/os0sync.c", line=693) at thr_mutex.c:153 #5 0x0852d48c in os_fast_mutex_lock (fast_mutex=0x88bf5e0) at os/os0sync.c:693 #6 0x08574673 in ut_malloc_low (n=1088, set_to_zero=1, assert_on_error=1) at ut/ut0mem.c:80 #7 0x085747e8 in ut_malloc (n=1088) at ut/ut0mem.c:189 #8 0x08525e0a in mem_area_alloc (size=1088, pool=0x9ae4348) at mem/mem0pool.c:355 #9 0x085250a5 in mem_heap_create_block (heap=0x0, n=1024, init_block=0x0, type=0, file_name=0x86e99bc "row/row0vers.c", line=451) at mem/mem0mem.c:362 #10 0x08556002 in row_vers_build_for_consistent_read (rec=0xad605467 "\200", mtr=0xa88f5b4c, index=0xadb8e268, offsets=0xa88f59b4, view=0xadb9f668, offset_heap=0xa88f5b48, in_heap=0xadb8c028, old_vers=0xa88f59b0) at ../../storage/innobase/include/mem0mem.ic:421 #11 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadb9f668, clust_index=0xadb8e268, prebuilt=0xadbb5668, rec=0xad605467 "\200", offsets=0xa88f59b4, offset_heap=0xa88f5b48, old_vers=0xa88f59b0, mtr=0xa88f5b4c) at row/row0sel.c:2774 #12 0x0854e978 in row_search_for_mysql (buf=0xa1c5618 "\003", mode=1, prebuilt=0xadbb5668, match_mode=0, direction=1) at row/row0sel.c:4111 #13 0x084cacfc in ha_innobase::general_fetch (this=0xa1c5480, buf=0xa1c5618 "\003", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #14 0x084cae23 in ha_innobase::rnd_next (this=0xa1c5480, buf=0xa1c5618 "\003") at handler/ha_innodb.cc:4609 #15 0x082fe7e7 in rr_sequential (info=0xa265ef8) at records.cc:366 #16 0x08281628 in sub_select (join=0xa851fc48, join_tab=0xa265eb4, end_of_records=false) at sql_select.cc:13646 #17 0x0828197d in flush_cached_records (join=0xa851fc48, join_tab=0xa265d10, skip_last=) at sql_select.cc:14020 #18 0x08281a30 in sub_select_cache (join=0xa851fc48, join_tab=0xa265d10, end_of_records=true) at sql_select.cc:13449 #19 0x08281575 in sub_select (join=0xa851fc48, join_tab=0xa265b6c, end_of_records=248) at sql_select.cc:13597 #20 0x08281575 in sub_select (join=0xa851fc48, join_tab=0xa2659c8, end_of_records=248) at sql_select.cc:13597 #21 0x0828b5d4 in do_select (join=0xa851fc48, fields=0xa8520f88, table=0x0, procedure=0x0) at sql_select.cc:13389 #22 0x0828d761 in JOIN::exec (this=0xa851fc48) at sql_select.cc:2811 #23 0x0828e1fa in mysql_select (thd=0xa075738, rref_pointer_array=0xa076c1c, tables=0xa092e90, wild_num=0, fields=@0xa076bac, conds=0xa851fad8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xa851fc38, unit=0xa076888, select_lex=0xa076b18) at sql_select.cc:3001 #24 0x082910dc in handle_select (thd=0xa075738, lex=0xa07682c, result=0xa851fc38, setup_tables_done_option=0) at sql_select.cc:302 #25 0x082201e2 in execute_sqlcom_select (thd=0xa075738, all_tables=0xa092e90) at sql_parse.cc:4847 #26 0x08220f61 in mysql_execute_command (thd=0xa075738) at sql_parse.cc:2015 #27 0x0822a02e in mysql_parse (thd=0xa075738, inBuf=0xa092308 "SELECT MAX( K . int_key ) AS X, MAX( K . pk ) AS Y, MAX( L . int_nokey ) AS Z FROM `C` AS K LEFT JOIN `B` AS L ON ( K . int_key = L . int_key ) WHERE L . pk IN ( SELECT L . int_key AS X FROM `A` AS K "..., length=420, found_semicolon=0xa88f7314) at sql_parse.cc:5811 #28 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa075738, packet=0xa08a2d9 "", packet_length=423) at sql_parse.cc:1051 #29 0x0822ba49 in do_command (thd=0xa075738) at sql_parse.cc:724 #30 0x0821bef0 in handle_one_connection (arg=0xa075738) at sql_connect.cc:1153 #31 0x0057d32f in start_thread () from /lib/libpthread.so.0 #32 0x0049a27e in clone () from /lib/libc.so.6 Current language: auto; currently c Thread 11 (process 9973): #0 0x0057e7c7 in pthread_mutex_lock () from /lib/libpthread.so.0 #1 0x085b37bb in safe_mutex_unlock (mp=0xad3004f8, file=0x86e3ef9 "os/os0sync.c", line=708) at thr_mutex.c:182 #2 0x0852d461 in os_fast_mutex_unlock (fast_mutex=0xad3004f8) at os/os0sync.c:708 #3 0x084e2a99 in buf_page_optimistic_get_func (rw_latch=1, block=0xad30045c, guess=0xad5fc000 "*©®?", modify_clock={high = 0, low = 175}, file=0x86eed69 "btr/btr0pcur.c", line=249, mtr=0xa88c4b7c) at ../../storage/innobase/include/sync0sync.ic:150 #4 0x0857dada in btr_pcur_restore_position (latch_mode=1, cursor=0xadba8968, mtr=0xa88c4b7c) at btr/btr0pcur.c:246 #5 0x0854d208 in sel_restore_position_for_mysql (same_user_rec=0xa88c4fd8, latch_mode=2, pcur=0x1, moves_up=1, mtr=0xa88c4b7c) at row/row0sel.c:2989 #6 0x0854dc3c in row_search_for_mysql (buf=0xa8509980 "\tá", mode=1, prebuilt=0xadbb8468, match_mode=0, direction=1) at row/row0sel.c:3642 #7 0x084cacfc in ha_innobase::general_fetch (this=0xa85097e8, buf=0xa8509980 "\tá", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #8 0x084cae23 in ha_innobase::rnd_next (this=0xa85097e8, buf=0xa8509980 "\tá") at handler/ha_innodb.cc:4609 #9 0x082fe7e7 in rr_sequential (info=0xa851945c) at records.cc:366 #10 0x08281628 in sub_select (join=0xa8521c48, join_tab=0xa8519418, end_of_records=false) at sql_select.cc:13646 #11 0x0828197d in flush_cached_records (join=0xa8521c48, join_tab=0xa8519274, skip_last=) at sql_select.cc:14020 #12 0x08281a30 in sub_select_cache (join=0xa8521c48, join_tab=0xa8519274, end_of_records=true) at sql_select.cc:13449 #13 0x08281575 in sub_select (join=0xa8521c48, join_tab=0xa85190d0, end_of_records=2) at sql_select.cc:13597 #14 0x0828b5d4 in do_select (join=0xa8521c48, fields=0x0, table=0xa851bcd0, procedure=0x0) at sql_select.cc:13389 #15 0x0828bff0 in JOIN::exec (this=0xa8521c48) at sql_select.cc:2399 #16 0x0828e1fa in mysql_select (thd=0xa094ec0, rref_pointer_array=0xa0963a4, tables=0xa09f4c8, wild_num=0, fields=@0xa096334, conds=0xa8510cd0, og_num=1, order=0xa8510e60, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xa8510ef8, unit=0xa096010, select_lex=0xa0962a0) at sql_select.cc:3001 #17 0x082910dc in handle_select (thd=0xa094ec0, lex=0xa095fb4, result=0xa8510ef8, setup_tables_done_option=0) at sql_select.cc:302 #18 0x082201e2 in execute_sqlcom_select (thd=0xa094ec0, all_tables=0xa09f4c8) at sql_parse.cc:4847 #19 0x08220f61 in mysql_execute_command (thd=0xa094ec0) at sql_parse.cc:2015 #20 0x0822a02e in mysql_parse (thd=0xa094ec0, inBuf=0xa09eb50 "SELECT MAX( K . int_nokey ) AS X, MIN( K . int_nokey ) AS Y, L . pk AS Z FROM `A` AS K LEFT JOIN `C` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_nokey IN ( SELECT L . int_key AS X FROM `A` AS K L"..., length=291, found_semicolon=0xa88c6314) at sql_parse.cc:5811 #21 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa094ec0, packet=0xa0968d9 "SELECT MAX( K . int_nokey ) AS X, MIN( K . int_nokey ) AS Y, L . pk AS Z FROM `A` AS K LEFT JOIN `C` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_nokey IN ( SELECT L . int_key AS X FROM `A` AS K L"..., packet_length=292) at sql_parse.cc:1051 #22 0x0822ba49 in do_command (thd=0xa094ec0) at sql_parse.cc:724 #23 0x0821bef0 in handle_one_connection (arg=0xa094ec0) at sql_connect.cc:1153 #24 0x0057d32f in start_thread () from /lib/libpthread.so.0 #25 0x0049a27e in clone () from /lib/libc.so.6 Thread 10 (process 9974): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x0852de52 in os_thread_sleep (tm=10000) at os/os0thread.c:281 #3 0x085582c2 in srv_conc_enter_innodb (trx=0xadba4068) at srv/srv0srv.c:1057 #4 0x084cacd1 in ha_innobase::general_fetch (this=0xa87d8410, buf=0xa87d85a8 "\002 \001", direction=1, match_mode=0) at handler/ha_innodb.cc:458 #5 0x084cae23 in ha_innobase::rnd_next (this=0xa87d8410, buf=0xa87d85a8 "\002 \001") at handler/ha_innodb.cc:4609 #6 0x082fe7e7 in rr_sequential (info=0xa83153d0) at records.cc:366 #7 0x08281628 in sub_select (join=0xa87f95a8, join_tab=0xa831538c, end_of_records=false) at sql_select.cc:13646 #8 0x0828197d in flush_cached_records (join=0xa87f95a8, join_tab=0xa83151e8, skip_last=) at sql_select.cc:14020 #9 0x08281a30 in sub_select_cache (join=0xa87f95a8, join_tab=0xa83151e8, end_of_records=true) at sql_select.cc:13449 #10 0x08281575 in sub_select (join=0xa87f95a8, join_tab=0xa8315044, end_of_records=false) at sql_select.cc:13597 #11 0x08281575 in sub_select (join=0xa87f95a8, join_tab=0xa8314ea0, end_of_records=false) at sql_select.cc:13597 #12 0x0828b5d4 in do_select (join=0xa87f95a8, fields=0x0, table=0xa8317e78, procedure=0x0) at sql_select.cc:13389 #13 0x0828bff0 in JOIN::exec (this=0xa87f95a8) at sql_select.cc:2399 #14 0x0835f3b2 in st_select_lex_unit::exec (this=0xa0a2cc0) at sql_union.cc:514 #15 0x08360b77 in mysql_union (thd=0xa0a1b70, lex=0xa0a2c64, result=0xa87f7ac0, unit=0xa0a2cc0, setup_tables_done_option=0) at sql_union.cc:34 #16 0x08290f89 in handle_select (thd=0xa0a1b70, lex=0xa0a2c64, result=0xa87f7ac0, setup_tables_done_option=0) at sql_select.cc:280 #17 0x082201e2 in execute_sqlcom_select (thd=0xa0a1b70, all_tables=0xa0b4228) at sql_parse.cc:4847 #18 0x08220f61 in mysql_execute_command (thd=0xa0a1b70) at sql_parse.cc:2015 #19 0x0822a02e in mysql_parse (thd=0xa0a1b70, inBuf=0xa0b35c0 "( SELECT COUNT( K . pk ) AS X, K . int_key AS Y, K . int_key AS Z FROM `A` AS K LEFT JOIN `B` AS L ON ( K . int_nokey = L . pk ) WHERE K . int_key < L . pk ORDER BY Y ) UNION ALL ( SELECT MIN( L . i"..., length=874, found_semicolon=0xa8895314) at sql_parse.cc:5811 #20 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa0a1b70, packet=0xa0a3589 "( SELECT COUNT( K . pk ) AS X, K . int_key AS Y, K . int_key AS Z FROM `A` AS K LEFT JOIN `B` AS L ON ( K . int_nokey = L . pk ) WHERE K . int_key < L . pk ORDER BY Y ) UNION ALL ( SELECT MIN( L . i"..., packet_length=874) at sql_parse.cc:1051 #21 0x0822ba49 in do_command (thd=0xa0a1b70) at sql_parse.cc:724 #22 0x0821bef0 in handle_one_connection (arg=0xa0a1b70) at sql_connect.cc:1153 #23 0x0057d32f in start_thread () from /lib/libpthread.so.0 #24 0x0049a27e in clone () from /lib/libc.so.6 Thread 9 (process 9975): #0 0x00110416 in __kernel_vsyscall () #1 0x0047cfdc in sched_yield () from /lib/libc.so.6 #2 0x0852de5f in os_thread_yield () at os/os0thread.c:253 #3 0x0855e561 in rw_lock_s_lock_spin (lock=0xadb83878, pass=0, file_name=0x86e99bc "row/row0vers.c", line=443) at sync/sync0rw.c:276 #4 0x08555fb7 in row_vers_build_for_consistent_read (rec=0xad716651 "\200", mtr=0xa8862abc, index=0xadb95068, offsets=0xa8862924, view=0xadba5c68, offset_heap=0xa8862ab8, in_heap=0xa1f4cf8, old_vers=0xa8862920) at ../../storage/innobase/include/sync0rw.ic:253 #5 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadba5c68, clust_index=0xadb95068, prebuilt=0xa133188, rec=0xad716651 "\200", offsets=0xa8862924, offset_heap=0xa8862ab8, old_vers=0xa8862920, mtr=0xa8862abc) at row/row0sel.c:2774 #6 0x0854e978 in row_search_for_mysql (buf=0xa0249d8 "\004é", mode=1, prebuilt=0xa133188, match_mode=0, direction=1) at row/row0sel.c:4111 #7 0x084cacfc in ha_innobase::general_fetch (this=0xa024840, buf=0xa0249d8 "\004é", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #8 0x084cae23 in ha_innobase::rnd_next (this=0xa024840, buf=0xa0249d8 "\004é") at handler/ha_innodb.cc:4609 #9 0x082fe7e7 in rr_sequential (info=0xa18ca18) at records.cc:366 #10 0x08281628 in sub_select (join=0xa1f0228, join_tab=0xa18c9d4, end_of_records=false) at sql_select.cc:13646 #11 0x0828197d in flush_cached_records (join=0xa1f0228, join_tab=0xa18c830, skip_last=) at sql_select.cc:14020 #12 0x08281a30 in sub_select_cache (join=0xa1f0228, join_tab=0xa18c830, end_of_records=true) at sql_select.cc:13449 #13 0x08281575 in sub_select (join=0xa1f0228, join_tab=0xa18c68c, end_of_records=100) at sql_select.cc:13597 #14 0x08281575 in sub_select (join=0xa1f0228, join_tab=0xa18c4e8, end_of_records=100) at sql_select.cc:13597 #15 0x0828b5d4 in do_select (join=0xa1f0228, fields=0xa1f1568, table=0x0, procedure=0x0) at sql_select.cc:13389 #16 0x0828d761 in JOIN::exec (this=0xa1f0228) at sql_select.cc:2811 #17 0x0835f3b2 in st_select_lex_unit::exec (this=0xa0b7730) at sql_union.cc:514 #18 0x08360b77 in mysql_union (thd=0xa0b65e0, lex=0xa0b76d4, result=0xa0185f0, unit=0xa0b7730, setup_tables_done_option=0) at sql_union.cc:34 #19 0x08290f89 in handle_select (thd=0xa0b65e0, lex=0xa0b76d4, result=0xa0185f0, setup_tables_done_option=0) at sql_select.cc:280 #20 0x082201e2 in execute_sqlcom_select (thd=0xa0b65e0, all_tables=0xa8700fd8) at sql_parse.cc:4847 #21 0x08220f61 in mysql_execute_command (thd=0xa0b65e0) at sql_parse.cc:2015 #22 0x0822a02e in mysql_parse (thd=0xa0b65e0, inBuf=0xa8700478 "( SELECT COUNT( L . pk ) AS X, MIN( K . int_nokey ) AS Y, K . int_nokey AS Z FROM `C` AS K LEFT JOIN `A` AS L ON ( K . int_nokey = L . int_nokey ) WHERE K . pk < L . int_nokey ) UNION ALL ( SELECT "..., length=598, found_semicolon=0xa8864314) at sql_parse.cc:5811 #23 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa0b65e0, packet=0xa0c27b9 "( SELECT COUNT( L . pk ) AS X, MIN( K . int_nokey ) AS Y, K . int_nokey AS Z FROM `C` AS K LEFT JOIN `A` AS L ON ( K . int_nokey = L . int_nokey ) WHERE K . pk < L . int_nokey ) UNION ALL ( SELECT "..., packet_length=600) at sql_parse.cc:1051 #24 0x0822ba49 in do_command (thd=0xa0b65e0) at sql_parse.cc:724 #25 0x0821bef0 in handle_one_connection (arg=0xa0b65e0) at sql_connect.cc:1153 #26 0x0057d32f in start_thread () from /lib/libpthread.so.0 #27 0x0049a27e in clone () from /lib/libc.so.6 Thread 8 (process 9976): #0 0x00110416 in __kernel_vsyscall () #1 0x00492a5f in fdatasync () from /lib/libc.so.6 #2 0x085a8162 in my_sync (fd=25, my_flags=16) at my_sync.c:62 #3 0x083ebcfd in write_meta_file (meta_file=25, rows=, dirty=true) at ha_tina.cc:317 #4 0x083ec7c2 in ha_tina::init_tina_writer (this=0xa87abf68) at ha_tina.cc:342 #5 0x083ee169 in ha_tina::write_row (this=0xa87abf68, buf=0xa87092b8 "[\237kH\"") at ha_tina.cc:884 #6 0x0830a043 in handler::ha_write_row (this=0xa87abf68, buf=0xa87092b8 "[\237kH\"") at handler.cc:5315 #7 0x082b7dd9 in Log_to_csv_event_handler::log_slow (this=0x9abee90, thd=0xa0b82d8, current_time=1215012699, query_start_arg=1215011625, user_host=0xa8832c28 "root[root] @ localhost [127.0.0.1]", user_host_len=34, query_utime=1074269863, lock_utime=6573, is_command=false, sql_text=0xa0f0560 "( SELECT COUNT( K . int_nokey ) AS X, K . int_key AS Y, COUNT( L . pk ) AS Z FROM `A` AS K LEFT JOIN `B` AS L ON ( K . int_nokey = L . int_key ) WHERE L . int_nokey IN ( SELECT L . int_nokey AS X FROM"..., sql_text_len=812) at log.cc:650 #8 0x082b3b90 in LOGGER::slow_log_print (this=0x8789ba0, thd=0xa0b82d8, query=0xa0f0560 "( SELECT COUNT( K . int_nokey ) AS X, K . int_key AS Y, COUNT( L . pk ) AS Z FROM `A` AS K LEFT JOIN `B` AS L ON ( K . int_nokey = L . int_key ) WHERE L . int_nokey IN ( SELECT L . int_nokey AS X FROM"..., query_length=812, current_utime=1215012699375050) at log.cc:994 #9 0x082b3c06 in slow_log_print (thd=0xa0b82d8, query=0xa0f0560 "( SELECT COUNT( K . int_nokey ) AS X, K . int_key AS Y, COUNT( L . pk ) AS Z FROM `A` AS K LEFT JOIN `B` AS L ON ( K . int_nokey = L . int_key ) WHERE L . int_nokey IN ( SELECT L . int_nokey AS X FROM"..., query_length=812, current_utime=1215011888300032) at log.cc:4037 #10 0x08220659 in log_slow_statement (thd=0xa0b82d8) at sql_parse.cc:1494 #11 0x0822b58d in dispatch_command (command=COM_QUERY, thd=0xa0b82d8, packet=0xa0d27e1 "", packet_length=812) at sql_parse.cc:1442 #12 0x0822ba49 in do_command (thd=0xa0b82d8) at sql_parse.cc:724 #13 0x0821bef0 in handle_one_connection (arg=0xa0b82d8) at sql_connect.cc:1153 #14 0x0057d32f in start_thread () from /lib/libpthread.so.0 #15 0x0049a27e in clone () from /lib/libc.so.6 Thread 7 (process 9977): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x0852de52 in os_thread_sleep (tm=10000) at os/os0thread.c:281 #3 0x085582c2 in srv_conc_enter_innodb (trx=0xadbab468) at srv/srv0srv.c:1057 #4 0x084cacd1 in ha_innobase::general_fetch (this=0xa07c4d8, buf=0xa07c670 "", direction=1, match_mode=0) at handler/ha_innodb.cc:458 #5 0x084cae23 in ha_innobase::rnd_next (this=0xa07c4d8, buf=0xa07c670 "") at handler/ha_innodb.cc:4609 #6 0x082fe7e7 in rr_sequential (info=0xa1eded8) at records.cc:366 #7 0x08281628 in sub_select (join=0xa2422f0, join_tab=0xa1ede94, end_of_records=false) at sql_select.cc:13646 #8 0x0828197d in flush_cached_records (join=0xa2422f0, join_tab=0xa1edcf0, skip_last=) at sql_select.cc:14020 #9 0x08281a30 in sub_select_cache (join=0xa2422f0, join_tab=0xa1edcf0, end_of_records=true) at sql_select.cc:13449 #10 0x08281575 in sub_select (join=0xa2422f0, join_tab=0xa1edb4c, end_of_records=false) at sql_select.cc:13597 #11 0x08281575 in sub_select (join=0xa2422f0, join_tab=0xa1ed9a8, end_of_records=false) at sql_select.cc:13597 #12 0x0828b5d4 in do_select (join=0xa2422f0, fields=0xa10185c, table=0x0, procedure=0x0) at sql_select.cc:13389 #13 0x0828d761 in JOIN::exec (this=0xa2422f0) at sql_select.cc:2811 #14 0x081d83bd in subselect_hash_sj_engine::exec (this=0xa1fd768) at item_subselect.cc:3185 #15 0x081d0c4a in Item_subselect::exec (this=0xa1d0220) at item_subselect.cc:280 #16 0x081d42fc in Item_in_subselect::exec (this=0xa1d0220) at item_subselect.cc:330 #17 0x081d1363 in Item_in_subselect::val_bool (this=0xa1d0220) at item_subselect.cc:899 #18 0x0817cd6d in Item::val_bool_result (this=0xa1d0220) at ../item.h:742 #19 0x081a17e1 in Item_in_optimizer::val_int (this=0xa1d1d80) at item_cmpfunc.cc:1595 #20 0x08281334 in evaluate_join_record (join=0xa1d0540, join_tab=0xa1fce90, error=) at sql_select.cc:13775 #21 0x08281633 in sub_select (join=0xa1d0540, join_tab=0xa1fce90, end_of_records=false) at sql_select.cc:13647 #22 0x0828b5b9 in do_select (join=0xa1d0540, fields=0x0, table=0xa01ac08, procedure=0x0) at sql_select.cc:13387 #23 0x0828bff0 in JOIN::exec (this=0xa1d0540) at sql_select.cc:2399 #24 0x0828e1fa in mysql_select (thd=0xa0f4378, rref_pointer_array=0xa0f585c, tables=0xa100990, wild_num=0, fields=@0xa0f57ec, conds=0xa1d0220, og_num=2, order=0xa1d0490, group=0xa1d03c0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xa1d0530, unit=0xa0f54c8, select_lex=0xa0f5758) at sql_select.cc:3001 #25 0x082910dc in handle_select (thd=0xa0f4378, lex=0xa0f546c, result=0xa1d0530, setup_tables_done_option=0) at sql_select.cc:302 #26 0x082201e2 in execute_sqlcom_select (thd=0xa0f4378, all_tables=0xa100990) at sql_parse.cc:4847 #27 0x08220f61 in mysql_execute_command (thd=0xa0f4378) at sql_parse.cc:2015 #28 0x0822a02e in mysql_parse (thd=0xa0f4378, inBuf=0xa0ffe50 "SELECT MAX( L . pk ) AS X, MAX( K . int_nokey ) AS Y, COUNT( L . int_key ) AS Z FROM `A` AS K LEFT JOIN `A` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_key IN ( SELECT K . int_key AS X FROM `B` A"..., length=443, found_semicolon=0xa86ff314) at sql_parse.cc:5811 #29 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa0f4378, packet=0xa0f5d91 "SELECT MAX( L . pk ) AS X, MAX( K . int_nokey ) AS Y, COUNT( L . int_key ) AS Z FROM `A` AS K LEFT JOIN `A` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_key IN ( SELECT K . int_key AS X FROM `B` A"..., packet_length=444) at sql_parse.cc:1051 #30 0x0822ba49 in do_command (thd=0xa0f4378) at sql_parse.cc:724 #31 0x0821bef0 in handle_one_connection (arg=0xa0f4378) at sql_connect.cc:1153 #32 0x0057d32f in start_thread () from /lib/libpthread.so.0 #33 0x0049a27e in clone () from /lib/libc.so.6 Thread 6 (process 9978): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057edb5 in _L_lock_758 () from /lib/libpthread.so.0 #3 0x0057ecce in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x085b3a3a in safe_mutex_lock (mp=0x88bf5e0, try_lock=0 '\0', file=0x86e3ef9 "os/os0sync.c", line=693) at thr_mutex.c:153 #5 0x0852d48c in os_fast_mutex_lock (fast_mutex=0x88bf5e0) at os/os0sync.c:693 #6 0x085744d8 in ut_free (ptr=0xa87d96a0) at ut/ut0mem.c:244 #7 0x08525972 in mem_area_free (ptr=0xa87d96a0, pool=0x9ae4348) at mem/mem0pool.c:472 #8 0x0852501c in mem_heap_block_free (heap=0xa87d96a0, block=0xa87d96a0) at mem/mem0mem.c:524 #9 0x08556405 in row_vers_build_for_consistent_read (rec=0xad604138 "\200", mtr=0xa86ccb4c, index=0xadb8e268, offsets=0xa86cc9b4, view=0xadbb2468, offset_heap=0xa86ccb48, in_heap=0xadbaea28, old_vers=0xa86cc9b0) at ../../storage/innobase/include/mem0mem.ic:487 #10 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadbb2468, clust_index=0xadb8e268, prebuilt=0xadb97068, rec=0xad604138 "\200", offsets=0xa86cc9b4, offset_heap=0xa86ccb48, old_vers=0xa86cc9b0, mtr=0xa86ccb4c) at row/row0sel.c:2774 #11 0x0854e978 in row_search_for_mysql (buf=0xa06f4b8 "ù\004", mode=1, prebuilt=0xadb97068, match_mode=0, direction=1) at row/row0sel.c:4111 #12 0x084cacfc in ha_innobase::general_fetch (this=0xa06f320, buf=0xa06f4b8 "ù\004", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #13 0x084cae23 in ha_innobase::rnd_next (this=0xa06f320, buf=0xa06f4b8 "ù\004") at handler/ha_innodb.cc:4609 #14 0x082fe7e7 in rr_sequential (info=0xa13b8b0) at records.cc:366 #15 0x08281628 in sub_select (join=0xa168a08, join_tab=0xa13b86c, end_of_records=false) at sql_select.cc:13646 #16 0x0828197d in flush_cached_records (join=0xa168a08, join_tab=0xa13b6c8, skip_last=) at sql_select.cc:14020 #17 0x08281a30 in sub_select_cache (join=0xa168a08, join_tab=0xa13b6c8, end_of_records=true) at sql_select.cc:13449 #18 0x08281575 in sub_select (join=0xa168a08, join_tab=0xa13b524, end_of_records=248) at sql_select.cc:13597 #19 0x08281575 in sub_select (join=0xa168a08, join_tab=0xa13b380, end_of_records=248) at sql_select.cc:13597 #20 0x0828b5d4 in do_select (join=0xa168a08, fields=0x0, table=0xa1c0a08, procedure=0x0) at sql_select.cc:13389 #21 0x0828bff0 in JOIN::exec (this=0xa168a08) at sql_select.cc:2399 #22 0x0828e1fa in mysql_select (thd=0xa107408, rref_pointer_array=0xa1088ec, tables=0xa1449d0, wild_num=0, fields=@0xa10887c, conds=0xa85151e0, og_num=2, order=0xa8515448, group=0xa8515378, having=0x0, proc_param=0x0, select_options=2147764736, result=0xa85154e0, unit=0xa108558, select_lex=0xa1087e8) at sql_select.cc:3001 #23 0x082910dc in handle_select (thd=0xa107408, lex=0xa1084fc, result=0xa85154e0, setup_tables_done_option=0) at sql_select.cc:302 #24 0x082201e2 in execute_sqlcom_select (thd=0xa107408, all_tables=0xa1449d0) at sql_parse.cc:4847 #25 0x08220f61 in mysql_execute_command (thd=0xa107408) at sql_parse.cc:2015 #26 0x0822a02e in mysql_parse (thd=0xa107408, inBuf=0xa144058 "SELECT MIN( L . pk ) AS X, MAX( L . pk ) AS Y, L . pk AS Z FROM `A` AS K LEFT JOIN `C` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_key IN ( SELECT L . int_nokey AS X FROM `B` AS K LEFT JOIN `B` A"..., length=296, found_semicolon=0xa86ce314) at sql_parse.cc:5811 #27 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa107408, packet=0xa108e21 "SELECT MIN( L . pk ) AS X, MAX( L . pk ) AS Y, L . pk AS Z FROM `A` AS K LEFT JOIN `C` AS L ON ( K . pk = L . int_nokey ) WHERE L . int_key IN ( SELECT L . int_nokey AS X FROM `B` AS K LEFT JOIN `B` A"..., packet_length=297) at sql_parse.cc:1051 #28 0x0822ba49 in do_command (thd=0xa107408) at sql_parse.cc:724 #29 0x0821bef0 in handle_one_connection (arg=0xa107408) at sql_connect.cc:1153 #30 0x0057d32f in start_thread () from /lib/libpthread.so.0 #31 0x0049a27e in clone () from /lib/libc.so.6 Thread 5 (process 9979): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057edb5 in _L_lock_758 () from /lib/libpthread.so.0 #3 0x0057ecce in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x085b3a3a in safe_mutex_lock (mp=0x88bf5e0, try_lock=0 '\0', file=0x86e3ef9 "os/os0sync.c", line=693) at thr_mutex.c:153 #5 0x0852d48c in os_fast_mutex_lock (fast_mutex=0x88bf5e0) at os/os0sync.c:693 #6 0x085744d8 in ut_free (ptr=0xa87117b8) at ut/ut0mem.c:244 #7 0x08525972 in mem_area_free (ptr=0xa87117b8, pool=0x9ae4348) at mem/mem0pool.c:472 #8 0x0852501c in mem_heap_block_free (heap=0xa87117b8, block=0xa87117b8) at mem/mem0mem.c:524 #9 0x08556644 in row_vers_build_for_consistent_read (rec=0xad6f9069 "\200", mtr=0xa869babc, index=0xadb95068, offsets=0xa869b924, view=0xadbb5068, offset_heap=0xa869bab8, in_heap=0xa01c048, old_vers=0xa869b920) at ../../storage/innobase/include/mem0mem.ic:487 #10 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadbb5068, clust_index=0xadb95068, prebuilt=0xa0e2a78, rec=0xad6f9069 "\200", offsets=0xa869b924, offset_heap=0xa869bab8, old_vers=0xa869b920, mtr=0xa869babc) at row/row0sel.c:2774 #11 0x0854e978 in row_search_for_mysql (buf=0xa1bde80 "\002\031\004", mode=1, prebuilt=0xa0e2a78, match_mode=0, direction=1) at row/row0sel.c:4111 #12 0x084cacfc in ha_innobase::general_fetch (this=0xa1bdce8, buf=0xa1bde80 "\002\031\004", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #13 0x084cae23 in ha_innobase::rnd_next (this=0xa1bdce8, buf=0xa1bde80 "\002\031\004") at handler/ha_innodb.cc:4609 #14 0x082fe7e7 in rr_sequential (info=0xa18af30) at records.cc:366 #15 0x08281628 in sub_select (join=0xa19ee88, join_tab=0xa18aeec, end_of_records=false) at sql_select.cc:13646 #16 0x0828197d in flush_cached_records (join=0xa19ee88, join_tab=0xa18ad48, skip_last=) at sql_select.cc:14020 #17 0x08281a30 in sub_select_cache (join=0xa19ee88, join_tab=0xa18ad48, end_of_records=true) at sql_select.cc:13449 #18 0x08281575 in sub_select (join=0xa19ee88, join_tab=0xa18aba4, end_of_records=248) at sql_select.cc:13597 #19 0x08281575 in sub_select (join=0xa19ee88, join_tab=0xa18aa00, end_of_records=248) at sql_select.cc:13597 #20 0x0828b5d4 in do_select (join=0xa19ee88, fields=0x0, table=0xa24a808, procedure=0x0) at sql_select.cc:13389 #21 0x0828bff0 in JOIN::exec (this=0xa19ee88) at sql_select.cc:2399 #22 0x0835f3b2 in st_select_lex_unit::exec (this=0xa10df80) at sql_union.cc:514 #23 0x08360b77 in mysql_union (thd=0xa10ce30, lex=0xa10df24, result=0xa8505620, unit=0xa10df80, setup_tables_done_option=0) at sql_union.cc:34 #24 0x08290f89 in handle_select (thd=0xa10ce30, lex=0xa10df24, result=0xa8505620, setup_tables_done_option=0) at sql_select.cc:280 #25 0x082201e2 in execute_sqlcom_select (thd=0xa10ce30, all_tables=0xa170b48) at sql_parse.cc:4847 #26 0x08220f61 in mysql_execute_command (thd=0xa10ce30) at sql_parse.cc:2015 #27 0x0822a02e in mysql_parse (thd=0xa10ce30, inBuf=0xa16f9d8 "( SELECT MAX( L . pk ) AS X, COUNT( K . int_nokey ) AS Y, MAX( K . pk ) AS Z FROM `B` AS K LEFT JOIN `C` AS L ON ( K . int_key = L . pk ) WHERE L . pk < 189 GROUP BY L . int_key ORDER BY X ) UNION AL"..., length=1236, found_semicolon=0xa869d314) at sql_parse.cc:5811 #28 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa10ce30, packet=0xa10ec61 "( SELECT MAX( L . pk ) AS X, COUNT( K . int_nokey ) AS Y, MAX( K . pk ) AS Z FROM `B` AS K LEFT JOIN `C` AS L ON ( K . int_key = L . pk ) WHERE L . pk < 189 GROUP BY L . int_key ORDER BY X ) UNION AL"..., packet_length=1236) at sql_parse.cc:1051 #29 0x0822ba49 in do_command (thd=0xa10ce30) at sql_parse.cc:724 #30 0x0821bef0 in handle_one_connection (arg=0xa10ce30) at sql_connect.cc:1153 #31 0x0057d32f in start_thread () from /lib/libpthread.so.0 #32 0x0049a27e in clone () from /lib/libc.so.6 Thread 4 (process 9980): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085b369a in safe_cond_wait (cond=0x9fe0cc8, mp=0x9fe0c78, file=0x86e3ef9 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x0852db12 in os_event_wait_low (event=0x9fe0c78, reset_sig_count=54) at os/os0sync.c:422 #4 0x0855df31 in sync_array_wait_event (arr=0x9ae4078, index=3) at sync/sync0arr.c:448 #5 0x0855e768 in rw_lock_s_lock_spin (lock=0xadb83878, pass=0, file_name=0x86e99bc "row/row0vers.c", line=443) at sync/sync0rw.c:323 #6 0x08555fb7 in row_vers_build_for_consistent_read (rec=0xad6e63a1 "\200", mtr=0xa866aabc, index=0xadb95068, offsets=0xa866a924, view=0xadbb0068, offset_heap=0xa866aab8, in_heap=0xadbb9628, old_vers=0xa866a920) at ../../storage/innobase/include/sync0rw.ic:253 #7 0x0854ce9d in row_sel_build_prev_vers_for_mysql (read_view=0xadbb0068, clust_index=0xadb95068, prebuilt=0xa1c2668, rec=0xad6e63a1 "\200", offsets=0xa866a924, offset_heap=0xa866aab8, old_vers=0xa866a920, mtr=0xa866aabc) at row/row0sel.c:2774 #8 0x0854e978 in row_search_for_mysql (buf=0xa1be988 "\0024\003", mode=1, prebuilt=0xa1c2668, match_mode=0, direction=1) at row/row0sel.c:4111 #9 0x084cacfc in ha_innobase::general_fetch (this=0xa1be7f0, buf=0xa1be988 "\0024\003", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #10 0x084cae23 in ha_innobase::rnd_next (this=0xa1be7f0, buf=0xa1be988 "\0024\003") at handler/ha_innodb.cc:4609 #11 0x082fe7e7 in rr_sequential (info=0xa876153c) at records.cc:366 #12 0x082819ab in flush_cached_records (join=0xa873e668, join_tab=0xa87614f8, skip_last=false) at sql_select.cc:13998 #13 0x08281aa8 in sub_select_cache (join=0xa873e668, join_tab=0xa87614f8, end_of_records=false) at sql_select.cc:13463 #14 0x0828197d in flush_cached_records (join=0xa873e668, join_tab=0xa8761354, skip_last=) at sql_select.cc:14020 #15 0x08281a30 in sub_select_cache (join=0xa873e668, join_tab=0xa8761354, end_of_records=true) at sql_select.cc:13449 #16 0x08281575 in sub_select (join=0xa873e668, join_tab=0xa87611b0, end_of_records=218) at sql_select.cc:13597 #17 0x0828b5d4 in do_select (join=0xa873e668, fields=0xa873f9a8, table=0x0, procedure=0x0) at sql_select.cc:13389 #18 0x0828d761 in JOIN::exec (this=0xa873e668) at sql_select.cc:2811 #19 0x0835f3b2 in st_select_lex_unit::exec (this=0xa113dc0) at sql_union.cc:514 #20 0x08360b77 in mysql_union (thd=0xa112c70, lex=0xa113d64, result=0xa2a05c8, unit=0xa113dc0, setup_tables_done_option=0) at sql_union.cc:34 #21 0x08290f89 in handle_select (thd=0xa112c70, lex=0xa113d64, result=0xa2a05c8, setup_tables_done_option=0) at sql_select.cc:280 #22 0x082201e2 in execute_sqlcom_select (thd=0xa112c70, all_tables=0xa128408) at sql_parse.cc:4847 #23 0x08220f61 in mysql_execute_command (thd=0xa112c70) at sql_parse.cc:2015 #24 0x0822a02e in mysql_parse (thd=0xa112c70, inBuf=0xa127770 "( SELECT COUNT( K . int_key ) AS X, MAX( L . int_key ) AS Y, MIN( L . int_key ) AS Z FROM `B` AS K LEFT JOIN `C` AS L ON ( K . int_key = L . int_nokey ) WHERE K . pk = L . int_key ) UNION ALL ( SEL"..., length=616, found_semicolon=0xa866c314) at sql_parse.cc:5811 #25 0x0822a921 in dispatch_command (command=COM_QUERY, thd=0xa112c70, packet=0xa114aa1 "( SELECT COUNT( K . int_key ) AS X, MAX( L . int_key ) AS Y, MIN( L . int_key ) AS Z FROM `B` AS K LEFT JOIN `C` AS L ON ( K . int_key = L . int_nokey ) WHERE K . pk = L . int_key ) UNION ALL ( SEL"..., packet_length=618) at sql_parse.cc:1051 #26 0x0822ba49 in do_command (thd=0xa112c70) at sql_parse.cc:724 #27 0x0821bef0 in handle_one_connection (arg=0xa112c70) at sql_connect.cc:1153 #28 0x0057d32f in start_thread () from /lib/libpthread.so.0 #29 0x0049a27e in clone () from /lib/libc.so.6 Thread 3 (process 10014): #0 0x00110416 in __kernel_vsyscall () #1 0x00492a5f in fdatasync () from /lib/libc.so.6 #2 0x085a8162 in my_sync (fd=23, my_flags=16) at my_sync.c:62 #3 0x083ebcfd in write_meta_file (meta_file=23, rows=, dirty=true) at ha_tina.cc:317 #4 0x083ec7c2 in ha_tina::init_tina_writer (this=0xa129788) at ha_tina.cc:342 #5 0x083ee169 in ha_tina::write_row (this=0xa129788, buf=0xa12c968 "1\235kH\031") at ha_tina.cc:884 #6 0x0830a043 in handler::ha_write_row (this=0xa129788, buf=0xa12c968 "1\235kH\031") at handler.cc:5315 #7 0x082b82e1 in Log_to_csv_event_handler::log_general (this=0x9abee90, thd=0xa18f2b8, event_time=1215012145, user_host=0xa84fe6bc "root[root] @ localhost []", user_host_len=25, thread_id=14, command_type=0x8631ef3 "Connect", command_type_len=7, sql_text=0xa84fe8e8 "root@localhost on test", sql_text_len=22, client_cs=0x877fc40) at log.cc:454 #8 0x082b37c9 in LOGGER::general_log_write (this=0x8789ba0, thd=0xa18f2b8, command=COM_CONNECT, query=0xa84fe8e8 "root@localhost on test", query_length=22) at log.cc:1046 #9 0x082b38ce in LOGGER::general_log_print (this=0x8789ba0, thd=0xa18f2b8, command=COM_CONNECT, format=0x8631480 "%s@%s on %s", args=0xa84fed2c "Èw\r\nÅhb\bâñO¨çØn\bÿÿÿ\017\\\024c\b\\íO¨\020") at log.cc:1065 #10 0x082b3921 in general_log_print (thd=0xa18f2b8, command=COM_CONNECT, format=0x8631480 "%s@%s on %s") at log.cc:4080 #11 0x0821ae4c in check_user (thd=0xa18f2b8, command=COM_CONNECT, passwd=0xa323406 "test", passwd_len=0, db=0x0, check_count=true) at sql_connect.cc:439 #12 0x0821bae8 in check_connection (thd=0xa18f2b8) at sql_connect.cc:925 #13 0x0821bb9d in login_connection (thd=0xa18f2b8) at sql_connect.cc:985 #14 0x0821beac in handle_one_connection (arg=0xa18f2b8) at sql_connect.cc:1144 #15 0x0057d32f in start_thread () from /lib/libpthread.so.0 #16 0x0049a27e in clone () from /lib/libc.so.6 Thread 2 (process 10017): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057edb5 in _L_lock_758 () from /lib/libpthread.so.0 #3 0x0057ecce in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x085b3a3a in safe_mutex_lock (mp=0x8785820, try_lock=0 '\0', file=0x8626198 "mysqld.cc", line=1879) at thr_mutex.c:153 #5 0x0821434a in close_connection (thd=0xa2a0760, errcode=0, lock=true) at mysqld.cc:1879 #6 0x0821bf1a in handle_one_connection (arg=0xa2a0760) at sql_connect.cc:1159 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 1 (process 9931): #0 0x00110416 in __kernel_vsyscall () #1 0x00581c78 in pthread_kill () from /lib/libpthread.so.0 #2 0x085b0dc4 in my_write_core (sig=6) at stacktrace.c:307 #3 0x08213e88 in handle_segfault (sig=6) at mysqld.cc:2638 #4 #5 0x00110416 in __kernel_vsyscall () #6 0x003e6660 in raise () from /lib/libc.so.6 #7 0x003e8028 in abort () from /lib/libc.so.6 #8 0x0855ad31 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2131 #9 0x0057d32f in start_thread () from /lib/libpthread.so.0 #10 0x0049a27e in clone () from /lib/libc.so.6 (gdb) quit