# gdb 2R01181807_crash_mysqld 2R01181807_crash_core.mysqld.17286 GNU gdb 6.3.50_2004-11-23-cvs Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-pc-solaris2.11"... Attaching to program `/tmp/2R01181807_crash_mysqld', process 2 warning: procfs: modify_flag failed to turn PR_RLC on /proc/2: Device busy. do_attach: couldn't set RLC. warning: core file may not match specified executable file. Core was generated by `/opt/mysql-5.1.14-beta/bin/mysqld --basedir=/opt/mysql-5.1.14-beta --datadir=/n'. Program terminated with signal 11, Segmentation fault. Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /lib/libdl.so.1...done. Loaded symbols for /lib/libdl.so.1 Reading symbols from /lib/libpthread.so.1... warning: Lowest section in /lib/libpthread.so.1 is .dynamic at 00000074 done. Loaded symbols for /lib/libpthread.so.1 Reading symbols from /lib/libthread.so.1... warning: Lowest section in /lib/libthread.so.1 is .dynamic at 00000074 done. Loaded symbols for /lib/libthread.so.1 Reading symbols from /lib/libgen.so.1...done. Loaded symbols for /lib/libgen.so.1 Reading symbols from /lib/libsocket.so.1...done. Loaded symbols for /lib/libsocket.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /usr/sfw/lib/libstdc++.so.6...done. Loaded symbols for /usr/sfw/lib/libstdc++.so.6 Reading symbols from /lib/libm.so.2...done. Loaded symbols for /lib/libm.so.2 Reading symbols from /usr/sfw/lib/libgcc_s.so.1...done. Loaded symbols for /usr/sfw/lib/libgcc_s.so.1 Reading symbols from /lib/libc.so.1...done. Loaded symbols for /lib/libc.so.1 #0 0xfec68567 in _lwp_kill () from /lib/libc.so.1 (gdb) backtrace full #0 0xfec68567 in _lwp_kill () from /lib/libc.so.1 No symbol table info available. #1 0xfec659fe in thr_kill () from /lib/libc.so.1 No symbol table info available. #2 0x082acd69 in write_core (sig=-20254720) at stacktrace.c:245 No locals. #3 0x081a2f03 in handle_segfault (sig=11) at mysqld.cc:2162 No locals. #4 0xfec6791f in __sighndlr () from /lib/libc.so.1 No symbol table info available. #5 0xfec5cf9b in call_user_handler () from /lib/libc.so.1 No symbol table info available. #6 No symbol table info available. #7 0xfebf503e in memcpy () from /lib/libc.so.1 No symbol table info available. #8 0x083be4e5 in mi_mmap_pread (info=0x5f8fff88, Buffer=0x5f7f19b0 "", Count=9928, offset=The value of variable 'offset' is distributed across several locations, and GDB cannot access its value. ) at mi_dynrec.c:147 No locals. #9 0x083c0c91 in _mi_read_dynamic_record (info=0x5f8fff88, filepos=The value of variable 'filepos' is distributed across several locations, and GDB cannot access its value. ) at mi_dynrec.c:1417 block_of_record = 1 b_type = 0 left_length = 9928 to = (byte *) 0x5f7f19b0 "" block_info = {header = "\003&Ø\000\002\205\002\000\000\000\000\000\000\02745addd", rec_len = 9944, data_len = 9928, block_len = 9944, blob_len = 2, filepos = 106633532, next_filepos = 18446744073709551615, prev_filepos = 18286314591409863344, second_read = 0, offset = 139161388} file = 61 _db_func_ = 0x84b6f36 "mi_rkey" _db_file_ = 0x84b6f2c "mi_rkey.c" _db_level_ = 10 _db_framep_ = (char **) 0x17 #10 0x083b4714 in mi_rkey (info=0x5f8fff88, buf=0x6040cc30 "\205\002", inx=0, key=0x5f996078 "\205\002", key_len=32, search_flag=HA_READ_KEY_EXACT) at mi_rkey.c:151 key_buff = (uchar *) 0x5f900ad8 "" share = (MYISAM_SHARE *) 0x6006f680 keyinfo = (MI_KEYDEF *) 0x6006f9f8 last_used_keyseg = (HA_KEYSEG *) 0x6006fab0 pack_key_length = 32 use_key_length = 32 nextflag = 9928 _db_func_ = 0x84a018e "join_read_const_table" _db_file_ = 0x849f88d "sql_select.cc" _db_level_ = 9 _db_framep_ = (char **) 0x5faba828 #11 0x083ae262 in ha_myisam::index_read_idx (this=0x6040cb20, buf=0x6040cc30 "\205\002", index=0, key=0x5f996078 "\205\002", key_len=104, find_flag=HA_READ_KEY_EXACT) at ha_myisam.cc:1223 error = 0 #12 0x081ff2df in join_read_const (tab=0x5fabab18) at sql_select.cc:10913 error = 120 table = (TABLE *) 0x602af828 #13 0x081fefd1 in join_read_const_table (tab=0x5fabab18, pos=0x5fab97a0) at sql_select.cc:10815 _db_func_ = 0x849fbf6 "make_join_statistics" _db_file_ = 0x849f88d "sql_select.cc" join = (JOIN *) 0x602af828 error = 1605080872 _db_level_ = 8 _db_framep_ = (char **) 0xfdc60d7c table = (TABLE *) 0x602af828 tbl = (TABLE_LIST *) 0x5fab97a0 #14 0x081efd89 in make_join_statistics (join=0x5fab9728, tables=0x0, conds=0x5fab9608, keyuse_array=0x5faba828) at sql_select.cc:2421 tmp = 0 pos = (JOIN_TAB **) 0xfdc60c64 const_count = 1 ---Type to continue, or q to quit--- key = 1605080872 stat_end = (JOIN_TAB *) 0x5fabac88 stat_ref = (JOIN_TAB **) 0x5fabac88 _db_func_ = 0x849f91d "JOIN::optimize" _db_file_ = 0x849f88d "sql_select.cc" table_count = 1 found_ref = 0 sargables = (SARGABLE_PARAM *) 0x5f99606c i = 1 const_ref = {map = 3} table_vector = (TABLE **) 0x5fabad80 s = (JOIN_TAB *) 0x5fabab18 table = (TABLE *) 0x602af828 found_const_table_map = 0 eq_part = {map = 3} _db_level_ = 7 _db_framep_ = (char **) 0x5fab94d8 all_table_map = 1 refs = 0 stat = (JOIN_TAB *) 0x5fabab18 keyuse = (KEYUSE *) 0x602af828 outer_join = 0 error = 0 start_keyuse = (KEYUSE *) 0x5f73da80 stat_vector = {0x5fabab18, 0x0, 0x5fab9608, 0x81f9930, 0x5fabaa60, 0x5fab94d8, 0x5fab9430, 0x8144958, 0x1aad4, 0x5fab9588, 0x5fab9538, 0x0, 0xfdc60cc4, 0x5fab967c, 0x5fab95f8, 0x1, 0x5fabaa60, 0x5fab9608, 0xfdc60cec, 0x841f84d, 0xfdc60d24, 0x5fab967c, 0x5fabab00, 0x5fabaa60, 0xfdc60d24, 0x5faba83c, 0xfdc60d4c, 0x81fa436, 0xfec6705d, 0x0, 0x5fab9728, 0x81f98a6, 0xfec6705d, 0x0, 0xfdc60d0c, 0x8400201, 0x2, 0x0, 0xfdc60d1c, 0x8400201, 0x2, 0xfdc60d14, 0xfdc60d2c, 0x8401022, 0x5f9a6868, 0xfec051ac, 0x5f9a6868, 0x8401e43, 0x5f9a6868, 0xfdc60d74, 0xfdc60d4c, 0x8401ebe, 0x5fab9728, 0x0, 0xfdc60d8c, 0x5fab9728, 0x0, 0x0, 0xfdc60d8c, 0x820457b, 0x3546, 0xfdc60d6c} ref_changed = 1 #15 0x081eb556 in JOIN::optimize (this=0x5fab9728) at sql_select.cc:759 _db_func_ = 0x849fbc1 "mysql_select" _db_file_ = 0x849f88d "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x8650a10 sel = (SELECT_LEX *) 0x5fab9728 #16 0x081eecb1 in mysql_select (thd=Internal: global symbol `THD' found in sql_class.cc psymtab but not in symtab. THD may be an inlined function, or may be a template function (if a template, try specifying an instantiation: THD). ) at sql_select.cc:2049 err = false free_join = true _db_func_ = 0x849f89b "handle_select" _db_file_ = 0x849f88d "sql_select.cc" join = (JOIN *) 0x5fab9728 _db_level_ = 5 _db_framep_ = (char **) 0xfdc60efc #17 0x081ea3f4 in handle_select (thd=0x5f971ed0, lex=0x5f971f10, result=0x5fab9718, setup_tables_done_option=0) at sql_select.cc:245 unit = (SELECT_LEX_UNIT *) 0x0 select_lex = (SELECT_LEX *) 0x5f9721b4 _db_func_ = 0x849a37d "mysql_execute_command" _db_file_ = 0x849a03e "sql_parse.cc" res = false _db_level_ = 4 _db_framep_ = (char **) 0x400 #18 0x081bc342 in execute_sqlcom_select (thd=0x5f971ed0, all_tables=0x5fab90a0) at sql_parse.cc:5285 lex = (LEX *) 0x5f971f10 result = (class select_result *) 0x5fab9718 res = false #19 0x081b6147 in mysql_execute_command (thd=0x5f971ed0) at sql_parse.cc:2702 res = false lex = (LEX *) 0x5f971f10 _db_func_ = 0x849a615 "mysql_parse" _db_file_ = 0x849a03e "sql_parse.cc" ---Type to continue, or q to quit--- _db_level_ = 3 _db_framep_ = (char **) 0xfec5f7de need_start_waiting = false result = 0 select_lex = (SELECT_LEX *) 0x5f9721b4 first_table = (TABLE_LIST *) 0x5fab90a0 all_tables = (TABLE_LIST *) 0x5fab90a0 unit = (SELECT_LEX_UNIT *) 0x5f971f78 #20 0x081bda31 in mysql_parse (thd=0x5f971ed0, inBuf=0x5fab8e10 "select data, length from dspam_signature_data where uid = 645 and signature = \"45addddb114474244920162\"", length=1603739408) at sql_parse.cc:6103 lex = (LEX *) 0x5f971f10 _db_func_ = 0x849a2c3 "dispatch_command" _db_file_ = 0x849a03e "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x3 #21 0x081b4996 in dispatch_command (command=COM_QUERY, thd=0x5f971ed0, packet=0x5fa55fb9 "select data, length from dspam_signature_data where uid = 645 and signature = \"45addddb114474244920162\"", packet_length=104) at sql_parse.cc:1862 packet_end = 0x5fab8e77 "" net = (NET *) 0x5f972754 _db_func_ = 0x84ba47b "?func" _db_file_ = 0x84ba481 "?file" error = false _db_level_ = 1 _db_framep_ = (char **) 0xd8 #22 0x081b423e in do_command (thd=0x5f971ed0) at sql_parse.cc:1631 packet = 0x5fa55fb8 "\003select data, length from dspam_signature_data where uid = 645 and signature = \"45addddb114474244920162\"" old_timeout = 30 packet_length = 104 net = (NET *) 0x5f972754 command = COM_QUERY _db_func_ = 0x84ba47b "?func" _db_file_ = 0x84ba481 "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1000 #23 0x081b355c in handle_one_connection (arg=0x0) at sql_parse.cc:1237 error = 0 net = (NET *) 0x5f972754 sctx = (Security_context *) 0x5f972f7c thd = (struct THD *) 0x5f971ed0 launch_time = 0 set = {__sigbits = {0, 0, 0, 0}} #24 0xfec675e4 in _thr_setup () from /lib/libc.so.1 No symbol table info available. #25 0xfec67840 in __csigsetjmp () from /lib/libc.so.1 No symbol table info available. #26 0x00000000 in ?? () No symbol table info available.