Percona Mysql 8.0.30 crash

Description

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

Environment

None

relates to

Activity

Aaditya Dubey October 10, 2023 at 10:10 AM

Hi ,

Thank you for the report.
Please check https://jira.percona.com/browse/PS-8555 for fix.

Done

Details

Assignee

Reporter

Needs QA

Yes

Affects versions

Priority

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