Crash When Running SHOW PROCESSLIST Or Selecting from Information_schema.Processlist (Doc ID 1611980.1)

Last updated on AUGUST 03, 2017

Applies to:

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

Symptoms

MySQL crashed with the follow stack trace in error log:

tack_bottom = 0x2b7ea1bdf0ef thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x850ffe]
/usr/sbin/mysqld(handle_segfault+0x322)[0x5c2652]
/lib64/libpthread.so.0[0x390760eca0]
/lib64/libc.so.6(strlen+0x30)[0x3906e78dd0]
/usr/sbin/mysqld(fill_schema_processlist(THD*, TABLE_LIST*, Item*)+0x270)[0x6c1730]
/usr/sbin/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x1d0)[0x6bfc20]
/usr/sbin/mysqld(JOIN::exec()+0x439)[0x6399c9]
/usr/sbin/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x16e)[0x63b95e]
/usr/sbin/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x169)[0x63c279]
/usr/sbin/mysqld[0x5cca54]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x4c1)[0x5cfc01]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x1c)[0x6fd56c]
/usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0xe2)[0x6fd712]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x58b)[0x7036bb]
/usr/sbin/mysqld(sp_head::execute(THD*)+0x474)[0x7018d4]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, List*)+0x450)[0x702050]
/usr/sbin/mysqld(mysql_execute_command(THD*)+0x1111)[0x5d0851]
/usr/sbin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x1c)[0x6fd56c]
/usr/sbin/mysqld(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*)+0xe2)[0x6fd712]
/usr/sbin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0x58b)[0x7036bb]
/usr/sbin/mysqld(sp_head::execute(THD*)+0x474)[0x7018d4]
/usr/sbin/mysqld(sp_head::execute_procedure(THD*, List*)+0x450)[0x702050]
/usr/sbin/mysqld(Event_job_data::execute(THD*, bool)+0x538)[0x710da8]
/usr/sbin/mysqld(Event_worker_thread::run(THD*, Event_queue_element_for_exec*)+0xf3)[0x70e833]
/usr/sbin/mysqld(event_worker_thread+0x18)[0x70e888]

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