100325 0:26:34 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 100325 0:26:34 [Warning] '--log' is deprecated and will be removed in a future release. Please use ''--general_log'/'--general_log_file'' instead. 100325 0:26:34 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 100325 0:26:34 [Note] Plugin 'FEDERATED' is disabled. 100325 0:26:34 [Note] Plugin 'ndbcluster' is disabled. InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100325 0:26:34 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100325 0:26:34 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... 100325 0:26:34 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 100325 0:26:34 InnoDB: Started; log sequence number 0 0 100325 0:26:34 [Warning] /mysql-5.1/sql/mysqld: unknown variable 'loose-falcon-debug-mask=2' 100325 0:26:34 [Note] Event Scheduler: Loaded 0 events 100325 0:26:34 [Note] /mysql-5.1/sql/mysqld: ready for connections. Version: '5.1.46-gcov-debug-log' socket: '/5var2/tmp/master.sock' port: 11212 Source distribution 100325 0:27:33 - 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=2 max_threads=151 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59976 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xa42d700 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 = 0xb28ea38c thread_stack 0x30000 /mysql-5.1/sql/mysqld(my_print_stacktrace+0x42)[0x8cbd71e] /mysql-5.1/sql/mysqld(handle_segfault+0x4a8)[0x83cf5bd] [0x164400] /mysql-5.1/sql/mysqld(_ZN4JOIN5clearEv+0x2d)[0x852005f] /mysql-5.1/sql/mysqld[0x850b88c] /mysql-5.1/sql/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x5d)[0x85063c3] /mysql-5.1/sql/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x5d)[0x85063c3] /mysql-5.1/sql/mysqld[0x8505a99] /mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0x4460)[0x84db4a6] /mysql-5.1/sql/mysqld(_ZN30subselect_single_select_engine4execEv+0xa0a)[0x833453a] /mysql-5.1/sql/mysqld(_ZN14Item_subselect4execEv+0x13f)[0x8328ad1] /mysql-5.1/sql/mysqld(_ZN17Item_in_subselect8val_boolEv+0x88)[0x832cb80] /mysql-5.1/sql/mysqld(_ZN4Item15val_bool_resultEv+0x34)[0x823e536] /mysql-5.1/sql/mysqld(_ZN17Item_in_optimizer7val_intEv+0x472)[0x82a4086] /mysql-5.1/sql/mysqld[0x84f32fd] /mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0xbac)[0x84d7bf2] /mysql-5.1/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x658)[0x84dc3dd] /mysql-5.1/sql/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x31e)[0x84cd9c5] /mysql-5.1/sql/mysqld[0x8408425] /mysql-5.1/sql/mysqld(_Z21mysql_execute_commandP3THD+0x1116)[0x83f5598] /mysql-5.1/sql/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x58d)[0x840cb28] /mysql-5.1/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x167f)[0x83f09d8] /mysql-5.1/sql/mysqld(_Z10do_commandP3THD+0x4f6)[0x83eec2f] /mysql-5.1/sql/mysqld(handle_one_connection+0x2fe)[0x83eb29b] /lib/tls/i686/cmov/libpthread.so.0[0xee980e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0x5558de] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xa4860a0 = SELECT DISTINCT SUM( table2 . `col_int_key` ) AS field1 , SUM( table1 . `col_int_key` ) AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM D AS SUBQUERY1_t1 WHERE SUBQUERY1_t1 . `pk` != SOME ( SELECT 5 UNION SELECT 1 ) ) AS table1 STRAIGHT_JOIN ( SELECT SUBQUERY2_t1 . * FROM B AS SUBQUERY2_t1 ) AS table2 ON (table2 . `col_varchar_nokey` = table1 . `col_varchar_key` ) ) WHERE ( NOT EXISTS ( SELECT DISTINCT SUBQUERY3_t1 . `col_varchar_nokey` AS SUBQUERY3_field1 FROM ( B AS SUBQUERY3_t1 LEFT OUTER JOIN A AS SUBQUERY3_t2 ON (SUBQUERY3_t2 . `col_varchar_key` = SUBQUERY3_t1 . `col_varchar_key` ) ) WHERE SUBQUERY3_t1 . `col_varchar_key` = table2 . `col_varchar_key` ) ) AND ( table1 . `pk` = 93 AND table1 . `col_varchar_key` = 'h' ) OR ( table1 . `col_int_nokey` IS NOT NULL AND table1 . `pk` = table1 . `col_int_key` ) HAVING ( 'k', 't' ) IN ( SELECT SUBQUERY4_t2 . `col_varchar_nokey` AS SUBQUERY4_field1 , SUM( SUBQUERY4_t1 . `col_varchar_key` ) AS SUBQUERY4_field2 FROM ( CC AS SUBQUERY4_t1 INNER J thd->thread_id=4 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 # 2010-03-24T17:27:36 datadir is /5var2/master-data/ # 2010-03-24T17:27:36 binary is /mysql-5.1/mysql-test//../sql/mysqld # 2010-03-24T17:27:36 bindir is /mysql-5.1/mysql-test//../sql # 2010-03-24T17:27:36 core is /5var2/master-data//core warning: Can't read pathname for load map: Input/output error. # 2010-03-24T17:27:37 [New Thread 24089] # 2010-03-24T17:27:37 [New Thread 24166] # 2010-03-24T17:27:37 [New Thread 24167] # 2010-03-24T17:27:37 [New Thread 24091] # 2010-03-24T17:27:37 [New Thread 24086] # 2010-03-24T17:27:37 [New Thread 24088] # 2010-03-24T17:27:37 [New Thread 24090] # 2010-03-24T17:27:37 [New Thread 24117] # 2010-03-24T17:27:37 [New Thread 24118] # 2010-03-24T17:27:37 [New Thread 24119] # 2010-03-24T17:27:37 Core was generated by `/mysql-5.1/sql/mysqld --no-defaults --basedir=/ho'. # 2010-03-24T17:27:37 Program terminated with signal 11, Segmentation fault. # 2010-03-24T17:27:37 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:37 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:37 #1 0x00eeee93 in __pthread_kill (threadid=2995694448, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 # 2010-03-24T17:27:37 #2 0x08cbd8a6 in my_write_core (sig=11) at stacktrace.c:329 # 2010-03-24T17:27:37 #3 0x083cfad2 in handle_segfault (sig=11) at mysqld.cc:2570 # 2010-03-24T17:27:37 #4 # 2010-03-24T17:27:37 #5 0x084f3679 in clear_tables (join=0xa4d3cc0) at sql_select.cc:7302 # 2010-03-24T17:27:37 #6 0x0852005f in JOIN::clear (this=0xa4d3cc0) at sql_select.cc:16214 # 2010-03-24T17:27:37 #7 0x0850b88c in end_send_group (join=0xa4d3cc0, join_tab=0xa4d8060, end_of_records=true) at sql_select.cc:12324 # 2010-03-24T17:27:37 #8 0x085063c3 in sub_select (join=0xa4d3cc0, join_tab=0xa4d7ecc, end_of_records=true) at sql_select.cc:11276 # 2010-03-24T17:27:37 #9 0x085063c3 in sub_select (join=0xa4d3cc0, join_tab=0xa4d7d38, end_of_records=true) at sql_select.cc:11276 # 2010-03-24T17:27:37 #10 0x08505a99 in do_select (join=0xa4d3cc0, fields=0xa4d4e28, table=0x0, procedure=0x0) at sql_select.cc:11069 # 2010-03-24T17:27:37 #11 0x084db4a6 in JOIN::exec (this=0xa4d3cc0) at sql_select.cc:2315 # 2010-03-24T17:27:37 #12 0x0833453a in subselect_single_select_engine::exec (this=0xa4a9718) at item_subselect.cc:1972 # 2010-03-24T17:27:37 #13 0x08328ad1 in Item_subselect::exec (this=0xa4a9668) at item_subselect.cc:265 # 2010-03-24T17:27:37 #14 0x0832cb80 in Item_in_subselect::val_bool (this=0xa4a9668) at item_subselect.cc:865 # 2010-03-24T17:27:37 #15 0x0823e536 in Item::val_bool_result (this=0xa4a9668) at item.h:745 # 2010-03-24T17:27:37 #16 0x082a4086 in Item_in_optimizer::val_int (this=0xa4d1c30) at item_cmpfunc.cc:1833 # 2010-03-24T17:27:37 #17 0x084f32fd in return_zero_rows (join=0xa4d0888, result=0xa4d0870, tables=0xa51a518, fields=..., send_row=true, select_options=2147764737, # 2010-03-24T17:27:37 info=0x8ea80c8 "Impossible HAVING noticed after reading const tables", having=0xa4d1c30) at sql_select.cc:7269 # 2010-03-24T17:27:37 #18 0x084d7bf2 in JOIN::exec (this=0xa4d0888) at sql_select.cc:1834 # 2010-03-24T17:27:37 #19 0x084dc3dd in mysql_select (thd=0xa42d700, rref_pointer_array=0xa42eba0, tables=0xa51a518, wild_num=0, fields=..., conds=0xa534f40, og_num=3, # 2010-03-24T17:27:37 order=0xa4a9810, group=0x0, having=0xa4a9668, proc_param=0x0, select_options=2147764737, result=0xa4d0870, unit=0xa42e838, select_lex=0xa42eaa8) # 2010-03-24T17:27:37 at sql_select.cc:2510 # 2010-03-24T17:27:37 #20 0x084cd9c5 in handle_select (thd=0xa42d700, lex=0xa42e7dc, result=0xa4d0870, setup_tables_done_option=0) at sql_select.cc:269 # 2010-03-24T17:27:37 #21 0x08408425 in execute_sqlcom_select (thd=0xa42d700, all_tables=0xa51a518) at sql_parse.cc:5052 # 2010-03-24T17:27:37 #22 0x083f5598 in mysql_execute_command (thd=0xa42d700) at sql_parse.cc:2248 # 2010-03-24T17:27:37 #23 0x0840cb28 in mysql_parse (thd=0xa42d700, # 2010-03-24T17:27:37 inBuf=0xa4860a0 "SELECT DISTINCT SUM( table2 . `col_int_key` ) AS field1 , SUM( table1 . `col_int_key` ) AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM D AS SUBQUERY1_t1 WHERE SUBQUERY1_t1 . `pk` != SOME ( SE"..., length=1185, found_semicolon=0xb28ea058) at sql_parse.cc:5971 # 2010-03-24T17:27:37 #24 0x083f09d8 in dispatch_command (command=COM_QUERY, thd=0xa42d700, # 2010-03-24T17:27:37 packet=0xa497c79 " SELECT DISTINCT SUM( table2 . `col_int_key` ) AS field1 , SUM( table1 . `col_int_key` ) AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM D AS SUBQUERY1_t1 WHERE SUBQUERY1_t1 . `pk` != SOME ( "..., packet_length=1187) at sql_parse.cc:1233 # 2010-03-24T17:27:37 #25 0x083eec2f in do_command (thd=0xa42d700) at sql_parse.cc:874 # 2010-03-24T17:27:37 #26 0x083eb29b in handle_one_connection (arg=0xa42d700) at sql_connect.cc:1127 # 2010-03-24T17:27:37 #27 0x00ee980e in start_thread (arg=0xb28eab70) at pthread_create.c:300 # 2010-03-24T17:27:37 #28 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 warning: Can't read pathname for load map: Input/output error. # 2010-03-24T17:27:38 [New Thread 24089] # 2010-03-24T17:27:38 [New Thread 24166] # 2010-03-24T17:27:38 [New Thread 24167] # 2010-03-24T17:27:38 [New Thread 24091] # 2010-03-24T17:27:38 [New Thread 24086] # 2010-03-24T17:27:38 [New Thread 24088] # 2010-03-24T17:27:38 [New Thread 24090] # 2010-03-24T17:27:38 [New Thread 24117] # 2010-03-24T17:27:38 [New Thread 24118] # 2010-03-24T17:27:38 [New Thread 24119] # 2010-03-24T17:27:38 Core was generated by `/mysql-5.1/sql/mysqld --no-defaults --basedir=/ho'. # 2010-03-24T17:27:38 Program terminated with signal 11, Segmentation fault. # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 11 (Thread 24119): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x0054ea71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-24T17:27:38 #2 0x089abed1 in os_thread_sleep (tm=5000000) at os/os0thread.c:281 # 2010-03-24T17:27:38 #3 0x089fdab9 in srv_monitor_thread (arg=0x0) at srv/srv0srv.c:1945 # 2010-03-24T17:27:38 #4 0x00ee980e in start_thread (arg=0xb3b53b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #5 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 10 (Thread 24118): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x0054ea71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-24T17:27:38 #2 0x089abed1 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 2010-03-24T17:27:38 #3 0x089fea58 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2241 # 2010-03-24T17:27:38 #4 0x00ee980e in start_thread (arg=0xb4354b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #5 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 9 (Thread 24117): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x0054ea71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-24T17:27:38 #2 0x089abed1 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 # 2010-03-24T17:27:38 #3 0x089fe2f9 in srv_lock_timeout_thread (arg=0x0) at srv/srv0srv.c:2087 # 2010-03-24T17:27:38 #4 0x00ee980e in start_thread (arg=0xb4b55b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #5 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 8 (Thread 24090): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eede15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-24T17:27:38 #2 0x08cd4638 in safe_cond_wait (cond=0xa3ce984, mp=0xa3ce938, file=0x8f2b1ca "os/os0sync.c", line=422) at thr_mutex.c:237 # 2010-03-24T17:27:38 #3 0x089aae0f in os_event_wait_low (event=0xa3ce938, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-24T17:27:38 #4 0x089a8bc6 in os_aio_simulated_handle (global_segment=2, message1=0xb5b58354, message2=0xb5b58350, type=0xb5b5834c) at os/os0file.c:4267 # 2010-03-24T17:27:38 #5 0x08958149 in fil_aio_wait (segment=2) at fil/fil0fil.c:4251 # 2010-03-24T17:27:38 #6 0x08a00dc8 in io_handler_thread (arg=0x924a028) at srv/srv0start.c:435 # 2010-03-24T17:27:38 #7 0x00ee980e in start_thread (arg=0xb5b58b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #8 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 7 (Thread 24088): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eede15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-24T17:27:38 #2 0x08cd4638 in safe_cond_wait (cond=0xa3ce854, mp=0xa3ce808, file=0x8f2b1ca "os/os0sync.c", line=422) at thr_mutex.c:237 # 2010-03-24T17:27:38 #3 0x089aae0f in os_event_wait_low (event=0xa3ce808, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-24T17:27:38 #4 0x089a8bc6 in os_aio_simulated_handle (global_segment=0, message1=0xb775a354, message2=0xb775a350, type=0xb775a34c) at os/os0file.c:4267 # 2010-03-24T17:27:38 #5 0x08958149 in fil_aio_wait (segment=0) at fil/fil0fil.c:4251 # 2010-03-24T17:27:38 #6 0x08a00dc8 in io_handler_thread (arg=0x924a020) at srv/srv0start.c:435 # 2010-03-24T17:27:38 #7 0x00ee980e in start_thread (arg=0xb775ab70) at pthread_create.c:300 # 2010-03-24T17:27:38 #8 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 6 (Thread 24086): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x0054ea71 in select () from /lib/tls/i686/cmov/libc.so.6 # 2010-03-24T17:27:38 #2 0x083d90f5 in handle_connections_sockets (arg=0x0) at mysqld.cc:5054 # 2010-03-24T17:27:38 #3 0x083d76bf in main (argc=41, argv=0xbfac28a4) at mysqld.cc:4538 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 5 (Thread 24091): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eede15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-24T17:27:38 #2 0x08cd4638 in safe_cond_wait (cond=0xa3cea1c, mp=0xa3ce9d0, file=0x8f2b1ca "os/os0sync.c", line=422) at thr_mutex.c:237 # 2010-03-24T17:27:38 #3 0x089aae0f in os_event_wait_low (event=0xa3ce9d0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-24T17:27:38 #4 0x089a8bc6 in os_aio_simulated_handle (global_segment=3, message1=0xb5357354, message2=0xb5357350, type=0xb535734c) at os/os0file.c:4267 # 2010-03-24T17:27:38 #5 0x08958149 in fil_aio_wait (segment=3) at fil/fil0fil.c:4251 # 2010-03-24T17:27:38 #6 0x08a00dc8 in io_handler_thread (arg=0x924a02c) at srv/srv0start.c:435 # 2010-03-24T17:27:38 #7 0x00ee980e in start_thread (arg=0xb5357b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #8 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 4 (Thread 24167): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00ef1d5a in do_sigwait (set=0xef9ff4, sig=) # 2010-03-24T17:27:38 at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63 # 2010-03-24T17:27:38 #2 0x00ef1e00 in __sigwait (set=0xb294c2f0, sig=0xb294c388) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100 # 2010-03-24T17:27:38 #3 0x083d0e74 in signal_hand (arg=0x0) at mysqld.cc:2772 # 2010-03-24T17:27:38 #4 0x00ee980e in start_thread (arg=0xb294cb70) at pthread_create.c:300 # 2010-03-24T17:27:38 #5 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 3 (Thread 24166): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eede15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-24T17:27:38 #2 0x08cd4638 in safe_cond_wait (cond=0x9f589cc, mp=0x9f58980, file=0x8f2b1ca "os/os0sync.c", line=422) at thr_mutex.c:237 # 2010-03-24T17:27:38 #3 0x089aae0f in os_event_wait_low (event=0x9f58980, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-24T17:27:38 #4 0x089ffff9 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2730 # 2010-03-24T17:27:38 #5 0x00ee980e in start_thread (arg=0xb314db70) at pthread_create.c:300 # 2010-03-24T17:27:38 #6 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 2 (Thread 24089): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eede15 in pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/i386/i686/../i486/pthread_cond_wait.S:122 # 2010-03-24T17:27:38 #2 0x08cd4638 in safe_cond_wait (cond=0xa3ce8ec, mp=0xa3ce8a0, file=0x8f2b1ca "os/os0sync.c", line=422) at thr_mutex.c:237 # 2010-03-24T17:27:38 #3 0x089aae0f in os_event_wait_low (event=0xa3ce8a0, reset_sig_count=0) at os/os0sync.c:422 # 2010-03-24T17:27:38 #4 0x089a8bc6 in os_aio_simulated_handle (global_segment=1, message1=0xb6359354, message2=0xb6359350, type=0xb635934c) at os/os0file.c:4267 # 2010-03-24T17:27:38 #5 0x08958149 in fil_aio_wait (segment=1) at fil/fil0fil.c:4251 # 2010-03-24T17:27:38 #6 0x08a00dc8 in io_handler_thread (arg=0x924a024) at srv/srv0start.c:435 # 2010-03-24T17:27:38 #7 0x00ee980e in start_thread (arg=0xb6359b70) at pthread_create.c:300 # 2010-03-24T17:27:38 #8 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 # 2010-03-24T17:27:38 # 2010-03-24T17:27:38 Thread 1 (Thread 24567): # 2010-03-24T17:27:38 #0 0x00164422 in __kernel_vsyscall () # 2010-03-24T17:27:38 #1 0x00eeee93 in __pthread_kill (threadid=2995694448, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 # 2010-03-24T17:27:38 #2 0x08cbd8a6 in my_write_core (sig=11) at stacktrace.c:329 # 2010-03-24T17:27:38 #3 0x083cfad2 in handle_segfault (sig=11) at mysqld.cc:2570 # 2010-03-24T17:27:38 #4 # 2010-03-24T17:27:38 #5 0x084f3679 in clear_tables (join=0xa4d3cc0) at sql_select.cc:7302 # 2010-03-24T17:27:38 #6 0x0852005f in JOIN::clear (this=0xa4d3cc0) at sql_select.cc:16214 # 2010-03-24T17:27:38 #7 0x0850b88c in end_send_group (join=0xa4d3cc0, join_tab=0xa4d8060, end_of_records=true) at sql_select.cc:12324 # 2010-03-24T17:27:38 #8 0x085063c3 in sub_select (join=0xa4d3cc0, join_tab=0xa4d7ecc, end_of_records=true) at sql_select.cc:11276 # 2010-03-24T17:27:38 #9 0x085063c3 in sub_select (join=0xa4d3cc0, join_tab=0xa4d7d38, end_of_records=true) at sql_select.cc:11276 # 2010-03-24T17:27:38 #10 0x08505a99 in do_select (join=0xa4d3cc0, fields=0xa4d4e28, table=0x0, procedure=0x0) at sql_select.cc:11069 # 2010-03-24T17:27:38 #11 0x084db4a6 in JOIN::exec (this=0xa4d3cc0) at sql_select.cc:2315 # 2010-03-24T17:27:38 #12 0x0833453a in subselect_single_select_engine::exec (this=0xa4a9718) at item_subselect.cc:1972 # 2010-03-24T17:27:38 #13 0x08328ad1 in Item_subselect::exec (this=0xa4a9668) at item_subselect.cc:265 # 2010-03-24T17:27:38 #14 0x0832cb80 in Item_in_subselect::val_bool (this=0xa4a9668) at item_subselect.cc:865 # 2010-03-24T17:27:38 #15 0x0823e536 in Item::val_bool_result (this=0xa4a9668) at item.h:745 # 2010-03-24T17:27:38 #16 0x082a4086 in Item_in_optimizer::val_int (this=0xa4d1c30) at item_cmpfunc.cc:1833 # 2010-03-24T17:27:38 #17 0x084f32fd in return_zero_rows (join=0xa4d0888, result=0xa4d0870, tables=0xa51a518, fields=..., send_row=true, select_options=2147764737, # 2010-03-24T17:27:38 info=0x8ea80c8 "Impossible HAVING noticed after reading const tables", having=0xa4d1c30) at sql_select.cc:7269 # 2010-03-24T17:27:38 #18 0x084d7bf2 in JOIN::exec (this=0xa4d0888) at sql_select.cc:1834 # 2010-03-24T17:27:38 #19 0x084dc3dd in mysql_select (thd=0xa42d700, rref_pointer_array=0xa42eba0, tables=0xa51a518, wild_num=0, fields=..., conds=0xa534f40, og_num=3, # 2010-03-24T17:27:38 order=0xa4a9810, group=0x0, having=0xa4a9668, proc_param=0x0, select_options=2147764737, result=0xa4d0870, unit=0xa42e838, select_lex=0xa42eaa8) # 2010-03-24T17:27:38 at sql_select.cc:2510 # 2010-03-24T17:27:38 #20 0x084cd9c5 in handle_select (thd=0xa42d700, lex=0xa42e7dc, result=0xa4d0870, setup_tables_done_option=0) at sql_select.cc:269 # 2010-03-24T17:27:38 #21 0x08408425 in execute_sqlcom_select (thd=0xa42d700, all_tables=0xa51a518) at sql_parse.cc:5052 # 2010-03-24T17:27:38 #22 0x083f5598 in mysql_execute_command (thd=0xa42d700) at sql_parse.cc:2248 # 2010-03-24T17:27:38 #23 0x0840cb28 in mysql_parse (thd=0xa42d700, # 2010-03-24T17:27:38 inBuf=0xa4860a0 "SELECT DISTINCT SUM( table2 . `col_int_key` ) AS field1 , SUM( table1 . `col_int_key` ) AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM D AS SUBQUERY1_t1 WHERE SUBQUERY1_t1 . `pk` != SOME ( SE"..., length=1185, found_semicolon=0xb28ea058) at sql_parse.cc:5971 # 2010-03-24T17:27:38 #24 0x083f09d8 in dispatch_command (command=COM_QUERY, thd=0xa42d700, # 2010-03-24T17:27:38 packet=0xa497c79 " SELECT DISTINCT SUM( table2 . `col_int_key` ) AS field1 , SUM( table1 . `col_int_key` ) AS field2 FROM ( ( SELECT SUBQUERY1_t1 . * FROM D AS SUBQUERY1_t1 WHERE SUBQUERY1_t1 . `pk` != SOME ( "..., packet_length=1187) at sql_parse.cc:1233 # 2010-03-24T17:27:38 #25 0x083eec2f in do_command (thd=0xa42d700) at sql_parse.cc:874 # 2010-03-24T17:27:38 #26 0x083eb29b in handle_one_connection (arg=0xa42d700) at sql_connect.cc:1127 # 2010-03-24T17:27:38 #27 0x00ee980e in start_thread (arg=0xb28eab70) at pthread_create.c:300 # 2010-03-24T17:27:38 #28 0x005558de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130