mysqld 5.1 crashes in InnoDB Function lock_clust_rec_cons_read_sees (Doc ID 1368003.1)

Last updated on MAY 05, 2016

Applies to:

MySQL Server - Version 5.1 to 5.5 [Release 5.1 to 5.5]
Information in this document applies to any platform.

Symptoms

Under certain conditions MySQL might crash with a "signal 11" error and the following stack trace:

/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x835efe]
/usr/sbin/mysqld(handle_segfault+0x322)[0x5b5602]
/lib64/libpthread.so.0[0x33a620eb10]
/usr/sbin/mysqld(lock_clust_rec_cons_read_sees+0x55)[0x76a295]
/usr/sbin/mysqld(row_search_for_mysql+0x2de5)[0x7a76f5]
/usr/sbin/mysqld(_ZN11ha_innobase13general_fetchEPhjj+0x79)[0x71c6a9]
/usr/sbin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x2d)[0x68861d]
/usr/sbin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x56)[0x61ead6]
/usr/sbin/mysqld[0x61ed7a]
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x914)[0x62bb74]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x16e)[0x62d61e]
/usr/sbin/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x169)[0x62df39]
/usr/sbin/mysqld[0x5bfcd4]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x4b1)[0x5c2951]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x1fa)[0x5c7e2a]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x101b)[0x5c8e5b]
/usr/sbin/mysqld(_Z10do_commandP3THD+0xe4)[0x5c9404]
/usr/sbin/mysqld(handle_one_connection+0x6f0)[0x5bc5d0]
/lib64/libpthread.so.0[0x33a620673d]
/lib64/libc.so.6(clone+0x6d)[0x33a56d3f6d]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms