Version: '5.4.4-alpha-gcov-debug-log' socket: '/azalea/mysql-test/var/tmp/master.sock' port: 19306 Source distribution mysqld: ../include/my_dbug.h:29: Dbug_violation_helper::~Dbug_violation_helper(): Assertion `!_entered' failed. 090917 23:33:16 - 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 = 60110 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xa7d5b58 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 = 0xb35a3f94 thread_stack 0x30c00 /azalea/sql/mysqld(my_print_stacktrace+0x63) [0x91bde6e] /azalea/sql/mysqld(handle_segfault+0x62e) [0x84bc71f] [0xb7f25400] /lib/tls/i686/cmov/libc.so.6(abort+0x188) [0xb7c49098] /lib/tls/i686/cmov/libc.so.6(__assert_fail+0xee) [0xb7c405ce] /azalea/sql/mysqld(Dbug_violation_helper::~Dbug_violation_helper()+0x5e) [0x8219ea8] /azalea/sql/mysqld(Aggregator_distinct::setup(THD*)+0x215c) [0x82b7812] /azalea/sql/mysqld(Item_sum::aggregator_setup(THD*)+0x50) [0x86e41ae] /azalea/sql/mysqld [0x8656362] /azalea/sql/mysqld(JOIN::optimize()+0x8e7f) [0x86cdbef] /azalea/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*)+0x63c) [0x86d3592] /azalea/sql/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x3d6) [0x86e37a6] /azalea/sql/mysqld [0x84f32f2] /azalea/sql/mysqld(mysql_execute_command(THD*)+0x20f2) [0x84f81cb] /azalea/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x801) [0x85155ba] /azalea/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x1c19) [0x85178bf] /azalea/sql/mysqld(do_command(THD*)+0x609) [0x851bb61] /azalea/sql/mysqld(handle_one_connection+0x3bc) [0x84df32a] /lib/tls/i686/cmov/libpthread.so.0 [0xb7efa4ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0xb7d0049e] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xa7f5a40 = SELECT DISTINCT SUM( DISTINCT table1 . `varchar_key` ) AS field1 FROM ( BB AS table1 STRAIGHT_JOIN ( ( CC AS table2 INNER JOIN C AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `int_key` = table2 . `int_key` ) ) WHERE ( ( 'c', 'b' ) NOT IN ( SELECT SUBQUERY1_t1 . `varchar_key` AS SUBQUERY1_field1 , SUBQUERY1_t1 . `varchar_key` AS SUBQUERY1_field2 FROM ( CC AS SUBQUERY1_t1 RIGHT JOIN B AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `pk` = SUBQUERY1_t1 . `int_key` ) ) ) ) AND ( table1 . `int_key` NOT BETWEEN 125 AND ( 125 + 206 ) OR table1 . `varchar_key` = 'i' ) AND ( table1 . `varchar_key` < table3 . `varchar_nokey` OR table1 . `int_key` IS NOT NULL ) ORDER BY table1 . `int_key` DESC , field1 LIMIT 2 OFFSET 2 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 # 16:33:18 datadir is /azalea/mysql-test/var/master-data/ # 16:33:18 Core file appears to be /azalea/mysql-test/var/master-data//core warning: Can't read pathname for load map: Input/output error. # 16:33:22 Core was generated by `/azalea/sql/mysqld --no-defaults --basedir=/home'. # 16:33:22 Program terminated with signal 6, Aborted. # 16:33:22 [New process 5094] # 16:33:22 [New process 5074] # 16:33:22 [New process 5035] # 16:33:22 [New process 5037] # 16:33:22 [New process 5038] # 16:33:22 [New process 5039] # 16:33:22 [New process 5040] # 16:33:22 [New process 5041] # 16:33:22 [New process 5042] # 16:33:22 [New process 5043] # 16:33:22 [New process 5044] # 16:33:22 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:22 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:22 #1 0xb7eff1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:22 #2 0x091be212 in my_write_core (sig=6) at stacktrace.c:309 # 16:33:22 #3 0x084bcda2 in handle_segfault (sig=6) at mysqld.cc:2739 # 16:33:22 #4 # 16:33:22 #5 0xb7f25430 in __kernel_vsyscall () # 16:33:22 #6 0xb7c476d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 16:33:22 #7 0xb7c49098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 16:33:22 #8 0xb7c405ce in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 # 16:33:22 #9 0x08219ea8 in ~Dbug_violation_helper (this=0xb35a1cf8) at ../../include/my_dbug.h:29 # 16:33:22 #10 0x082b7812 in Aggregator_distinct::setup (this=0xad8f988, thd=0xa7d5b58) at item_sum.cc:892 # 16:33:22 #11 0x086e41ae in Item_sum::aggregator_setup (this=0xa7f6120, thd=0xa7d5b58) at item_sum.h:480 # 16:33:22 #12 0x08656362 in setup_sum_funcs (thd=0xa7d5b58, func_ptr=0xa845834) at sql_select.cc:20681 # 16:33:22 #13 0x086cdbef in JOIN::optimize (this=0xaa55780) at sql_select.cc:2155 # 16:33:22 #14 0x086d3592 in mysql_select (thd=0xa7d5b58, rref_pointer_array=0xa7d70bc, tables=0xa7f6700, wild_num=0, fields=@0xa7d704c, conds=0xa88d5d0, og_num=2, # 16:33:22 order=0xa88dbd8, group=0x0, having=0x0, proc_param=0x0, select_options=2147764737, result=0xa88ddb0, unit=0xa7d6b00, select_lex=0xa7d6fb8) at sql_select.cc:3073 # 16:33:22 #15 0x086e37a6 in handle_select (thd=0xa7d5b58, lex=0xa7d6aa4, result=0xa88ddb0, setup_tables_done_option=0) at sql_select.cc:306 # 16:33:22 #16 0x084f32f2 in execute_sqlcom_select (thd=0xa7d5b58, all_tables=0xa7f6700) at sql_parse.cc:4942 # 16:33:22 #17 0x084f81cb in mysql_execute_command (thd=0xa7d5b58) at sql_parse.cc:2122 # 16:33:22 #18 0x085155ba in mysql_parse (thd=0xa7d5b58, # 16:33:22 inBuf=0xa7f5a40 "SELECT DISTINCT SUM( DISTINCT table1 . `varchar_key` ) AS field1 FROM ( BB AS table1 STRAIGHT_JOIN ( ( CC AS table2 INNER JOIN C AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `int_"..., length=735, found_semicolon=0xb35a3988) at sql_parse.cc:5957 # 16:33:22 #19 0x085178bf in dispatch_command (command=COM_QUERY, thd=0xa7d5b58, # 16:33:22 packet=0xa8057e9 " SELECT DISTINCT SUM( DISTINCT table1 . `varchar_key` ) AS field1 FROM ( BB AS table1 STRAIGHT_JOIN ( ( CC AS table2 INNER JOIN C AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `in"..., packet_length=737) at sql_parse.cc:1073 # 16:33:22 #20 0x0851bb61 in do_command (thd=0xa7d5b58) at sql_parse.cc:755 # 16:33:22 #21 0x084df32a in handle_one_connection (arg=0xa7d5b58) at sql_connect.cc:1163 # 16:33:22 #22 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:22 #23 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 warning: Can't read pathname for load map: Input/output error. # 16:33:23 Core was generated by `/azalea/sql/mysqld --no-defaults --basedir=/home'. # 16:33:23 Program terminated with signal 6, Aborted. # 16:33:23 [New process 5094] # 16:33:23 [New process 5074] # 16:33:23 [New process 5035] # 16:33:23 [New process 5037] # 16:33:23 [New process 5038] # 16:33:23 [New process 5039] # 16:33:23 [New process 5040] # 16:33:23 [New process 5041] # 16:33:23 [New process 5042] # 16:33:23 [New process 5043] # 16:33:23 [New process 5044] # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 # 16:33:23 Thread 11 (process 5044): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7f02300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x084b9e8b in signal_hand (arg=0x0) at mysqld.cc:2941 # 16:33:23 #3 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #4 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 10 (process 5043): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7efe0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x0919ac4c in safe_cond_wait (cond=0xa106b6c, mp=0xa106b00, file=0x95d8a9a "os/os0sync.c", line=422) at thr_mutex.c:423 # 16:33:23 #3 0x08dbf8ef in os_event_wait_low (event=0xa106b00, reset_sig_count=0) at os/os0sync.c:422 # 16:33:23 #4 0x08e398a9 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2629 # 16:33:23 #5 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #6 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 9 (process 5042): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7cf87b1 in select () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #2 0x08dc0f4f in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 16:33:23 #3 0x08e37c3d in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2140 # 16:33:23 #4 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #5 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 8 (process 5041): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7cf87b1 in select () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #2 0x08dc0f4f in os_thread_sleep (tm=1000000) at os/os0thread.c:268 # 16:33:23 #3 0x08e369d3 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1914 # 16:33:23 #4 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #5 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 7 (process 5040): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7efe0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x0919ac4c in safe_cond_wait (cond=0xa663a44, mp=0xa6639d8, file=0x95d8a9a "os/os0sync.c", line=422) at thr_mutex.c:423 # 16:33:23 #3 0x08dbf8ef in os_event_wait_low (event=0xa6639d8, reset_sig_count=0) at os/os0sync.c:422 # 16:33:23 #4 0x08dbc95b in os_aio_simulated_handle (global_segment=3, message1=0xb581036c, message2=0xb5810368, type=0xb5810364) at os/os0file.c:4207 # 16:33:23 #5 0x08d4b7b2 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 # 16:33:23 #6 0x08e3aba8 in io_handler_thread (arg=0x9931d8c) at srv/srv0start.c:435 # 16:33:23 #7 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #8 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 6 (process 5039): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7efe0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x0919ac4c in safe_cond_wait (cond=0xa66398c, mp=0xa663920, file=0x95d8a9a "os/os0sync.c", line=422) at thr_mutex.c:423 # 16:33:23 #3 0x08dbf8ef in os_event_wait_low (event=0xa663920, reset_sig_count=0) at os/os0sync.c:422 # 16:33:23 #4 0x08dbc95b in os_aio_simulated_handle (global_segment=2, message1=0xb601136c, message2=0xb6011368, type=0xb6011364) at os/os0file.c:4207 # 16:33:23 #5 0x08d4b7b2 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 # 16:33:23 #6 0x08e3aba8 in io_handler_thread (arg=0x9931d88) at srv/srv0start.c:435 # 16:33:23 #7 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #8 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 5 (process 5038): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7efe0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x0919ac4c in safe_cond_wait (cond=0xa6638d4, mp=0xa663868, file=0x95d8a9a "os/os0sync.c", line=422) at thr_mutex.c:423 # 16:33:23 #3 0x08dbf8ef in os_event_wait_low (event=0xa663868, reset_sig_count=0) at os/os0sync.c:422 # 16:33:23 #4 0x08dbc95b in os_aio_simulated_handle (global_segment=1, message1=0xb681236c, message2=0xb6812368, type=0xb6812364) at os/os0file.c:4207 # 16:33:23 #5 0x08d4b7b2 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 # 16:33:23 #6 0x08e3aba8 in io_handler_thread (arg=0x9931d84) at srv/srv0start.c:435 # 16:33:23 #7 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #8 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 4 (process 5037): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7efe0e5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x0919ac4c in safe_cond_wait (cond=0xa66381c, mp=0xa6637b0, file=0x95d8a9a "os/os0sync.c", line=422) at thr_mutex.c:423 # 16:33:23 #3 0x08dbf8ef in os_event_wait_low (event=0xa6637b0, reset_sig_count=0) at os/os0sync.c:422 # 16:33:23 #4 0x08dbc95b in os_aio_simulated_handle (global_segment=0, message1=0xb7c1a36c, message2=0xb7c1a368, type=0xb7c1a364) at os/os0file.c:4207 # 16:33:23 #5 0x08d4b7b2 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 # 16:33:23 #6 0x08e3aba8 in io_handler_thread (arg=0x9931d80) at srv/srv0start.c:435 # 16:33:23 #7 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #8 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 3 (process 5035): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7cf87b1 in select () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #2 0x084bea49 in handle_connections_sockets () at mysqld.cc:5274 # 16:33:23 #3 0x084cde52 in main (argc=42, argv=0xbf940ee4) at mysqld.cc:4767 # 16:33:23 # 16:33:23 Thread 2 (process 5074): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7f010fb in read () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x09315849 in vio_read (vio=0xa6f4220, buf=0xa7cd898 "\a", size=4) at viosocket.c:44 # 16:33:23 #3 0x0848ac5f in my_real_read (net=0xa7adc54, complen=0xb35d4ee8) at net_serv.cc:839 # 16:33:23 #4 0x0848bd0c in my_net_read (net=0xa7adc54) at net_serv.cc:1029 # 16:33:23 #5 0x0851b6fd in do_command (thd=0xa7adbc0) at sql_parse.cc:701 # 16:33:23 #6 0x084df32a in handle_one_connection (arg=0xa7adbc0) at sql_connect.cc:1163 # 16:33:23 #7 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #8 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 # 16:33:23 Thread 1 (process 5094): # 16:33:23 #0 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #1 0xb7eff1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #2 0x091be212 in my_write_core (sig=6) at stacktrace.c:309 # 16:33:23 #3 0x084bcda2 in handle_segfault (sig=6) at mysqld.cc:2739 # 16:33:23 #4 # 16:33:23 #5 0xb7f25430 in __kernel_vsyscall () # 16:33:23 #6 0xb7c476d0 in raise () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #7 0xb7c49098 in abort () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #8 0xb7c405ce in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 # 16:33:23 #9 0x08219ea8 in ~Dbug_violation_helper (this=0xb35a1cf8) at ../../include/my_dbug.h:29 # 16:33:23 #10 0x082b7812 in Aggregator_distinct::setup (this=0xad8f988, thd=0xa7d5b58) at item_sum.cc:892 # 16:33:23 #11 0x086e41ae in Item_sum::aggregator_setup (this=0xa7f6120, thd=0xa7d5b58) at item_sum.h:480 # 16:33:23 #12 0x08656362 in setup_sum_funcs (thd=0xa7d5b58, func_ptr=0xa845834) at sql_select.cc:20681 # 16:33:23 #13 0x086cdbef in JOIN::optimize (this=0xaa55780) at sql_select.cc:2155 # 16:33:23 #14 0x086d3592 in mysql_select (thd=0xa7d5b58, rref_pointer_array=0xa7d70bc, tables=0xa7f6700, wild_num=0, fields=@0xa7d704c, conds=0xa88d5d0, og_num=2, # 16:33:23 order=0xa88dbd8, group=0x0, having=0x0, proc_param=0x0, select_options=2147764737, result=0xa88ddb0, unit=0xa7d6b00, select_lex=0xa7d6fb8) at sql_select.cc:3073 # 16:33:23 #15 0x086e37a6 in handle_select (thd=0xa7d5b58, lex=0xa7d6aa4, result=0xa88ddb0, setup_tables_done_option=0) at sql_select.cc:306 # 16:33:23 #16 0x084f32f2 in execute_sqlcom_select (thd=0xa7d5b58, all_tables=0xa7f6700) at sql_parse.cc:4942 # 16:33:23 #17 0x084f81cb in mysql_execute_command (thd=0xa7d5b58) at sql_parse.cc:2122 # 16:33:23 #18 0x085155ba in mysql_parse (thd=0xa7d5b58, # 16:33:23 inBuf=0xa7f5a40 "SELECT DISTINCT SUM( DISTINCT table1 . `varchar_key` ) AS field1 FROM ( BB AS table1 STRAIGHT_JOIN ( ( CC AS table2 INNER JOIN C AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `int_"..., length=735, found_semicolon=0xb35a3988) at sql_parse.cc:5957 # 16:33:23 #19 0x085178bf in dispatch_command (command=COM_QUERY, thd=0xa7d5b58, # 16:33:23 packet=0xa8057e9 " SELECT DISTINCT SUM( DISTINCT table1 . `varchar_key` ) AS field1 FROM ( BB AS table1 STRAIGHT_JOIN ( ( CC AS table2 INNER JOIN C AS table3 ON (table3 . `pk` = table2 . `pk` ) ) ) ON (table3 . `in"..., packet_length=737) at sql_parse.cc:1073 # 16:33:23 #20 0x0851bb61 in do_command (thd=0xa7d5b58) at sql_parse.cc:755 # 16:33:23 #21 0x084df32a in handle_one_connection (arg=0xa7d5b58) at sql_connect.cc:1163 # 16:33:23 #22 0xb7efa4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 # 16:33:23 #23 0xb7d0049e in clone () from /lib/tls/i686/cmov/libc.so.6