MySQL crashes on running some queries

MySQL on my server keeps crashing on some queries. The stack trace I get is below. I havent had much luck trying to figure out whats going on. Any ideas?

Thread pointer: 0xc52e8e0
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 = 7f6651801d98 thread_stack 0x40000
/usr/libexec/mysqld(my_print_stacktrace+0x29) [0x850989]
/usr/libexec/mysqld(handle_fatal_signal+0x483) [0x6a3ef3]
/lib64/libpthread.so.0(+0xf710) [0x7f6655228710]
/usr/libexec/mysqld(heap_scan+0xc2) [0x72a3f2]
/usr/libexec/mysqld(ha_heap::rnd_next(unsigned char*)+0x2d) [0x727b5d]
/usr/libexec/mysqld(rr_sequential(READ_RECORD*)+0x15) [0x691875]
/usr/libexec/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x69) [0x621be9]
/usr/libexec/mysqld() [0x622500]
/usr/libexec/mysqld(JOIN::exec()+0xbb6) [0x6344e6]
/usr/libexec/mysqld(subselect_single_select_engine::exec()+0x3cc) [0x582dcc]
/usr/libexec/mysqld(Item_subselect::exec()+0x2b) [0x58194b]
/usr/libexec/mysqld(Item_in_subselect::val_bool()+0x18) [0x581ef8]
/usr/libexec/mysqld(Item_in_optimizer::val_int()+0x131) [0x54adc1]
/usr/libexec/mysqld(Item::val_bool()+0x9c) [0x51bb9c]
/usr/libexec/mysqld(Item_cond_and::val_int()+0x31) [0x54bdf1]
/usr/libexec/mysqld(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, bool)+0xa0a) [0x64bdfa]
/usr/libexec/mysqld(mysql_execute_command(THD*)+0x3586) [0x5cd0d6]
/usr/libexec/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2d3) [0x5cf5b3]
/usr/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xd4b) [0x5d168b]
/usr/libexec/mysqld(do_command(THD*)+0xea) [0x5d220a]
/usr/libexec/mysqld(handle_one_connection+0x23e) [0x5c548e]
/lib64/libpthread.so.0(+0x79d1) [0x7f66552209d1]
/lib64/libc.so.6(clone+0x6d) [0x7f66539149dd]

Can you please post the whole of the two queries identified in the stack trace?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.