Script started on Tue 22 Dec 2009 10:19:04 PM PST ]0;root@db2:~[root@db2 ~]# script /tmp/core_generate.log [root@db2 ~]# sudo gdb /home/y/libexec64/mysqld /home/y/var/crash/mysqld.core.10001.15844 GNU gdb Red Hat Linux (6.3.0.0-1.159.el4rh) 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 "x86_64-redhat-linux-gnu"...Using host libthread_db library "/lib64/tls/libthread_db.so.1". Core was generated by `/home/y/libexec64/mysqld --basedir=/home/y --datadir=/home/y/var/mysql/data --u'. Program terminated with signal 11, Segmentation fault. Reading symbols from /lib64/tls/libpthread.so.0...done. Loaded symbols for /lib64/tls/libpthread.so.0 Reading symbols from /usr/lib64/libz.so.1...done. Loaded symbols for /usr/lib64/libz.so.1 Reading symbols from /lib64/libdl.so.2...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libssl.so.4...done. Loaded symbols for /lib64/libssl.so.4 Reading symbols from /lib64/libcrypto.so.4...done. Loaded symbols for /lib64/libcrypto.so.4 Reading symbols from /lib64/libcrypt.so.1...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libnsl.so.1...done. Loaded symbols for /lib64/libnsl.so.1 Reading symbols from /usr/lib64/libstdc++.so.6...done. Loaded symbols for /usr/lib64/libstdc++.so.6 Reading symbols from /lib64/tls/libm.so.6...done. Loaded symbols for /lib64/tls/libm.so.6 Reading symbols from /lib64/libgcc_s.so.1...done. Loaded symbols for /lib64/libgcc_s.so.1 Reading symbols from /lib64/tls/libc.so.6...done. Loaded symbols for /lib64/tls/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /usr/lib64/libgssapi_krb5.so.2...done. Loaded symbols for /usr/lib64/libgssapi_krb5.so.2 Reading symbols from /usr/lib64/libkrb5.so.3...done. Loaded symbols for /usr/lib64/libkrb5.so.3 Reading symbols from /lib64/libcom_err.so.2...done. Loaded symbols for /lib64/libcom_err.so.2 Reading symbols from /usr/lib64/libk5crypto.so.3...done. Loaded symbols for /usr/lib64/libk5crypto.so.3 Reading symbols from /lib64/libresolv.so.2...done. Loaded symbols for /lib64/libresolv.so.2 Reading symbols from /lib64/libnss_files.so.2...done. Loaded symbols for /lib64/libnss_files.so.2 Reading symbols from /home/y/lib64/mysql/plugin/ha_innodb.so...done. Loaded symbols for /home/y/lib64/mysql/plugin/ha_innodb.so Reading symbols from /lib64/libnss_dns.so.2...done. Loaded symbols for /lib64/libnss_dns.so.2 #0 0x0000003a7ab098b7 in pthread_kill () from /lib64/tls/libpthread.so.0 (gdb) thread apply all bt full Thread 15 (process 15844): #0 0x0000003a7ab0af8b in __lll_mutex_lock_wait () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000000001 in ?? () No symbol table info available. #2 0x0000003a7ab07d87 in pthread_mutex_lock () from /lib64/tls/libpthread.so.0 No symbol table info available. #3 0x0000000000000010 in ?? () No symbol table info available. Previous frame inner to this frame (corrupt stack?) Thread 14 (process 15850): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0x2e4e088, mp=0x2e4e010, file=0x2af4609964 "os/os0sync.c", line=422) at thr_mutex.c:237 error = Variable "error" is not available. Thread 13 (process 15851): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0x2e4e168, mp=0x2e4e0f0, file=0x2af4609964 "os/os0sync.c", line=422) at thr_mutex.c:237 error = Variable "error" is not available. Thread 12 (process 15852): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0x2e4e248, mp=0x2e4e1d0, file=0x2af4609964 "os/os0sync.c", line=422) at thr_mutex.c:237 error = Variable "error" is not available. Thread 11 (process 15853): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0x2e4e328, mp=0x2e4e2b0, file=0x2af4609964 "os/os0sync.c", line=422) at thr_mutex.c:237 error = Variable "error" is not available. Thread 10 (process 15861): #0 0x0000003a79ec28d6 in __select_nocancel () from /lib64/tls/libc.so.6 No symbol table info available. #1 0x0000002af459665b in os_thread_sleep (tm=Variable "tm" is not available. ) at os/os0thread.c:281 t = {tv_sec = 0, tv_usec = 762000} #2 0x0000002af45d0528 in srv_lock_timeout_and_monitor_thread (arg=Variable "arg" is not available. ) at srv/srv0srv.c:2001 ---Type to continue, or q to quit--- slot = Variable "slot" is not available. Thread 9 (process 15862): #0 0x0000003a79ec28d6 in __select_nocancel () from /lib64/tls/libc.so.6 No symbol table info available. #1 0x0000002af459665b in os_thread_sleep (tm=Variable "tm" is not available. ) at os/os0thread.c:281 t = {tv_sec = 0, tv_usec = 685000} #2 0x0000002af45d09ab in srv_error_monitor_thread (arg=Variable "arg" is not available. ) at srv/srv0srv.c:2227 fatal_cnt = 0 old_lsn = {high = 1, low = 2133506929} new_lsn = {high = 1, low = 2133506929} #3 0x0000003a7ab06137 in start_thread () from /lib64/tls/libpthread.so.0 No symbol table info available. #4 0x0000003a79ec9883 in clone () from /lib64/tls/libc.so.6 No symbol table info available. Thread 8 (process 15863): #0 0x0000003a79ec28d6 in __select_nocancel () from /lib64/tls/libc.so.6 No symbol table info available. #1 0x0000002af459665b in os_thread_sleep (tm=Variable "tm" is not available. ) at os/os0thread.c:281 t = {tv_sec = 0, tv_usec = 262000} #2 0x0000002af45d12ba in srv_master_thread (arg=Variable "arg" is not available. ) at srv/srv0srv.c:2370 event = Variable "event" is not available. Thread 7 (process 15864): #0 0x0000003a7ab0c34b in do_sigwait () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000003a7ab0c3fd in sigwait () from /lib64/tls/libpthread.so.0 No symbol table info available. #2 0x000000000063025e in signal_hand (arg=0x0) at mysqld.cc:2754 error = 0 sig = 14 _db_func_ = 0xabe9f7 "?func" _db_file_ = 0xabe9fd "?file" set = {__val = {548869, 0 }} _db_level_ = 1 _db_framep_ = (char **) 0x0 #3 0x0000003a7ab06137 in start_thread () from /lib64/tls/libpthread.so.0 No symbol table info available. ---Type to continue, or q to quit--- #4 0x0000003a79ec9883 in clone () from /lib64/tls/libc.so.6 No symbol table info available. Thread 6 (process 15878): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0xdc9ee0, mp=0xdc8cc0, file=0x9f820d "mysqld.cc", line=1878) at thr_mutex.c:237 error = Variable "error" is not available. Thread 5 (process 15899): #0 0x0000003a7ab0b25f in __read_nocancel () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x000000000095021e in vio_read (vio=0x154d71b0, buf=0x155380b0 "Q", size=16384) at viosocket.c:44 r = Variable "r" is not available. Thread 4 (process 15900): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0x15517b90, mp=0x155175e8, file=0xa615ea "log.cc", line=4596) at thr_mutex.c:237 error = Variable "error" is not available. Thread 3 (process 15903): #0 0x0000003a7ab0af8b in __lll_mutex_lock_wait () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000000001 in ?? () No symbol table info available. #2 0x0000003a7ab07d87 in pthread_mutex_lock () from /lib64/tls/libpthread.so.0 No symbol table info available. #3 0x0000003a7ac10280 in completed.1 () from /lib64/tls/libpthread.so.0 No symbol table info available. #4 0x0000000015642c40 in ?? () No symbol table info available. #5 0x0000000000979f54 in _db_return_ (_line_=0, _sfunc_=0x15521f60, _sfile_=0x15554d20, _slevel_=Variable "_slevel_" is not available. ) at dbug.c:1082 save_errno = 0 cs = (CODE_STATE *) 0xdc8cc0 #6 0x0000000015649330 in ?? () No symbol table info available. #7 0x000000004514b4e0 in ?? () No symbol table info available. #8 0x0000000000975dc2 in safe_mutex_lock (mp=0x3a79e81b8d, try_lock=88 'X', file=0x4b1f0fae
, line=9825434) at thr_mutex.c:149 ---Type to continue, or q to quit--- error = Variable "error" is not available. Thread 2 (process 1975): #0 0x0000003a7ab08b3a in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x0000000000976055 in safe_cond_wait (cond=0xdc9ee0, mp=0xdc8cc0, file=0x9f820d "mysqld.cc", line=1878) at thr_mutex.c:237 error = Variable "error" is not available. Thread 1 (process 24113): #0 0x0000003a7ab098b7 in pthread_kill () from /lib64/tls/libpthread.so.0 No symbol table info available. #1 0x000000000062f94b in handle_segfault (sig=11) at mysqld.cc:2552 curr_time = 1260326830 tm = {tm_sec = 10, tm_min = 47, tm_hour = 18, tm_mday = 8, tm_mon = 11, tm_year = 109, tm_wday = 2, tm_yday = 341, tm_isdst = 0, tm_gmtoff = -28800, tm_zone = 0xde6da0 "PST"} thd = (class THD *) 0x156402d0 #2 No symbol table info available. #3 0x0000003a79e70be0 in strlen () from /lib64/tls/libc.so.6 No symbol table info available. #4 0x000000000095dec1 in strdup_root (root=0x15642c40, str=0x0) at my_alloc.c:403 No locals. #5 0x0000000000576c89 in Query_arena::strdup (this=0x156402e8, str=0x0) at sql_class.h:564 No locals. #6 0x0000000000791fa2 in mysqld_list_processes (thd=0x156402d0, user=0x0, verbose=false) at sql_show.cc:1774 thd_info = (thread_info *) 0x1564e220 tmp_sctx = (Security_context *) 0x1564a200 mysys_var = (st_my_thread_var *) 0x977c5f it = { = {list = 0xdc7f00, el = 0x15649340, current = 0x15649330}, } tmp = (class THD *) 0x15649330 field = (class Item *) 0x1564e158 _db_func_ = 0xa05be6 "mysql_execute_command" _db_file_ = 0xa056a0 "sql_parse.cc" _db_level_ = 5 _db_framep_ = (char **) 0x4518b710 protocol = (class Protocol *) 0x156406a0 thd_info = (thread_info *) 0x1564e220 field_list = { = { = {}, first = 0x1564de10, last = 0x1564e1d0, elements = 8}, } thread_infos = { = {first = 0x4518b6c8, last = {_vptr.ilink = 0x9f6dd0, prev = 0x4518b6c0, next = 0x0}}, } ---Type to continue, or q to quit--- max_query_length = 100 now = 9927775 #7 0x0000000000642738 in mysql_execute_command (thd=0x156402d0) at sql_parse.cc:3461 res = 0 lex = (LEX *) 0x15641d18 _db_func_ = 0xa0669f "mysql_parse" _db_file_ = 0xa056a0 "sql_parse.cc" _db_level_ = 4 _db_framep_ = (char **) 0x156402e8 up_result = 0 need_start_waiting = false select_lex = (SELECT_LEX *) 0x156421e0 first_table = (TABLE_LIST *) 0x0 all_tables = (TABLE_LIST *) 0x0 unit = (SELECT_LEX_UNIT *) 0x15641db8 have_table_map_for_update = false __FUNCTION__ = "mysql_execute_command" #8 0x00000000006491ba in mysql_parse (thd=0x156402d0, inBuf=0x1564dd00 "SHOW PROCESSLIST", length=16, found_semicolon=0x4518ce98) at sql_parse.cc:6173 lex = (LEX *) 0x15641d18 parser_state = {m_lip = {m_thd = 0x156402d0, yylineno = 1, yytoklen = 0, yylval = 0x4518c2b0, m_ptr = 0x1564dd11 "ections", m_tok_start = 0x1564dd11 "ections", m_tok_end = 0x1564dd11 "ections", m_end_of_query = 0x1564dd10 "", m_tok_start_prev = 0x1564dd10 "", m_buf = 0x1564dd00 "SHOW PROCESSLIST", m_buf_length = 16, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x1564dd80 "SHOW PROCESSLIST", m_cpp_ptr = 0x1564dd90 "", m_cpp_tok_start = 0x1564dd90 "", m_cpp_tok_start_prev = 0x1564dd90 "", m_cpp_tok_end = 0x1564dd90 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x3000000008
, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 112 'p', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, in_comment_saved = 9927775, m_cpp_text_start = 0x4518d960 "`Ù\030E", m_cpp_text_end = 0x156a6d70
, m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0}} err = false _db_func_ = 0xa05931 "dispatch_command" _db_file_ = 0xa056a0 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x4518c4a8 start_usecs = 1260326830032162 end_usecs = 0 end_time_error = 0 start_time_error = 0 start_time = {tv_sec = 1260326830, tv_usec = 32162} end_time = {tv_sec = 1159251168, tv_usec = 251166482592} __FUNCTION__ = "mysql_parse" ---Type to continue, or q to quit--- #9 0x000000000063e2f1 in dispatch_command (command=COM_QUERY, thd=0x156402d0, packet=0x15642c81 "", packet_length=16) at sql_parse.cc:1307 packet_end = 0x1564dd10 "" end_of_stmt = 0x0 net = (NET *) 0x156403b8 _db_func_ = 0xa05880 "do_command" _db_file_ = 0xa056a0 "sql_parse.cc" error = false _db_level_ = 2 _db_framep_ = (char **) 0xdc9980 __FUNCTION__ = "dispatch_command" #10 0x000000000063d67a in do_command (thd=0x156402d0) at sql_parse.cc:945 return_value = false packet = 0x15642c80 "\001" packet_length = 17 net = (NET *) 0x156403b8 command = COM_QUERY _db_func_ = 0xabe9f7 "?func" _db_file_ = 0xabe9fd "?file" _db_level_ = 1 _db_framep_ = (char **) 0x156a6d70 #11 0x000000000063bb9b in handle_one_connection (arg=0x156a6d70) at sql_connect.cc:1142 net = (NET *) 0x156403b8 thd = (class THD *) 0x156402d0 #12 0x0000003a7ab06137 in start_thread () from /lib64/tls/libpthread.so.0 No symbol table info available. #13 0x0000003a79ec9883 in clone () from /lib64/tls/libc.so.6 No symbol table info available. (gdb) quit ]0;root@db2:~[root@db2 ~]# exit Script done on Tue 22 Dec 2009 10:19:24 PM PST