Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My mysql server died while running select queries.

Status of every table is good. When I went to the error log I found this:

Thread pointer: 0x2ab63e0f49e0
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...
stack_bottom = 40f34098 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x35)[0x7d08b5]
/usr/sbin/mysqld(handle_fatal_signal+0x4b4)[0x6a90e4]
/lib64/libpthread.so.0[0x2b4d4c6a6be0]
/usr/sbin/mysqld[0x904618]
/usr/sbin/mysqld[0x904725]
/usr/sbin/mysqld[0x90496c]
/usr/sbin/mysqld[0x848b18]
/usr/sbin/mysqld[0x848b7d]
/usr/sbin/mysqld[0x84e581]
/usr/sbin/mysqld[0x834878]
/usr/sbin/mysqld[0x82a885]
/usr/sbin/mysqld[0x7fb138]
/usr/sbin/mysqld[0x7f3b39]
/usr/sbin/mysqld[0x5c38c5]
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x66)[0x5bd396]
/usr/sbin/mysqld[0x5c20d7]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0xca0)[0x5d7570]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12c)[0x5d8d7c]
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1cd)[0x5d982d]
/usr/sbin/mysqld[0x591282]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x34b0)[0x599580]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x33b)[0x59b88b]
/usr/sbin/mysqld[0x59c8a2]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1af2)[0x59ea62]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x167)[0x59f057]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x14f)[0x63af3f]
/usr/sbin/mysqld(handle_one_connection+0x51)[0x63b121]
/lib64/libpthread.so.0[0x2b4d4c69e77d]
/lib64/libc.so.6(clone+0x6d)[0x2b4d4d9ef9ad]

This is a percona xtradb cluster; version is mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1.

share|improve this question
    
You need to give the version of MySQL and the request which triggers that. You should ugrade your MySQL to a recent version (or consider MariaDB). –  Basile Starynkevitch Jul 19 '13 at 6:53
    
Not quite enough information. Please post more of the error log both before and after the stack trace. –  eroomydna Jul 19 '13 at 9:07
add comment

migrated from stackoverflow.com Jul 19 '13 at 7:37

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.