# 14:15:40 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=19306:user=root:database=test # 14:15:42 Killing periodic reporting process with pid 79929... # 14:15:42 Server crash reported, initiating post-crash analysis... # 14:15:42 The last 100 lines from /azalea/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090821 21:14:54 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead. 090821 21:14:54 [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. 090821 21:14:54 [ERROR] An old style --language value with language specific part detected: /azalea/sql/share/english/ 090821 21:14:54 [ERROR] Use --lc-messages-dir without language specific part instead. 090821 21:14:54 [Warning] Setting lower_case_table_names=2 because file system for /azalea/mysql-test/var/master-data/ is case insensitive 090821 21:14:54 [Note] Plugin 'FEDERATED' is disabled. 090821 21:14:54 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090821 21:14:54 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090821 21:14:54 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... 090821 21:14:54 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 090821 21:14:54 InnoDB: Started; log sequence number 0 0 090821 21:14:54 [Warning] /azalea/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090821 21:14:54 [Note] Event Scheduler: Loaded 0 events 090821 21:14:54 [Note] /azalea/sql/mysqld: ready for connections. Version: '5.4.4-alpha-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/wkpQXwWE6W/master.sock' port: 19306 Source distribution 090821 21:15:17 - mysqld got signal 10 ; 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=2 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 = 60098 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x124b218 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 0x005abbab my_print_stacktrace + 44 1 mysqld 0x000fd035 handle_segfault + 909 2 libSystem.B.dylib 0x90e8e2bb _sigtramp + 43 3 ??? 0xffffffff 0x0 + 4294967295 4 mysqld 0x000ac242 _ZN21Item_allany_subselect5printEP6String15enum_query_type + 272 5 mysqld 0x0004883f _ZN9Item_func10print_argsEP6Stringj15enum_query_type + 105 6 mysqld 0x000488af _ZN9Item_func5printEP6String15enum_query_type + 93 7 mysqld 0x0006205d _ZN17Item_func_not_all5printEP6String15enum_query_type + 45 8 mysqld 0x0006e5c9 _ZN9Item_cond5printEP6String15enum_query_type + 117 9 mysqld 0x001bdb0d _ZN13st_select_lex5printEP3THDP6String15enum_query_type + 975 10 mysqld 0x000066a6 _ZN18st_select_lex_unit5printEP6String15enum_query_type + 224 11 mysqld 0x0010fafc _Z20prepare_schema_tableP3THDP3LEXP11Table_ident18enum_schema_tables + 1682 12 mysqld 0x001160ee _Z21mysql_execute_commandP3THD + 3124 13 mysqld 0x0011fbd7 _Z11mysql_parseP3THDPKcjPS2_ + 575 14 mysqld 0x00120754 _Z16dispatch_command19enum_server_commandP3THDPcj + 2500 15 mysqld 0x00121b2a _Z10do_commandP3THD + 620 16 mysqld 0x0010d589 handle_one_connection + 371 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 0x1251628 = EXPLAIN EXTENDED SELECT ( ( table2 . `pk` ) - ( table1 . `int_nokey` ) ) AS field1 FROM ( CC AS table1 INNER JOIN ( ( C AS table2 RIGHT OUTER JOIN D AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `varchar_nokey` = table2 . `varchar_key` ) ) WHERE ( table3 . `varchar_key` > ANY ( ( SELECT SUBQUERY1_t2 . `varchar_key` AS SUBQUERY1_field1 FROM ( CC AS SUBQUERY1_t1 STRAIGHT_JOIN ( ( BB AS SUBQUERY1_t2 LEFT JOIN CC AS SUBQUERY1_t3 ON (SUBQUERY1_t3 . `varchar_key` = SUBQUERY1_t2 . `varchar_nokey` ) ) ) ON (SUBQUERY1_t3 . `pk` = SUBQUERY1_t2 . `pk` ) ) ) UNION ( SELECT SUBQUERY1_t1 . `varchar_key` AS SUBQUERY1_field1 FROM ( CC AS SUBQUERY1_t4 STRAIGHT_JOIN C AS SUBQUERY1_t5 ON (SUBQUERY1_t5 . `varchar_key` = SUBQUERY1_t4 . `varchar_nokey` ) ) ) ) ) OR table1 . `varchar_key` IS NULL GROUP BY field1 ORDER BY field1 ASC, field1 thd->thread_id=7 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 # 14:15:42 datadir is /azalea/mysql-test/var/master-data/ # 14:15:42 Core file appears to be /cores/core.79840 # 14:15:42 Reading symbols for shared libraries .... done # 14:15:42 Core was generated by `/azalea/sql/mysqld'. # 14:15:42 Reading symbols for shared libraries . done # 14:15:42 Reading symbols for shared libraries .... done # 14:15:42 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:42 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:42 #1 0x00100e88 in handle_connections_sockets () at mysqld.cc:5260 # 14:15:42 #2 0x00107a41 in main (argc=42, argv=0xbfffaf44) at mysqld.cc:4766 # 14:15:43 Reading symbols for shared libraries .... done # 14:15:43 Core was generated by `/azalea/sql/mysqld'. # 14:15:43 Reading symbols for shared libraries . done # 14:15:43 Reading symbols for shared libraries .... done # 14:15:43 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:43 # 14:15:43 Thread 11 (core thread 10): # 14:15:43 #0 0x90f03402 in __assert_rtn () # 14:15:43 #1 0x005abc7c in my_write_core (sig=10) at stacktrace.c:309 # 14:15:43 #2 0x000fd260 in handle_segfault (sig=10) at mysqld.cc:2738 # 14:15:43 #3 # 14:15:43 #4 0x000a755d in Item_subselect::print (this=0x131a8c8, str=0xb051169c, query_type=QT_ORDINARY) at item_subselect.cc:383 # 14:15:43 #5 0x000ac242 in Item_allany_subselect::print (this=0x131a8c8, str=0xb051169c, query_type=QT_ORDINARY) at item_subselect.cc:1982 # 14:15:43 #6 0x0004883f in Item_func::print_args (this=0x131a9c0, str=0xb051169c, from=0, query_type=QT_ORDINARY) at item_func.cc:418 # 14:15:43 #7 0x000488af in Item_func::print (this=0x131a9c0, str=0xb051169c, query_type=QT_ORDINARY) at item_func.cc:407 # 14:15:43 #8 0x0006205d in Item_func_not_all::print (this=0x131a9c0, str=0xb051169c, query_type=QT_ORDINARY) at item_cmpfunc.cc:327 # 14:15:43 #9 0x0006e5c9 in Item_cond::print (this=0x1347a28, str=0xb051169c, query_type=QT_ORDINARY) at item_cmpfunc.cc:4220 # 14:15:43 #10 0x001bdb0d in st_select_lex::print (this=0x124c61c, thd=0x124b218, str=0xb051169c, query_type=QT_ORDINARY) at sql_select.cc:22175 # 14:15:43 #11 0x000066a6 in st_select_lex_unit::print (this=0x124c16c, str=0xb051169c, query_type=QT_ORDINARY) at sql_lex.cc:2088 # 14:15:43 #12 0x0010fafc in execute_sqlcom_select (thd=0x124b218, all_tables=0x12523e8) at sql_parse.cc:4914 # 14:15:43 #13 0x001160ee in mysql_execute_command (thd=0x124b218) at sql_parse.cc:2112 # 14:15:43 #14 0x0011fbd7 in mysql_parse (thd=0x124b218, inBuf=0x1251628 "EXPLAIN EXTENDED SELECT ( ( table2 . `pk` ) - ( table1 . `int_nokey` ) ) AS field1 FROM ( CC AS table1 INNER JOIN ( ( C AS table2 RIGHT OUTER JOIN D AS table3 ON (table3 . `pk` = table2 . `pk` ) )"..., length=867, found_semicolon=0xb0512e14) at sql_parse.cc:5945 # 14:15:43 #15 0x00120754 in dispatch_command (command=COM_QUERY, thd=0x124b218, packet=0x19f0019 "", packet_length=869) at sql_parse.cc:1062 # 14:15:43 #16 0x00121b2a in do_command (thd=0x124b218) at sql_parse.cc:744 # 14:15:43 #17 0x0010d589 in handle_one_connection (arg=0x124b218) at sql_connect.cc:1163 # 14:15:43 #18 0x90e53155 in _pthread_start () # 14:15:43 #19 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 10 (core thread 9): # 14:15:43 #0 0x90e45f9a in read$UNIX2003 () # 14:15:43 #1 0x00605644 in vio_read (vio=0x1f69cb8, buf=0x19eb018 "\a", size=4) at viosocket.c:44 # 14:15:43 #2 0x000ef7fa in my_real_read (net=0x11546ac, complen=0xb0490ea8) at net_serv.cc:839 # 14:15:43 #3 0x000efe7a in my_net_read (net=0x11546ac) at net_serv.cc:1029 # 14:15:43 #4 0x0012195e in do_command (thd=0x1154618) at sql_parse.cc:690 # 14:15:43 #5 0x0010d589 in handle_one_connection (arg=0x1154618) at sql_connect.cc:1163 # 14:15:43 #6 0x90e53155 in _pthread_start () # 14:15:43 #7 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 9 (core thread 8): # 14:15:43 #0 0x90e97412 in sigwait$UNIX2003 () # 14:15:43 #1 0x00107e32 in signal_hand (arg=0x0) at mysqld.cc:2940 # 14:15:43 #2 0x90e53155 in _pthread_start () # 14:15:43 #3 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 8 (core thread 7): # 14:15:43 #0 0x90e2946e in nanosleep$UNIX2003 () # 14:15:43 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 14:15:43 #2 0x005b11f7 in safe_cond_wait (cond=0xe05794, mp=0xe05700, file=0x6e59fa "os/os0sync.c", line=422) at thr_mutex.c:423 # 14:15:43 #3 0x004077d8 in os_event_wait_low (event=0xe05700, reset_sig_count=0) at os/os0sync.c:422 # 14:15:43 #4 0x0043a69d in srv_master_thread (arg=0x0) at srv/srv0srv.c:2629 # 14:15:43 #5 0x90e53155 in _pthread_start () # 14:15:43 #6 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 7 (core thread 6): # 14:15:43 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:43 #1 0x00407ff8 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 14:15:43 #2 0x00439b5b in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2140 # 14:15:43 #3 0x90e53155 in _pthread_start () # 14:15:43 #4 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 6 (core thread 5): # 14:15:43 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:43 #1 0x00407ff8 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 14:15:43 #2 0x004394af in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1914 # 14:15:43 #3 0x90e53155 in _pthread_start () # 14:15:43 #4 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 5 (core thread 4): # 14:15:43 #0 0x90e2946e in nanosleep$UNIX2003 () # 14:15:43 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 14:15:43 #2 0x005b11f7 in safe_cond_wait (cond=0x1f14054, mp=0x1f13fc0, file=0x6e59fa "os/os0sync.c", line=422) at thr_mutex.c:423 # 14:15:43 #3 0x004077d8 in os_event_wait_low (event=0x1f13fc0, reset_sig_count=0) at os/os0sync.c:422 # 14:15:43 #4 0x00406574 in os_aio_simulated_handle (global_segment=3, message1=0xb0206f34, message2=0xb0206f30, type=0xb0206f2c) at os/os0file.c:4207 # 14:15:43 #5 0x003e0754 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 14:15:43 #6 0x0043ad31 in io_handler_thread (arg=0x90ad2c) at srv/srv0start.c:435 # 14:15:43 #7 0x90e53155 in _pthread_start () # 14:15:43 #8 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 4 (core thread 3): # 14:15:43 #0 0x90e2946e in nanosleep$UNIX2003 () # 14:15:43 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 14:15:43 #2 0x005b11f7 in safe_cond_wait (cond=0x1f13f84, mp=0x1f13ef0, file=0x6e59fa "os/os0sync.c", line=422) at thr_mutex.c:423 # 14:15:43 #3 0x004077d8 in os_event_wait_low (event=0x1f13ef0, reset_sig_count=0) at os/os0sync.c:422 # 14:15:43 #4 0x00406574 in os_aio_simulated_handle (global_segment=2, message1=0xb0184f34, message2=0xb0184f30, type=0xb0184f2c) at os/os0file.c:4207 # 14:15:43 #5 0x003e0754 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 14:15:43 #6 0x0043ad31 in io_handler_thread (arg=0x90ad28) at srv/srv0start.c:435 # 14:15:43 #7 0x90e53155 in _pthread_start () # 14:15:43 #8 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 3 (core thread 2): # 14:15:43 #0 0x90e2946e in nanosleep$UNIX2003 () # 14:15:43 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 14:15:43 #2 0x005b11f7 in safe_cond_wait (cond=0x1f13eb4, mp=0x1f13e20, file=0x6e59fa "os/os0sync.c", line=422) at thr_mutex.c:423 # 14:15:43 #3 0x004077d8 in os_event_wait_low (event=0x1f13e20, reset_sig_count=0) at os/os0sync.c:422 # 14:15:43 #4 0x00406574 in os_aio_simulated_handle (global_segment=1, message1=0xb0102f34, message2=0xb0102f30, type=0xb0102f2c) at os/os0file.c:4207 # 14:15:43 #5 0x003e0754 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 14:15:43 #6 0x0043ad31 in io_handler_thread (arg=0x90ad24) at srv/srv0start.c:435 # 14:15:43 #7 0x90e53155 in _pthread_start () # 14:15:43 #8 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 2 (core thread 1): # 14:15:43 #0 0x90e2946e in nanosleep$UNIX2003 () # 14:15:43 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 14:15:43 #2 0x005b11f7 in safe_cond_wait (cond=0x1f13de4, mp=0x1f13d50, file=0x6e59fa "os/os0sync.c", line=422) at thr_mutex.c:423 # 14:15:43 #3 0x004077d8 in os_event_wait_low (event=0x1f13d50, reset_sig_count=0) at os/os0sync.c:422 # 14:15:43 #4 0x00406574 in os_aio_simulated_handle (global_segment=0, message1=0xb0080f34, message2=0xb0080f30, type=0xb0080f2c) at os/os0file.c:4207 # 14:15:43 #5 0x003e0754 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 14:15:43 #6 0x0043ad31 in io_handler_thread (arg=0x90ad20) at srv/srv0start.c:435 # 14:15:43 #7 0x90e53155 in _pthread_start () # 14:15:43 #8 0x90e53012 in thread_start () # 14:15:43 # 14:15:43 Thread 1 (core thread 0): # 14:15:43 #0 0x90e716fa in select$DARWIN_EXTSN () # 14:15:43 #1 0x00100e88 in handle_connections_sockets () at mysqld.cc:5260 # 14:15:43 #2 0x00107a41 in main (argc=42, argv=0xbfffaf44) at mysqld.cc:4766 # 14:15:43 The last 100 lines from /mysql-5.1/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090821 21:14:59 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead. 090821 21:14:59 [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. 090821 21:14:59 [Warning] Setting lower_case_table_names=2 because file system for /mysql-5.1/mysql-test/var/master-data/ is case insensitive 090821 21:14:59 [Note] Plugin 'FEDERATED' is disabled. 090821 21:14:59 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090821 21:14:59 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090821 21:14:59 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... 090821 21:14: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 090821 21:14:59 InnoDB: Started; log sequence number 0 0 090821 21:14:59 [Warning] /mysql-5.1/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090821 21:14:59 [Note] Event Scheduler: Loaded 0 events 090821 21:14:59 [Note] /mysql-5.1/sql/mysqld: ready for connections. Version: '5.1.39-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/dAiZ5JM1Yt/master.sock' port: 19308 Source distribution # 14:15:43 datadir is /mysql-5.1/mysql-test/var/master-data/ # 14:15:43 Core file appears to be "/rqg/mysql-test/gentest/" is not a core dump: File format not recognized No stack. # 14:15:44 Reading symbols for shared libraries .... done "/rqg/mysql-test/gentest/" is not a core dump: File format not recognized # 14:15:45 Reading symbols for shared libraries .... done # 14:15:45 Test completed with failure status 101. # 14:15:45 gentest.pl exited with exit status 101 Fri Aug 21 14:15:45 2009 [79759] ./runall.pl will exit with exit status 101