Done
Details
Assignee
UnassignedUnassignedReporter
Ashish BahugunaAshish BahugunaNeeds QA
YesAffects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
Ashish Bahuguna
Ashish BahugunaNeeds QA
Yes
Affects versions
Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created September 12, 2023 at 3:46 AM
Updated March 6, 2024 at 9:33 AM
Resolved October 10, 2023 at 10:11 AM
The database crashed with Signal 11. This is happening quite often
2023-09-10T10:09:36.8729407:43:26 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Build ID: Not Available
Server Version: 8.0.30-22 Percona Server (GPL), Release 22, Revision 7e301439b65
Thread pointer: 0x7fce3a01e000
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 = 7fcf60539bb0 thread_stack 0x100000
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x206883d]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(print_fatal_signal(int)+0x30f) [0x114a4af]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(handle_fatal_signal+0xc5) [0x114a585]
/lib64/libpthread.so.0(+0xf630) [0x7fcf8fb40630]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Object_creation_ctx::restore_env(THD*, Object_creation_ctx*)+0x1f) [0x10da9ef]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_head::execute(THD*, bool)+0x717) [0xf03a77]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_head::execute_function(THD*, Item*, unsigned int, Field)+0x5f5) [0xf06035]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Item_func_sp::execute_impl(THD*)+0x126) [0xd761a6]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Item_func_sp::execute()+0x8b) [0xd762fb]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Item_func_sp::val_json(Json_wrapper*)+0x58) [0xd767e8]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Item_typecast_json::val_json(Json_wrapper*)+0x110) [0xd96930]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(get_json_wrapper(Item*, unsigned int, String, char const*, Json_wrapper*)+0x44) [0xd89d24]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Table_function_json::fill_result_table()+0x96) [0x10f2806]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(MaterializedTableFunctionIterator::Init()+0x23) [0x1278a03]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(NestedLoopIterator::Read()+0xd5) [0x1278e75]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(StreamingIterator::Read()+0x30) [0x1279260]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(filesort(THD*, Filesort*, RowIterator*, unsigned long, unsigned long long, Filesort_info*, Sort_result*, unsigned long long*)+0x74d) [0x125238d]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(SortingIterator::DoSort()+0x6e) [0x12883ae]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(SortingIterator::Init()+0x30) [0x1288440]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(AggregateIterator::Init()+0x27) [0x127a297]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(MaterializeIterator<DummyIteratorProfiler>::MaterializeQueryBlock(materialize_iterator::QueryBlock const&, unsigned long long*)+0x8c) [0x127d3bc]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(MaterializeIterator<DummyIteratorProfiler>::Init()+0x351) [0x127de11]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(NestedLoopIterator::Read()+0xd5) [0x1278e75]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(UpdateRowsIterator::Read()+0x4a) [0x10aed2a]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0x2fe) [0x10a844e]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Query_expression::execute(THD*)+0x2f) [0x10a874f]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x189) [0x10230b9]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(mysql_execute_command(THD*, bool)+0xa10) [0xfc5180]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_instr_stmt::exec_core(THD*, unsigned int*)+0x4f) [0xf0a6bf]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x172) [0xf0ca92]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0xb5) [0xf0da15]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_instr_stmt::execute(THD*, unsigned int*)+0xf9) [0xf0f3e9]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_head::execute(THD*, bool)+0x5e1) [0xf03941]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x8ce) [0xf06d3e]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Sql_cmd_call::execute_inner(THD*)+0x14c) [0xf3cc3c]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x189) [0x10230b9]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(mysql_execute_command(THD*, bool)+0xa10) [0xfc5180]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(dispatch_sql_command(THD*, Parser_state*, bool)+0x508) [0xfc9268]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x21dc) [0xfcb9cc]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld(do_command(THD*)+0x282) [0xfcc862]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld() [0x113a880]
/usr/local/Percona-Server-8.0.30-22-Linux.x86_64.glibc2.17/bin/mysqld() [0x253e925]
/lib64/libpthread.so.0(+0x7ea5) [0x7fcf8fb38ea5]
/lib64/libc.so.6(clone+0x6d) [0x7fcf8de81b0d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fce35069030): WITH
Query (7fce35069030)
You may download the Percona Server operations manual by visiting
http://www.percona.com/software/percona-server/. You may find information
in the manual which will help you identify the cause of the crash.
2023-09-11T07:43:27.043795Z mysqld_safe mysqld from pid file /db/****/data/mysqld.pid ended with return value of 2