(gdb) bt full #0 0x0000003901e0c63c in pthread_kill () from /lib64/libpthread.so.0 No symbol table info available. #1 0x000000000066b3e1 in handle_fatal_signal (sig=8) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/signal_handler.cc:247 curr_time = tmins = hrs_buf = "00" mins_buf = "24" secs_buf = "01" thd = 0x195f530 #2 No symbol table info available. #3 ha_partition::min_rows_for_estimate (this=) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/ha_partition.cc:6340 i = max_used_partitions = 0 tot_used_partitions = 0 #4 0x000000000072a90f in check_quick_keys (param=0x7f10940e0fc0, idx=2013332416, key_tree=0x0, min_key=0x7f10940e1118 "\377\222\357O", min_key_flag=0, min_keypart=-1, max_key=0x7f10940e2016 "", max_key_flag=0, max_keypart=-1) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/opt_range.cc:7789 min_range = {key = 0x7f10940e1118 "\377\222\357O", length = 4, keypart_map = 1, flag = HA_READ_AFTER_KEY} max_range = {key = 0x7f10940e2016 "", length = 0, keypart_map = 18446744073709551615, flag = HA_READ_AFTER_KEY} records = 0 tmp = tmp_min_flag = 4 tmp_max_flag = keynr = 2013284928 min_key_length = 0 max_key_length = 0 tmp_min_keypart = 0 tmp_max_keypart = 4294967295 tmp_min_key = 0x7f10940e111c "" tmp_max_key = 0x7f10940e2016 "" save_first_null_comp = 0 '\000' #5 0x000000000072b01e in check_quick_select (param=0x7f10940e0fc0, idx=0, tree=0x7f107802f0c8, update_tbl_stats=) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/opt_range.cc:7560 records = 0 cpk_scan = false key = 0 #6 0x000000000072b29c in get_key_scans_params (param=0x7f10940e0fc0, tree=0x7f107802ee78, index_read_must_be_used=false, update_tbl_stats=, read_time=1.2) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/opt_range.cc:4959 keynr = 0 read_index_only = true cpu_cost = 6.9025273785215229e-310 found_records = 1 found_read_time = 0 idx = 0 key = 0x7f107802ee80 end = 0x7f107802ee88 key_to_read = 0x0 best_records = 0 read_plan = pk_is_clustered = true #7 0x0000000000734f29 in SQL_SELECT::test_quick_select (this=0x7f1078005d30, thd=0x195f530, keys_to_use=, prev_tables=, limit=, force_quick_range=) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/opt_range.cc:2321 range_trp = rori_trp = can_build_covering = false alloc = {free = 0x7f107802ee20, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 4064, block_num = 5, first_block_usage = 0, error_handler = 0x5f6180 } tree = 0x7f107802ee78 key_info = 0x7f1078004a40 param = { = {thd = 0x195f530, table = 0x7f107800fae0, cond = 0x7f1078005590, prev_tables = 0, read_tables = 0, current_table = 1, key_parts = 0x7f107802ee30, key_parts_end = 0x7f107802ee70, mem_root = 0x7f10940e4af0, old_root = 0x1961fd8, keys = 1, using_real_indexes = true, remove_jump_scans = true, real_keynr = {0 }, min_key = "\377\222\357O", '\000' , max_key = '\000' "\340, *\016\224\020\177\000\000\006*h", '\000' , "\002", '\000' "\200, .\016\224\020\177\000\000\304P\216", '\000' , "H.\016\224\020\177\000\000@.\016\224\020\177\000\000\070.\016\224\020\177\000\000H.\016\224\020\177\000\000@.\016\224\020\177\000\000\070.\016\224\020\177\000\000\000\000\000\000\000\000\000\000\360\062\016\224\020\177\000\000\370\062\016\224\020\177\000\000\002\000\000\000\000\000\000\000---Type to continue, or q to quit--- \000E\016\224\020\177\000\000h?\001\000\000\000\000\000x,\207\020\177", '\000' "\300, \177\207\020\177\000\000t\300\177\207\020\177", '\000' , "@0\016\224\020\177\000\000H0\016\224\020\177\000\000gB\177\207\020\177\000\000h/\002x"..., alloced_sel_args = 0}, key = {0x7f107802ee30, 0x7f1000000007, 0x7f10940e2f40, 0x7f107802e8a0, 0x20, 0xfe0, 0x2, 0x7f1078005418, 0x7f1078017140, 0x7f1078005590, 0x0, 0x7f10940e2fe0, 0x7329dc, 0x7f10940e2fe0, 0x7f1078005510, 0x7f10940e3060, 0x0, 0x7f10940e2fe0, 0x7f10940e5080, 0x1, 0x1, 0x1, 0x7924ba, 0x1, 0x7f107802e8b8, 0x7f10940e5110, 0x7335df, 0x15cd798, 0x7f10877f4000, 0x7f10872c7500, 0x7f10940e4390, 0x7f10940e5080, 0x7f10940e3060, 0x7f1078005590, 0x7f107800fae0, 0x195f530, 0x7f10780174a0, 0x7f107802e880, 0x7f10780174a0, 0x0, 0x2, 0x195f530, 0x7f107800fae0, 0x7f1078005590, 0x0, 0x0, 0x1, 0x7f107802e880, 0x7f107802e8a0, 0x7f10940e5080, 0x1961fd8, 0x1, 0x7f1000000000, 0x7f10940e34e8, 0x7f10940e34e0, 0x7f10940e34f8, 0x7f10940e34f0, 0x193dab8, 0x7f10940e4390, 0x2, 0x7f1078022f68, 0x0, 0x193da38, 0xffffffffffffffe0}, baseflag = 51606815886, max_key_part = 0, range_count = 1, quick = false, fields_bitmap_size = 4, needed_fields = {bitmap = 0x7f107802ee70, n_bits = 4, last_word_mask = 4294967280, last_word_ptr = 0x7f107802ee70, mutex = 0x0}, tmp_covered_fields = {bitmap = 0x0, n_bits = 26467648, last_word_mask = 0, last_word_ptr = 0x7f10940e3170, mutex = 0x1}, needed_reg = 0x7f1078005e80, imerge_cost_buff = 0x0, imerge_cost_buff_size = 0, is_ror_scan = false, n_ranges = 1, first_null_comp = 0 '\000'} buff = "\320I\016\224\020\177\000\000\234qa\000\000\000\000\000\003\000\000\000\000\000\000\000\070R\000x\020\177\000\000\370\365\225\001\000\000\000\000E$z\000\000\000\000\000\340X\021\001\000\000\000\000\070R\000x\020\177\000\000 J\016\224\020\177\000\000\373\231a\000\000\000\000\000\360I\016\224\020\177\000\000\255\004Q\000\000\000\000\000`J\016\224\020\177\000\000\251\tY\000\000\000\000\000\030V\000x\020\177\000\000\070R\000x\020\177\000\000\220U\000x\020\177\000\000\000S\016\224\000\000\000\000\310P\016\224\020\177\000\000 V\000x\020\177\000\000\000\000\000\000\000\000\000\000\030T\000x\020\177\000\000\220U\000x\020\177\000\000@q\001x\020\177\000\000\000\000\000\000\000\000\000\000\030V\000x\020\177\000\000\340J\016\224\020\177\000\000\020\fY\000\000\000\000\000"... key_parts = 0x7f1078004a40 best_trp = 0x0 group_trp = 0x7f107802c890 best_read_time = 1.2 idx = 0 scan_time = #8 0x00000000005a9a66 in get_quick_record_count (join=0x7f107802c890, tables_arg=0x7f1078004ec8, conds=, keyuse_array=0x7f107802de48) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_select.cc:2614 error = buff = "\300w\360\000\000\000\000\000@O\016\224\020\177\000\000\000\000\000\000\020\177\000\000\000\000\000\000\000\000\000\000\210P\016\224\020\177\000\000\220U\000x\020\177\000\000 V\000x\020\177\000\000\211\002", '\000' "\201, \002\000\000\000\000\000\000\240O\016\224\020\177\000\000\255\004Q\000\000\000\000\000\320O\016\224\020\177\000\000\037 k\000\000\000\000\000 P\016\224\000\000\000\000\240t\001x\020\177\000\000p5v\000\000\000\000\000\000&r\000\000\000\000\000\200\350\002x\020\177\000\000\001", '\000' "\377, \377\377\377\250\350\002x\020\177\000\000\260\350\002x\020\177\000\000\000P\016\224\020\177\000\000\240\350\002x\020\177\000\000\240\350\002x\020\177\000\000\000\000\000\000\000\000\000\000\340\370u\000\000\000\000\000\000\000\360\000\000\000\000\000\004\000\000\000\004\000\000\000"... #9 make_join_statistics (join=0x7f107802c890, tables_arg=0x7f1078004ec8, conds=, keyuse_array=0x7f107802de48) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_select.cc:3058 records = select = error = 0 table = 0x7f107800fae0 tables = i = table_count = 1 const_count = 0 key = found_const_table_map = 0 all_table_map = 1 found_ref = 0 refs = stat_end = 0x7f1078005ac0 s = 0x7f1078005868 stat_ref = 0x7f1078005ac0 keyuse = 0x0 outer_join = 0 sargables = 0x7f1078005d18 stat_vector = {0x7f1078005868, 0x0, 0x195f530, 0x7f10940e51c0, 0x7f10940e5170, 0x7f10940e4dd0, 0xf06d80, 0x7f10940e51ec, 0x7f10940e4fe0, 0x7f10940e5300, 0x7f10940e52c0, 0x454c4241, 0x115f656c62, 0x6020200a9213ea80, 0x745f64726f636572, 0x616d732060657079, 0x293528746e696c6c, 0x656e6769736e7520, 0x0, 0x114ca88, 0x0, 0x7f107801a7d8, 0x7f10940e4e90, 0x849d97, 0x6020200a2c4c4c55, 0x736f705f6174656d, 0x616d73206064695f, 0x293528746e696c6c, 0x656e6769736e7520, 0x114cc00, 0x7f10940e4e80, 0x4, 0x0, 0x7a23b0, 0x114cc00, 0x114ca88, 0xf24e60, 0x1, 0x7f10940e4ea0, 0x8e3583, 0x7f10940e4f20, 0x0, 0x7f10940e4f20, 0x82f124, 0x535241484320544c, 0x6e6974616c3d5445, 0x7f10940e4ee0, 0x6756b2, 0x7f1078005418, 0x0, 0x7f10940e4f30, 0x5106e4, 0x289, 0x0, 0x281, 0x0, 0x7f1078005618, 0x7f1078005418, 0x281, 0x0, 0x7f10940e4fd0, 0x6b98d9} ref_changed = 0 #10 0x00000000005aae31 in JOIN::optimize (this=0x7f107802c890) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_select.cc:1055 sel = 0x1961538 __FUNCTION__ = "optimize" #11 0x00000000005aea71 in mysql_select (thd=0x195f530, rref_pointer_array=0x1961710, tables=0x0, wild_num=2, fields=..., conds=0x7f1078005590, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7f1078005790, unit=0x1960f18, select_lex=0x1961538) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_select.cc:2565 err = free_join = true join = 0x7f107802c890 __FUNCTION__ = "mysql_select" #12 0x00000000005b4829 in handle_select (thd=0x195f530, lex=0x1960e68, result=0x7f1078005790, setup_tables_done_option=0) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_select.cc:297 unit = 0x1960f18 res = ---Type to continue, or q to quit--- select_lex = 0x1961538 #13 0x0000000000572831 in execute_sqlcom_select (thd=0x195f530, all_tables=0x7f1078004ec8) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_parse.cc:4584 lex = 0x1960e68 result = 0x7f1078005790 res = #14 0x0000000000577e56 in mysql_execute_command (thd=0x195f530) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_parse.cc:2145 privileges_requested = res = 0 up_result = lex = 0x1960e68 select_lex = first_table = 0x7f1078004ec8 all_tables = 0x7f1078004ec8 unit = 0x1960f18 have_table_map_for_update = false __FUNCTION__ = "mysql_execute_command" #15 0x000000000057a42a in mysql_parse (thd=0x195f530, rawbuf=, length=, parser_state=0x7f10940e6bc0) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_parse.cc:5621 found_semicolon = lex = 0x1960e68 err = __FUNCTION__ = "mysql_parse" #16 0x000000000057bfd1 in dispatch_command (command=COM_QUERY, thd=0x195f530, packet=, packet_length=63) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_parse.cc:1036 parser_state = {m_lip = {m_thd = 0x195f530, yylineno = 1, yytoklen = 10, yylval = 0x7f10940e6370, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x7f1078004c10 "\004", m_tok_start = 0x7f1078004c10 "\004", m_tok_end = 0x7f1078004c10 "\004", m_end_of_query = 0x7f1078004c0f "", m_tok_start_prev = 0x7f1078004c0f "", m_buf = 0x7f1078004bd0 "SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799", m_buf_length = 63, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x7f1078004c78 "SELECT COUNT(*) FROM table_XXXXX WHERE `timestamp` > 1341100799", m_cpp_ptr = 0x7f1078004cb7 "", m_cpp_tok_start = 0x7f1078004cb7 "", m_cpp_tok_start_prev = 0x7f1078004cb7 "", m_cpp_tok_end = 0x7f1078004cb7 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x1010
, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 48 '0', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = 19371985, m_cpp_text_start = 0x7f1078004cad "1341100799", m_cpp_text_end = 0x7f1078004cb7 "", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 }}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}} net = error = __FUNCTION__ = "dispatch_command" #17 0x0000000000610d97 in do_handle_one_connection (thd_arg=) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_connect.cc:814 rc = thd = 0x195f530 #18 0x0000000000610e04 in handle_one_connection (arg=) at /pb2/build/sb_0-5519472-1334854211.98/mysql-5.5.24/sql/sql_connect.cc:733 thd = 0x195f530 #19 0x0000003901e077f1 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #20 0x00000039012e5ccd in clone () from /lib64/libc.so.6 No symbol table info available.