Version: '5.0.38-debug' socket: '/tmp/mysql.sock' port: 3306 yes 070225 23:42:34 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space 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=8388572 read_buffer_size=131072 max_used_connections=43 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225788 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x41b365e8 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... Cannot determine thread, fp=0xba7fbc68, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80de94b handle_segfault + 417 0x83d60cd __pthread_sighandler + 173 0x8194c74 _ZN7SEL_ARGC1EP5FieldhPcS2_hhh + 12 0x8194d96 _ZN7SEL_ARG5cloneEPS_PS0_ + 182 0x8194dd0 _ZN7SEL_ARG5cloneEPS_PS0_ + 240 0x8194dfe _ZN7SEL_ARG5cloneEPS_PS0_ + 286 0x8194fda _ZN7SEL_ARG10clone_treeEv + 38 0x819b095 _Z7key_andP7SEL_ARGS0_j + 97 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819afa0 _Z12and_all_keysP7SEL_ARGS0_j + 192 0x819b168 _Z7key_andP7SEL_ARGS0_j + 308 0x819a8a3 _Z8tree_andP13st_qsel_paramP8SEL_TREES2_ + 519 0x819934d _Z11get_mm_treeP13st_qsel_paramP4Item + 199 0x8195a47 _ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyyb + 1875 0x81337e4 _Z22get_quick_record_countP3THDP10SQL_SELECTP8st_tablePK6BitmapILj64EEy + 158 0x8134c86 _Z20make_join_statisticsP4JOINP13st_table_listP4ItemP16st_dynamic_array + 5078 0x812f9dc _ZN4JOIN8optimizeEv + 1872 0x8133603 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_sel + 549 0x812e6b9 _Z13handle_selectP3THDP6st_lexP13select_resultm + 329 0x80f6022 _Z21mysql_execute_commandP3THD + 1718 0x80fe2fe _Z11mysql_parseP3THDPcj + 380 0x80f4262 _Z16dispatch_command19enum_server_commandP3THDPcj + 1940 0x80f3ac2 _Z10do_commandP3THD + 538 0x80f2c57 handle_one_connection + 991 0x83d0fa1 pthread_start_thread + 225 0x842be3a __clone + 106 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8e06728 = select * from xl1 where c1 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c2 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c3 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c4 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c5 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c6 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c7 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c8 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c9 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c10 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c11 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c12 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c13 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c14 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c15 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") and c16 in ("abcdefgh", "123456789", "qwertyuio", "asddfgh") thd->thread_id=7709 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 070225 23:42:35 mysqld restarted