# 00:11:10 Server crash reported, initiating post-crash analysis... # 00:11:10 The last 100 lines from/azalea_ogb/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090813 7:09:49 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead. 090813 7:09:49 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow-query-log'/'--slow-query-log-file' instead. 090813 7:09:49 [ERROR] An old style --language value with language specific part detected:/azalea_ogb/sql/share/english/ 090813 7:09:49 [ERROR] Use --lc-messages-dir without language specific part instead. 090813 7:09:49 [Warning] Setting lower_case_table_names=2 because file system for/azalea_ogb/mysql-test/var/master-data/ is case insensitive 090813 7:09:49 [Note] Plugin 'FEDERATED' is disabled. 090813 7:09:49 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090813 7:09:49 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090813 7:09:51 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... 090813 7:09:52 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 090813 7:09:52 InnoDB: Started; log sequence number 0 0 090813 7:09:52 [Warning]/azalea_ogb/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090813 7:09:52 [Note] Event Scheduler: Loaded 0 events 090813 7:09:52 [Note]/azalea_ogb/sql/mysqld: ready for connections. Version: '5.4.4-alpha-gcov-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/HCBpDfVhBk/master.sock' port: 19306 Source distribution 090813 7:10:29 - 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 = 60020 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x1a49218 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 = 0xb0512f64 thread_stack 0x30c00 0 mysqld 0x009ac1a9 my_print_stacktrace + 63 1 mysqld 0x001bf0bd handle_segfault + 1301 2 libSystem.B.dylib 0x90e8e2bb _sigtramp + 43 3 ??? 0xffffffff 0x0 + 4294967295 4 mysqld 0x002f3479 _Z23is_indexed_agg_distinctP4JOINP4ListI10Item_fieldE + 12859 5 mysqld 0x002f4867 _ZN4JOIN8optimizeEv + 4439 6 mysqld 0x003019c9 _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex + 1027 7 mysqld 0x004ffbde _Z21mysql_derived_fillingP3THDP3LEXP10TABLE_LIST + 638 8 mysqld 0x004ff0d5 _Z20mysql_handle_derivedP3LEXPFbP3THDS0_P10TABLE_LISTE + 197 9 mysqld 0x0028e10f _Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTbj + 847 10 mysqld 0x001ff89b _Z20open_and_lock_tablesP3THDP10TABLE_LIST + 65 11 mysqld 0x001de010 _Z20prepare_schema_tableP3THDP3LEXP11Table_ident18enum_schema_tables + 2102 12 mysqld 0x001e9197 _Z21mysql_execute_commandP3THD + 4783 13 mysqld 0x001f9925 _Z11mysql_parseP3THDPKcjPS2_ + 1041 14 mysqld 0x001fabbf _Z16dispatch_command19enum_server_commandP3THDPcj + 3959 15 mysqld 0x001fce21 _Z10do_commandP3THD + 1021 16 mysqld 0x001dabe8 handle_one_connection + 680 17 libSystem.B.dylib 0x90e53155 _pthread_start + 321 18 libSystem.B.dylib 0x90e53012 thread_start + 34 Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x1aebc28 = SELECT ( SELECT MIN( SUBQUERY1_t1 . `int_key` ) AS SUBQUERY1_field1 FROM ( D AS SUBQUERY1_t1 ) WHERE ( SUBQUERY1_t1 . `pk` > SUBQUERY1_t1 . `int_nokey` AND SUBQUERY1_t1 . `varchar_nokey` != 'n' ) ) AS field1 , table1 . `int_key` AS field2 FROM ( ( ( SELECT SUBQUERY2_t1 . * FROM ( CC AS SUBQUERY2_t1 ) WHERE ( 140, 4 ) IN ( SELECT CHILD_SUBQUERY1_t1 . `int_key` AS CHILD_SUBQUERY1_field1 , CHILD_SUBQUERY1_t1 . `pk` AS child_subquery1_field2 FROM ( B AS CHILD_SUBQUERY1_t1 STRAIGHT_JOIN CC AS CHILD_SUBQUERY1_t2 ON (CHILD_SUBQUERY1_t2 . `int_nokey` = CHILD_SUBQUERY1_t1 . `int_key` ) ) ) ) ) AS table1 LEFT OUTER JOIN B AS table2 ON (table2 . `varchar_nokey` = table1 . `pk` ) ) WHERE ( table1 . `varchar_nokey` IN ( SELECT SUBQUERY3_t1 . `varchar_key` AS SUBQUERY3_field1 FROM ( C AS SUBQUERY3_t1 LEFT OUTER JOIN ( ( D AS SUBQUERY3_t2 LEFT OUTER JOIN B AS SUBQUERY3_t3 ON (SUBQUERY3_t3 . `int_key` = SUBQUERY3_t2 . `pk` ) ) ) ON (SUBQUERY3_t3 . `pk` = SUBQUERY3_t2 . `pk` ) ) WHERE ( SUBQUERY3_t2 . `varc 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 # 00:11:11 datadir is/azalea_ogb/mysql-test/var/master-data/ # 00:11:11 Core file appears to be /cores/core.83560 # 00:11:14 Reading symbols for shared libraries .... done # 00:11:14 Core was generated by `/Users/pcrews/usr/local/bin/data1/work/azalea_lcov/azalea_ogb/sql/mysqld'. # 00:11:14 Reading symbols for shared libraries . done # 00:11:14 Reading symbols for shared libraries .... done # 00:11:14 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:14 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:14 #1 0x001c5bd6 in handle_connections_sockets () at mysqld.cc:5256 # 00:11:14 #2 0x001d0d49 in main (argc=41, argv=0xbfffad4c) at mysqld.cc:4762 # 00:11:16 Reading symbols for shared libraries .... done # 00:11:16 Core was generated by `/Users/pcrews/usr/local/bin/data1/work/azalea_lcov/azalea_ogb/sql/mysqld'. # 00:11:16 Reading symbols for shared libraries . done # 00:11:16 Reading symbols for shared libraries .... done # 00:11:16 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:16 # 00:11:16 Thread 11 (core thread 10): # 00:11:16 #0 0x90f03402 in __assert_rtn () # 00:11:16 #1 0x009ac384 in my_write_core (sig=11) at stacktrace.c:309 # 00:11:16 #2 0x001bf478 in handle_segfault (sig=11) at mysqld.cc:2734 # 00:11:16 #3 # 00:11:16 #4 0x002c754b in optimize_semijoin_nests (join=0x21d6028, all_table_map=7) at sql_select.cc:4575 # 00:11:16 #5 0x002f3479 in make_join_statistics (join=0x21d6028, tables_arg=0x1b12ec0, conds=0x15fc578, keyuse_array=0x21dad54) at sql_select.cc:4459 # 00:11:16 #6 0x002f4867 in JOIN::optimize (this=0x21d6028) at sql_select.cc:1609 # 00:11:16 #7 0x003019c9 in mysql_select (thd=0x1a49218, rref_pointer_array=0x1b1284c, tables=0x1b12ec0, wild_num=0, fields=@0x1b127dc, conds=0x1b43f70, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416200192, result=0x1b1ada8, unit=0x1b128e0, select_lex=0x1b12748) at sql_select.cc:3077 # 00:11:16 #8 0x004ffbde in mysql_derived_filling (thd=0x1a49218, lex=0x1a4a11c, orig_table_list=0x1b442e0) at sql_derived.cc:295 # 00:11:16 #9 0x004ff0d5 in mysql_handle_derived (lex=0x1a4a11c, processor=0x4ff960 ) at sql_derived.cc:56 # 00:11:16 #10 0x0028e10f in open_and_lock_tables_derived (thd=0x1a49218, tables=0x1b442e0, derived=true, flags=0) at sql_base.cc:4331 # 00:11:16 #11 0x001ff89b in open_and_lock_tables (thd=0x1a49218, tables=0x1b442e0) at mysql_priv.h:1520 # 00:11:16 #12 0x001de010 in execute_sqlcom_select (thd=0x1a49218, all_tables=0x1b442e0) at sql_parse.cc:4892 # 00:11:16 #13 0x001e9197 in mysql_execute_command (thd=0x1a49218) at sql_parse.cc:2112 # 00:11:16 #14 0x001f9925 in mysql_parse (thd=0x1a49218, inBuf=0x1aebc28 "SELECT ( SELECT MIN( SUBQUERY1_t1 . `int_key` ) AS SUBQUERY1_field1 FROM ( D AS SUBQUERY1_t1 ) WHERE ( SUBQUERY1_t1 . `pk` > SUBQUERY1_t1 . `int_nokey` AND SUBQUERY1_t1 . `varchar_nokey` != 'n' )"..., length=1189, found_semicolon=0xb0512e14) at sql_parse.cc:5942 # 00:11:16 #15 0x001fabbf in dispatch_command (command=COM_QUERY, thd=0x1a49218, packet=0x21cc019 " SELECT ( SELECT MIN( SUBQUERY1_t1 . `int_key` ) AS SUBQUERY1_field1 FROM ( D AS SUBQUERY1_t1 ) WHERE ( SUBQUERY1_t1 . `pk` > SUBQUERY1_t1 . `int_nokey` AND SUBQUERY1_t1 . `varchar_nokey` != 'n' "..., packet_length=1193) at sql_parse.cc:1062 # 00:11:16 #16 0x001fce21 in do_command (thd=0x1a49218) at sql_parse.cc:744 # 00:11:16 #17 0x001dabe8 in handle_one_connection (arg=0x1a49218) at sql_connect.cc:1163 # 00:11:16 #18 0x90e53155 in _pthread_start () # 00:11:16 #19 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 10 (core thread 9): # 00:11:16 #0 0x90e45f9a in read$UNIX2003 () # 00:11:16 #1 0x00a482d1 in vio_read (vio=0x2769cc8, buf=0x21c7018 "\a", size=4) at viosocket.c:44 # 00:11:16 #2 0x001a801a in my_real_read (net=0x19524b4, complen=0xb0490ea8) at net_serv.cc:839 # 00:11:16 #3 0x001a8b65 in my_net_read (net=0x19524b4) at net_serv.cc:1029 # 00:11:16 #4 0x001fcb23 in do_command (thd=0x1952418) at sql_parse.cc:690 # 00:11:16 #5 0x001dabe8 in handle_one_connection (arg=0x1952418) at sql_connect.cc:1163 # 00:11:16 #6 0x90e53155 in _pthread_start () # 00:11:16 #7 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 9 (core thread 8): # 00:11:16 #0 0x90e97412 in sigwait$UNIX2003 () # 00:11:16 #1 0x001d1459 in signal_hand (arg=0x0) at mysqld.cc:2936 # 00:11:16 #2 0x90e53155 in _pthread_start () # 00:11:16 #3 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 8 (core thread 7): # 00:11:16 #0 0x90e2946e in nanosleep$UNIX2003 () # 00:11:16 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 00:11:16 #2 0x009b5386 in safe_cond_wait (cond=0x16057a4, mp=0x1605710, file=0xb988f2 "os/os0sync.c", line=422) at thr_mutex.c:423 # 00:11:16 #3 0x006f28ca in os_event_wait_low (event=0x1605710, reset_sig_count=0) at os/os0sync.c:422 # 00:11:16 #4 0x0074e7aa in srv_master_thread (arg=0x0) at srv/srv0srv.c:2629 # 00:11:16 #5 0x90e53155 in _pthread_start () # 00:11:16 #6 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 7 (core thread 6): # 00:11:16 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:16 #1 0x006f37a5 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 00:11:16 #2 0x0074d402 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2140 # 00:11:16 #3 0x90e53155 in _pthread_start () # 00:11:16 #4 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 6 (core thread 5): # 00:11:16 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:16 #1 0x006f37a5 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 00:11:16 #2 0x0074c79d in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1914 # 00:11:16 #3 0x90e53155 in _pthread_start () # 00:11:16 #4 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 5 (core thread 4): # 00:11:16 #0 0x90e2946e in nanosleep$UNIX2003 () # 00:11:16 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 00:11:16 #2 0x009b5386 in safe_cond_wait (cond=0x2714064, mp=0x2713fd0, file=0xb988f2 "os/os0sync.c", line=422) at thr_mutex.c:423 # 00:11:16 #3 0x006f28ca in os_event_wait_low (event=0x2713fd0, reset_sig_count=0) at os/os0sync.c:422 # 00:11:16 #4 0x006f0a4c in os_aio_simulated_handle (global_segment=3, message1=0xb0206f34, message2=0xb0206f30, type=0xb0206f2c) at os/os0file.c:4207 # 00:11:16 #5 0x006abca6 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 00:11:16 #6 0x0074f3cd in io_handler_thread (arg=0xfbac6c) at srv/srv0start.c:435 # 00:11:16 #7 0x90e53155 in _pthread_start () # 00:11:16 #8 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 4 (core thread 3): # 00:11:16 #0 0x90e2946e in nanosleep$UNIX2003 () # 00:11:16 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 00:11:16 #2 0x009b5386 in safe_cond_wait (cond=0x2713f94, mp=0x2713f00, file=0xb988f2 "os/os0sync.c", line=422) at thr_mutex.c:423 # 00:11:16 #3 0x006f28ca in os_event_wait_low (event=0x2713f00, reset_sig_count=0) at os/os0sync.c:422 # 00:11:16 #4 0x006f0a4c in os_aio_simulated_handle (global_segment=2, message1=0xb0184f34, message2=0xb0184f30, type=0xb0184f2c) at os/os0file.c:4207 # 00:11:16 #5 0x006abca6 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 00:11:16 #6 0x0074f3cd in io_handler_thread (arg=0xfbac68) at srv/srv0start.c:435 # 00:11:16 #7 0x90e53155 in _pthread_start () # 00:11:16 #8 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 3 (core thread 2): # 00:11:16 #0 0x90e2946e in nanosleep$UNIX2003 () # 00:11:16 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 00:11:16 #2 0x009b5386 in safe_cond_wait (cond=0x2713ec4, mp=0x2713e30, file=0xb988f2 "os/os0sync.c", line=422) at thr_mutex.c:423 # 00:11:16 #3 0x006f28ca in os_event_wait_low (event=0x2713e30, reset_sig_count=0) at os/os0sync.c:422 # 00:11:16 #4 0x006f0a4c in os_aio_simulated_handle (global_segment=1, message1=0xb0102f34, message2=0xb0102f30, type=0xb0102f2c) at os/os0file.c:4207 # 00:11:16 #5 0x006abca6 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 00:11:16 #6 0x0074f3cd in io_handler_thread (arg=0xfbac64) at srv/srv0start.c:435 # 00:11:16 #7 0x90e53155 in _pthread_start () # 00:11:16 #8 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 2 (core thread 1): # 00:11:16 #0 0x90e2946e in nanosleep$UNIX2003 () # 00:11:16 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 00:11:16 #2 0x009b5386 in safe_cond_wait (cond=0x2713df4, mp=0x2713d60, file=0xb988f2 "os/os0sync.c", line=422) at thr_mutex.c:423 # 00:11:16 #3 0x006f28ca in os_event_wait_low (event=0x2713d60, reset_sig_count=0) at os/os0sync.c:422 # 00:11:16 #4 0x006f0a4c in os_aio_simulated_handle (global_segment=0, message1=0xb0080f34, message2=0xb0080f30, type=0xb0080f2c) at os/os0file.c:4207 # 00:11:16 #5 0x006abca6 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 00:11:16 #6 0x0074f3cd in io_handler_thread (arg=0xfbac60) at srv/srv0start.c:435 # 00:11:16 #7 0x90e53155 in _pthread_start () # 00:11:16 #8 0x90e53012 in thread_start () # 00:11:16 # 00:11:16 Thread 1 (core thread 0): # 00:11:16 #0 0x90e716fa in select$DARWIN_EXTSN () # 00:11:16 #1 0x001c5bd6 in handle_connections_sockets () at mysqld.cc:5256 # 00:11:16 #2 0x001d0d49 in main (argc=41, argv=0xbfffad4c) at mysqld.cc:4762 # 00:11:16 The last 100 lines from/mysql-5.1/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090813 7:10:03 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead. 090813 7:10:03 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 090813 7:10:03 [Warning] Setting lower_case_table_names=2 because file system for/mysql-5.1/mysql-test/var/master-data/ is case insensitive 090813 7:10:03 [Note] Plugin 'FEDERATED' is disabled. 090813 7:10:03 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090813 7:10:03 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090813 7:10:03 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... 090813 7:10:04 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 090813 7:10:06 InnoDB: Started; log sequence number 0 0 090813 7:10:06 [Warning]/mysql-5.1/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090813 7:10:06 [Note] Event Scheduler: Loaded 0 events 090813 7:10:06 [Note]/mysql-5.1/sql/mysqld: ready for connections. Version: '5.1.38-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/irlQGBf5X8/master.sock' port: 19308 Source distribution # 00:11:16 datadir is/mysql-5.1/mysql-test/var/master-data/ # 00:11:16 Core file appears to be "/Users/pcrews/usr/local/bin/data1/work/azalea_lcov/rqg_oga/mysql-test/gentest/" is not a core dump: File format not recognized No stack. # 00:11:18 Reading symbols for shared libraries .... done "/Users/pcrews/usr/local/bin/data1/work/azalea_lcov/rqg_oga/mysql-test/gentest/" is not a core dump: File format not recognized # 00:11:19 Reading symbols for shared libraries .... done # 00:11:19 Test completed with failure status 101. # 00:11:19 gentest.pl exited with exit status 101