# 11:13:25 Server crash reported, initiating post-crash analysis... # 11:13:25 The last 100 lines from /azalea/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090817 18:12:25 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead. 090817 18:12:25 [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. 090817 18:12:25 [ERROR] An old style --language value with language specific part detected: /azalea/sql/share/english/ 090817 18:12:25 [ERROR] Use --lc-messages-dir without language specific part instead. 090817 18:12:25 [Warning] Setting lower_case_table_names=2 because file system for /azalea/mysql-test/var/master-data/ is case insensitive 090817 18:12:25 [Note] Plugin 'FEDERATED' is disabled. 090817 18:12:25 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090817 18:12:25 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090817 18:12:26 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... 090817 18:12:26 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 090817 18:12:26 InnoDB: Started; log sequence number 0 0 090817 18:12:26 [Warning] /azalea/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090817 18:12:26 [Note] Event Scheduler: Loaded 0 events 090817 18:12:26 [Note] /azalea/sql/mysqld: ready for connections. Version: '5.4.4-alpha-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/JAoFsv5j1L/master.sock' port: 19306 Source distribution Assertion failed: (fixed == 0), function fix_fields, file item.cc, line 6004. 090817 18:12:46 - mysqld got signal 6 ; 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: 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 0x30c00 0 mysqld 0x005aa3e3 my_print_stacktrace + 44 1 mysqld 0x000fc739 handle_segfault + 909 2 libSystem.B.dylib 0x90e8e2bb _sigtramp + 43 3 ??? 0xffffffff 0x0 + 4294967295 4 mysqld 0x00107145 main + 1427 5 mysqld 0x00001802 start + 54 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 # 11:13:25 datadir is /azalea/mysql-test/var/master-data/ # 11:13:25 Core file appears to be /cores/core.14328 # 11:13:26 Reading symbols for shared libraries .... done # 11:13:26 Core was generated by `/azalea/sql/mysqld'. # 11:13:26 Reading symbols for shared libraries . done # 11:13:26 Reading symbols for shared libraries .... done # 11:13:26 #0 0x90f03402 in __assert_rtn () # 11:13:26 #0 0x90f03402 in __assert_rtn () # 11:13:26 #1 0x005aa4b4 in my_write_core (sig=6) at stacktrace.c:309 # 11:13:26 #2 0x000fc964 in handle_segfault (sig=6) at mysqld.cc:2738 # 11:13:26 #3 # 11:13:26 #4 0x90e716fa in select$DARWIN_EXTSN () # 11:13:26 #5 0x0010058c in handle_connections_sockets () at mysqld.cc:5260 # 11:13:26 #6 0x00107145 in main (argc=41, argv=0xbfffafdc) at mysqld.cc:4766 # 11:13:27 Reading symbols for shared libraries .... done # 11:13:27 Core was generated by `/azalea/sql/mysqld'. # 11:13:27 Reading symbols for shared libraries . done # 11:13:27 Reading symbols for shared libraries .... done # 11:13:27 #0 0x90f03402 in __assert_rtn () # 11:13:27 # 11:13:27 Thread 11 (core thread 10): # 11:13:27 #0 0x90efe136 in clock_get_attributes () # 11:13:27 #1 0x90ef7013 in usleep$NOCANCEL$UNIX2003 () # 11:13:27 #2 0x90f0e685 in abort () # 11:13:27 #3 0x90f033db in __assert_rtn () # 11:13:27 #4 0x00029879 in Item_ref::fix_fields (this=0x19fabf0, thd=0x1248e18, reference=0x19fadc8) at item.cc:6004 # 11:13:27 #5 0x000b0edf in Item_row::fix_fields (this=0x19fad60, thd=0x1248e18, ref=0x2b5b5b8) at item_row.cc:68 # 11:13:27 #6 0x000ab17d in Item_in_subselect::select_in_like_transformer (this=0x2b58248, join=0x2b72028, func=0x8f46b4) at item_subselect.cc:1720 # 11:13:27 #7 0x000ab34c in Item_in_subselect::select_transformer (this=0x2b58248, join=0x2b72028) at item_subselect.cc:1647 # 11:13:27 #8 0x001b01c8 in JOIN::prepare (this=0x2b72028, rref_pointer_array=0x19faed4, tables_init=0x19fbae8, wild_num=0, conds_init=0x2b58158, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x19fadd0, unit_arg=0x19faf68) at sql_select.cc:707 # 11:13:27 #9 0x000abe59 in subselect_single_select_engine::prepare (this=0x2b58300) at item_subselect.cc:2109 # 11:13:27 #10 0x000a6589 in Item_subselect::fix_fields (this=0x2b58248, thd_param=0x1248e18, ref=0x2b65c98) at item_subselect.cc:174 # 11:13:27 #11 0x000ab4ed in Item_in_subselect::fix_fields (this=0x2b58248, thd_arg=0x1248e18, ref=0x2b65c98) at item_subselect.cc:1788 # 11:13:27 #12 0x001afa07 in JOIN::prepare (this=0x2b61028, rref_pointer_array=0x124a320, tables_init=0x12569f8, wild_num=0, conds_init=0x19fa958, og_num=10, order_init=0x2b583f0, group_init=0x19faab0, having_init=0x2b58248, proc_param_init=0x0, select_lex_arg=0x124a21c, unit_arg=0x1249d6c) at sql_select.cc:555 # 11:13:27 #13 0x001bbebe in mysql_select (thd=0x1248e18, rref_pointer_array=0x124a320, tables=0x12569f8, wild_num=0, fields=@0x124a2b0, conds=0x19fa958, og_num=10, order=0x2b583f0, group=0x19faab0, having=0x2b58248, proc_param=0x0, select_options=2147764736, result=0x2b5b2e8, unit=0x1249d6c, select_lex=0x124a21c) at sql_select.cc:3070 # 11:13:27 #14 0x001bc2bd in handle_select (thd=0x1248e18, lex=0x1249d10, result=0x2b5b2e8, setup_tables_done_option=0) at sql_select.cc:306 # 11:13:27 #15 0x0010f2db in execute_sqlcom_select (thd=0x1248e18, all_tables=0x12569f8) at sql_parse.cc:4930 # 11:13:27 #16 0x0011576a in mysql_execute_command (thd=0x1248e18) at sql_parse.cc:2112 # 11:13:27 #17 0x0011f277 in mysql_parse (thd=0x1248e18, inBuf=0x1255228 "SELECT table1 . `date_key` AS field1 , table2 . `varchar_key` AS field2 , MAX( table1 . `int_nokey` ) AS field3 , MAX( table1 . `varchar_key` ) AS field4 FROM ( C AS table1 RIGHT OUTER JOIN ( ( ( ("..., length=1652, found_semicolon=0xb0512e14) at sql_parse.cc:5945 # 11:13:27 #18 0x0011fdf4 in dispatch_command (command=COM_QUERY, thd=0x1248e18, packet=0x19f0019 " SELECT table1 . `date_key` AS field1 , table2 . `varchar_key` AS field2 , MAX( table1 . `int_nokey` ) AS field3 , MAX( table1 . `varchar_key` ) AS field4 FROM ( C AS table1 RIGHT OUTER JOIN ( ( ( "..., packet_length=1653) at sql_parse.cc:1062 # 11:13:27 #19 0x001211ca in do_command (thd=0x1248e18) at sql_parse.cc:744 # 11:13:27 #20 0x0010cc0b in handle_one_connection (arg=0x1248e18) at sql_connect.cc:1163 # 11:13:27 #21 0x90e53155 in _pthread_start () # 11:13:27 #22 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 10 (core thread 9): # 11:13:27 #0 0x90e45f9a in read$UNIX2003 () # 11:13:27 #1 0x00603e7c in vio_read (vio=0x1f69cb8, buf=0x19eb018 "\a", size=4) at viosocket.c:44 # 11:13:27 #2 0x000eefba in my_real_read (net=0x11524ac, complen=0xb0490ea8) at net_serv.cc:839 # 11:13:27 #3 0x000ef63a in my_net_read (net=0x11524ac) at net_serv.cc:1029 # 11:13:27 #4 0x00120ffe in do_command (thd=0x1152418) at sql_parse.cc:690 # 11:13:27 #5 0x0010cc0b in handle_one_connection (arg=0x1152418) at sql_connect.cc:1163 # 11:13:27 #6 0x90e53155 in _pthread_start () # 11:13:27 #7 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 9 (core thread 8): # 11:13:27 #0 0x90e97412 in sigwait$UNIX2003 () # 11:13:27 #1 0x00107536 in signal_hand (arg=0x0) at mysqld.cc:2940 # 11:13:27 #2 0x90e53155 in _pthread_start () # 11:13:27 #3 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 8 (core thread 7): # 11:13:27 #0 0x90e2946e in nanosleep$UNIX2003 () # 11:13:27 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 11:13:27 #2 0x005afa2f in safe_cond_wait (cond=0xe05794, mp=0xe05700, file=0x6e3b3e "os/os0sync.c", line=422) at thr_mutex.c:423 # 11:13:27 #3 0x00406010 in os_event_wait_low (event=0xe05700, reset_sig_count=0) at os/os0sync.c:422 # 11:13:27 #4 0x00438ed5 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2629 # 11:13:27 #5 0x90e53155 in _pthread_start () # 11:13:27 #6 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 7 (core thread 6): # 11:13:27 #0 0x90e716fa in select$DARWIN_EXTSN () # 11:13:27 #1 0x00406830 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 11:13:27 #2 0x00438393 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2140 # 11:13:27 #3 0x90e53155 in _pthread_start () # 11:13:27 #4 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 6 (core thread 5): # 11:13:27 #0 0x90e716fa in select$DARWIN_EXTSN () # 11:13:27 #1 0x00406830 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 11:13:27 #2 0x00437ce7 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1914 # 11:13:27 #3 0x90e53155 in _pthread_start () # 11:13:27 #4 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 5 (core thread 4): # 11:13:27 #0 0x90e2946e in nanosleep$UNIX2003 () # 11:13:27 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 11:13:27 #2 0x005afa2f in safe_cond_wait (cond=0x1f14054, mp=0x1f13fc0, file=0x6e3b3e "os/os0sync.c", line=422) at thr_mutex.c:423 # 11:13:27 #3 0x00406010 in os_event_wait_low (event=0x1f13fc0, reset_sig_count=0) at os/os0sync.c:422 # 11:13:27 #4 0x00404dac in os_aio_simulated_handle (global_segment=3, message1=0xb0206f34, message2=0xb0206f30, type=0xb0206f2c) at os/os0file.c:4207 # 11:13:27 #5 0x003def8c in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 11:13:27 #6 0x00439569 in io_handler_thread (arg=0x908d0c) at srv/srv0start.c:435 # 11:13:27 #7 0x90e53155 in _pthread_start () # 11:13:27 #8 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 4 (core thread 3): # 11:13:27 #0 0x90e2946e in nanosleep$UNIX2003 () # 11:13:27 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 11:13:27 #2 0x005afa2f in safe_cond_wait (cond=0x1f13f84, mp=0x1f13ef0, file=0x6e3b3e "os/os0sync.c", line=422) at thr_mutex.c:423 # 11:13:27 #3 0x00406010 in os_event_wait_low (event=0x1f13ef0, reset_sig_count=0) at os/os0sync.c:422 # 11:13:27 #4 0x00404dac in os_aio_simulated_handle (global_segment=2, message1=0xb0184f34, message2=0xb0184f30, type=0xb0184f2c) at os/os0file.c:4207 # 11:13:27 #5 0x003def8c in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 11:13:27 #6 0x00439569 in io_handler_thread (arg=0x908d08) at srv/srv0start.c:435 # 11:13:27 #7 0x90e53155 in _pthread_start () # 11:13:27 #8 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 3 (core thread 2): # 11:13:27 #0 0x90e2946e in nanosleep$UNIX2003 () # 11:13:27 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 11:13:27 #2 0x005afa2f in safe_cond_wait (cond=0x1f13eb4, mp=0x1f13e20, file=0x6e3b3e "os/os0sync.c", line=422) at thr_mutex.c:423 # 11:13:27 #3 0x00406010 in os_event_wait_low (event=0x1f13e20, reset_sig_count=0) at os/os0sync.c:422 # 11:13:27 #4 0x00404dac in os_aio_simulated_handle (global_segment=1, message1=0xb0102f34, message2=0xb0102f30, type=0xb0102f2c) at os/os0file.c:4207 # 11:13:27 #5 0x003def8c in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 11:13:27 #6 0x00439569 in io_handler_thread (arg=0x908d04) at srv/srv0start.c:435 # 11:13:27 #7 0x90e53155 in _pthread_start () # 11:13:27 #8 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 2 (core thread 1): # 11:13:27 #0 0x90e2946e in nanosleep$UNIX2003 () # 11:13:27 #1 0x90e53dcd in pthread_cond_wait$UNIX2003 () # 11:13:27 #2 0x005afa2f in safe_cond_wait (cond=0x1f13de4, mp=0x1f13d50, file=0x6e3b3e "os/os0sync.c", line=422) at thr_mutex.c:423 # 11:13:27 #3 0x00406010 in os_event_wait_low (event=0x1f13d50, reset_sig_count=0) at os/os0sync.c:422 # 11:13:27 #4 0x00404dac in os_aio_simulated_handle (global_segment=0, message1=0xb0080f34, message2=0xb0080f30, type=0xb0080f2c) at os/os0file.c:4207 # 11:13:27 #5 0x003def8c in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 11:13:27 #6 0x00439569 in io_handler_thread (arg=0x908d00) at srv/srv0start.c:435 # 11:13:27 #7 0x90e53155 in _pthread_start () # 11:13:27 #8 0x90e53012 in thread_start () # 11:13:27 # 11:13:27 Thread 1 (core thread 0): # 11:13:27 #0 0x90f03402 in __assert_rtn () # 11:13:27 #1 0x005aa4b4 in my_write_core (sig=6) at stacktrace.c:309 # 11:13:27 #2 0x000fc964 in handle_segfault (sig=6) at mysqld.cc:2738 # 11:13:27 #3 # 11:13:27 #4 0x90e716fa in select$DARWIN_EXTSN () # 11:13:27 #5 0x0010058c in handle_connections_sockets () at mysqld.cc:5260 # 11:13:27 #6 0x00107145 in main (argc=41, argv=0xbfffafdc) at mysqld.cc:4766 # 11:13:27 The last 100 lines from /mysql-5.1/mysql-test/var/master-data/../log/master.err : CURRENT_TEST: main.1st 090817 18:12:32 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general_log'/'--general_log_file' instead. 090817 18:12:32 [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. 090817 18:12:32 [Warning] Setting lower_case_table_names=2 because file system for /mysql-5.1/mysql-test/var/master-data/ is case insensitive 090817 18:12:32 [Note] Plugin 'FEDERATED' is disabled. 090817 18:12:32 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 090817 18:12:32 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 090817 18:12:32 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... 090817 18:12:32 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 090817 18:12:32 InnoDB: Started; log sequence number 0 0 090817 18:12:32 [Warning] /mysql-5.1/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 090817 18:12:32 [Note] Event Scheduler: Loaded 0 events 090817 18:12:32 [Note] /mysql-5.1/sql/mysqld: ready for connections. Version: '5.1.38-debug-log' socket: '/var/folders/Pt/PtJd7NDTGgyOk3+iDGXrQk+++TI/-Tmp-/NHlJOVvPYQ/master.sock' port: 19308 Source distribution # 11:13:27 datadir is /mysql-5.1/mysql-test/var/master-data/ # 11:13:27 Core file appears to be "/rqg/mysql-test/gentest/" is not a core dump: File format not recognized No stack. # 11:13:31 Reading symbols for shared libraries .... done "/rqg/mysql-test/gentest/" is not a core dump: File format not recognized # 11:13:32 Reading symbols for shared libraries .... done # 11:13:32 Test completed with failure status 101. # 11:13:32 gentest.pl exited with exit status 101 Mon Aug 17 11:13:32 2009 [13862] ./runall.pl will exit with exit status 101