# 2010-03-26T10:45:57 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=12610:user=root:database=test # 2010-03-26T10:45:58 Killing periodic reporting process with pid 9638... # 2010-03-26T10:45:58 Kill GenTest::ErrorFilter(9637) # 2010-03-26T10:45:58 Server crash reported, initiating post-crash analysis... # 2010-03-26T10:45:58 The last 100 lines from /6var6/master-data//../log/master.err : CURRENT_TEST: main.1st 100326 17:36:58 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general-log'/'--general-log-file'' instead. 100326 17:36:58 [Warning] '--log-slow-queries' is deprecated and will be removed in a future release. Please use ''--slow-query-log'/'--slow-query-log-file'' instead. 100326 17:36:58 [Note] Buffered information: Performance schema disabled (reason: start parameters). 100326 17:36:58 [Note] Plugin 'FEDERATED' is disabled. 100326 17:36:58 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The InnoDB memory heap has been disabled. InnoDB: ios_per_array 256 read threads 8 write threads 8 InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100326 17:36:58 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100326 17:36:58 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 100326 17:36:59 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created InnoDB master thread running with io_capacity 200 100326 17:36:59 InnoDB: Started; log sequence number 0 0 100326 17:36:59 [Warning] /mysql-6.0/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 100326 17:36:59 [Note] Event Scheduler: Loaded 0 events 100326 17:36:59 [Note] /mysql-6.0/sql/mysqld: ready for connections. Version: '6.0.14-alpha-gcov-debug-log' socket: '/6var6/tmp/master.sock' port: 12610 Source distribution 100326 17:45:57 - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=3 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60134 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xa425048 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0xabdc1f4c thread_stack 0x30c00 /mysql-6.0/sql/mysqld(my_print_stacktrace+0x42) [0x8d1edf6] /mysql-6.0/sql/mysqld(handle_segfault+0x4e3) [0x8421d0d] [0xa98400] /mysql-6.0/sql/mysqld(JOIN_CACHE::get_rec_length(unsigned char*)+0x3e) [0x84cd0b2] /mysql-6.0/sql/mysqld(JOIN_CACHE::read_referenced_field(st_cache_field*, unsigned char*, unsigned int*)+0x117) [0x84c77c5] /mysql-6.0/sql/mysqld(JOIN_CACHE_BKA::get_next_key(unsigned char**)+0x3dd) [0x84ca53d] /mysql-6.0/sql/mysqld [0x84c9726] /mysql-6.0/sql/mysqld(handler::multi_range_read_next(char**)+0x2d0) [0x87014ee] /mysql-6.0/sql/mysqld(DsMrr_impl::dsmrr_fill_buffer()+0x260) [0x870266c] /mysql-6.0/sql/mysqld(DsMrr_impl::dsmrr_init(handler*, st_range_seq_if*, void*, unsigned int, unsigned int, st_handler_buffer*)+0x7db) [0x8701e17] /mysql-6.0/sql/mysqld(ha_myisam::multi_range_read_init(st_range_seq_if*, void*, unsigned int, unsigned int, st_handler_buffer*)+0x5d) [0x8baedf1] /mysql-6.0/sql/mysqld(JOIN_CACHE_BKA::init_join_matching_records(st_range_seq_if*, unsigned int)+0x1ce) [0x84ca066] /mysql-6.0/sql/mysqld(JOIN_CACHE_BKA::join_matching_records(bool)+0x199) [0x84c9ae9] /mysql-6.0/sql/mysqld(JOIN_CACHE::join_records(bool)+0xfa) [0x84c7d2c] /mysql-6.0/sql/mysqld(JOIN_CACHE::join_records(bool)+0x441) [0x84c8073] /mysql-6.0/sql/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x10a) [0x858303f] /mysql-6.0/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xa3) [0x85834ad] /mysql-6.0/sql/mysqld [0x8582127] /mysql-6.0/sql/mysqld(JOIN::exec()+0x12ad) [0x8545667] /mysql-6.0/sql/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x5aa) [0x85490d1] /mysql-6.0/sql/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2e2) [0x853944d] /mysql-6.0/sql/mysqld [0x8459ca5] /mysql-6.0/sql/mysqld(mysql_execute_command(THD*)+0x1427) [0x8448b0c] /mysql-6.0/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x4ed) [0x845dd5a] /mysql-6.0/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x12f5) [0x84439ad] /mysql-6.0/sql/mysqld(do_command(THD*)+0x492) [0x84421c7] /mysql-6.0/sql/mysqld(do_handle_one_connection(THD*)+0x2f6) [0x843e551] /mysql-6.0/sql/mysqld(handle_one_connection+0x60) [0x843e238] /lib/tls/i686/cmov/libpthread.so.0 [0x38080e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x2928de] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xa40e9f0 = SELECT table2 . `col_datetime_key` AS field1 , CONCAT ( table2 . `col_varchar_key` , table2 . `col_varchar_nokey` ) AS field2 , table2 . `col_datetime_key` AS field3 , table2 . `col_datetime_key` AS field4 FROM ( C AS table1 INNER JOIN ( ( CC AS table2 STRAIGHT_JOIN C AS table3 ON (( table3 . `col_int_key` = table2 . `col_int_nokey` ) AND ( table3 . `col_int_nokey` = table2 . `pk` ) ) ) ) ON (( table3 . `pk` = table2 . `col_int_nokey` ) AND ( table3 . `col_varchar_nokey` != table2 . `col_varchar_key` ) ) ) GROUP BY field1, field2, field3, field4 LIMIT 1 /* TRANSFORM_OUTCOME_SINGLE_ROW */ thd->thread_id=6 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file # 2010-03-26T10:45:58 datadir is /6var6/master-data/ # 2010-03-26T10:45:58 binary is /mysql-6.0/mysql-test/../sql/mysqld # 2010-03-26T10:45:58 bindir is /mysql-6.0/mysql-test/../sql # 2010-03-26T10:45:58 core is /6var6/master-data//core warning: Can't read pathname for load map: Input/output error. # 2010-03-26T10:46:00 [New Thread 9608] # 2010-03-26T10:46:00 [New Thread 9611] # 2010-03-26T10:46:00 [New Thread 9609] # 2010-03-26T10:46:00 [New Thread 9624] # 2010-03-26T10:46:00 [New Thread 9628] # 2010-03-26T10:46:00 [New Thread 9627] # 2010-03-26T10:46:00 [New Thread 9630] # 2010-03-26T10:46:00 [New Thread 9617] # 2010-03-26T10:46:00 [New Thread 9613] # 2010-03-26T10:46:00 [New Thread 9623] # 2010-03-26T10:46:00 [New Thread 9619] # 2010-03-26T10:46:00 [New Thread 9615] # 2010-03-26T10:46:00 [New Thread 9626] # 2010-03-26T10:46:00 [New Thread 9605] # 2010-03-26T10:46:00 [New Thread 9621] # 2010-03-26T10:46:00 [New Thread 9607] # 2010-03-26T10:46:00 [New Thread 9625] # 2010-03-26T10:46:00 [New Thread 9610] # 2010-03-26T10:46:00 [New Thread 9612] # 2010-03-26T10:46:00 [New Thread 9614] # 2010-03-26T10:46:00 [New Thread 9616] # 2010-03-26T10:46:00 [New Thread 9618] # 2010-03-26T10:46:00 [New Thread 9620] # 2010-03-26T10:46:00 [New Thread 9622] # 2010-03-26T10:46:00 Core was generated by `/mysql-6.0/sql/mysqld --no-defaults --basedir=/ho'. # 2010-03-26T10:46:00 Program terminated with signal 11, Segmentation fault. # 2010-03-26T10:46:00 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:00 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:00 #1 0x00385e93 in __pthread_kill (threadid=2883331952, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 # 2010-03-26T10:46:00 #2 0x08d1f00f in my_write_core (sig=11) at stacktrace.c:328 # 2010-03-26T10:46:00 #3 0x08422222 in handle_segfault (sig=11) at mysqld.cc:2843 # 2010-03-26T10:46:00 #4 # 2010-03-26T10:46:00 #5 0x084cce4a in JOIN_CACHE::get_offset (this=0xa5d5720, ofs_sz=1, ptr=0xb5e9127
) at sql_select.h:445 # 2010-03-26T10:46:00 #6 0x084cd0b2 in JOIN_CACHE::get_rec_length (this=0xa5d5720, ptr=0xb5e9127
) at sql_select.h:624 # 2010-03-26T10:46:00 #7 0x084c77c5 in JOIN_CACHE::read_referenced_field (this=0xa5d5720, copy=0xa5d57d8, rec_ptr=0xb5e9128
, # 2010-03-26T10:46:00 len=0xabdbfc1c) at sql_join_cache.cc:1499 # 2010-03-26T10:46:00 #8 0x084ca53d in JOIN_CACHE_BKA::get_next_key (this=0xa5d5850, key=0xa5d5b60) at sql_join_cache.cc:2495 # 2010-03-26T10:46:00 #9 0x084c9726 in bka_range_seq_next (rseq=0xa5d5850, range=0xa5d5b60) at sql_join_cache.cc:2164 # 2010-03-26T10:46:00 #10 0x087014ee in handler::multi_range_read_next (this=0xa5d5ac0, range_info=0xabdbfd4c) at handler.cc:4427 # 2010-03-26T10:46:00 #11 0x0870266c in DsMrr_impl::dsmrr_fill_buffer (this=0xa424654) at handler.cc:4660 # 2010-03-26T10:46:00 #12 0x08701e17 in DsMrr_impl::dsmrr_init (this=0xa424654, h_arg=0xa4244f8, seq_funcs=0xabdbfe5c, seq_init_param=0xa5d5850, n_ranges=340, mode=128, # 2010-03-26T10:46:00 buf=0xa5d58d0) at handler.cc:4578 # 2010-03-26T10:46:00 #13 0x08baedf1 in ha_myisam::multi_range_read_init (this=0xa4244f8, seq=0xabdbfe5c, seq_init_param=0xa5d5850, n_ranges=340, mode=128, buf=0xa5d58d0) # 2010-03-26T10:46:00 at ha_myisam.cc:2119 # 2010-03-26T10:46:00 #14 0x084ca066 in JOIN_CACHE_BKA::init_join_matching_records (this=0xa5d5850, seq_funcs=0xabdbfe5c, ranges=340) at sql_join_cache.cc:2379 # 2010-03-26T10:46:00 #15 0x084c9ae9 in JOIN_CACHE_BKA::join_matching_records (this=0xa5d5850, skip_last=false) at sql_join_cache.cc:2287 # 2010-03-26T10:46:00 #16 0x084c7d2c in JOIN_CACHE::join_records (this=0xa5d5850, skip_last=false) at sql_join_cache.cc:1627 # 2010-03-26T10:46:00 #17 0x084c8073 in JOIN_CACHE::join_records (this=0xa5d5720, skip_last=false) at sql_join_cache.cc:1673 # 2010-03-26T10:46:00 #18 0x0858303f in sub_select_cache (join=0xa5d0500, join_tab=0xa50f574, end_of_records=true) at sql_select.cc:16405 # 2010-03-26T10:46:00 #19 0x085834ad in sub_select (join=0xa5d0500, join_tab=0xa50f3b8, end_of_records=true) at sql_select.cc:16568 # 2010-03-26T10:46:00 #20 0x08582127 in do_select (join=0xa5d0500, fields=0x0, table=0xa50ff48, procedure=0x0) at sql_select.cc:16159 # 2010-03-26T10:46:00 #21 0x08545667 in JOIN::exec (this=0xa5d0500) at sql_select.cc:2567 # 2010-03-26T10:46:00 #22 0x085490d1 in mysql_select (thd=0xa425048, rref_pointer_array=0xa426658, tables=0xa40f958, wild_num=0, fields=..., conds=0x0, og_num=4, # 2010-03-26T10:46:00 order=0x0, group=0xa5cf1a0, having=0x0, proc_param=0x0, select_options=2147781376, result=0xa5cf4b8, unit=0xa426094, select_lex=0xa426554) # 2010-03-26T10:46:00 at sql_select.cc:3184 # 2010-03-26T10:46:00 #23 0x0853944d in handle_select (thd=0xa425048, lex=0xa426038, result=0xa5cf4b8, setup_tables_done_option=0) at sql_select.cc:304 # 2010-03-26T10:46:00 #24 0x08459ca5 in execute_sqlcom_select (thd=0xa425048, all_tables=0xa40f958) at sql_parse.cc:5032 # 2010-03-26T10:46:00 #25 0x08448b0c in mysql_execute_command (thd=0xa425048) at sql_parse.cc:2295 # 2010-03-26T10:46:00 #26 0x0845dd5a in mysql_parse (thd=0xa425048, # 2010-03-26T10:46:00 inBuf=0xa40e9f0 "SELECT table2 . `col_datetime_key` AS field1 , CONCAT ( table2 . `col_varchar_key` , table2 . `col_varchar_nokey` ) AS field2 , table2 . `col_datetime_key` AS field3 , table2 . `col_datetime_key` A"..., length=602, found_semicolon=0xabdc1950) at sql_parse.cc:6060 # 2010-03-26T10:46:00 #27 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xa425048, # 2010-03-26T10:46:00 packet=0xa3fab19 " SELECT table2 . `col_datetime_key` AS field1 , CONCAT ( table2 . `col_varchar_key` , table2 . `col_varchar_nokey` ) AS field2 , table2 . `col_datetime_key` AS field3 , table2 . `col_datetime_key` "..., packet_length=603) at sql_parse.cc:1091 # 2010-03-26T10:46:00 #28 0x084421c7 in do_command (thd=0xa425048) at sql_parse.cc:775 # 2010-03-26T10:46:00 #29 0x0843e551 in do_handle_one_connection (thd_arg=0xa425048) at sql_connect.cc:1173 # 2010-03-26T10:46:00 #30 0x0843e238 in handle_one_connection (arg=0xa425048) at sql_connect.cc:1113 # 2010-03-26T10:46:00 #31 0x0038080e in start_thread (arg=0xabdc2770) at pthread_create.c:300 # 2010-03-26T10:46:00 #32 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 warning: Can't read pathname for load map: Input/output error. # 2010-03-26T10:46:01 [New Thread 9608] # 2010-03-26T10:46:01 [New Thread 9611] # 2010-03-26T10:46:01 [New Thread 9609] # 2010-03-26T10:46:01 [New Thread 9624] # 2010-03-26T10:46:01 [New Thread 9628] # 2010-03-26T10:46:01 [New Thread 9627] # 2010-03-26T10:46:01 [New Thread 9630] # 2010-03-26T10:46:01 [New Thread 9617] # 2010-03-26T10:46:01 [New Thread 9613] # 2010-03-26T10:46:01 [New Thread 9623] # 2010-03-26T10:46:01 [New Thread 9619] # 2010-03-26T10:46:01 [New Thread 9615] # 2010-03-26T10:46:01 [New Thread 9626] # 2010-03-26T10:46:01 [New Thread 9605] # 2010-03-26T10:46:01 [New Thread 9621] # 2010-03-26T10:46:01 [New Thread 9607] # 2010-03-26T10:46:01 [New Thread 9625] # 2010-03-26T10:46:01 [New Thread 9610] # 2010-03-26T10:46:01 [New Thread 9612] # 2010-03-26T10:46:01 [New Thread 9614] # 2010-03-26T10:46:01 [New Thread 9616] # 2010-03-26T10:46:01 [New Thread 9618] # 2010-03-26T10:46:01 [New Thread 9620] # 2010-03-26T10:46:01 [New Thread 9622] # 2010-03-26T10:46:01 Core was generated by `/mysql-6.0/sql/mysqld --no-defaults --basedir=/ho'. # 2010-03-26T10:46:01 Program terminated with signal 11, Segmentation fault. # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 25 (Thread 9622): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa187254, mp=0xa1871e8, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa1871e8, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=15, message1=0xaf2f3344, message2=0xaf2f3340, type=0xaf2f333c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=15) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43bc) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xaf2f3b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 24 (Thread 9620): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa1870e4, mp=0xa187078, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa187078, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=13, message1=0xb02f5344, message2=0xb02f5340, type=0xb02f533c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=13) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43b4) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb02f5b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 23 (Thread 9618): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186f74, mp=0xa186f08, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186f08, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=11, message1=0xb12f7344, message2=0xb12f7340, type=0xb12f733c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=11) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43ac) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb12f7b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 22 (Thread 9616): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186e04, mp=0xa186d98, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186d98, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=9, message1=0xb22f9344, message2=0xb22f9340, type=0xb22f933c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=9) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43a4) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb22f9b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 21 (Thread 9614): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186c94, mp=0xa186c28, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186c28, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=7, message1=0xb32fb344, message2=0xb32fb340, type=0xb32fb33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=7) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b439c) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb32fbb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 20 (Thread 9612): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186b24, mp=0xa186ab8, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186ab8, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=5, message1=0xb42fd344, message2=0xb42fd340, type=0xb42fd33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=5) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4394) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb42fdb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 19 (Thread 9610): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa1869b4, mp=0xa186948, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186948, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=3, message1=0xb52ff344, message2=0xb52ff340, type=0xb52ff33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b438c) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb52ffb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 18 (Thread 9625): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x0028ba71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-26T10:46:01 #2 0x08a7a3bd in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 2010-03-26T10:46:01 #3 0x08acc1a9 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:2104 # 2010-03-26T10:46:01 #4 0x0038080e in start_thread (arg=0xadaefb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #5 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 17 (Thread 9607): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa18678c, mp=0xa186720, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186720, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=0, message1=0xb7789344, message2=0xb7789340, type=0xb778933c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4380) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb7789b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 16 (Thread 9621): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa18719c, mp=0xa187130, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa187130, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=14, message1=0xafaf4344, message2=0xafaf4340, type=0xafaf433c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=14) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43b8) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xafaf4b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 15 (Thread 9605): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00284c96 in *__GI___poll (fds=0x306ff4, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:87 # 2010-03-26T10:46:01 #2 0x0842bd61 in handle_connections_sockets () at mysqld.cc:5562 # 2010-03-26T10:46:01 #3 0x0842a71b in mysqld_main (argc=42, argv=0x9af3ca0) at mysqld.cc:5035 # 2010-03-26T10:46:01 #4 0x084189ff in main (argc=42, argv=0xbfdfc4b4) at main.cc:24 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 14 (Thread 9626): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x0028ba71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-26T10:46:01 #2 0x08a7a3bd in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 2010-03-26T10:46:01 #3 0x08accddf in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2307 # 2010-03-26T10:46:01 #4 0x0038080e in start_thread (arg=0xad2eeb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #5 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 13 (Thread 9615): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186d4c, mp=0xa186ce0, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186ce0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=8, message1=0xb2afa344, message2=0xb2afa340, type=0xb2afa33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=8) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43a0) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb2afab70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 12 (Thread 9619): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa18702c, mp=0xa186fc0, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186fc0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=12, message1=0xb0af6344, message2=0xb0af6340, type=0xb0af633c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=12) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43b0) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb0af6b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 11 (Thread 9623): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa18730c, mp=0xa1872a0, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa1872a0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=16, message1=0xaeaf2344, message2=0xaeaf2340, type=0xaeaf233c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=16) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43c0) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xaeaf2b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 10 (Thread 9613): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186bdc, mp=0xa186b70, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186b70, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=6, message1=0xb3afc344, message2=0xb3afc340, type=0xb3afc33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=6) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4398) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb3afcb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 9 (Thread 9617): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186ebc, mp=0xa186e50, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186e50, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=10, message1=0xb1af8344, message2=0xb1af8340, type=0xb1af833c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=10) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43a8) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb1af8b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 8 (Thread 9630): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00387c8b in read () from /lib/tls/i686/cmov/libpthread.so.0 # 2010-03-26T10:46:01 #2 0x08e7eda3 in vio_read (vio=0x9c062a0, buf=0xa3d23f0 "\a", size=4) at viosocket.c:44 # 2010-03-26T10:46:01 #3 0x0840021d in my_real_read (net=0xa33e280, complen=0xabdf2ec8) at net_serv.cc:835 # 2010-03-26T10:46:01 #4 0x08400ddb in my_net_read (net=0xa33e280) at net_serv.cc:1025 # 2010-03-26T10:46:01 #5 0x08441e57 in do_command (thd=0xa33e130) at sql_parse.cc:721 # 2010-03-26T10:46:01 #6 0x0843e551 in do_handle_one_connection (thd_arg=0xa33e130) at sql_connect.cc:1173 # 2010-03-26T10:46:01 #7 0x0843e238 in handle_one_connection (arg=0xa33e130) at sql_connect.cc:1113 # 2010-03-26T10:46:01 #8 0x0038080e in start_thread (arg=0xabdf3770) at pthread_create.c:300 # 2010-03-26T10:46:01 #9 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 7 (Thread 9627): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0x9c2c83c, mp=0x9c2c7d0, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0x9c2c7d0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08ace748 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2839 # 2010-03-26T10:46:01 #5 0x0038080e in start_thread (arg=0xac625b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #6 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 6 (Thread 9628): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00388d5a in do_sigwait (set=0x390ff4, sig=) # 2010-03-26T10:46:01 at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63 # 2010-03-26T10:46:01 #2 0x00388e00 in __sigwait (set=0xabe23ed4, sig=0xabe23f6c) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100 # 2010-03-26T10:46:01 #3 0x08423395 in signal_hand (arg=0x0) at mysqld.cc:3046 # 2010-03-26T10:46:01 #4 0x0038080e in start_thread (arg=0xabe24770) at pthread_create.c:300 # 2010-03-26T10:46:01 #5 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 5 (Thread 9624): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa1873c4, mp=0xa187358, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa187358, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=17, message1=0xae2f1344, message2=0xae2f1340, type=0xae2f133c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=17) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b43c4) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xae2f1b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 4 (Thread 9609): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa1868fc, mp=0xa186890, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186890, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=2, message1=0xb5b00344, message2=0xb5b00340, type=0xb5b0033c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4388) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb5b00b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 3 (Thread 9611): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186a6c, mp=0xa186a00, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa186a00, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=4, message1=0xb4afe344, message2=0xb4afe340, type=0xb4afe33c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=4) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4390) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb4afeb70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 2 (Thread 9608): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00384e15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-26T10:46:01 #2 0x08d6ed96 in safe_cond_wait (cond=0xa186844, mp=0xa1867d8, file=0x90fa50a "os/os0sync.c", line=422) at thr_mutex.c:426 # 2010-03-26T10:46:01 #3 0x08a79343 in os_event_wait_low (event=0xa1867d8, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-26T10:46:01 #4 0x08a77013 in os_aio_simulated_handle (global_segment=1, message1=0xb6301344, message2=0xb6301340, type=0xb630133c) at os/os0file.c:4252 # 2010-03-26T10:46:01 #5 0x08a26eea in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 2010-03-26T10:46:01 #6 0x08acf518 in io_handler_thread (arg=0x95b4384) at srv/srv0start.c:435 # 2010-03-26T10:46:01 #7 0x0038080e in start_thread (arg=0xb6301b70) at pthread_create.c:300 # 2010-03-26T10:46:01 #8 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-26T10:46:01 # 2010-03-26T10:46:01 Thread 1 (Thread 9640): # 2010-03-26T10:46:01 #0 0x00a98422 in __kernel_vsyscall () # 2010-03-26T10:46:01 #1 0x00385e93 in __pthread_kill (threadid=2883331952, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 # 2010-03-26T10:46:01 #2 0x08d1f00f in my_write_core (sig=11) at stacktrace.c:328 # 2010-03-26T10:46:01 #3 0x08422222 in handle_segfault (sig=11) at mysqld.cc:2843 # 2010-03-26T10:46:01 #4 # 2010-03-26T10:46:01 #5 0x084cce4a in JOIN_CACHE::get_offset (this=0xa5d5720, ofs_sz=1, ptr=0xb5e9127
) at sql_select.h:445 # 2010-03-26T10:46:01 #6 0x084cd0b2 in JOIN_CACHE::get_rec_length (this=0xa5d5720, ptr=0xb5e9127
) at sql_select.h:624 # 2010-03-26T10:46:01 #7 0x084c77c5 in JOIN_CACHE::read_referenced_field (this=0xa5d5720, copy=0xa5d57d8, rec_ptr=0xb5e9128
, # 2010-03-26T10:46:01 len=0xabdbfc1c) at sql_join_cache.cc:1499 # 2010-03-26T10:46:01 #8 0x084ca53d in JOIN_CACHE_BKA::get_next_key (this=0xa5d5850, key=0xa5d5b60) at sql_join_cache.cc:2495 # 2010-03-26T10:46:01 #9 0x084c9726 in bka_range_seq_next (rseq=0xa5d5850, range=0xa5d5b60) at sql_join_cache.cc:2164 # 2010-03-26T10:46:01 #10 0x087014ee in handler::multi_range_read_next (this=0xa5d5ac0, range_info=0xabdbfd4c) at handler.cc:4427 # 2010-03-26T10:46:01 #11 0x0870266c in DsMrr_impl::dsmrr_fill_buffer (this=0xa424654) at handler.cc:4660 # 2010-03-26T10:46:01 #12 0x08701e17 in DsMrr_impl::dsmrr_init (this=0xa424654, h_arg=0xa4244f8, seq_funcs=0xabdbfe5c, seq_init_param=0xa5d5850, n_ranges=340, mode=128, # 2010-03-26T10:46:01 buf=0xa5d58d0) at handler.cc:4578 # 2010-03-26T10:46:01 #13 0x08baedf1 in ha_myisam::multi_range_read_init (this=0xa4244f8, seq=0xabdbfe5c, seq_init_param=0xa5d5850, n_ranges=340, mode=128, buf=0xa5d58d0) # 2010-03-26T10:46:01 at ha_myisam.cc:2119 # 2010-03-26T10:46:01 #14 0x084ca066 in JOIN_CACHE_BKA::init_join_matching_records (this=0xa5d5850, seq_funcs=0xabdbfe5c, ranges=340) at sql_join_cache.cc:2379 # 2010-03-26T10:46:01 #15 0x084c9ae9 in JOIN_CACHE_BKA::join_matching_records (this=0xa5d5850, skip_last=false) at sql_join_cache.cc:2287 # 2010-03-26T10:46:01 #16 0x084c7d2c in JOIN_CACHE::join_records (this=0xa5d5850, skip_last=false) at sql_join_cache.cc:1627 # 2010-03-26T10:46:01 #17 0x084c8073 in JOIN_CACHE::join_records (this=0xa5d5720, skip_last=false) at sql_join_cache.cc:1673 # 2010-03-26T10:46:01 #18 0x0858303f in sub_select_cache (join=0xa5d0500, join_tab=0xa50f574, end_of_records=true) at sql_select.cc:16405 # 2010-03-26T10:46:01 #19 0x085834ad in sub_select (join=0xa5d0500, join_tab=0xa50f3b8, end_of_records=true) at sql_select.cc:16568 # 2010-03-26T10:46:01 #20 0x08582127 in do_select (join=0xa5d0500, fields=0x0, table=0xa50ff48, procedure=0x0) at sql_select.cc:16159 # 2010-03-26T10:46:01 #21 0x08545667 in JOIN::exec (this=0xa5d0500) at sql_select.cc:2567 # 2010-03-26T10:46:01 #22 0x085490d1 in mysql_select (thd=0xa425048, rref_pointer_array=0xa426658, tables=0xa40f958, wild_num=0, fields=..., conds=0x0, og_num=4, # 2010-03-26T10:46:01 order=0x0, group=0xa5cf1a0, having=0x0, proc_param=0x0, select_options=2147781376, result=0xa5cf4b8, unit=0xa426094, select_lex=0xa426554) # 2010-03-26T10:46:01 at sql_select.cc:3184 # 2010-03-26T10:46:01 #23 0x0853944d in handle_select (thd=0xa425048, lex=0xa426038, result=0xa5cf4b8, setup_tables_done_option=0) at sql_select.cc:304 # 2010-03-26T10:46:01 #24 0x08459ca5 in execute_sqlcom_select (thd=0xa425048, all_tables=0xa40f958) at sql_parse.cc:5032 # 2010-03-26T10:46:01 #25 0x08448b0c in mysql_execute_command (thd=0xa425048) at sql_parse.cc:2295 # 2010-03-26T10:46:01 #26 0x0845dd5a in mysql_parse (thd=0xa425048, # 2010-03-26T10:46:01 inBuf=0xa40e9f0 "SELECT table2 . `col_datetime_key` AS field1 , CONCAT ( table2 . `col_varchar_key` , table2 . `col_varchar_nokey` ) AS field2 , table2 . `col_datetime_key` AS field3 , table2 . `col_datetime_key` A"..., length=602, found_semicolon=0xabdc1950) at sql_parse.cc:6060 # 2010-03-26T10:46:01 #27 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xa425048, # 2010-03-26T10:46:01 packet=0xa3fab19 " SELECT table2 . `col_datetime_key` AS field1 , CONCAT ( table2 . `col_varchar_key` , table2 . `col_varchar_nokey` ) AS field2 , table2 . `col_datetime_key` AS field3 , table2 . `col_datetime_key` "..., packet_length=603) at sql_parse.cc:1091 # 2010-03-26T10:46:01 #28 0x084421c7 in do_command (thd=0xa425048) at sql_parse.cc:775 # 2010-03-26T10:46:01 #29 0x0843e551 in do_handle_one_connection (thd_arg=0xa425048) at sql_connect.cc:1173 # 2010-03-26T10:46:01 #30 0x0843e238 in handle_one_connection (arg=0xa425048) at sql_connect.cc:1113 # 2010-03-26T10:46:01 #31 0x0038080e in start_thread (arg=0xabdc2770) at pthread_create.c:300 # 2010-03-26T10:46:01 #32 0x002928de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130