Remaining crash output: key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=4 max_threads=151 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59965 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x0 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 = 0x0 thread_stack 0x30000 # 22:52:17 datadir is /Users/pcrews/usr/local/bin/data1/work/54_80509/mysql-5.1/mysql-test/var/master-data/ # 22:52:17 Core file appears to be /cores/core.3203 # 22:52:18 Reading symbols for shared libraries .... done # 22:52:18 Core was generated by `/mysql-5.1/sql/mysqld'. # 22:52:18 Reading symbols for shared libraries . done # 22:52:18 Reading symbols for shared libraries .... done # 22:52:18 #0 0x8fe09cd1 in __dyld_dladdr () # 22:52:18 #0 0x8fe09cd1 in __dyld_dladdr () # 22:52:18 #1 0x90e2b269 in dladdr () # 22:52:18 #2 0x90eda72d in backtrace_symbols_fd () # 22:52:18 #3 0x0056a38d in my_print_stacktrace (stack_bottom=0x0, thread_stack=196608) at stacktrace.c:124 # 22:52:18 #4 0x000f8897 in handle_segfault (sig=6) at mysqld.cc:2481 # 22:52:18 #5 # 22:52:18 #6 0x90e716fa in select$DARWIN_EXTSN () # 22:52:18 #7 0x000fc48e in handle_connections_sockets (arg=0x0) at mysqld.cc:4993 # 22:52:18 #8 0x00102a86 in main (argc=41, argv=0xbfffa9d4) at mysqld.cc:4490 # 22:52:20 Reading symbols for shared libraries .... done # 22:52:20 Core was generated by `/Users/pcrews/usr/local/bin/data1/work/54_80509/mysql-5.1/sql/mysqld'. # 22:52:20 Reading symbols for shared libraries . done # 22:52:20 Reading symbols for shared libraries .... done # 22:52:20 #0 0x8fe09cd1 in __dyld_dladdr () # 22:52:20 # 22:52:20 Thread 11 (core thread 10): # 22:52:20 #0 0x90efe136 in clock_get_attributes () # 22:52:20 #1 0x90ef7013 in usleep$NOCANCEL$UNIX2003 () # 22:52:20 #2 0x90f0e62e in __ovfl_delete () # 22:52:20 #3 0x90f0e68a in abort () # 22:52:20 #4 0x90f033db in __assert_rtn () # 22:52:20 #5 0x00231f60 in check_group_min_max_predicates (cond=0x1121860, min_max_arg_item=0x1121358, image_type=Field::itRAW) at opt_range.cc:9633 # 22:52:20 #6 0x002333a8 in get_best_group_min_max (param=0xb041ee9c, tree=0x0) at opt_range.cc:9543 # 22:52:20 #7 0x00234062 in SQL_SELECT::test_quick_select (this=0x1122ef8, thd=0x1103418, keys_to_use={map = 32}, prev_tables=0, limit=18446744073709551615, force_quick_range=false) at opt_range.cc:2352 # 22:52:20 #8 0x0017a32f in get_quick_record_count (thd=0x1103418, select=0x1122ef8, table=0x1118c18, keys=0x1122cc8, limit=18446744073709551615) at sql_select.cc:2445 # 22:52:20 #9 0x0018fae8 in make_join_statistics (join=0x1121a30, tables_arg=0x1121658, conds=0x1121860, keyuse_array=0x1122b34) at sql_select.cc:2855 # 22:52:20 #10 0x0019dedd in JOIN::optimize (this=0x1121a30) at sql_select.cc:954 # 22:52:20 #11 0x001a5cae in mysql_select (thd=0x1103418, rref_pointer_array=0x1104864, tables=0x1121658, wild_num=0, fields=@0x1104800, conds=0x1121860, og_num=1, order=0x0, group=0x1121988, having=0x0, proc_param=0x0, select_options=2147764736, result=0x1121a18, unit=0x11044fc, select_lex=0x110476c) at sql_select.cc:2384 # 22:52:20 #12 0x001a60c2 in handle_select (thd=0x1103418, lex=0x11044a0, result=0x1121a18, setup_tables_done_option=0) at sql_select.cc:268 # 22:52:20 #13 0x0010a4a6 in execute_sqlcom_select (thd=0x1103418, all_tables=0x1121658) at sql_parse.cc:5011 # 22:52:20 #14 0x00110f14 in mysql_execute_command (thd=0x1103418) at sql_parse.cc:2206 # 22:52:20 #15 0x0011afa8 in mysql_parse (thd=0x1103418, inBuf=0x1121228 "SELECT MAX( `int_key` ) , `varchar_key` field2 FROM D table1 WHERE `int_key` GROUP BY field2", length=99, found_semicolon=0xb0422df0) at sql_parse.cc:5931 # 22:52:20 #16 0x0011bd66 in dispatch_command (command=COM_QUERY, thd=0x1103418, packet=0x1931019 " SELECT MAX( `int_key` ) , `varchar_key` field2 FROM D table1 WHERE `int_key` GROUP BY field2 ", packet_length=103) at sql_parse.cc:1213 # 22:52:20 #17 0x0011d07a in do_command (thd=0x1103418) at sql_parse.cc:854 # 22:52:20 #18 0x00108122 in handle_one_connection (arg=0x1103418) at sql_connect.cc:1127 # 22:52:20 #19 0x90e53155 in _pthread_start () # 22:52:20 #20 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 10 (core thread 9): # 22:52:20 #0 0x90e45f9a in read$UNIX2003 () # 22:52:20 #1 0x0053801c in vio_read (vio=0x1e69a98, buf=0xcf6018 "\a", size=4) at viosocket.c:44 # 22:52:20 #2 0x000ebff0 in my_real_read (net=0x1019294, complen=0xb03f0e98) at net_serv.cc:817 # 22:52:20 #3 0x000ec65c in my_net_read (net=0x1019294) at net_serv.cc:1005 # 22:52:20 #4 0x0011ce9e in do_command (thd=0x1019218) at sql_parse.cc:796 # 22:52:20 #5 0x00108122 in handle_one_connection (arg=0x1019218) at sql_connect.cc:1127 # 22:52:20 #6 0x90e53155 in _pthread_start () # 22:52:20 #7 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 9 (core thread 8): # 22:52:20 #0 0x90e97412 in sigwait$UNIX2003 () # 22:52:20 #1 0x00102ece in signal_hand (arg=0x0) at mysqld.cc:2754 # 22:52:20 #2 0x90e53155 in _pthread_start () # 22:52:20 #3 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 8 (core thread 7): # 22:52:20 #0 0x90e716fa in select$DARWIN_EXTSN () # 22:52:20 #1 0x003ce2d1 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 22:52:20 #2 0x00400050 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2279 # 22:52:20 #3 0x90e53155 in _pthread_start () # 22:52:20 #4 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 7 (core thread 6): # 22:52:20 #0 0x90e716fa in select$DARWIN_EXTSN () # 22:52:20 #1 0x003ce2d1 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 22:52:20 #2 0x003ffd93 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2148 # 22:52:20 #3 0x90e53155 in _pthread_start () # 22:52:20 #4 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 6 (core thread 5): # 22:52:20 #0 0x90e716fa in select$DARWIN_EXTSN () # 22:52:20 #1 0x003ce2d1 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 22:52:20 #2 0x003ff6e7 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1922 # 22:52:20 #3 0x90e53155 in _pthread_start () # 22:52:20 #4 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 5 (core thread 4): # 22:52:20 #0 0x90e2946e in nanosleep$UNIX2003 () # 22:52:20 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 22:52:20 #2 0x0056f0d8 in safe_cond_wait (cond=0x1e229d4, mp=0x1e22960, file=0x64d19e "os/os0sync.c", line=422) at thr_mutex.c:237 # 22:52:20 #3 0x003cda9c in os_event_wait_low (event=0x1e22960, reset_sig_count=0) at os/os0sync.c:422 # 22:52:20 #4 0x003cc87c in os_aio_simulated_handle (global_segment=3, message1=0xb0206f34, message2=0xb0206f30, type=0xb0206f2c) at os/os0file.c:4207 # 22:52:20 #5 0x003a6b1f in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 22:52:20 #6 0x00400f69 in io_handler_thread (arg=0x8572ac) at srv/srv0start.c:435 # 22:52:20 #7 0x90e53155 in _pthread_start () # 22:52:20 #8 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 4 (core thread 3): # 22:52:20 #0 0x90e2946e in nanosleep$UNIX2003 () # 22:52:20 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 22:52:20 #2 0x0056f0d8 in safe_cond_wait (cond=0x1e22924, mp=0x1e228b0, file=0x64d19e "os/os0sync.c", line=422) at thr_mutex.c:237 # 22:52:20 #3 0x003cda9c in os_event_wait_low (event=0x1e228b0, reset_sig_count=0) at os/os0sync.c:422 # 22:52:20 #4 0x003cc87c in os_aio_simulated_handle (global_segment=2, message1=0xb0184f34, message2=0xb0184f30, type=0xb0184f2c) at os/os0file.c:4207 # 22:52:20 #5 0x003a6b1f in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 22:52:20 #6 0x00400f69 in io_handler_thread (arg=0x8572a8) at srv/srv0start.c:435 # 22:52:20 #7 0x90e53155 in _pthread_start () # 22:52:20 #8 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 3 (core thread 2): # 22:52:20 #0 0x90e2946e in nanosleep$UNIX2003 () # 22:52:20 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 22:52:20 #2 0x0056f0d8 in safe_cond_wait (cond=0x1e22874, mp=0x1e22800, file=0x64d19e "os/os0sync.c", line=422) at thr_mutex.c:237 # 22:52:20 #3 0x003cda9c in os_event_wait_low (event=0x1e22800, reset_sig_count=0) at os/os0sync.c:422 # 22:52:20 #4 0x003cc87c in os_aio_simulated_handle (global_segment=1, message1=0xb0102f34, message2=0xb0102f30, type=0xb0102f2c) at os/os0file.c:4207 # 22:52:20 #5 0x003a6b1f in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 22:52:20 #6 0x00400f69 in io_handler_thread (arg=0x8572a4) at srv/srv0start.c:435 # 22:52:20 #7 0x90e53155 in _pthread_start () # 22:52:20 #8 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 2 (core thread 1): # 22:52:20 #0 0x90e2946e in nanosleep$UNIX2003 () # 22:52:20 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 22:52:20 #2 0x0056f0d8 in safe_cond_wait (cond=0x1e227c4, mp=0x1e22750, file=0x64d19e "os/os0sync.c", line=422) at thr_mutex.c:237 # 22:52:20 #3 0x003cda9c in os_event_wait_low (event=0x1e22750, reset_sig_count=0) at os/os0sync.c:422 # 22:52:20 #4 0x003cc87c in os_aio_simulated_handle (global_segment=0, message1=0xb0080f34, message2=0xb0080f30, type=0xb0080f2c) at os/os0file.c:4207 # 22:52:20 #5 0x003a6b1f in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 22:52:20 #6 0x00400f69 in io_handler_thread (arg=0x8572a0) at srv/srv0start.c:435 # 22:52:20 #7 0x90e53155 in _pthread_start () # 22:52:20 #8 0x90e53012 in thread_start () # 22:52:20 # 22:52:20 Thread 1 (core thread 0): # 22:52:20 #0 0x8fe09cd1 in __dyld_dladdr () # 22:52:20 #1 0x90e2b269 in dladdr () # 22:52:20 #2 0x90eda72d in backtrace_symbols_fd () # 22:52:20 #3 0x0056a38d in my_print_stacktrace (stack_bottom=0x0, thread_stack=196608) at stacktrace.c:124 # 22:52:20 #4 0x000f8897 in handle_segfault (sig=6) at mysqld.cc:2481 # 22:52:20 #5 # 22:52:20 #6 0x90e716fa in select$DARWIN_EXTSN () # 22:52:20 #7 0x000fc48e in handle_connections_sockets (arg=0x0) at mysqld.cc:4993 # 22:52:20 #8 0x00102a86 in main (argc=41, argv=0xbfffa9d4) at mysqld.cc:4490 # 22:52:20 Test completed with failure status 101. # 22:52:20 gentest.pl exited with exit status 101