(gdb) run Starting program: /home/miguel/dbs/5.0/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread 1075758784 (LWP 20941)] [New Thread 1089481648 (LWP 20944)] [New Thread 1091582896 (LWP 20945)] [New Thread 1093684144 (LWP 20946)] [New Thread 1095785392 (LWP 20947)] [New Thread 1097886640 (LWP 20948)] [New Thread 1102662576 (LWP 20949)] [New Thread 1104763824 (LWP 20950)] [Thread 1097886640 (zombie) exited] [New Thread 1106865072 (LWP 20951)] 060807 19:25:36 InnoDB: Started; log sequence number 0 48383 [New Thread 1098210224 (LWP 20952)] [New Thread 1098410928 (LWP 20953)] 060807 19:25:37 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.25-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1130646448 (LWP 20981)] [Thread 1130646448 (zombie) exited] [New Thread 1130646448 (LWP 20983)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1130646448 (LWP 20983)] 0x00000000 in ?? () (gdb) bt full #0 0x00000000 in ?? () No symbol table info available. #1 0x081b074f in Item_cond::copy_andor_arguments (this=0x8f2d7a0, thd=0x8eec110, item=0x8f27958) at item_cmpfunc.cc:2644 it = (class Item *) 0x8f2f3d0 li = { = {list = 0x8f279c8, el = 0x8f279f8, prev = 0x0, current = 0x0}, } #2 0x081b6e64 in Item_cond_and::copy_andor_structure (this=0x8f27958, thd=0x8eec110) at item_cmpfunc.h:1342 item = (Item_cond_and *) 0x8f2d7a0 #3 0x082910bc in reinit_stmt_before_use (thd=0x8eec110, lex=0x8f21818) at sql_prepare.cc:2098 order = (ORDER *) 0x8f1af00 _db_func_ = 0x85d39df "\211Â\213E\b\211P<\213E\b\213@8\215P\001\213E\b\211P8\213E\b\213@8\203ø\001t/¡lI\206\bÿu\020ÿu\fh`\225s\bPèÁN¹ÿ\203Ä\020¡lI\206\b\203ì\fPè\020O¹ÿ\203Ä\020è\210R¹ÿ\213U\b\213E\f\211B0\213U\b\213E\020\211B4\213E\b\203ì\fPè\212Z¹ÿ\203Ä\020\213Eø\213]üÉÃU\211åS\203ì$\213E\b\203ì\fPèLS¹ÿ\203Ä\020\213E\b\213@8\205Àu]\213E\b\213@4\211Eä\213E\b\213@0\205Àt\v\213E\b\213@0\211Eèë\aÇEè¯\225s\b¡lI\206\b\203ì\bÿ"... _db_file_ = 0x43642908 "8)dC¿X8\b\020Áî\b\030\030ò\b\033\t" sl = (SELECT_LEX *) 0x8f1a1d8 _db_level_ = 150132336 _db_framep_ = (char **) 0x8865360 __PRETTY_FUNCTION__ = "void reinit_stmt_before_use(THD*, LEX*)" #4 0x083858bf in sp_lex_keeper::reset_lex_and_exec_core (this=0x8f1aee8, thd=0x8eec110, nextp=0x43642a74, open_tables=false, instr=0x8f1aec0) at sp_head.cc:2352 res = 0 __PRETTY_FUNCTION__ = "int sp_lex_keeper::reset_lex_and_exec_core(THD*, uint*, bool, sp_instr*)" #5 0x083897b0 in sp_instr_stmt::execute (this=0x8f1aec0, thd=0x8eec110, nextp=0x43642a74) at sp_head.cc:2440 _db_func_ = 0x43642ac8 "h,dCf\2068\b\230\220ñ\b\020Áî\b\004,dCð+dC" _db_file_ = 0x8eed454 "XÔî\bà\"h\bTÔî\b" query = 0x8f0bd38 "SELECT getTracks(Member_ID) FROM cardiac" query_length = 40 res = 0 _db_level_ = 149864732 _db_framep_ = (char **) 0x81f58ff #6 0x083837c3 in sp_head::execute (this=0x8f19098, thd=0x8eec110) at sp_head.cc:1052 i = (sp_instr *) 0x8f1aec0 hip = 0 old_db_buf = "dbq\000\b|¿ò\bè)dC¨\023\030\b\001\000\000\000Bcs\b\b*dC*\030\027\b@Àò\b ³\205\b\b*dC|\030\027\bè\224ñ\b\000\000\000\000\000\000\000\000\2056\005@" old_db = {str = 0x436429bf "dbq", length = 3} dbchanged = false err_status = false save_sql_mode = 0 ---Type to continue, or q to quit--- execute_arena = {_vptr.Query_arena = 0x8681888, free_list = 0x0, mem_root = 0x43642a00, is_backup_arena = false, state = INITIALIZED_FOR_SP} _db_func_ = 0x8681e20 "THD::set_n_backup_active_arena" _db_file_ = 0x81f9087 "\203Ä \213E\020\212@\f%ÿ" _db_level_ = 1130638024 old_lex = (LEX *) 0x8eec150 old_change_list = { = {first = 0x8eed458, last = {_vptr.ilink = 0x86822e0, prev = 0x8eed454, next = 0x0}}, } ctx = (sp_rcontext *) 0x8f2b688 save_abort_on_warning = false old_arena = (class Query_arena *) 0x8eec11c execute_mem_root = {free = 0x8f2d660, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0} _db_framep_ = (char **) 0x0 ip = 1 backup_arena = {_vptr.Query_arena = 0x8681888, free_list = 0x8f2c008, mem_root = 0x43642bbc, is_backup_arena = true, state = INITIALIZED_FOR_SP} old_query_id = 14 old_derived_tables = (TABLE *) 0x0 old_packet = {Ptr = 0x8f0ed88 "ûdef", str_length = 0, Alloced_length = 16384, alloced = true, str_charset = 0x885b3a0} __PRETTY_FUNCTION__ = "bool sp_head::execute(THD*)" #7 0x08388666 in sp_head::execute_function (this=0x8f19098, thd=0x8eec110, argp=0x8f0bf5c, argcount=1, return_value_fld=0x8f0d740) at sp_head.cc:1493 octx = (sp_rcontext *) 0x0 err_status = false call_mem_root = {free = 0x8f2b678, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0x81cfd66 } _db_func_ = 0x0 _db_file_ = 0x0 binlog_save_options = 2158250496 nctx = (sp_rcontext *) 0x8f2b688 binlog_buf = {Ptr = 0x43642b6c "", str_length = 80, Alloced_length = 80, alloced = false, str_charset = 0x885b3a0} _db_level_ = 0 _db_framep_ = (char **) 0x0 save_security_ctx = (Security_context *) 0x0 arg_no = 1 buf = '\0' call_arena = {_vptr.Query_arena = 0x8681888, free_list = 0x8f2c008, mem_root = 0x43642bbc, is_backup_arena = false, state = INITIALIZED_FOR_SP} ---Type to continue, or q to quit--- backup_arena = {_vptr.Query_arena = 0x8681888, free_list = 0x8f0c9a8, mem_root = 0x8eec130, is_backup_arena = true, state = CONVENTIONAL_EXECUTION} need_binlog_call = false __PRETTY_FUNCTION__ = "bool sp_head::execute_function(THD*, Item**, uint, Field*)" #8 0x081a3767 in Item_func_sp::execute_impl (this=0x8f0bf10, thd=0x8eec110, return_value_fld=0x8f0d740) at item_func.cc:4872 err_status = true statement_state = {options = 2158250496, last_insert_id = 1, next_insert_id = 0, current_insert_id = 11936128518282651045, limit_found_rows = 0, cuted_fields = 0, sent_row_count = 1, examined_row_count = 8, client_capabilities = 239245, in_sub_stmt = 0, enable_slow_log = true, insert_id_used = false, clear_next_insert_id = false, last_insert_id_used = false, no_send_ok = 0 '\0', savepoints = 0x0} _db_func_ = 0x81813a8 "\203Ä\020ÉÃ\220U\211å\213E\bÇ" _db_file_ = 0x43642d18 "@×ð\b¹7\032\bt-dCð \005@h-dC±;]\b\020Áî\b@×ð\b\210-dCaZ\032\b\020¿ð\b\220¿ð\b\024" save_security_ctx = (Security_context *) 0x8eed0f8 _db_level_ = 0 _db_framep_ = (char **) 0x8f0d2f8 #9 0x081a388f in Item_func_sp::execute (this=0x8f0bf10, flp=0x8f0bf90) at item_func.cc:4830 thd = (class THD *) 0x8eec110 f = (class Field *) 0x8f0d740 #10 0x081a5a61 in Item_func_sp::val_str (this=0x8f0bf10, str=0x4364315c) at item_func.h:1456 buf = {Ptr = 0x43642d60 "", str_length = 0, Alloced_length = 20, alloced = false, str_charset = 0x885b3a0} buff = "\000\000\000\000\017\000\000\000\210-dC\232ÈM\b î\206\b" #11 0x0817bb28 in Item::send (this=0x8f0bf10, protocol=0x8eecbb0, buffer=0x4364315c) at item.cc:4484 res = (String *) 0x0 result = false type = MYSQL_TYPE_VARCHAR #12 0x081f6894 in select_send::send_data (this=0x8f0cfd0, items=@0x8eec46c) at sql_class.cc:942 protocol = (class Protocol *) 0x8eecbb0 buffer = {Ptr = 0x43642e4e "", str_length = 766, Alloced_length = 766, alloced = false, str_charset = 0x885b3a0} _db_func_ = 0x4026d9f8 "\t" _db_file_ = 0x15
li = { = {list = 0x8eec46c, el = 0x8f0c790, prev = 0x0, current = 0x0}, } buff = "\000\000 Ëð\b\001\000\000\000\001", '\0' , "\210Ðð\b£d&\b\001\000\000\000\000\000\000\000\030/dCÎh&\b|\021\000\000Ì.dCÈ.dCÄ.dC\000\000\000\000\r\000\000\001", '\0' , "ð?\001\000\000\000\000\000\000\000\\Ðð\b \226ò\bÔ.dC\000\000\000\000È.dCð \005@è.dC\214\024\037\b\020Áî\b\000\000\000\000\000\000\000\000\000\000\030@\000\000\000\000\000\000ð?\b/dCÔ0dC", '\0' , "\030@\232\231\231\231\231\231\001@8/dC", '\0' , "¨/dC\233i&\b\000\000\000\000\000"... _db_level_ = 0 _db_framep_ = (char **) 0x0 item = (class Item *) 0x8f0bf10 #13 0x08273d1c in end_send (join=0x8f296a0, join_tab=0x8f0d468, end_of_records=false) at sql_select.cc:10603 ---Type to continue, or q to quit--- error = 0 _db_func_ = 0x8eed658 "\bêm\b\020Aí\bàUv\bHØî\b`Øî\b" _db_file_ = 0x43643200 "øÒð\bøÒð\bh2dCf\004'\b \226ò\bhÔð\b" _db_level_ = 1130639876 _db_framep_ = (char **) 0x43643208 #14 0x08270466 in evaluate_join_record (join=0x8f296a0, join_tab=0x8f0d2f8, error=0, report_error=0x8eecb88 "") at sql_select.cc:9906 rc = NESTED_LOOP_OK found = true not_exists_optimize = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x0 #15 0x08270830 in sub_select (join=0x8f296a0, join_tab=0x8f0d2f8, end_of_records=false) at sql_select.cc:9797 error = 0 rc = NESTED_LOOP_OK report_error = (my_bool *) 0x8eecb88 "" info = (READ_RECORD *) 0x8f0d334 #16 0x08270b43 in do_select (join=0x8f296a0, fields=0x8eec46c, table=0x0, procedure=0x0) at sql_select.cc:9554 join_tab = (JOIN_TAB *) 0x8f0d2f8 _db_func_ = 0x8eec46c "\220Çð\b\220Çð\b\001" _db_file_ = 0x8eecbb0 "È'h\b\020Áî\b Ìî\b4Ìî\b" rc = 0 error = NESTED_LOOP_OK _db_level_ = 136275613 _db_framep_ = (char **) 0x43643308 #17 0x082836e1 in JOIN::exec (this=0x8f296a0) at sql_select.cc:1818 _db_func_ = 0x0 _db_file_ = 0x8f0d468 "" _db_level_ = 2158250496 _db_framep_ = (char **) 0x8f296a0 tmp_error = 1130640328 curr_join = (JOIN *) 0x8f296a0 curr_fields_list = (List *) 0x8eec46c columns_list = (List *) 0x8eec46c curr_all_fields = (List *) 0x8f2a3d8 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #18 0x082839cb in mysql_select (thd=0x8eec110, rref_pointer_array=0x8eec508, tables=0x8f0c800, wild_num=0, fields=@0x8eec46c, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2158250496, result=0x8f0cfd0, unit=0x8eec1b4, ---Type to continue, or q to quit--- select_lex=0x8eec3e0) at sql_select.cc:1982 err = false free_join = true _db_func_ = 0x43643458 "" _db_file_ = 0x4364349c "\200P\037\b0Áî\bÐÏð\bÈ4dCú\a#\bÐÏð\b" join = (JOIN *) 0x8f296a0 _db_level_ = 788 _db_framep_ = (char **) 0x8350934 #19 0x08283c95 in handle_select (thd=0x8eec110, lex=0x8eec150, result=0x8f0cfd0, setup_tables_done_option=0) at sql_select.cc:254 unit = (SELECT_LEX_UNIT *) 0x8eec1b4 select_lex = (SELECT_LEX *) 0x8eec3e0 _db_func_ = 0x8f0cfd0 "\210\026h\b\020Áî\b´Áî\b\001" _db_file_ = 0x82307fa "\203Ä\020º\210\026h\b\213E\b\211\020\213E\bÇ@\f" res = 8 _db_level_ = 1130640584 _db_framep_ = (char **) 0x8f0cfd0 #20 0x08225ce9 in mysql_execute_command (thd=0x8eec110) at sql_parse.cc:2573 result = (class select_result *) 0x8f0cfd0 res = false lex = (LEX *) 0x8eec150 _db_func_ = 0x8eec414 "" _db_file_ = 0x8f0bd98 "`K\206\b\024Äî\bgetTracks" _db_level_ = 135718876 _db_framep_ = (char **) 0x43643ca8 need_start_waiting = false result = 0 select_lex = (SELECT_LEX *) 0x8eec3e0 first_table = (TABLE_LIST *) 0x8f0c800 all_tables = (TABLE_LIST *) 0x8f0c800 unit = (SELECT_LEX_UNIT *) 0x8eec1b4 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #21 0x0822d94f in mysql_parse (thd=0x8eec110, inBuf=0x8f0bd38 "SELECT getTracks(Member_ID) FROM cardiac", length=40) at sql_parse.cc:5831 lex = (LEX *) 0x8eec150 _db_func_ = 0x8869ac0 "ÈGm\b" _db_file_ = 0x822e2b7 "\203Ä ¡Ôå\206\b\205Àt/\203ì\bhL)i\bhá\006" _db_level_ = 1130644248 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #22 0x0822e336 in dispatch_command (command=COM_QUERY, thd=0x8eec110, packet=0x8f03cd9 "", packet_length=41) at sql_parse.cc:1766 ---Type to continue, or q to quit--- packet_end = 0x8f0bd60 "" net = (NET *) 0x8eec920 _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8eed214 #23 0x0822f6b6 in do_command (thd=0x8eec110) at sql_parse.cc:1550 packet = 0x8f03cd8 "\001" old_timeout = 30 packet_length = 41 net = (NET *) 0x8eec920 command = COM_QUERY _db_func_ = 0x43644378 "XDdCÂú\"\b\020Áî\b\001" _db_file_ = 0x8eed330 "XÝð\b" _db_level_ = 150003032 _db_framep_ = (char **) 0x1010 #24 0x0822fac2 in handle_one_connection (arg=0x8eec110) at sql_parse.cc:1181 error = 0 net = (NET *) 0x8eec920 sctx = (Security_context *) 0x8eed0f8 thd = (class THD *) 0x8eec110 launch_time = 0 set = {__val = {0 }} #25 0x40050297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #26 0x4018b37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #27 0x43644bb0 in ?? () No symbol table info available. (gdb)